How to pull "User Id" values

1,826 views
Skip to first unread message

eran....@verizon.com

unread,
Feb 28, 2018, 4:51:10 PM2/28/18
to google-analytics-spreadsheet-add-on
How can I use the add-on to pull "User Id" (Audience -> User Explorer -> User Id)

This is critical in order to link GA data with other sources.

(Not to be confused with "Client Id", that is also not listed in Reporting API V4)

Jørn Reidel

unread,
Mar 1, 2018, 3:02:31 AM3/1/18
to google-analytics-spreadsheet-add-on
Userid is unfortunately not available as a dimension in the API. You should add userid as a custom dimension.


-Jørn

eran....@verizon.com

unread,
Mar 1, 2018, 11:39:14 AM3/1/18
to google-analytics-spreadsheet-add-on
Does the UserId available in the API for GA 360 subscribers?

Hollis Bowman

unread,
Mar 8, 2018, 1:25:24 PM3/8/18
to google-analytics-spreadsheet-add-on
Seconded on custom dimension, it's useful for a lot of things. 

One thing to note-  Typically you'll want this (and any user-related) custom dimension to be hit scoped so that it doesn't get over-written with subsequent values. 


On Thursday, March 1, 2018 at 3:02:31 AM UTC-5, Jørn Reidel wrote:

eran....@verizon.com

unread,
Mar 8, 2018, 8:02:09 PM3/8/18
to google-analytics-spreadsheet-add-on
Thanks, Hollis. I'm going to use Custom Dimension to keep our "User-ID" that later can be linked to our database, but I believe that the scope should be "User".

I am confused about your tip to define the variable's scope as "Hit". Why?

This is what I found about the scope:

>Hit - Use Hit level scope for dimensions and metrics that can change between hits in a single session.

>User - Choose User level for values that rarely change.Or the ones that never do.

James Corr

unread,
Mar 14, 2018, 6:43:49 PM3/14/18
to google-analytics-spreadsheet-add-on
I would highly recommend not using a hit scoped dimension for User-ID OR Client ID as this would over ride the value with a new value on each hit. User scoped would create the value and only override it if the value changed. Which, in this case, shouldn't happen. But for instance, if you set a User scoped custom dimension up for when a user clicked a red button to return true, and false if they haven't, it would return false until that user clicked the button. Once they clicked it, it would return true and update the value for all previous sessions to true. 
Reply all
Reply to author
Forward
Message has been deleted
Message has been deleted
Message has been deleted
Message has been deleted
0 new messages