PPC Management: AdWords Keyword Data Exposed With Google Analytics!
Introducing our QualityScores PPC Management series where we expose some of the best ppc management
secrets ever!
_______________________________________
You CAN expose your specific AdWords Keyword Data beyond the dreaded “other unique queries” in the AdWords Search Query Report with Google Analytics!
Don’t you hate running the AdWords Search Query report because you know the best data is behind the cold words “other unique queries”?
Do you have a sick feeling in your gut because you know you can make more money with your affiliate programs, blogs, and ads if you could only tighten up your AdWords advertising?
If you answered “yes”, then you need to read and implement this Analytics secret immediately.
Here is a detailed, step by step process to take a look at what lies beneath the silky covers of “other unique queries” using Google Analytics:
1. Log into AdWords and click on My Account -> Account Preferences:
2. Find the Tracking section in Account Preferences and make sure Auto-tagging is set to “yes”:
3. Click on Analytics from your AdWords account or sign into your Google Analytics account:
4. You can choose to skip this step if you want to edit your current website Analytics profile – we recommend you create a separate profile. Click on Add Website Profile >>:
5. Choose to add a profile to an existing domain:
6. Pick your domain, label the profile, make sure you have a check mark in the Apply Cost Data section and click finish:
7. You should see your new profile listed with any other profiles you already have:
8. Now you need to edit the settings of your new profile – Click on Edit next to your new profile:
Analytics Filter 1
9. Find the Filters Applied to Profile section and click Add Filter:
10. Choose to Add new Filter for Profile:
11. Give your filter a good name, drop down to the Custom Filter type and choose the Advanced option:
12. In Field A -> Extract A choose the Referral drop down and copy and paste this code into the available field -
(\?|&)(q|p|query|kw|searchfor|wd)=([^&]*)
I’ll update the image later – but the q|p…etc will effectively pull almost all queries from the url at the serp. Each search engine uses a different url parameter for this so if you find one you want to track, simply add it to the regex above using the bar | to separate them. The above regex was copied from the search lab.
13. In Field B -> Extract B choose the Campaign Medium drop down and copy and paste this code into the available field -
cpc|ppc
14. In Output To -> Constructor choose the Custom Field 1 drop down and copy and paste this code into the available field -
$A3
15. Make sure all fields are required and they do not need to be case sensitive, then click Finish:
16. You should be back on the profile settings page where you can see this first filter has been applied to your detailed analytics profile.
Analytics Filter 2
17. Repeat steps 9 through 11 to create a second filter. Remember to give the second filter a different name and give this filter the attributes outlined in steps 18 through 21. ***You NEED both filters for detailed keyword data to work!***
18. In Field A -> Extract A choose the Custom Field 1 drop down and copy and paste this code into the available field -
(.*)
19. In Field B -> Extract B choose the Campaign Term drop down and copy and paste this code into the available field -
(.*)
20. In Output To -> Constructor choose the Campaign Term drop down and copy and paste this code into the available field -
$B1, ($A1)
Some replicated posts detail using $B1, $A1 without parenthesis – and I haven’t seen any difference in results so it appears either way should work fine.
21. Make sure all fields are required and they do not need to be case sensitive, then click Finish:
22. You should be back on the profile settings page where you can see this second filter has been applied to your detailed analytics profile. Make sure they are in the order we described – filter 1 should be listed BEFORE filter 2 under the Filters Applied to Profile section.
You are done setting up the secret that will expose your AdWords Keyword Data!
Now you need to wait a few hours for the data to be captured and reported. When you revisit Analytics you simply need to look at these reports and note the added data next to your AdWords keywords:
Traffic Sources -> Keywords
- or -
Traffic Sources -> AdWords -> Keyword Positions
Or a number of other reports…
The data in your old Analytics profile should look like this:
And the data in your new profile should look like this:
The keywords shown in parentheses (key+word) is the exact term the user searched when they found and clicked on your advertisement.
This particular client is only selling home security systems so I would look at this report and add “car” as a negative keyword and I would research “home security devices” to see if there is a decent volume for that term. Then I would consider optimizing a page for that term and add the keyword to my AdWords campaign to see if I can turn those visitors into the kind of visitor that puts money in my wallet. 
One note regarding GOALS
We published a post detailing how to see your keyword data for Goals/conversions. Enjoy!
That’s a wrap! Your AdWords Keyword Data is now EXPOSED!
Our source for learning and applying this secret to our client accounts and our own accounts comes from a November 2007 blog post by the GA-Experts. Thank you, GA-Experts, for sharing this secret with us!
68 comments
Trackbacks/Pingbacks
- Get Naked at the PPC Book - [...] A wicked good tip from the guys at QualityScoressem on how to break through the generic search query data ...
- NUDE: AdWords Keyword Data Exposed With Google Analytics! « SEO Nonsense - [...] read more | digg story [...]
- December ‘07: Best Search/Marketing Posts » Small Business SEM - [...] James/semvironment: NUDE: AdWords Keyword Data Exposed With Google Analytics! [...]
- 7 Tips For Finding & Expanding Your Negative Keywords - [...] by terms you don’t want them to. The guys over at QualityScoresSEM have a fantastic article on extracting your ...
- SEMMYS - [...] NUDE: AdWords Keyword Data Exposed With Google Analytics! James Zolman, QualityScores | 12/19/07 [...]
- Costa Rica: SEO in Paradise - [...] and when I read what James over at QualityScores found I was floored! They put together a write-up on ...
- SEO Training - Tracking Adwords Keyword Data with Google Analytics « SEO & Affiliate Marketing Training - [...] friend pointed me to a blog post from QualityScores about tracking Adwords keyword data in Google Analytics. I really ...
- Google Analytics Auto-Tagging Issues | QualityScores - [...] looks like the problem was resolved around January 14 but if you tried implementing the AdWords keyword Data Exposed ...
- PPC - All 2008 Nominees » SEMMYS.org - [...] NUDE: AdWords Keyword Data Exposed With Google Analytics! James Zolman, QualityScores | 12/19/07 [...]
- The Adventures of PPC Hero - Heroic Feats of Pay Per Click Management : How to Use Analytics and Reports to Get to Know Your Customers Better - [...] very frustrating to me as an advertiser. Thankfully, the guys over at QualityScores put together this set of instructions ...
- PPC - 2008 Finalists » SEMMYS.org - [...] NUDE: AdWords Keyword Data Exposed With Google Analytics! James Zolman, QualityScores | 12/19/07 [...]
- Google - You Suck And I Will Find Another Way | QualityScores - [...] month Google changed their auto-tagging function so it would render the “AdWords keywords exposed” tip useless for a short ...
- The Affiliate Toolbox » Blog Archive » Cool Adwords Trick - [...] That was until today, my friends, when I stumbled on this post at QualityScores titled "NUDE: AdWords Keyword Data ...
- Track exact PPC keywords with Google Analytics | PPC Whiz - [...] was using an old filter posted by a great PPC resource, and newly named QualityScores, but unfortunately it seemed ...
- What is the Automatic Matching | Neil Lemons' Blog - [...] string in Google Analytics that triggered your ads for broad, extended, or automatic match type, follow these instructions. ...
- Harvesting Performance Keywords in Google Analytics | Rise to the Top Blog - [...] aspects of your site that are not performing well for you. Use it to track entire campaigns, with special ...
- Google as a "Discovery Engine"...and How to Protect Yourself | Search Marketing Sage - [...] matches without full disclosure of the results. (If you are interested, it is possible to bypass this keyword data ...
- Stop Google Analytics From Stealing Your Valuable AdWords Keyword Data | Get Elastic - [...] The solutions (Using Filters): - How to Get Detailed PPC Keyword Data from Google Analytics - NUDE: AdWords ...
- Negative Keywords Vital to PPC Campaign Success - [...] AdWords ad clicks! This would otherwise reveal a lot of great negative keywords to add. (Learn to reveal this ...
- The New New Shopper | the PPC Book | Pay Per Click Management & Internet Marketing - [...] Google Analytics Keyword Filtering. Hands down the best data you’ll ever get for free. If you are running broad ...
- Stop Wasting Money! How to Find the Right Negative Keywords for your Campaigns - The Official Clickable Blog | Clickable.com - [...] and/or reports. More information on creating advanced profiles in Google Analytics can be found here.Competitive Intelligence ToolsTools such as ...
- The Importance of Tracking Bounce Rates - The Official Clickable Blog | Clickable.com - [...] be a challenging task. If you do not have advanced search query reporting reference the following site for additional ...
- Adwords - Power of testing at SEOflow Blog - [...] suggest you set up filters on your keywords to be able to see if actual terms visitors are entering ...
- A Guide to Google Analytics and Useful Tools « Tech7.Net - [...] PPC Management: AdWords Keyword Data Exposed With Google AnalyticsYou CAN expose your specific AdWords Keyword Data beyond the dreaded ...
- Everything You Ever Wanted to Know About Google Analytics - Birdsall Social Media - [...] PPC Management: AdWords Keyword Data Exposed With Google Analytics You CAN expose your specific AdWords Keyword Data beyond the ...
- A Guide to Google Analytics and Useful Tools | Brainless Web - [...] PPC Management: AdWords Keyword Data Exposed With Google Analytics You CAN expose your specific AdWords Keyword Data beyond the ...
- Evaluating long tail opportunities - [...] only displays the trigger keyword rather than the actual search term. It was possible to install a filter but ...
- Evaluating long tail opportunities | Reviews, Reviews And More Reviews... - [...] only displays the trigger keyword rather than the actual search term. It was possible to install a filter but ...
- A Guide to Google Analytics and Useful Tools « Smashing Magazine - [...] PPC Management: AdWords Keyword Data Exposed With Google Analytics You CAN expose your specific AdWords Keyword Data beyond the ...
- Google AdWords – Friend or Enemy? | Marketing In New Media - [...] There is an excellent article on this topic on SEM Vironment [...]
- A Guide to Google Analytics and Useful Tools | WebsGeek - [...] PPC Management: AdWords Keyword Data Exposed With Google Analytics You CAN expose your specific AdWords Keyword Data beyond the ...
- A Guide to Google Analytics and Useful Tools | Astagram Studios- A Creative Studio- Official Blog - [...] PPC Management: AdWords Keyword Data Exposed With Google Analytics You CAN expose your specific AdWords Keyword Data beyond the ...
- AdWords exact search keywords coming to Analytics in May - [...] this was only available via AdWords (great if you have access, not so great otherwise) and by a filter ...
- 8 Step Checklist When Reviewing an Existing Pay-Per-Click Account | StayOnSearch - [...] on phrase match to better qualify the searcher. 5. Negative KeywordsThere is a little Google Analytics hack that ...
Subscribe Today!
Excellent article, thanks.
I was thinking about how this could be improved.
For example, the data this report generates is related to keywords which generate clicks.
What about the keywords which don’t generate clicks?
Is it possible to identify the keywords brought in on broad/phrase match which generate impressions but fail to generate any clicks?
Knowing the exact keywords people typed and then clicked on your ads is extremelly useful. I don’t know why Google Analytics doesn’t show those keywords instead of the broad match ones. I wrote about this not long time back, Best PPC Practice – Exact Keywords.
@Dom
GA only tracks keywords with clicks.
an excellent post…thanks for sharing…i would be implementing this in my account very soon and hope it will give more clear picture of the keywords to work with…
Great tip guys this is awesome would never have known such a thing will definitely help in weeding out those bad keywords and finding more negative matches
i’ve been using the filter, it works great EXCEPT for this….
it is not reporting my goal conversions
Help
anyone else having problems with tracking goals using this technique?
Hi,
great article – this is killer information for me.
Can I ask a question though. You say:
20. In Output To -> Constructor choose the Campaign Term drop down and copy and paste this code into the available field -
$B1, ($A1)
..however, on this URL http://www.seoptimise.com/blog/2008/11/a-google-analytics-trick-everyone-should-know.html
it says “Finally in the “Output To -> Constructor” menu choose “Campaign Term” or wherever you want your data to go and then enter “$B1, $A1” The space after the comma means that you can export your data to a .csv and have a separate field for the actual search term.”
…what is the difference betweeen saying “$B1, ($A1)” and “$B1, $A1″?
thanks
Joel
Sorry to all recent commentators! We have been traveling and insanely busy – but that is not a reason to leave you in the dark.
@Dan – I’m checking into why the filter isn’t tracking all the way to the goals.
We should be updating this post soon, it’s at the top of my list so I should actually get it done today (2/18) or tomorrow.
@Joel – I’ll address your question in the update, it’s a very good question!
Thanks James – I’ll look forward to that – my current implementation of this (even though I’ve checked everything a bazillion) is still showing “google (organic)” “yahoo (organic)” etc in “traffic sources”) so there must be something wrong as I assume I should only be seeing PPC traffic here?
Joel
Great Piece of work.
Is there a way you can see the search terms that people used that did not click your ad ; ).
I have followed the directions for setting up the filters EXACTLY – went over it with a fine tooth comb for possible errors in implementation – and they are working BUT…next to the keywords I am seeing the entire URL string, not simply the keywords (keyword1+keyword2+keyword3). Can anyone help?
Hi James,
have you managed to figure out the goals issue?
Thanks,
Dan
Yes this is a great piece of work, no doubt!
However, I just noticed that this stopped working on about March 21.
Anyone else notice it?
We’ve made no additional changes – and it was working fine up until then.
Thanks,
-C
I had the filters all setup and workingd beautifully until late March 2009.
Now I am not seeing any keyword data in my filtered profile, although my unfiltered profile is showing data.
I haven’t changed anything, so it appears the filters have just stopped working. Has anyone else seen this? Any ideas what has happened?
Thanks for your help. I was really looking for the way to know the actual keywords which are originating traffic to my website via my adwords account.
Is this method still works?
I saw some posts (#87) saying that it stopped working around 03/2009!!
Any response is greatly appreciated.
Hi! I was surfing and found your blog post… nice! I love your blog.
Cheers! Sandra. R.
This filters work really well and we are able to see the actual query. However is anyone else seeing the issue of the differences in the # of visits, avg. page views & the avg. time on site stats?
I have an unfiltered profile and one with the filter and these values differ across the two profiles. The unfiltered has just one entry for the term area rugs, where as the one with the filter has multiple entries, but the average of the multiple entries does not always match that of the unfiltered profile. Did you find this, which is right? Let me know if anyone else is seeign this.
Thanks
Philippa