This manipulation of variable values is a whole new world, but we will probably want to cross-reference data in another way to show more model data in our dashboards.
Loading model or cross-GA data into Looker Studio
Well, first of all I’m sorry to say that this really can’t be done yet . And that’s because Looker Studio’s font itor doesn’t allow this work yet. It looks like it will eventually do so, but that’s not the case yet.
But GA isn’t the only connection we have, right? So as long as you don’t try to load data directly through that connection, you could load model data. The trick? Do it through other connections. Simple as that.
Option 1: BigQuery
For those who have a GA4 account link to BigQuery, we want. So what we ne is to create a custom query with the data we ne, with this query we cash app database will create a data source using the BigQuery connection within Looker Studio.
Creating session or user segments can be
A bit awkward in BigQuery the first few times, and even more so when cross-referencing data with other sources. You have to learn how to join positioning and targeting our established collectibles brand tables and understand how to use fields like ga_session_id or user_pseudo_id (since the field names don’t always match the dimension names) to manually group tables. Once you master how to do these types of queries, the world becomes friendlier.
For those who haven’t touch it
I’ll leave you with just a link, a step-by-step explanation of how to query funnels within BigQuery, a post that, due to the complexity of the problem, has to solve several parts and gives you several example queries: How to Create a Sequential Funnel Report in BigQuery.
I won’t go into this any further, those who know how to yeezys shoes use BigQuery know how and those who don’t won’t learn with just one post.