Data Studio
2K members online now
2K 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.