Error with data when extracting data from Analytics UA

Naiane Santana

unread,

Jul 4, 2023, 10:37:13 AM7/4/23

to google-analytics-spreadsheet-add-on

Hi guys, good morning!
I'm trying to extract data from pageviews of a certain period of time from google sheets, but it's giving me an error with the date I added ( API call to analyticsreporting.reports.batchGet failed with error Invalid Date specified: 20090603 ). can you help me?

Stuart Young

unread,

Jul 4, 2023, 6:37:52 PM7/4/23

to google-analytics-spreadsheet-add-on

It expects the date to be in a date format. When you click on the cell with the date it should open up a date picker.

Naiane Santana

unread,

Jul 6, 2023, 10:45:25 AM7/6/23

to google-analytics-spreadsheet-add-on

Here in my browser this data selector is not opening. I already clicked with the right and left mouse button, but without solution. Is it possible that it has a time range limit? In my case, I was able to collect pageviews over a 12 year period.

Naiane Santana

unread,

Jul 6, 2023, 10:46:51 AM7/6/23

to google-analytics-spreadsheet-add-on

WhatsApp Image 2023-07-06 at 11.46.16.jpeg

Reply all

Reply to author

Forward