Skip to main content

Hi there

Would it be possible to allow the GA4 dimension `user_pseudo_id` to be selected in the Table Manager?

We are using Supermetrics Storage to store GA4 data and are exeperiencing issues when summing non-aggreagatable user metrics over dynamic date rages in Looker Studio.

I have read that `user_pseudo_id` can assist with accurately calculating non-aggregatable user metrics.

Thanks

Luke

 

Hi!

Sadly, the Data API we use for the GA4 connector does not expose/support this field, so we are unable to add it.

I think it may be only exposed in the BigQuery export tool that Google provides, in fact. More information can be found here - https://support.google.com/analytics/answer/12769371?hl=en

We do offer data sources for BigQuery, so it would be possible to use Google’s tool to load the GA4 data in, and then extract what you needed with our BigQuery data source to combine with other items in Looker Studio.

 

Sorry we don’t have a more streamlined solution for this.

Jessica


@lukedolan ​@jessiebrock 

Correct me if I’m wrong, but Supermetrics’ GA4 connection supports custom dimensions & metrics… Luke, this might be a mild pain, but if you’re able to implement user_pseudo_id on your website and pass that back as a user-scoped custom dimension, you should be able to pull it into Supermetrics Storage.

I store data with BigQuery in a similar way, and a lot of what I do on websites is built through custom events, dimensions and metrics that get set up on Google Tag Manager, then passed back to GA4 using event-scoped parameters. I haven’t setup anything user-scoped, but this might be something a custom javascript snippet might be able to handle when the site loads, storing user-specific data in LocalStorage or SessionStorage as a cookie. As long as it gets defined as a custom dimension, it gets passed back to the API, and Supermetrics can pick it up from there:


Jessica, if I’m off base with this idea, let me know, but this might be a way to solve this issue!


Yeah that could work if you can get the psuedo_id in to GA4 as a custom dimension (as we do support those). I think that was a work around for the Client ID as it also wasn’t in the API proper.

I wasn’t sure if that was possible with this piece of data, sounds like some experimentation may be needed to see how to pass that in.

Jessica


Hi ​@jessiebrock and ​@gcfmineo 

Many thanks for your replies.

I will look into the suggestion of setting up a user-scoped custom dimension to see if it can work for us.

Thanks again

Luke