utm_term and MSN AdCenter: Getting Google Analytics to Measure MSN Paid Search

by DigitalAlex on October 24, 2007

Welcome to Digital Alex, where you'll get Actionable Advice for Better Internet Marketing. If you're new, explore my archives and subscribe to my RSS feed.

As you may recall, I wrote a while ago about how you have to setup the utm_term parameter in Google Analytics to properly measure your paid search campaigns on Yahoo. I was talking with Justin Cutroni (blogger and of the Google Analytics eBook fame) at eMetrics and apparently Google Analytics used to just grab the search query from referring data, but alas that has changed. This change also means that if you’re running paid search ads through MSN AdCenter, then you need to be vigilant with your destination url tagging or else run the risk of disappearing numbers. Here’s the scoop.

Why do I get a lot of (not set) and lost data in Google Analytics for MSN?

For any marketing tactic besides AdWords, Google Analytics relies on destination URLs (where you send your visitors) to decode the visit. There are a variety of parameters (parts of the destination URL) that I detailed in my first post about utm_term.

In the case of MSN paid search measurement with Google Analytics, you must use the utm_term parameter to define the keyword that brought the visitors to your site. Ah, but here’s the sticky part. If you do this manually, it’s going to take forever. You can concatenate things in Excel, but then you have to tag every single keyword. As with Yahoo paid search, we need a more elegant solution.

Clearly, you can’t use Yahoo’s dynamic variable, so you have to choose among MSN’s. Here’s the list of possibilities (and the original source, thank Craig).

MSN AdCenter Dynamic Variables

Of this list, the one you want is {QueryString}. This will return a value of the actual search query the user entered, not just what you purchased (which is how it will be reported for AdWords and Yahoo search). The challenge here is that data in the keyword report won’t be aggregated under one purchased keyword. The benefit is that you can mine these data to figure out ways to optimize your paid search campaigns.

If you’re playing along at home, you’ll want to define the parameter as utm_term={QueryString} for your MSN AdCenter destination URLs only. A complete URL might look something like this (I put in line breaks between parameters to make it readable on the blog):



The dynamic variable QueryString will automatically populate with the search query.

Now, if you are still see some (not set) pop up in your keywords report, I find the easiest way to zero in on the offending ads is to click on (not set) in your MSN paid keywords report and segment it by Ad Content, like this:

Google analytics segment by ad content

This shows you the titles of the ads that were improperly tagged, which makes identification easier. If that leaves you for a loss, try segmenting by landing page.

On a tangentially related topic, MSN AdCenter actually does not offer full conversion tagging for you to aggregate data into their reporting interface. I say “full” because you can track conversions with AdCenter, but not with a dynamic value. Clearly, this is pointless for an ecommerce site. I put the question to Microsoft’s Charles Thrasher. He basically points to Project Gatineau, MSN’s upcoming competitor to Google Analytics, as the solution to this issue. Shouldn’t this be standard? Come on MSN, pony up the code.

Thanks to Greg and Matt for their help this this.

{ 4 trackbacks }

new movies releases,hindi new movies,new motion pictures on dvd,new films 2011,new motion pictures download,new motion pictures
January 2, 2012 at 11:13 am
January 3, 2012 at 6:47 pm
noida schools colleges mba engineering
January 10, 2012 at 6:40 am
good keywords software
May 22, 2012 at 6:43 pm

{ 11 comments… read them below or add one }

1 Eloi April 9, 2008 at 3:50 am

That’s a good informative post, people often ‘forget’ to tag their destination URLs, and since you have to tailor them to each network it can get tricky… good thinking!

MSN are realy working to try and improve the Query String thingy…

2 DigitalAlex April 9, 2008 at 5:15 pm

Hey Eloi,

Yes, link tagging is one of the many ways you can pollute your web analytics data. It’s a “garbage in, garbage out” world, so you have to be careful.

I do hope MSN offers more tagging options, but I doubt it’s coming any time soon.


3 Don September 12, 2008 at 1:14 am

{QueryString} did not work for me. Google analytics just shows {querystring} as the keyword phrase. I replaced it with {keyword} in MSN adcenter.

4 Eloi September 12, 2008 at 3:16 am

Now what do you think about tagging your URLs now Google’s got an “auto2tagging” feature?…
I found this has messed up a lot of analytics – auto-taggin is autmatically on, but you don’t “see” the things they attach at the end of your destination URL… when I turn it off it seems to stop data from going into analytics, so I tend to leave it on and remove all ?parametres… What do you think ?

5 DigitalAlex September 14, 2008 at 1:36 pm

Don–did {keyword} work for you?

Eloi–I’m not sure what you mean by “auto2tagging”. I searched for it, but didn’t get any results.

6 Eloi September 15, 2008 at 4:45 am

sorry, i just meant auto tagging not auto2tagging.

7 DigitalAlex September 16, 2008 at 7:05 pm


As far as I know, auto-tagging only works for AdWords, not paid search advertising with Yahoo! Search Marketing or MSN AdCenter.

Did I miss an announcement?

8 Bobby August 3, 2010 at 11:31 am

Does the tagging have to be capitailiased. Eg.{QueryString} of can it be {querystring}

9 Alex Cohen August 3, 2010 at 6:13 pm

I’m not sure, Bobby. You may want to check out PPC Hero. They have an article on the topic too.

10 Campaignsync December 9, 2010 at 11:35 am

adCenter now recognizes {keyword} as the string to relay the keyword triggered by the users search query – not the actual search phrase. This allows you to tie your traffic back to your campaign more easily for decision making.

Additionally, Campaignsync performs this type of tagging for adCenter and Google Analytics and it’s free. Save yourself some time & try it out.

11 Lasonya June 26, 2013 at 4:40 am

What’s up, yes this paragraph is actually good and I have learned lot of things from it concerning blogging. thanks.

Leave a Comment

Previous post:

Next post: