This entry was posted on Wednesday, December 19th, 2007 at 7:20 am and is filed under NUDE. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Introducing our semvironment NUDE series where we expose some of the best ppc management secrets ever! This series will be posted roughly every 2 weeks…so watch out for the naked secrets of the super successful in pay per click advertising!
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 -
13. In Field B -> Extract B choose the Campaign Medium drop down and copy and paste this code into the available field -
14. In Output To -> Constructor choose the Custom Field 1 drop down and copy and paste this code into the available field -
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 -
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.
That’s a wrap! Your AdWords Keyword Data is now EXPOSED, NAKED, IN THE BUFF, NUDE, or whatever you want to call it!
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!
If you enjoyed this post, make sure you subscribe to our RSS feed or get email updates whenever we post anything new!
AdWords/Analytics Keyword Data Fix - Thanks Jeff!
Per ROI Revolution's request, here are the credits for this post - at the top instead of the bottom: If you have any questions, you...
UPDATE: ROI Revolution Updates AdWords/Analytics Exact Data Script
Getting Conversion Data With Your New Analytics Profile
A few people emailed/posted a great question about finding the conversion data with the new filters you added to your Google Analytics profiles we discussed...
Hooray! Detailed Keyword Data Is Available Again!!!!
A buddy just emailed me to say that his Google Analytics advanced filters were working again to expose the detailed search queries of AdWords visitors!...