Analytics
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
star_border
Reply

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
Typecore
View (Profile) ID / idsga:64465530
Start Date2/23/2016
End Date2/29/2016
Last N Days 
Metricsga:newUsers
gaSmiley TongueercentNewSessions
ga:sessions
ga:bounceRate
ga:goalCompletionsAll
gaSmiley TongueageviewsPerSession
ga:avgSessionDuration
ga:goal9ConversionRate
ga:goal9Completions
Dimensionsga:userType

 

 

Marked as Best Answer.
Solution
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.