• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Analytics Ninja

Analytics Ninja

Silently Surpass the Competition

  • Our Team
  • Services
    • Google Analytics Audit
    • Google Analytics Implementation
    • Google Tag Manager Implementation
    • Dashboarding and Reporting
    • Data Analysis
    • Amplitude Implementation Services
    • Amplitude Reporting Services
    • Tracking & Analytics for Shopify Stores
    • Shopify Data Reporting Services
  • Our Clients
    • Client Portfolio
    • Testimonials
  • Blog
  • Contact Info
  • Hire Us

Let Google Analytics run a Search Query Report for Yahoo PPC

July 20, 2009 by Analytics Ninja 1 Comment

There are a lot of things that bother me about Yahoo Search Marketing.  A LOT.  If anyone from Yahoo out there reads this blog, please pass on this piece of advice to your supervisors –> copy Google.  DO WHAT THEY DO.

*Sigh*  I’ll vent more frustration about Yahoo later.  There does happen to be, however, one or two areas that Yahoo is superior to Adwords, imvho.  Today’s post is about one of them:  Tagging.

For the purposes of this post, I assume that everyone reading this blog knows how to tag their links.  If not, please read up here.  And use the URL builder.

Here is the tag that I put on all of my Yahoo PPC destination URLs.

?utm_source=yahoo&utm_medium=cpc&utm_campaign=PUT-THE-CAMPAIGN-NAME-HERE%20{YSMMTC}&utm_term={YSMKEY}&utm_content={YSMRAW}

Another option is to leave the match type off of the name of your campaign.  I have found it helpful to leave it in, like the first example.

?utm_source=yahoo&utm_medium=cpc&utm_campaign=PUT-THE-CAMPAIGN-NAME-HERE&utm_term={YSMKEY}&utm_content={YSMRAW}

The utm_term={YSMKEY} tag populates the Keyword dimension with the keyword that you are bidding on, and the utm_content={YSMRAW} populates the Ad Content dimension with the raw query.

Make sure that you have tracking urls turned on in the Yahoo backend.

The result in Google Analytics is the ability to drill down on a keyword in Yahoo and see all of the raw queries which triggered the keyword.  In other words, a search query report (which, not surprisingly Yahoo doesn’t even offer in their UI, you have to request it from the support team.  argh! )

Yahoo Search Query Report

Yahoo Search Query Report

IMPORTANT:  Make sure to exclude the URL parameters from your Analytics reports.  Otherwise it messes up your Content Report, landing page analytics, etc.

exclude URL parameters

exclude URL parameters

Reader Interactions

Comments

  1. Mark R DeForest says

    August 3, 2014 at 9:54 pm

    I wanted to read what you wrote, but none of the links in your article work?

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

What we Offer

  • Google Analytics Audit
  • Google Analytics Implementation
  • GTM Implementation
  • Dashboarding and Reporting
  • Data Analysis

Find us here

  • Facebook
  • LinkedIn
  • Phone
  • Twitter

Who we Are

  • About Us
  • Contact Us
  • Privacy and Cookies

Blog Topics

  • Advanced Segmentation (4)
  • Bounce Rate (1)
  • Conversion Attribution (3)
  • Conversion Tracking (1)
  • Google Analytics Cookies (3)
  • Google Cloud Platform (1)
    • BigQuery (1)
  • Google Product Search (1)
  • Key Performance Indicators (2)
  • Miscellaneous (3)
    • Shopify (1)
  • Tagging (2)
  • Troubleshooting (2)
  • Uncategorized (23)
  • Universal Analytics (1)

Footer

Like us, Follow us

  • Facebook
  • LinkedIn
  • Phone
  • Twitter

Services

  • Google Analytics Audit
  • Google Analytics Implementation
  • GTM Implementation
  • Dashboarding and Reporting
  • Data Analysis

About

  • About Us
  • Contact Us
  • Privacy and Cookies

Copyright (c) 2010 - 2025 Analytics Ninja LLC