How to pull "User Id" values

1,589 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. 

Mushrooms Gimme

unread,
Jun 25, 2024, 7:41:52 AM (8 days ago) Jun 25
to google-analytics-spreadsheet-add-on

Mushrooms contain macronutrients that support a healthy immune system. According to the Mushroom Council, your immune system will benefit from mushrooms whose nutrients include: Selenium, which helps your body make antioxidant enzymes to prevent cell damage. Choose cremini or portabella mushrooms for the most benefit.😋


Check my telegram group for more information

https://t.me/exotics_shop_1



Buy FIREMAN online
https://t.me/exotics_shop_1/103
Buy lucky kush online
https://t.me/exotics_shop_1/113
Buy gello gelato online
https://t.me/exotics_shop_1/114
Buy grape fanta online
https://t.me/exotics_shop_1/103
Buy tiramesu smalls online
https://t.me/exotics_shop_1/97
Buy icebergs online
https://t.me/exotics_shop_1/107?single
Buy dabwoods × runtz disposable online
https://t.me/exotics_shop_1/115?single
Buy wax crumble online
https://t.me/exotics_shop_1/120?single
Buy golden teacher online 🍄
https://t.me/exotics_shop_1/121?single
Buy 3 grams runtz disposable vapes online
https://t.me/exotics_shop_1/126?single
Buy polkadot bars online
https://t.me/exotics_shop_1/128
Buy mushrooms online
https://t.me/exotics_shop_1/130?single
Buy rosin dot bars online
https://t.me/exotics_shop_1/132
Buy kiwano (heavy loadz) online
https://t.me/exotics_shop_1/133?single
Buy mix and match d9  edibles online
https://t.me/exotics_shop_1/137?single
Buy black cherry online
https://t.me/exotics_shop_1/140
Buy FIREMAN
Clone card available
https://t.me/exotics_shop_1/169
Buy lsd sheets online
https://t.me/exotics_shop_1/172
Buy polkatdot starter pack 🍄 online
https://t.me/exotics_shop_1/178?single
Buy edible candy online
https://t.me/exotics_shop_1/180
Buy potent carbs
https://t.me/exotics_shop_1/190?single
Buy persy snowcaps online
https://t.me/exotics_shop_1/193?single
Buy galactic gummies online
https://t.me/exotics_shop_1/210
Buy new cake cards online
https://t.me/exotics_shop_1/214?single
Buy pure mdma online
https://t.me/exotics_shop_1/215
Buy distillate online
https://t.me/exotics_shop_1/217
Buy crumble online
https://t.me/exotics_shop_1/218
Buy codeine online
https://t.me/exotics_shop_1/221?single
Buy quagen online
https://t.me/exotics_shop_1/223?single
Buy jeeter dispos online
https://t.me/exotics_shop_1/230?single
Buy Columbia coke online
https://t.me/exotics_shop_1/238
Buy inhale excellence online
https://t.me/exotics_shop_1/103
Buy lucky kush online
https://t.me/exotics_shop_1/113
Buy gello gelato online
https://t.me/exotics_shop_1/114
Buy grape fanta online
https://t.me/exotics_shop_1/103
Buy tiramesu smalls online
https://t.me/exotics_shop_1/97
Buy icebergs online
https://t.me/exotics_shop_1/107?single
https://t.me/exotics_shop_1/281?single
https://t.me/exotics_shop_1/282?single
https://t.me/exotics_shop_1/291
https://t.me/exotics_shop_1/292
https://t.me/exotics_shop_1/296
https://t.me/exotics_shop_1/299
https://t.me/exotics_shop_1/301

"Our commitment is to provide exceptional service, unparalleled quality, and personalized solutions to meet your unique needs. We strive to exceed your expectations and deliver results that make a lasting impact. Trust us to be your reliable partner in achieving your goals. Your satisfaction is our utmost priority."

Mushrooms Gimme

unread,
Jun 25, 2024, 7:43:07 AM (8 days ago) Jun 25
to google-analytics-spreadsheet-add-on

Kud Brian

unread,
Jul 2, 2024, 9:18:12 AM (yesterday) Jul 2
to google-analytics-spreadsheet-add-on
All psychedelic products available mushroom, MDMA, pills, coke, lsd, carts etc....
Telegram: @tripyjames
Telegram: @tripyjames
Telegram: @tripyjames
Call or text: +14807191696
https://t.me/goldenmuseTM
https://t.me/goldenmuseTM
https://t.me/goldenmuseTM
https://t.me/goldenmuseTM
Reply all
Reply to author
Forward
0 new messages