New Release .... But zero values for a day doesn't appear any more

208 views
Skip to first unread message

Martin Rousseau

unread,
Jan 22, 2018, 5:45:47 PM1/22/18
to google-analytics-spreadsheet-add-on





Before today , for this report (see images ) - Push_SMS


I ve got result for every day. Since Today,  Day with 0 as value doesn't appear anymore. Why ?



Example of results (sample) -  No value Jan 15, Jan 16, Jan 18..... I need those values no mather if 0 or another value 




Philip Walton

unread,
Jan 22, 2018, 5:52:40 PM1/22/18
to Martin Rousseau, google-analytics-spreadsheet-add-on
Sorry for this initial oversight in the upgrade. This has been fixed, but it looks like a few users (you included) were affected in the initial roll-out, and they'll have to update their Report Configuration sheets manually.

How to fix it (i.e. get the old behavior):

The v4 Reporting API changed it's default includeEmptyRows value from false to true, and that's what's causing this problem for you. To get the old behavior you can set the hidden configuration parameter Include Empty Rows to TRUE, and it should be exactly as before.

Please let me know if you experience any other issues as a result of the upgrade. You can also check out the updated documentation to see what's changed:


--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spreadsheet-add-on+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/8faf408b-d1d1-45af-b956-d2bf068c6f03%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

jo...@vampr.me

unread,
Jan 22, 2018, 6:00:53 PM1/22/18
to google-analytics-spreadsheet-add-on
How do you add/chhange the hidden parameter?

Martin Rousseau

unread,
Jan 22, 2018, 6:02:02 PM1/22/18
to google-analytics-spreadsheet-add-on
Thank you , problem fixed. You make my day!

Philip Walton

unread,
Jan 22, 2018, 6:02:38 PM1/22/18
to jo...@vampr.me, google-analytics-spreadsheet-add-on
You have to un-hide them. Here's the instructions from the docs:

Hidden parameters are advanced options that are not needed for most reports and are hidden by default. You can use these parameters by un-hiding the rows 14-16 in the Report Configuration sheet.


Max Thomas

unread,
Jan 24, 2018, 7:02:34 AM1/24/18
to google-analytics-spreadsheet-add-on
Thank you!!! I ran into the same issue with the upgrade...and the IncludeEmptyRows was the fix. Thanks!!
Reply all
Reply to author
Forward
0 new messages