No download limit for Google Analytics export, part 2

Useful stuff! Although the limit for exporting is 20,000 rather than 50,000 so I edited the script once I installed it. Works like a charm :)

@wendy: maybe it’s different per account? I can download untill 50,000 rows per time.. Anyway: have fun with the script :-)

Do you know if it is possible to do the same for the ad report on Adwords interface? I’m interested in getting the %served information that it is only available on the ad tab on Adwords interface but not available via Adwords reports

http://8289b2.tempopage.com/example.jpg

@hachefe: I don’t think I understand your question.. Do you want to have an export functionality itself in the Adwords reports, or is there a limit to these reports that you want to “remove”?

(Sorry, I’m not that familiar with Adwords)

@arjan: there is a limit on these reports on Adwords similar to the one that you have on Analytics; I would like to remove this limit, if possible.

Here you have an example of the amount of rows that I would like to load and export:http://8289b2.tempopage.com/example2.jpg

Here you have an example of the URL that I would like to modify to show all rows in one page and export them: http://8289b2.tempopage.com/example3.jpg

@hachefe if there’s a way to remove the limit through the URL (which is the case in GA), the I guess it would be possible to make a same script for Adwords.

However, I’m quite busy at the moment and I don;t have the time to create/adjust such a script.

Off course you are completely free to adjust this script to which you want..

In GA site it says there’s a daily quota of 10000 limit. Is there any paying extras to GA or it’s completely free.

@Jopicarra I don’t know the limit of 10,000 a day. And in my account I can just download what I need, limited by 50,000 rows a time with this script.

Sorry Arjan I was mixing things, the daily quota is for the Google Analytics Data Export API.

http://code.google.com/intl/en/apis/analytics/docs/gdata/gdataDeveloperGuide.html

I don’t see any way to “run” the script. How are you supposed to get the script to engage with the Export links of Google Analytics? Is there supposed to be a right-click context menu selection? Thanks.

Hi Jerry,

You should install the Firefox extension ‘Greasemonkey‘ first.

When you’ve done that you can just download the files you need just like you did before.

Good luck!

I discovered what the problem was…

Analytics > Traffic Sources > Keywords > Export

Turns out you MUST NOT select “CSV for Excel”.
However, it works if you select TSV, or plain CSV.

Greasemonkey – installed and enabled.
GA Download Limit Remover – enabled.

@Jerry: thanks for this addition

someone can tell me how to edit js after installed? couldn’t find it
I also need to change limit from 50k to 20k

thanks

Hi Paolo,

You can right click on the Greasemonkey icon in the statusbar and choose “MAnage user scripts”. Then select this script and click the Edit button on the bottom of this popup.

That should do the trick ;-)

Thanks Arjan, everything OK, great script

Thanks ;-)

Hello, I have installed your script, I have already installed Greasemonkey a I have allowed to work in GA, but I´m getting this error when I am trying to Export.

There´s no several rows with 0-50.000 or 50.000 – 100.000 options, but only one and it´s ending with Result 0 – NaN.

Any sugestions what´s the problem?

@Thomas: on what page do you exactly use the script? I can’t reproduce it right now, but maybe we’re on a different page..

You can also mail me for details at: arjan {at} uprise {dot} nl

Thomas,
if you get “Result 0 – NaN.” it is because you just need to modify the function “getNrRows” :

var rows = rows.replace(/[\.,]/g, “”);
must be
var rows = rows.replace(/[\.,( )]/g, “”);

That’s all :-)

Problème with my message it must be
var rows = rows.replace(/[\.,(& n b s p ;)]/g, “”);
(without space for the & n b s p ;)

Arjan: I´m trying to export data about content, so it´s all in “Content”, e.g. Top Content or Content Drilldown. But it didn´t work for me in “Visitors” (keywords) neither.

Guillaume: Thanks for the tip. I´m not dev guru type of guy, so everything I could do, was remove original script, download it from here, edit with your tips, upload to my website and the manually install it to Greasemonkey/Firefox but after that the script didn´t work at all. No “NaN” error, no word at all. Have you upload your version of script to your website, from where I can try it?

Hi guys,

I’m a bit busy right now, but I’ll try to look into it as soon as possible!

Arjan

Hi Arjan,

Great script!!! This is super useful. I was able to pull all keyword data for a site that brings in over 500,000 unique keywords a month :)

One thing I was wondering if you could help improve the script, it seems to only work when you are viewing all keywords with Show: Total selected in GA and Site Usage tab selected. I’d like to select the ecommerce tab and Show just non-paid keywords. Do you know what needs to be tweaked in order for the list of each report rows to show when I select export in that view. When I view non-paid and ecommerce keywords and click export, I just get the standard options for exporting.

Thanks!
Andrew