Examples of how you can use the raw data
Posted: Mon Dec 23, 2024 9:53 am
In GA4 you can create funnels just fine. This is a really good feature. However, you cannot yet export these to your external dashboard. In the example below, a visualization has been created in a dashboard based on an SQL query. As you can see, you can filter on device, but in fact all dimensions are possible here.
visualization created in a dashboard based on a SQL query using BigQuery.
2. Event Precedence
Ever wondered how often an event is email id database free download triggered before a conversion? The query below calculates how often website events are triggered before the main form submit.
Event Precedence.
3. Page pathing
For when you want to quickly see what the previous and next pages are for a particular page.
Page pathing
As indicated, the native connection between GA4 and Looker Studio is far from perfect. Simple things like conversion rates and landing pages are not yet available. This can be easily tackled by linking BigQuery to Looker Studio. But more difficult reports are also possible.
Don't want to depend on Google's attribution models? Then build your own attribution model based on BigQuery data, for example. Do you have any ideas? Please let us know.
visualization created in a dashboard based on a SQL query using BigQuery.
2. Event Precedence
Ever wondered how often an event is email id database free download triggered before a conversion? The query below calculates how often website events are triggered before the main form submit.
Event Precedence.
3. Page pathing
For when you want to quickly see what the previous and next pages are for a particular page.
Page pathing
As indicated, the native connection between GA4 and Looker Studio is far from perfect. Simple things like conversion rates and landing pages are not yet available. This can be easily tackled by linking BigQuery to Looker Studio. But more difficult reports are also possible.
Don't want to depend on Google's attribution models? Then build your own attribution model based on BigQuery data, for example. Do you have any ideas? Please let us know.