cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sguenther Member
Member

Google Analytics client-ID or user-ID (cid/uid)

Hey guys,

 

does anybody know how I get user specific information from Google Analytics through the built-in GA connector?

I have my own database of users for my website and now would like to connect a few other metrics from Google Analytics to the data in my database. For that I already logged the Google Analytics cid and uid in the database through the Google Analytics API.

 

But now I can't find this cid in the data the connector offers me in PowerBI. Does anybody know how to do this?

 

Thank you!

Sebastian

3 REPLIES 3
Moderator v-qiuyu-msft
Moderator

Re: Google Analytics client-ID or user-ID (cid/uid)

Hi @sguenther,

 

Google Analytics connector in desktop relys on the Google Analytics Core Reporting API. Although we attempt to release updates in accordance with any changes, the API may change in a way that affects the results of the queries we generate. Please note the Google Analytics - All API Changelogs, try to always run the latest desktop version.  

 

Available dimensions and metrics of Google Analytics Core Reporting API are listed in this document. In your scenario, I would suggest you check if wanted data are listed on supported dimensions and metrics. You can post a thread here to confirm if Google Analytics Core Reporting API can retrieve this kind of data firstly.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sguenther Member
Member

Re: Google Analytics client-ID or user-ID (cid/uid)

Everything I found out so far makes it seem like it is not possible to export the cid or uid via the connector (or even the api). It seems to be against Google policy to make it possible to track the actions of individual users in a way that exceeds the capabilities of their User Explorer in Google Analytics.

 

In case anybody found a solution, let me know. I gave up on it.

nikjft Frequent Visitor
Frequent Visitor

Re: Google Analytics client-ID or user-ID (cid/uid)

This is an old post, but the answer seems worth sharing.

 

You will need to set a unique ID as a custom dimension. If you have access to a true user ID from your CMS/app, you can use that, or you can set your own unique ID to join your data. You can retrieve the Google UID from the ga cookie values or via JS if you want to use Google's - there are pros and cons to doing that. I'd also recommend passing your gclid values into a custom dimension so you can join your data to DoubleClick ad response.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)