Query Cost

278 views
Skip to first unread message

Jørn Reidel

unread,
Jan 25, 2018, 4:46:51 AM1/25/18
to google-analytics-spreadsheet-add-on
Hi,

thanks for the updated plugin, it's really appreciated!

I just tried the new feature for resource based quota system, to get data more than 1 mill sessions for 360 clients. It's working as it should, but query cost output seems to have wrong format? Should it be "5000" or "5000%" in this case?


It would also be nice to have the absolute value of the sample size, not only percentage (like in the old plugin):



Thanks,

Jorn


Jørn Reidel

unread,
Jan 25, 2018, 4:58:02 AM1/25/18
to google-analytics-spreadsheet-add-on
Looks like the first one (5000%) was actually just a sheets format issue. I haven't done anything to the cell format, but I applied "number", and now it's showing "50".


-Jørn

Philip Walton

unread,
Jan 25, 2018, 1:38:57 PM1/25/18
to Jørn Reidel, google-analytics-spreadsheet-add-on
You can get the absolute value of the same size by multiplying the sample percentage by the session count.

This was removed to be consistent with how it is in Google Analytics; also I didn't want to risk breaking people's existing reports by pushing everything down one row to add Query Cost.

--
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/7f0abcd9-0d5e-4b9d-8bdf-214507e44cf8%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages