Forum Moderators: buckworks & skibum

Message Too Old, No Replies

Google Search Queries

         

dane120

3:06 pm on Aug 4, 2008 (gmt 0)

10+ Year Member



Other than the search query report what do other advertisers use to understand the real search queries which are triggering your keywords and adverts?

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.

netmeg

3:57 pm on Aug 4, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



Are you running Google Analytics? I have a nice little filter that does it.

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]

dane120

4:13 pm on Aug 4, 2008 (gmt 0)

10+ Year Member



Thanks for this Nutmeg, I will give this a go and keep you posted.

arieng

6:00 pm on Aug 4, 2008 (gmt 0)

10+ Year Member



Hey Netmeg - Why are you creating a new profile for the domain? What is the downside of adding these filters to the existing profile?

netmeg

6:29 pm on Aug 4, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



I *always* create new profiles for the domain, and I maintain one profile with absolutely no filters. Because if you typo something or the filter doesn't work properly, you don't get that data back. It's gone.

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.

arieng

6:46 pm on Aug 4, 2008 (gmt 0)

10+ Year Member



Ahhh - very smart. Do you merge together your 'tested' filters or just keep them seperate in a long list?

netmeg

8:21 pm on Aug 4, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



I merge some of them - like the ones that exclude myself and my partners, and the ones that exclude the clients if I have their IP information. For the rest, I just keep them separate.

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)

caribguy

3:34 pm on Sep 21, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Thanks Netmeg for pointing me in the right direction,

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

cyberandroid

5:38 am on Sep 22, 2008 (gmt 0)

10+ Year Member



wow netmeg you are the best
it took me about an hour to realize how much work your scripts will save me

cyberandroid

10:53 am on Oct 6, 2008 (gmt 0)

10+ Year Member



whats the differance between this [semvironment.com...] and your script netmeg?

netmeg

5:00 pm on Oct 6, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



Looks like essentially the same thing.