Welcome to WebmasterWorld Guest from 54.205.115.177

Message Too Old, No Replies

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

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

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



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)

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



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)

WebmasterWorld Administrator 5+ Year Member Top Contributors Of The Month



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

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



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)

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



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)

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



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)

WebmasterWorld Senior Member 5+ Year Member



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)

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



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)



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)