Video Tutorial: Hacking Google Analytics for Keyword Research
"Ask and ye shall receive," and by ask I mean set up a couple custom filters that will expose this data to you. I will be so bold to say that if you can not see exact keyword referrals you have no business using the broad match type! (
I decided to screencast the set up process for a few reasons.
1) To share this tip again with our new readers (we've almost doubled in readership last summer) and remind those who have put off adding the filter to set it up ASAP.
2) To show you how quick and easy this is and provide you with a resource (printable PDF) that will give you the confidence that you can set this filter up yourself!
3) To show you how to find your data in Google Analytics by AdGroup, so you can add apply the appropriate negative keywords at the Ad Group level.
If you bear with me to the end, I share some of the crazy matches we've been getting for the Vancouver 2010 Olympic store's broad matched keywords. You'll see why I value this information so much!
Can't see video? View it here.
Download "Cheat Sheet" Instructions (PDF)
Cut and Paste Values:
As with almost all multi-part filters, sequence is critical and must be ordered accordingly using the “Assign Filter Order” page for the profile.
Field A -> Extract A: Referral: (\?|&)(q|p|query)=([^&]*)
Field B -> Extract B: Campaign Medium: (cpc|ppc)
Output To -> Constructor: Custom Field 1: $A3
Field A -> Extract A: Custom Field 1: (.*)
Field B -> Extract B: Campaign Term: (.*)
Output To -> Constructor: Campaign Term: $B1 ($A1)