Analytics
3.5K 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 Last N Days required

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello All

I am using the Google Sheets Analytics Add-On to create a report.

I indicate the "start date" and "end date" and when i execute the script, using  "Run reports" command, i get the following error message: "Invalid value 'daysAgo'. Value must match the following regular expression: '[0-9]{4}-[0-9]{2}-[0-9]{2}today|yesterday|[0-9]+(daysAgo)'".

 

I must indicate too "Last N Days" field. But this field is optional, then i do not understand because i must indicate it.

May you explain me? Thank you.

 

This is my report configuration:

 

Typecore
View (Profile) ID / idsga:xxxxxx
Start Date2/23/2016
End Date2/29/2016
Last N Days 
Metricsga:sessions
Dimensionsga:ciTy
Sort-ga:sessions
1 Expert replyverified_user
Marked as Best Answer.
Solution
Accepted by topic author Antonino S
August 2016

Re: Google Analytics Sheets Add-On Date Last N Days required

Rising Star
# 2
Rising Star
Hey Antonio,

The problem is that you have something in the last N days field. Perhaps a space? If you go back in and delete, you should be fine.

Best,

Theo Bennett
Analytics Evangelist at MoreVisibility | Contact Me
Connect on LinkedIn

Re: Google Analytics Sheets Add-On Date Last N Days required

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Yes, i have a space.
Thanks.