Analytics
2.2K members online now
Discuss regaining access to Analytics accounts, restoring accounts, changing user access levels, and navigating the homepage
 
Guide Me
star_border
Reply

Need help to extract User Explorer (Unique ID) with google sheets GA Add-on

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi I'm newbie in Google Analytics and I'm trying to export a certain data to google sheets with the Google Analytics Add-on.
What I need is Unique ID/Client ID, and Number of sessions. Image of what I need http://imgur.com/a/ptq3g

What should I add in metrics and dimensions in order to extract the data that I need. http://imgur.com/a/OG7J2

Thanks a ton!

Need help to extract User Explorer (Unique ID) with google sheets GA Add-on

Follower ✭ ✭ ✭
# 2
Follower ✭ ✭ ✭

Hi Aleksandar,

 

I don't believe the API allows your to extract the client ID. You would have to setup CRM integration by passing a user id to GA and then pull out the custom dimension to access a "unique ID".

 

Google, User ID feature.

 

Thanks,

A