AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
4.4K members online now
4.4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Downloading more than 5K data points at 1 time?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Is there a way I can export more than the maximum amount of rows (5K) from GA? I have 85K data points and I am trying to avoid having to do this manually. Thank you.  

Re: Downloading more than 5K data points at 1 time?

Follower ✭ ✭ ✭
# 2
Follower ✭ ✭ ✭
Either a) pay $150K for unsampled report dowloads in GA premium.

b) Page $15per month for Batch reporting via Supermetrics plugin for GoogleSheets:
https://analytics.googleblog.com/2016/06/get-facebook-bing-twitter-more-into.html
http://supermetrics.com/blog/#!ga-data-grabber-can-now-avoid-google-analytics-data-sampling

c) Manually setup the batches and then manually combine using GoogleSheets (I dont think DataStudios support the "start-index" field, so you have to use GoogleSheets)
samplingLevel=HIGHER_PRECISION
start-index=1
max-results=10000

start-index=10001
max-results=20000

start-index=20001
max-results=30000

etc...

https://ga-dev-tools.appspot.com/query-explorer/
https://developers.google.com/analytics/devguides/reporting/core/v3/reference#startIndex

Hope that helps!

Cheers

Phil.