Setting up Google Analytics to measure Yahoo and Bing Pay-Per-Click (PPC) Campaigns

If you run PPC campaigns on Yahoo and Bing then it is essential you change your PPC campaign destination URLs in Yahoo and Bing to properly track visitors from paid search engines and non-paid organic visitors from your SEO campaign.

Fortunately, Google Analytics already tracks visitors from Google correctly, so one-third of your job is already done for you.

It’s a bit roundabout, but this is the way to track CPC traffic from non-Google sources (e.g. Yahoo and Bing).

In 2010 Yahoo integrated their campaign management tool into Bing’s Adcenter which really speeds up the process of managing your campaigns across these sites. Using the method detailed below you’ll be able to see all of this data within Google Analytics, making it the one stop shop for all your analytics needs.

Bing and Yahoo PPC Campaign Ad Tracking In Google Analytics

1. Create a custom tracking URL using Google’s URL Builder

Follow the instructions on screen and you should produce something like this URL string or similar:

http://www.yourdomain.com/?utm_source=bing&utm_medium=cpc&utm_term=keyword&utm_campaign=Bing+CPC+Campaign

The "Bing+CPC+Campaign" can be anything you like which described this CPC campaign; it can be the name of the campaign e.g. spring flowers, and is just for your own reference.

2. Replace the parameter “keyword" with a placeholder which Bing will populate when they generate an ad to display. In Step 2 of Google’s instructions, in the box labelled “Campaign Term” enter {QueryString}. The {QueryString} should result in Bing presenting the words that were searched for that resulted in your ad being shown. This should produce a revised URL something like this:

http://www.yourdomain.com/?utm_source=bing&utm_medium=cpc&utm_term={QueryString}&utm_campaign=Bing+CPC+Campaign

Or for a deep URL, something like this:

http://www.yourdomain.com/yourpagename?utm_source=Bing&utm_medium=CPC&utm_term={QueryString}&utm_campaign=Campaign1

You can use the term {KeyWord} rather than {QueryString} if you want Bing to tell you which of the keywords you’ve bid on resulted in your ad being shown.

3. In the Bing Adcenter campaign manager, enter this URL as the tracking URL for the campaign.

Clearly you do not want to add this URL for every keyword – so the best way to do this to change the “Destination URL” at the Ad Group Level.

Select “Ad Group”, then go to the “Ads Tab”.  Now click on “Ad Title” from your list of adverts.  You then get a screen which lists; “Ad Title”, “Ad Text”, “Display URL” and “Destination URL” – paste the long URL into the “Destination URL” box and click save.

Now repeat this for every Ad Group. If someone knows an even quicker way of doing this please feel free to post it here.

4. As things stand you will see the combined data for Bing and Yahoo and there is no quick way to change this. If you do want to see these as separate metrics you should first set up a new profile in GA, this is because it will change the way the data is presented and you probably want a clear, unfiltered view of all your data first and foremost!

You can then set up a new filter by visiting the ‘Admin’ section of GA. You’ll then be presented with the following screen which you should fill in as shown below (click on the image to view it full size).

The expression that you need to insert in the Field B -> Extract B case is: https?://([^/]+)

This should result in the referring domain appearing after the campaign source, making it easy to differentiate between traffic from Bing and Yahoo by analysing your traffic by source.

Wait for a day or so; and then check your Google Analytics reports to see whether you are now seeing paid search engine traffic from Bing and Yahoo.

You should be able to clearly distinguish and drill down into paid vs no-paid traffic from all search engines and have a list of sources something like this:

yahoo / cpc

yahoo / organic

Bing / CPC

Bing / organic

google / cpc

google / organic

Search engines change the ways they handle reporting and tracking from time to time; please do add a post if this process has changed or no longer works for you.

By: Laurie OToole

15 Responses to Setting up Google Analytics to measure Yahoo and Bing Pay-Per-Click (PPC) Campaigns

  1. Anonymous says:

    Hi,

    Thank you so much for your article. I have set it up exactly the way you have described and named my campaign source Yahoo/Bing PPC. But for some reason in analytics I am getting some clicks from Yahoo/Bing PPC and some also show up as , http://www.bing.com / CPC and , search.yahoo.com / CPC (including commas). Any idea what am I doing wrong?

    Thank you so much.

    Reply
    • Hi, I’m glad you found the article useful.
      Sorry that you’re having this problem, I’m not actually sure what could be happening there! I’ll have a look into it and see if I can find an answer for you.

      Reply
  2. abcubed3 says:

    Thanks for this. I created a google doc spreadsheet, called URL builder that concatenate the parameters, and its easy to copy & paste. My question is that; how can I see other metrics like clicks and impression from GA, for Yahoo traffic

    Reply
  3. Anonymous says:

    I thought I was doing pretty well following this, for a naif that is, then I encountered this, “3. In the Bing Adcenter campaign manager, enter this URL as the tracking URL for the campaign.”

    Nothing I can bring up identifies itself as the “Bing Adcenter” and the only thing I can find fhat asks me for a Destination URL is “Create an Ad Group”.

    Help.

    Reply
  4. Anonymous says:

    Hi All,

    We launched a tool to auto-tag Bing Ads with Google Analytics UTM parameters to save the headache of doing this manually.

    bizible.com/bing-auto-tag

    Best,
    Andy Turman
    co-founder
    Bizible Marketing Analytics

    Reply
  5. Anonymous says:

    Just tried Bizible and it inserted the code with no trouble.
    Just waiting to see if the reporting is correct.

    Reply
  6. William Foody says:

    “show up as , http://www.bing.com / CPC and , search.yahoo.com / CPC (including commas)”

    I have the same problem i used the query string:
    “?utm_source=bing&utm_medium=cpc&utm_term={QueryString}&utm_campaign=Bing+CPC+Campaign”

    For the filter (Field A -> Extract A) just put “bing”.

    Am I doing somehting wrong?

    Reply
  7. Thanks for the lovely post. I have 34 different landing pages in my site and I am doing PPC campaign for all of my landing pages. It will be helpful to know If I want to get the accurate result do I need to customize 34 URL’s with this Google URL builder. Also, I have Google Adwords conversion tracking code setup in my ‘Thank you’ page if I now setup Bing Conversion tracking code in my ‘Thank you’ is there any chance of collisions?

    Reply
  8. Thanks for this! When I enter {QueryString} in Campaign Term, the URL generator displays the following: …cpc&utm_term=%7BQueryString%7D&utm_campaign=nps

    Is this correct or does {QueryString} have to be displayed as per the url you have stated?

    …cpc&utm_term={QueryString}&utm_campaign=Bing+CPC+Campaign

    If you could help that would be great!

    Reply
  9. I can see my Bing_Yahoo/cpc in Analytics, but I am not able to see which campaign generated the clicks. Did I enter something wrong when setting up the parameters??

    Reply

Get involved...

Scroll to Top