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

1.8K members online now
Understand information in your reports and troubleshoot reporting issues such as self-referrals, (not set) data, and inaccurate information
Guide Me

Exporting more than 5000 rows of data

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

is there a way to export more than 5000 lines without any add-ons? I only have limited access to the Analytics account and I can't access their drive to add the add-ons

1 Expert replyverified_user

Exporting more than 5000 rows of data

Rising Star
# 2
Rising Star

Without add-ons I don't think this is possible - time was you could hack the request URL but this no longer works :-(

Are add-ons definitely not an option? I thought the google sheets google analytics add-on only requires read and analyze (sic) access? You could try testing it anyway. The API imposes a 10 000 row limit. 

John Wedderburn, Advertiser Community, Rising Star
Was my response helpful? If yes, please mark it as the ‘Best Answer.’ Learn how here.