The Secret of Tracking Yahoo! Keyword Data in Google Analytics

By ,

11 SHARES

Pay-per-click marketing and web analytics – they go together like peas and carrots. Why you ask? Because the reports provided by the PPC search engines aren’t always enough! Services like Google Analytics provide advertisers with a wealth of knowledge for fine-tuning and perfecting their paid-search campaigns. This includes data like bounce rate, time on site or goal funnel visualizations. For advertisers who are using Analytics in tandem with their AdWords PPC account, the process for tracking data is a cinch. Google has an auto-tagging feature that will pull all of your PPC data into Analytics – including keyword level data. The question then becomes, “How do I track this data for my Yahoo! Search Marketing PPC campaigns?” Today I’m going to quickly explain how you can build custom tracking URLs to get the same comprehensive data for Yahoo!.

The first step is to head on over to the trusty Google Analytics URL Builder. This tool will let you input your landing page and variables including term (keyword), name (campaign), source (search engine), medium (cpc vs. email or organic) and content (ad version). After you manually input your data, the URL builder will provide you with a full tracking URL that you can copy/paste into your Yahoo! ads. Here’s a quick example:

  • Landing page: www.example.com/tracking
  • Variables: Source is Yahoo!, medium is CPC, term is PPC Hero, campaign is Tracking URLs and content is Best Blog Ad 1.
  • Custom Tracking URL: http://www.example.com/tracking?utm_source=yahoo &utm_medium=cpc&utm_term=ppc%2Bhero &utm_content=best%2Bblog%2Bad%2B1&utm_campaign=tracking%2Burls

This example would basically only work for a single keyword and a single ad text. If you have the time to create a separate URL for every keyword in your Yahoo! account, all I can say is go for it! If you’re like me, you need a much quicker process for capturing data. It just so happens that Yahoo! has an auto-tagging feature. In your account, go to the Administration tab and click on Tracking URLs. Select the option Tracking URLs On and save changes. This will tell Yahoo! to append your destination URLs with information ranging from the keyword you bid on, to the actual search query and account specific information like campaign and ad group IDs.

trackingurls.JPG

How do you pull this information into Analytics? It’s relatively easy. If you look at the custom tracking URL example above, you will need to make modifications to the term, content and campaign variables. You will need to insert Yahoo!’s identifiers into each of these variables to pull the auto-tagged information into Analytics. Some of the basics include {OVKEY} for the paid keyword, {OVRAW} for the actual search query, {OVADID} for the ad text ID number and {OVCAMPGID} for the campaign ID numer. Here’s another quick example:

  • Old Tracking URL: http://www.example.com/tracking?utm_source=yahoo&utm_medium=cpc &utm_term=ppc%2Bhero&utm_content=best%2Bblog%2Bad%2B1 &utm_campaign=tracking%2Burls
  • New Variables: Term is {OVKey}, content is {OVADID} and campaign is {OVCAMPGID}.
  • New Tracking URL: http://www.example.com/tracking?utm_source=yahoo&utm_medium=cpc &utm_term={OVKEY}&utm_content={OVADID}&utm_campaign={OVCAMPGID}

Now you can use this customized destination URL for an entire campaign (if applicable) and you will still pull detailed information into Analytics. I should point out that using Yahoo!’s auto-tagging identifiers will only produce real data if you have turned auto-tagging ON in your account! Otherwise all of your Yahoo! PPC visitors will register keywords as {OVKEY}. And trust me when I say, that isn’t very helpful. Discovering this process and putting it to use in my Yahoo! Search Marketing accounts has proved to be an invaluable asset. I would recommend to everyone reading this blog to set this up for your accounts as soon as you get the chance! And check in next week – I’ll explain how to do this for your MSN adCenter PPC accounts, too!

***UPDATE:  We’ve written an updated post on URL tagging for Yahoo! Search Marketing campaigns.  Check it out to make sure you’re getting the most up-to-date information!***

ACO_endad_Secrets

Twitter Facebook LinkedIn Google+ Email Print More
  • http://www.campaignsync.com Campaignsync

    We fully automated this time consuming process. Simply import your Yahoo campaign as a CSV file in to Campaignsync, specify a destination URL and a few clicks later you’re done. You can even assign a unique destination URL to each adgroup now. It’s completely free so try it out and let us know what you think.

  • http://goodtrips.info Nydia

    Wow! what an idea ! What a concept ! Beautiful .. Amazing …

  • http://www.tuhotel.com.mx Jorge

    There is a problem with that way of following campaigns, the terms {OVADID} and {OVCAMPGID} make it fast but it also make it irrelevant, specially because those terms send back to Google Analytics ONLY the ID number of such things like campaign and ad content.

    ¿Do you know the parameters that can deliver the actual Ad Content or Campaign Name to Google Analytics?, other wise filtering or analyzing data is imposible if you only have numbers instead of real campaign names.

  • http://www.ppcmaze.com/ PPC Maze

    If it’s only passing the ID# back, you would need a separate file to map ID# and campaign name back to each other.

    The easiest solution to this issue is to load your account to MSN and forget about this because Yahoo is going away in October, less than 3 months away.

  • http://www.soul-support.org/ Noel

    Thanks for the helpful article!

  • http://php2ranjan.com Php2ranajn

    Hi all, Its very nice Article. The Concept i thing is very good. We have to think for that point of view also.

  • http://www.uwsp.edu/ATHLETICS/mbb/06-07/index.htm Pointer Men’s Basketball

    Best you could edit the page title The Secret of Tracking Yahoo! Keyword Data in Google Analytics | The Adventures of PPC Hero to something more catching for your subject you create. I loved the the writing withal.

  • http://www.myseopandit.com MYSEOPANDIT

    This is a very innovative concept providing with up-to-date information. I agree the reports provided by the PPC search engines are not enough.
    The concept of creating a separate URL for every keyword in Yahoo! account is the one we need to concentrate as it is a time basis one.

  • http://www.searcoupon.com Sears Coupons

    Thank you for your excellent article ! Can you show me how I can track keywords in Google Adwords in the same way with Yahoo Keywords, please ?

  • http://www.oom.com.sg/seo-singapore.html Stephanie Zhang

    Hey thanks! this has been really useful 

  • Pingback: internet marketing

  • Pingback: new films releases,hindi new motion pictures,new films on dvd,new films 2011,new films download,new films

  • Pingback: classic xxx

  • Pingback: macysezx discount

  • Pingback: Dich Vu Thiet Ke Web Uy Tin - Chat Luong - Chi Phi Hop Ly

  • Pingback: hacker

  • Pingback: profit