Welcome to WebmasterWorld Guest from 34.226.234.20

Forum Moderators: buckworks & eWhisper & skibum

Message Too Old, No Replies

Best Way to See AdWords Search Query

New Search Query Report lists mostly "other queries"

     
10:56 pm on Aug 6, 2007 (gmt 0)

Junior Member

10+ Year Member

joined:June 27, 2007
posts:63
votes: 0


What's the best tool to see every search phrase that was entered associated with an AdWords campaign that cost you a click charge?

My traffic is manageable enough that I would like to see them all.

Google's new Search Query Report shows a few and lists the majority as "other queries" What use is that?

10:52 am on Aug 7, 2007 (gmt 0)

Preferred Member

10+ Year Member

joined:Aug 19, 2006
posts:524
votes: 0


Analyze your server log files. You'll get some information in the referer details there that is not listed in the Search Query report.
2:14 pm on Aug 7, 2007 (gmt 0)

Junior Member

10+ Year Member

joined:June 27, 2007
posts:63
votes: 0


Thanks Rehan

Is there a way to get more detail?

I have a client who is trying to run a campaign that is rather unusual with negative keywords.

Say they sell "Britney Spears Apples" but they recently got a legal spanking for using the term "Britney Spears" They want to come up for searches of "Britney Spears Apples" without actually buying that term. Instead they want to buy "Apples" and try to negative out all the other terms "green apples" "washington apples" etc.

I know that Google would allow them to buy a trademarked term...just can't use it in their ad text. But they don't care about Google. They don't want to take the chance of being sued again.

So the question becomes how can I get good detail on every search phrase so I can start to negative out everything but "Britney Spears Apples"

Thanks

2:28 pm on Aug 7, 2007 (gmt 0)

Full Member

10+ Year Member

joined:Dec 8, 2004
posts:338
votes: 0


Check out the new Search Query Performance report

More details here -
[adwords.blogspot.com...]

2:48 pm on Aug 7, 2007 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Aug 27, 2002
posts:770
votes: 1


BigAdventure,
with a little PHP you can solve this quite easily:

Call an include file from within your landing page. Lets call it tracker.inc
tracker.inc writes to a text file with date/time, ip-address, and referer into a logfile (testlog.txt).
Don't forget to set write permissions for the log file.
Code for tracker.inc is here:

$timestamp=date("Y/m/j H:i:s");
$addr=getenv("REMOTE_ADDR");

$ref=getenv("HTTP_REFERER");
$myfile="/testlog.txt";

$fd=fopen($myfile,"a");

$success=fwrite($fd, $timestamp."".$addr."".$ref ."\n");
fclose($fd);

The textfile you can import into MS Excel and select all lines beginning with http:// www .google .tld/search?hl=en
Do a Text to columns conversion by using & as delimiter.
Next you get a column where the data beginns with q= and the original query.

I know, it is a little complicated, but it helps me in finding the real search phrases.

2:11 pm on Aug 8, 2007 (gmt 0)

Junior Member

10+ Year Member

joined:June 27, 2007
posts:63
votes: 0


Thanks online

But PHP is probably beyond my skill set. Doesn't your whole page have to be in PHP to use that?

I really need something though. I just did a search query report for one campaign, and out of 32 searches, 23 are the so-called "other unique queries. Since the others were all my narrow search phrases, I would assume those "other unique queries" are probably the garbage that I need to negative keyword.

2:28 pm on Aug 8, 2007 (gmt 0)

Senior Member from US 

WebmasterWorld Senior Member netmeg is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Mar 30, 2005
posts:13012
votes: 222


Doesn't your whole page have to be in PHP to use that?

No, it doesn't.

Copy it just like this into your .html page:

<%
$timestamp=date("Y/m/j H:i:s");
$addr=getenv("REMOTE_ADDR");

$ref=getenv("HTTP_REFERER");
$myfile="/testlog.txt";

$fd=fopen($myfile,"a");

$success=fwrite($fd, $timestamp."".$addr."".$ref ."\n");
fclose($fd);
%>

If you have a lot of traffic, that file could get pretty big, though.

2:34 pm on Aug 8, 2007 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Aug 27, 2002
posts:770
votes: 1


If you have a lot of traffic, that file could get pretty big, though

for my main site I download the file daily, forthe smaller sites on a weekly or monthly basis. After downloading, I delete them on the server and the next visitor creates the new file.
2:37 pm on Aug 8, 2007 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Aug 27, 2002
posts:770
votes: 1



Doesn't your whole page have to be in PHP to use that?

No, it doesn't.
Copy it just like this into your .html page:

Provided that PHP is running on your server and setup in such a way, that files ending with .htm or .html can execute it.

3:02 pm on Aug 8, 2007 (gmt 0)

Senior Member from US 

WebmasterWorld Senior Member netmeg is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Mar 30, 2005
posts:13012
votes: 222


Opps, yea, I forgot that part, it's such a default for us I forget other people aren't necessarily set up that way.
5:07 pm on Aug 9, 2007 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 2, 2006
posts:2241
votes: 8


A Search Query Performance report does what you want. It will show you exact keywords which triggered clicks onto your ads. One fact is that many of these queries will fall under "other". I guess that for various reasons, they cannot pull every single keyword. I am hopping to see that improving over the time.
1:48 pm on Aug 10, 2007 (gmt 0)

Junior Member

10+ Year Member

joined:June 9, 2006
posts:45
votes: 0


If you can set it up then do your own web server log analysis to get this data. We find that it is much more precise than google's Search Query Report.
1:57 pm on Aug 10, 2007 (gmt 0)

New User

10+ Year Member

joined:May 18, 2006
posts:40
votes: 0


Why not use Google Analytics? You can extract the search term from the referrer with a simple regex and place it the user defined field. Provided the tight integration with adwords you'll be able to drill down on campaigns, adgroups, keywords and even the exact search phrases for each keyword. If you opt to import adwords cost data and enable e-commerce then you can even analyse roi down to the exact search phrase.
2:02 pm on Aug 10, 2007 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Aug 27, 2002
posts:770
votes: 1


more precise than google's Search Query Report

Yeah, the SQR needs a lot of improvement

do your own web server log analysis to get this data

This is the preferred way to do things, but sometimes, depending on the analytics software you use, you don't get everything you really want or you get even too much.
I for my part use analog as an analysis tool. Although it is a little bit old fashioned when you want to configure it via a text file, it gives me the possibility to even analyze a single page over a longer period. Just exclude all pages and include the page you want to analyze.
In case you have a landing page that only receives ppc traffic and is not linked from within your site and is not listed anywhere in the SERPs, you could go this way.
I prefer my little script from above (in an enhanced version) as it also gives me the possibility to track which ad the click was coming from.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members