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

[Sgt_Kickaxe]

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 ?

[tedster]

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.

[aakk9999]

Statcounter can give you this info

[lucy24]

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.

[Planet13]

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.

[Planet13]

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.

[indyank]

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.

[tangor]

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)

[100up]

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)