How to export ALL keywords to excel? Can only do 500 at a time :/

[DiscoStu]

I guess this is the first time I've ever tried to export ALL traffic generating keywords for a site, because I'm noticing that I can't figure out to export more than whatever is displayed on the page (which is a max of 500). I have 30K keywords on several of my sites, is there a way to export all keywords to csv file?

[DiscoStu]

Found the solution. There's an analytics hack where you append "&limit=50000" at the end of the traffic source > keywords report. I found that the limit is 20K that can be exported at once (it doesn't change what you see, only what you can export - and you have to use export to csv, not csv for excel). This way it's possible to export 20k keywords at a time, then just go to keyword #20 000 and export the next 20k etc

[Receptional]

Glad you found an answer DS.

Next time you post, if you could avoid assuming this forum is about one analytics system and let us know what you are using, that would help to get a more accurate reply.