Getting Search Queries for Google AdWords in Google Analytics – Part 2

Posted by David Whitehouse

Ok so I’ve been doing a bit of research, and I still need to write the script and run a test, but here is the logic I have determined:

If referrer = Google and request_url contains gclid {
utm_keyword = strip_out_search_string(request_url)
}

My only worries is that if you have the Google Adwords Cost Data enabled that despite setting utm_keyword it may overwrite it. This is why I need to do a test. If there are any volunteers, let me know :)

Like this post? Subscribe to my RSS feed or receive updates via email.

Got something to say? Say it below :)

Related posts:

  1. Google Analytics Qualified
  2. AdWords not linking to Analytics
  3. The 5 Most Common Google Analytics Mistakes
  4. Getting Search Queries for Adwords in Analytics
  5. Google Affiliate Network Begins Integration with AdSense and AdWords?

2 Comments »

RSS feed for comments on this post. TrackBack URI

  1. Hi David,

    Did this method work for you? If not, here’s a good way of doing it through Analytics using a filter:
    http://www.searchlaboratory.com/articles/cleaningbroadmatch.php

    It works for any search engine and is pretty easy to set up.

    Comment by Ryan — August 20, 2009 #

  2. No my way won’t work. I have seen that before, but you will need to setup a separate profile, using the “User Defined” field is the incorrect way of using that field.

    Anyways, the best way to find this data now is to use the Google AdWords search terms report.

    Comment by David Whitehouse — August 27, 2009 #

Leave a comment

XHTML: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Feedback Form