I understand I can trawl through my log files, but I am wondering if there is a more efficient way and also that the correct search queries are triggering the correct keywords.
Actually, it's two filters. So first you want to create a new profile that uses the same domain.
Then create your first filter - call it AdWords Search Query 1
Filter Type is Custom
Select the Advanced radio button
In the Field A -> Extract A row, select Referral for the first field, and type in (\?¦&)(q¦p)=([^&]*) in the second.
In the Field B -> Extract B row, select Medium for the first field, and cpc¦ppc for the second.
In the Output To -> Constructor row, you want Referrals in the first field again, and $A3 in the second.
The next three radio buttons are all set to Yes, and Case Sensitive is set to No.
Save your Changes.
Now create AdWords Search Query 2
Again the filter type is a Custom Filter, set to Advanced.
In the Field A -> Extract A row, the first field is Referral and the second field type in (.*)
In the Field B -> Extract B row, the first field is Campaign Term and the second is (.*)
In the Output To -> Constructor row, the first field is Campaign Term and the second is $B1, ($A1)
Again, next three radio buttons set to Yes, and the last one set to No.
Then add them to the profile that you just created. Make sure that you have them in the correct order, with #1 coming first and #2 coming second.
After a day, you can go into your Analytics, select that you want to see the paid keywords, and the actual keyword typed in should show up in parentheses next to the one listed in your AdWords account.
[edited by: engine at 9:31 am (utc) on Aug. 12, 2008]
That happened to me once when I first got started with GA, before I learned how the filters worked - I accidentally excluded like *all* data when I was just trying to keep my own visits out - so I learned the hard way.
Plus in some cases, I have filters that overlap usage of the fields - i.e. I might use a field for X in one filter, but I need to use it for Y in another.
And regardless, I always keep one profile with absolutely no filters on it whatsoever.
At one point, I ran up against a 50 profile limit - dunno if that has been lifted, but I've never come close to that since, so it hasn't really mattered (I was just testing some stuff when I ran into it)
I have just set up a filter to consolidate image search traffic, after many years of webmastering I still don't grok regexpes...
Hoping this will do it:
Filter 1: Custom / Include / Referral ^http:\/\/images\.google\..*$
Filter 2: Custom / Advanced
Field A: Referral / ^http:\/\/images\.google\.(.*)\/(.*)$
Field B: None
Output: hxxp://imagefilter.google.com/$A2
Settings: Y / N / Y /N