Report: Percentages are xx.xx in Totals but are 0.xxxx in breakdown

315 views
Skip to first unread message

zsum...@crescendocollective.com

unread,
Jan 22, 2018, 6:18:42 PM1/22/18
to google-analytics-spreadsheet-add-on
Hey, since the update all the totals of percentages are three decimal places larger than they used to be, and no longer match the details/breakdowns format of being a ratio. Attached is a snip of a daily breakdown, with showing bounce rate, the totals number is not a fraction anymore (there are more rows that aren't included in snippet). Also attached is a second snip of a ad campaign report breakdown, it shows bounce rate, new session %, and click through rate. all of which have 100x the total rate than is shown in the breakdown (only one campaign is in this report). This change would require me to divide the total by 100 before displaying it as a % in google sheets, but only for Totals. The breakdown per dimension lines are all unaffected by the change.
Screen Shot 2018-01-22 at 5.09.40 PM.png
Screen Shot 2018-01-22 at 5.08.57 PM.png

Philip Walton

unread,
Jan 22, 2018, 10:35:26 PM1/22/18
to zsum...@crescendocollective.com, google-analytics-spreadsheet-add-on
Yes, this is a bug that's been fixed in the most recent version, we're just waiting for it to pass approvals in the Chrome web store, and then you'll automatically get the updates (look for version 69 of the add-on).

You shouldn't need to do anything with your spreadsheet. You'll get the updates most likely tomorrow.


On Mon, Jan 22, 2018 at 3:18 PM, <zsum...@crescendocollective.com> wrote:
Hey, since the update all the totals of percentages are three decimal places larger than they used to be, and no longer match the details/breakdowns format of being a ratio. Attached is a snip of a daily breakdown, with showing bounce rate, the totals number is not a fraction anymore (there are more rows that aren't included in snippet). Also attached is a second snip of a ad campaign report breakdown, it shows bounce rate, new session %, and click through rate. all of which have 100x the total rate than is shown in the breakdown (only one campaign is in this report). This change would require me to divide the total by 100 before displaying it as a % in google sheets, but only for Totals. The breakdown per dimension lines are all unaffected by the change.

--
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/adc01025-17a1-4cab-a73a-ebf97830a86d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Philip Walton

unread,
Jan 23, 2018, 11:29:49 AM1/23/18
to google-analytics-spreadsheet-add-on
The new version was just released. Let me know if you're still seeing an issue with this.


On Monday, January 22, 2018 at 7:35:26 PM UTC-8, Philip Walton wrote:
Yes, this is a bug that's been fixed in the most recent version, we're just waiting for it to pass approvals in the Chrome web store, and then you'll automatically get the updates (look for version 69 of the add-on).

You shouldn't need to do anything with your spreadsheet. You'll get the updates most likely tomorrow.

zsum...@crescendocollective.com

unread,
Jan 23, 2018, 2:44:51 PM1/23/18
to google-analytics-spreadsheet-add-on
Update seems to have eliminated my issue.

Philip Walton

unread,
Jan 23, 2018, 2:52:23 PM1/23/18
to zsum...@crescendocollective.com, google-analytics-spreadsheet-add-on
Reply all
Reply to author
Forward
0 new messages