How to export keyword and URL from Google Analytics?

Hi all!

On Google Analytics, I recently learned that I can get the list of keywords used by visitors to find my website on the Search Engines. But I could not find a way to export the terms used together with the landing page.

If it's possible, the Search Engine used and the timestamp are a plus, but not even the first data I've managed to find over the various menu items that Analytics has. From what I've seen, this data exists, but scattered over several different parts.

I am looking for something like this:

keyword1 http://example.com
keyword1 http://example.com/page.html
keyword2 http://example.com/page.html
keyword3 http://example.com/another_page.html

Code (markup):

Bonus if it does (time and SE):

keyword1 http://example.com 2006-06-08 14:32:05 Google
keyword1 http://example.com/page.html 2006-06-08 14:35:47 MSN
keyword2 http://example.com/page.html 2006-06-08 14:48:23 Google
keyword3 http://example.com/another_page.html 2006-06-08 15:01:30 Google

Code (markup):

Anyone knows if Analytics can export data like the previous example?

Muchas gracias,

 

The trick is to get the data you are interested in to show, then click the "Export" link.

If you select
Marketing Optimization
->Search Engine Marketing
-->Overall Keyword Conversion

You'll get the list of keywords and the other data shown on that page.

I don't know how to get the exact dataset you listed, but one thing you can do is :

Content Optimization
-> Navigational Analysis
--> Initial Navigation

Click the red button next to the page in the list you are interested in, and select to Cross Segment Performance -> keywords

That will give you the list of keywords people used to land on that particular page on your site. You can then click the "Export" button (looks like a T) at the top of the data window to export the data.

(If anyone knows how to list all of the urls together, I'd be interested in learning how)

 

To get the keyword summary:

Marketing Campaign Results
-> Search Engine Marketing
--> Overall Keyword Conversion

I haven't been able to go from that to the URL landing pages, though.