The Ecommerce Expert

Successful Ecommerce Businesses Start Here

  • Home
  • Services
    • Ecommerce PPC Management
    • Conversion Rate Optimization
    • Ecommerce Consulting
    • Website Design / Redesign
  • Free Resources

How to Track Yahoo Paid Search in Google Analytics

By Eric Leuenberger 8 Comments

If you want to really take your business to the next level you must have an analytics system in place that provides you with data which can help you make informed decisions. By informed decisions I don’t mean “oh, my visitors use ‘xxx’ browser” or “the screen resolution of most visitors is ‘xxx'”. Sure, these elements might be useful to a very small degree if, and only if, you are looking at ensuring your site is designed to meet the right audience.

But, if you did your homework, your site should already be designed to fit any visitor that arrives, no matter the platform, browser type, screen resolution, or what ever it is you come up with relating to design.

Now there are many flavors of analytics that may work for your needs. In this article I am going to focus on Google Analytics. It’s free, it’s powerful, and it flat out can get the job done.

So, we’re talking Google Analytics setup to provide us with valuable decision making data. To get this type of information, just installing Google Analytics alone is not going to be enough. You need to take advantage of the full tracking capabilities to provide you with data from all your advertising channels. This will help you understand where to invest your time and resources to optimize a given channel—ideally that which provides a positive ROI.

I’ve written about Google Analytics in a number of past articles and discussed the ecommerce tracking, goal / funnel tracking, etc… so I won’t go into that in this article (although in future articles I will revisit these areas as much has changed in GA since the writing of those.)

In this article I am going to talk about tracking paid search traffic channels, specifically from Yahoo (Search Marketing).

As anyone running paid search campaigns might have already gathered, it’s fairly easy to track Adwords traffic in Google Analytics when you link the two and flip the proper auto-tagging switches, but it’s not so easy to track paid search traffic from Yahoo (or MSN for that matter but that topic is for my next article.)

Yes, Yahoo offers its own ppc tracking tools—including its own form of analytics. However, anyone that wants to find out from within Google Analytics how their paid search traffic from Yahoo is performing, has to do a little work.

In fact, currently—for those of you not already separating this out within your analytics—your paid search traffic from Yahoo (and again, MSN) comes over mixed with the organic traffic and is listed as such within Analytics. This isn’t good.

Google Analytics Screenshot of Yahoo / MSN Traffic
Google Analytics Screenshot of Yahoo / MSN Traffic

This is a problem. How can you make informed decisions about which channel of traffic provides the biggest bang for your buck when it’s mixed with organic. You can’t—at least not real easily.

So to track paid search traffic from MSN and Yahoo we need to separate them using the link itself and the variables we can pass to native Google Analytics. In short we need to develop a proper URL structure that we can use from within our MSN and Yahoo paid search ads themselves. These links must contain information which passes data to Google Analytics about the origin of that traffic.

The official term is called URL Tagging. Sounds complicated yes, and it could be, if it weren’t for this handy little tool that Google provides.

It’s called the URL Builder.

The URL Builder gives us the power to fill in a few fields click a button, and return a pre-built URL that we can use within our ppc campaigns. These would represent what are known as the Destination URL’s for a given keyword (you do break your destination URL’s down to the keyword level right? Doing so gives you more control and if you’re not, you should be.)

Let’s dive in and show you how you can gather keyword level data from Yahoo paid search, but one last thing you may be wondering before we do.

If you are wondering whether you need to provide a unique URL for each keyword the answer is no. Yahoo by default passes variable information to you with each visitor. All you need to know is what they pass and what to grab to insert into your analytics. That’s what I’m going to show you here.

Google’s URL Builder

Here’s is a crash course in Google’s URL Builder:

Google URL Builder
Google URL Builder Screenshot

The URL Builder let’s you enter your landing page (website URL) and associated variables including source (search engine), medium (cpc vs. email, organic, etc…), term (your keyword), content (ad version), and name (your campaign). After completing the form, the URL Builder provides you with a full tracking URL that you can copy/paste into your Yahoo or MSN ads. Here’s an example:

  • Landing page: www.ecommerceamplifier.com/
  • Variables: Source = ‘Yahoo’ (or could be ‘MSN’), medium = ‘CPC’, term = ‘Ecommerce Coaching’, campaign = ‘Coaching Program’ and content = ‘Ecommerce Coaching National Ad’.
  • Custom Tracking URL: //www.ecommerceamplifier.com/?utm_source=Yahoo&utm_medium=cpc&utm_term=ecommerce%2Bcoaching&utm_content=National%2BEcommerce%20Coaching%20Ad&utm_campaign=Ecommerce%2BAmplifier

Tracking Yahoo PPC With Google Analytics

First thing we need to do to get Yahoo to send us the data we are after is to turn on auto-tagging from within your Yahoo Search Marketing account or you’ll get nothing but the keyword coming over (and that doesn’t help a whole lot on its own.)

Yahoo Search Marketing Tracking URL Section
Yahoo Search Marketing Tracking URL Section

To do this you’ll need to login to your YSM (Yahoo Search Marketing) account and go to:

Administration > Tracking URLs

Once that is complete Yahoo will begin to pass a lot more data than just the keyword over in the query string and we’ll be able to retrieve that data from within Google Analytics.

