Unknown dimension: ga:acquisitionSourceMedium

434 views
Skip to first unread message

kevi...@worldvision.ca

unread,
Aug 30, 2016, 9:29:36 AM8/30/16
to google-analytics-spreadsheet-add-on
I'm getting an error when trying to use acquisition source/medium as a dimension:


Even though there were no errors in the report creator and it's clearly listed under dimensions:


Even listed as a dimension in Google's own reference:




Anyone know what's going on? Is this dimension obsolete or something?


I'm trying to pull this dimension from GA into spreadsheet, the ecommerce conversion rate under acquisition -> all campaigns when sorted by source/medium. I'm assuming it's ga:AcquisitionSourceMedium?





Philip Walton

unread,
Aug 30, 2016, 4:43:46 PM8/30/16
to kevi...@worldvision.ca, google-analytics-spreadsheet-add-on
Yes, this is a bug (sort of).

If you look at the ga:acquisitionSourceMedium dimensions documentation, you'll see a column that says "Adding in API version" and this dimensions was added in version 4.

The add-on only uses version 3 of the Core Reporting API because the new version (v4) hasn't been added to the apps scripts framework yet.

I'll see if I can make some updates so v4 dimensions/metrics don't appear in the dropdown list in the create sidebar.




--
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/91e1c83e-a0d7-48ae-905a-17be60b217ba%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Philip Walton

unread,
Aug 30, 2016, 5:21:03 PM8/30/16
to kevi...@worldvision.ca, google-analytics-spreadsheet-add-on
I've updated the add-on to exclude metrics/dimensions not supported by the v3 reporting API.

kevi...@worldvision.ca

unread,
Aug 31, 2016, 8:57:42 AM8/31/16
to google-analytics-spreadsheet-add-on, kevi...@worldvision.ca
I see... so there is no way to get this dimension into GA for spreadsheet? It's the dimension highlighted in the pic I linked, I'm assuming it's ga:acquisitionSourceMedium? Or is it something else. 

Philip Walton

unread,
Aug 31, 2016, 2:00:13 PM8/31/16
to kevi...@worldvision.ca, google-analytics-spreadsheet-add-on
There's no way to get it using the add-on until the v4 reporting API is supported in Sheets add-ons and I release an update (which I will as soon as it's supported).

Here's the documentation on that dimension:

On Wed, Aug 31, 2016 at 5:57 AM, <kevi...@worldvision.ca> wrote:
I see... so there is no way to get this dimension into GA for spreadsheet? It's the dimension highlighted in the pic I linked, I'm assuming it's ga:acquisitionSourceMedium? Or is it something else. 

--
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.
Reply all
Reply to author
Forward
0 new messages