Hiren Ponkia

Google Analytics Hack For Export All Your Keywords

HirenPonkia

Today I was checking traffic data for a client from their Google Analytics account and wanted to see what keywords were driving the traffic for them and those which weren’t. It is large site and millions of visits per month and thousands of visits come from Long-tail version keywords. I wanted to export all that keywords to see different keyword data trends.

Now Problem with Google Analytics is that you can export only 500 Results once. So I have to export Keywords in group of 500 many times to export all keywords and that is bit time consuming.

After Searching Google Analytics Help Forums and Groups; Finally I had learn how to export all keywords together.

Steps for export up to 50,000 Keywords from Google Analytic:

  1. Log into Google Analytics Account.
  2. Select the domain you wish to check.
  3. On the left click on Traffic Sources, then Keywords.
  4. Add the words “&limit=50000″ to end of URL in browser address bar and hit return.
  5. Click the “Export” button and then choose CSV.
  6. Open in Excel and have fun.

Google Analytics has a hard maximum built-in limit of 50,000 for each and every data type, including URL’s under Top Content, Keywords under Traffic Sources, etc. If you want to export more than 50,000 Results than following is tricky steps.

Steps for Export more than 50,000 Keywords from Google Analytics:

  1. On the left click on Traffic Sources, then Keywords.
  2. Insert “49990” at in “Go to” field at right bottom of Google Analytics page and press Enter; then GA would show you the page.
  3. Add the words “&limit=50000″ to end of URL in browser address bar and hit return. Now you get the next 50,000.
  4. Click the “Export” button and then choose CSV.

Update: Arjan Snaterse made this process automated. He wrote a small greasemonkey script which automatically adds the limit parameter to the URL. And so you will have 50,000 rows in your export data within once click. You can install the script from here. Thanks Arjan 🙂

Image Credit : Arjan Snaters

[NOTE: Since systems change frequently, if the steps above are not identical to what you see in Google Analytics if you will leave a comment or use the contact form they will be updated to match the current system. Your assistance in keeping these how-to tips accurate will help many others and their assistance may help you. Thank you.]