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

Google Analytics Sheets Add-On Date Range Dimension

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello All:


I am using the Google Sheets Analytics Add-On to re-create a report that my organization had been manually compiling in Excel, based on data they were copying and pasting into their spreadsheet from Google Analytics UI. I've managed to recreate that spreadsheet through the Analytics Add-On, tying to their old numbers (except where their old numbers had errors) - re-creating just one row from that spreadsheet - where one row represents a date range.


I'd like to now run that analytics report for every date range in their spreadsheet, there are about 100 of them - but I'd like to do so without having to type in the date ranges into the 'start' and 'end' fields in the report configuration tab. Is there any way that I could add date-range as a 'segment', so that each range is returned in a unique row (i.e. there'd be a column at the begining of the returned report with date range, my other dimension column (only 1 dimension in this report), then all my metrics columns)?


Below is an example of the report now - I want to replace that start and end date reference somehow moving it into a dimension - perhaps then modifying the start end date to encompass all date ranges in my set.


If this isn't doable, is there perhaps a way to script this so that the report loops through start/end date based on some other sheet that holds those start-end dates? 




Report Namega:userType
View (Profile) ID / idsga:64465530
Start Date2/23/2016
End Date2/29/2016
Last N Days 
gaSmiley TongueercentNewSessions
gaSmiley TongueageviewsPerSession



Marked as Best Answer.
Accepted by topic author Tyler H
May 2016

Re: Google Analytics Sheets Add-On Date Range Dimension

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭
I ended up doing this manually. Please disregard.