How to Export All Your Keywords from Google Analytics

Last month Google introduced a “solution” to export all of your keywords from Google Analytics. It’s not a solution, it’s a hack. The good news is the hack works and you can (finally) export all of your keywords to CSV for sorting and filtering in Excel.

How to get your keywords out of Google Analytics:

1. Login into Google Analytics
2. Click “view report” for your domain
3. Click “Traffic Sources”
4. Click “Keywords”
5. Copy this: &limit=5000
6. Go to the address bar in your browser and paste &limit=5000 at the end of the URL
7. Press “Enter” (“return” on the Mac) to reload the page
8. Click “Export” in Analytics
9. Click “CSV”
10. Done!

Long and stupid? Yep. Like I said, this is a hack not a solution. This feature should be built into Analytics because it’s a task most SEOs need to do.

What if you have more than 5000 keywords?

No problem – just change 5000 to the number of keywords your site has (but don’t include commas). However, there is a maximum of 50000 keywords. If you’re site has more than 50000 keywords, (congratulations!) you can still use the &limit=50000 hack. But, you’ll have to make a couple of other tweaks. Check out this blog for more info.

Don’t Use Firefox on PC

I love Firefox. It beats the crap out of Internet Explorer in every possible way. However, there seems to be a problem with using the Firefox on a PC and the &limit=5000 hack. I could not get it to work on my PC. If you have this problem, I’m very sorry, but you’ll have to switch to Internet Explorer to get  your keywords… Terrible. I know.

No related posts.