Welcome to WebmasterWorld Guest from 54.225.58.238

Forum Moderators: Robert Charlton & aakk9999 & andy langton & goodroi

Message Too Old, No Replies

Need search terms used and resulting url, Can analytics help?

     
1:55 am on Aug 3, 2011 (gmt 0)

Senior Member

WebmasterWorld Senior Member sgt_kickaxe is a WebmasterWorld Top Contributor of All Time 5+ Year Member

joined:Apr 14, 2010
posts:3169
votes: 0


I need a list, preferably xml or csv, of all the keywords used by visitors coming from search engines as well as the url they landed on. I can build a function to capture this data but before I do I wanted to know - does Google analytics provide this data already?

I've searched and I can find loads of keyword data and loads of url data but it seems there isn't any 'this keyword led to this page' data, unless I missed it. Is there a list I can download in there with BOTH keyword used and url landed on ?
8:43 pm on Aug 3, 2011 (gmt 0)

Senior Member

WebmasterWorld Senior Member tedster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:May 26, 2000
posts:37301
votes: 0


This can be tough data to tweeze out of Google Analytics - and other commercial analytics packages as well. Seems like part of the problem is because one query phrase can send traffic to different URLs, so it's no longer a 1-to-1 model.
8:53 pm on Aug 3, 2011 (gmt 0)

Moderator This Forum from GB 

WebmasterWorld Administrator 5+ Year Member Top Contributors Of The Month

joined:Apr 30, 2008
posts:2599
votes: 179


Statcounter can give you this info
9:39 pm on Aug 3, 2011 (gmt 0)

Senior Member from US 

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

joined:Apr 9, 2011
posts:13210
votes: 347


The information is easy to extract from your raw logs. Or, if you're only concerned with *that* search engine, from GWT. (The stuff you get if you download, not what you see onscreen.)

Seems like part of the problem is because one query phrase can send traffic to different URLs

Or: one query phrase can bring up more than one of your pages in search results, so it's the user's choice which one to grab.

The assumption is that most people will take the first one they see. So... Under what circumstances would a user go for a page that isn't the highest-placed one for that particular query? Is there something wrong with that page? Or with its snippet text? Is the search engine not doing a good enough job of reading the user's mind? Was the search itself imperfectly worded?

If people are ignoring your top-ten page and homing in on your #28-ranked page for the same query, you definitely want to know about it.
5:45 am on Aug 4, 2011 (gmt 0)

Senior Member

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

joined:June 16, 2010
posts:3813
votes: 29


I am not sure this is what you want or not (maybe it won't show ALL the landing pages when you have a single keyword showing multiple pages from your site).

But in GA if you click on Traffic Sources, then Keywords, you will of course get a list of the keywords used.

Then there are a couple of small drop down menus that are right under the Visits and Pages/Visits headers. One of the drop downs will already be set to Keywords.

Click on the second drop down (which by default says None) and then change it to Landing Page.

Anyway, I THINK this is what you were asking for.

Hope this helps.
5:51 am on Aug 4, 2011 (gmt 0)

Senior Member

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

joined:June 16, 2010
posts:3813
votes: 29


BTW: Seems to work well even when a single keyword will result in more than one landing page. Sort the results alphabetically by keyword and you will see the different URLs clearly listed.
6:17 am on Aug 4, 2011 (gmt 0)

Senior Member

WebmasterWorld Senior Member 5+ Year Member

joined:Mar 9, 2010
posts:1806
votes: 9


Yes, Planet13 is right . This information is directly available in google analytics unless you meant something else.

Traffic sources --> keywords and choose landing pages as the second filter. But I think you can export only 500 rows at a time.
7:40 am on Aug 4, 2011 (gmt 0)

Senior Member from US 

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

joined:Nov 29, 2005
posts:6964
votes: 385


Work smart... that info is in raw logs, which should be a part of hosting. Parse it out (I use Access and custom written queries) but use whatever works. The data is there. What to make of that data come from contemplating naval lint. (No Magic Bullets)
2:35 pm on Aug 4, 2011 (gmt 0)

New User

5+ Year Member

joined:Mar 18, 2011
posts:16
votes: 0


But I think you can export only 500 rows at a time.


If you add &limit=x to the end of the URL and export using CSV (not for excel) you can get as many as you need (x)