How to Get Detailed PPC Keyword Data from Google Analytics
Google Analytics, Hacks and Tools Add comments
At GA-Experts, we also provide PPC Management services through our parent company Omega Digital Media, so we are continually looking at ways to improve the data that Google Analytics provides about a PPC campaign. With this in mind we have developed a new filter that shows exactly the Search Term (i.e. keywords that are searched on) rather than just the Bid Term (i.e. the keywords that triggered a PPC advert).
For example, if a visitor searches for “sony digital camera” and you have an ad configured for the keywords “digital camera” as a Broad Match in Google AdWords, then this search will show your ad. But in your GA reports, the keywords for this search will be reported as “digital camera“. Whilst this gives you good data on your Bid Term, it doesn’t help you refine your keyword triggers because the reports don’t show the actual Search Term.
If you use our Override Bid Term Filter then the same search will show “digital camera, (sony+digital+camera)” in any Google Analytics report that shows keywords (e.g. Marketing Optimisation -> Search Engine Marketing -> Overall Keyword Conversion) or any time you cross-segment against keywords.
This data now allows you to fine-tune your PPC campaigns by getting greater detail from your GA reports. In the example above, if the ‘sony+digital+camera‘ search is a frequent one, you might consider creating an Exact Match advert that took visitors to a dedicated Sony landing page. Or replacing the Broad Match ‘digital camera‘ term with a more precise ‘sony digital camera‘ Exact Match to increase your clickthrough rate.
There’s lots that can be done to optimise a campaign using this filter, so please see below for configuration instructions:
1) Create two filters as per the images here:
Override Bid Term 1 & Override Bid Term 2
2) Create a new profile for your existing site. This keeps the detailed keyword data in a separate profile. You can apply this filter to your main profile(s) if you prefer, but a separate profile allows for continuity and top level reporting in your main profile with keyword detail available as required.
3) Apply the two filters to the new profile, in the order Override Bid Term 1 *then* Override Bid Term 2
You can now view detailed Search Term data from any GA report that shows keyword information. Please let us know any feedback via the blog comments, or email at mail@ga-experts.co.uk.
November 3rd, 2006 at 9:18 am
Jim,
This is *brilliant*. Bravo!
Timothy
November 17th, 2006 at 2:44 pm
This is so lovely. I read this a week or more ago and finally had time to implement for a customer. Thank you for the screen shots, they make it trivial.
Robbin Steif
LunaMetrics
December 7th, 2006 at 11:08 am
This is great stuff guys. I really like the referrals post too. I have been looking for these stats for a while. Previously I had to take the strain of outputting it through burny raw log files.
This really takes GA up to another level. The extra keywords keywords are great for refining adwords campaigns and I am about to setup an affiliate campaign for a client, so looking at the referrals from the Google content network is a great way for targeting websites who are commercial aware and could potentially be great affiliates.
Keep up the good work…
If only I knew how to create a filter so I could see stats for Robots/Spiders …hmmm…
December 7th, 2006 at 11:39 am
Thanks Joe. Just a quick point - you won’t see search engines or spiders in GA reports as in order to be logged by GA as a site visitor you need to process the JavaScript page tags. At the moment, despite rumours to the contrary, we don’t believe there are any SE spiders that can process JavaScript (processing power, security issues, etc.) - but in the future who knows…
January 10th, 2007 at 7:09 pm
hello there. thanks so much for the helpful tips on this. Is it possible to ask one question?
in the ‘override bid term 1′ filter the output to constructor is a custom field 1 with a varible called $A3.
in the override bid term 2 filter the output to constructor is a campaign term with the regex of: $B1,($A1). Is this a typo or should the regex be: $B1,($A3) to match the variable in filter 1 above?
sorry for the question. i am new to this.
appreciate it very much!
jay wilner - out of bounds
January 10th, 2007 at 7:10 pm
thanks for the help on this. one question. in the override bid term 1 filter, you have the output to-> going to $A3. Is this supposed to be $A1 to match that term in Override Bid term 2 constructor? just checking, i dont know this stuff too well. or do we just follow exactly like you have it? thanks again!! jay wilner - out of bounds
January 10th, 2007 at 7:11 pm
Great writeup guys! So many analytics available to us now, and its good when we’re able to combine processes to drill down into the real value of stats.
April 2nd, 2007 at 4:42 pm
Sorry this doesnt work for me, Ive put the code of every page of my site (for the new profile) - analytivs is showing as receiving data - but theres nothing in my reports not even a single visitor for the last 4 days which is totally wrong.
can anyone help me?
thanks in advance
April 2nd, 2007 at 4:42 pm
The filter is correct - and working for this site.
$A3 relates to the matching in the regular expression. It is not stored in the filter.
HTH
August 18th, 2007 at 12:43 am
[...] GA-Experts » Blog Archive » How to Get Detailed PPC Keyword Data from Google Analytics (tags: google+analytics) [...]
August 30th, 2007 at 10:22 pm
This is really great. Thank you for taking the time to share it!
October 29th, 2007 at 11:06 pm
I’ve been looking for this kind of solution for a long time. It only took a couple minutes to set-up and the detailed keyword tracking is perfect. The data on broad matches are already showing areas that need to be adjusted. By the way, the link from ROI Revolution is linking to a 404ed page.
Thanks for the filter.
Adam
November 2nd, 2007 at 3:55 am
I installed the filters and they work great! Only problem is that they don’t appear to be able to track conversions. Anyone have any luck figuring that out?
Great hack none the less.
November 3rd, 2007 at 3:56 pm
Hi,
Great tip, but I can’t get it to work! I installed and applied the filters, but can’t see the ‘raw’ search terms … (Eg. in ‘Traffice Sources -> Keywords’) Do i just have to be patience or am I doing something wrong?
Thanks, Bas.
November 3rd, 2007 at 10:27 pm
Never mind, patience is not my thing I suppose ..
It works great, just what I wanted to see! Thanks!
January 28th, 2008 at 1:23 am
I tried the code above (double checked everything) but I am not getting the detail information. I suspect similar problem as to Ingo’s - we are also running on the new GA code… Anybody else having problems with this?
January 28th, 2008 at 8:49 pm
[...] 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 [...]
February 4th, 2008 at 9:09 pm
Like Paul, I can’t seem to get this to work. Have you identified any account configuration issues that might explain the problems we are having? Thanks for publishing the technique! If I can get it working it will be very powerful. — Jaimie Scott
February 11th, 2008 at 12:31 pm
We’re seeing exactly the same thing happening. We have this code running on 10 of our clients accounts and all the data has stopped being reported on all the accounts.
We’re running the old .js code on these accounts.
February 14th, 2008 at 7:20 pm
Same thing here…had this filter working on several client accounts and then Jan. 8th hit and it no longer works. Something definitely happened that day…
February 14th, 2008 at 7:45 pm
I have heard that Custom Field 1, which is used in this filter, became read-only on January 8th. Looks like this filter may be out of commission.
February 18th, 2008 at 7:53 am
Hi Tyson,
yes, the same here. The filter worked without any problems until Jan 8th. After that all data turned into “not set”.
Do you have any statement from Google that there was a change on custom field?
February 19th, 2008 at 7:17 pm
Anyone know if this can be fixed?
February 21st, 2008 at 10:59 am
This is the response I received from Google so far:
“The filters are not officially supported by Google. That’s why we cannot offer any support here.
Please check whether the auto tagging function in Google AdWords is enabled and that cost data is applied to the Google Analytics profile.”
That hasn’t solved my problem since both check boxes are checked. It would be good to get in touch with somebody where the filters still work in order to compare settings. Any volunteers?
May 9th, 2008 at 9:41 am
Nice information, GA is a excellent tool.
can any one provide me detailed information about MIVA