The parameters identifiers that Yahoo uses to pass various paid search data in the query string are:

  • {OVKEY} representing the keyword
  • {OVADID} representing the ad itself
  • {OVCAMPGID} representing the campaign itself

Inserting these parameters into the utm_term, utm_content, and utm_campaign sections of your URL, you’ll be able to successfully pull the keyword you bid on, the ad it came from, and the campaign that held the ad into Google Analytics.

So going back to the above example (bullet points) the url for Yahoo would look like this after we inserted the parameters:

//www.ecommerceamplifier.com/?utm_source=Yahoo&utm_medium=cpc&utm_term={OVKEY}&utm_content={OVADID}&utm_campaign={OVCAMPGID}

Yahoo Parameters in Google URL Builder
Yahoo Parameters in Google URL Builder

Notice in place of the term, content, and campaign level data we entered earlier there are now Yahoo specific parameters that fill the string with dynamic data.

That’s all you need to do to begin to track the information on Yahoo paid search in Google Analytics. In the next article I’ll show you how to do the same thing using MSN Adcenter and after that one show you how to drill down on this data from within Google Analytics to find out what it’s all telling you.

Don’t be afraid to use this same strategy to track all kinds of marketing activity. Using this technique you can track email campaigns, banner advertising, or just about anything else you can imagine.

Related posts:

  1. Using Google Analytics to Track Email Campaigns
  2. How to Track MSN Paid Search in Google Analytics
  3. New Release: Yahoo Search Marketing Conversion Tracking for Zen Cart
  4. How to Get Higher Paid Search Conversion

Filed Under: Search Marketing, Website Analytics Tagged With: track yahoo ppc with google analytics, tracking yahoo cpc in google analytics, yahoo paid search google analytics

Books by The Ecommerce Expert

Google Analytics Uncovered: How to Set Up and Maximize Ecommerce Data in Google Analytics
Available on Amazon Now!

About Eric Leuenberger

Ecommerce conversion marketing expert who has been helping store owners since 1995 increase sales and build more profitable, more sustainable ecommerce businesses.

Comments

  1. Jessica says

    February 11, 2010 at 4:23 pm

    I’ve tried tracking my Yahoo Search campaign in Google Analytics, but now when I look at my data, the keyword is just being reported as {ovkey} instead of the actual keyword. Is there something else that needs adjusting – maybe on the Yahoo side besides turning URL Tracking on?

    Thanks,
    JB

    Reply
  2. nytsua says

    March 27, 2010 at 3:11 pm

    @Jessica

    I believe it’s case sensitive. Try to change them to {OVKEY}.

    nytsua

    Reply
  3. Jessica says

    April 1, 2010 at 3:30 pm

    I have it set as {OVKEY} in the actual code, it just gets reported as lower case in Analytics for some reason.

    Reply
    • Eric says

      April 2, 2010 at 8:27 am

      @Jessica I’ll look into this as well here and see if I can’t determine what is going on with yours.

      Reply
  4. Campaignsync says

    April 24, 2010 at 12:45 am

    Jessica:

    What’s happening is that the Google URL Builder is sanitizing the { } chars in {OVKEY} into URL friendly characters. This actually breaks the functionality when those URLs are put into YSM. When you tag your keywords make sure that {OVKEY} appears just like that and not like this: %7BOVKEY%7D

    Or, you could just use Campaignsync, which does everything mentioned in this post almost instantly. Just import your campaign as a CSV file, enter your destination URL and you’re done! Try it out, it’s free. Let us know what you think.

    Reply
  5. King Rosales says

    May 21, 2010 at 3:20 pm

    Hi Eric,
    thanks for this post.
    Im going to be trying this on one of my smaller campaigns this week. If it works, I’ll let you all know then put it on a larger campaign Im managing with over 400 product specific adgroups.
    I shall let you know :)

    Reply
  6. King Rosales says

    May 21, 2010 at 4:52 pm

    Hi Eric,
    I think you should read this post by John over at PPCHero.com, he actually suggests using the actual name of the AdGroup and Campaign rather than OVADID and CAMPID since using the latter shows you the actual IDs and not the names, possibly less useful.
    Thanks!

    http://www.ppchero.com/url-tagging-tracking-ppc-campaigns-google-analytics/

    Reply
    • Eric says

      May 23, 2010 at 6:47 am

      Thanks for the info King. They have some great posts over there (I read it quite a bit myself.)

      Reply

Leave a Reply Cancel reply

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

Categories

  • Blogging
  • Conversion
  • Customer Retention
  • Design & Usability
  • E-Commerce Optimization
  • Email Marketing
  • Featured
  • Google Adwords
  • Increase sales
  • Marketing Strategies
  • Mobile Commerce
  • Search Engine Optimization
  • Search Marketing
  • Security
  • Shopping Cart Abandonment
  • Social Media
  • Website Analytics
  • Zen Cart
  • Zen Cart Contributions
  • Popular
  • Recent

About

The Ecommerce Expert offers products and services that help move ecommerce businesses toward growth and success. Our products and services help store owners maximize their ROI, decreasing expenses and increasing revenue. The net result is sustainable growth and stability with above average results.

Services

  • Conversion Rate Optimization
  • Search Engine Marketing (SEM)
  • Ecommerce PPC Management
  • Social Media Marketing
  • Ecommerce Consulting
  • Website Design / Redesign

Copyright © 2023 | Privacy Policy

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
Cookie SettingsAccept
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT