GA4 to Big Query

Job ID: 32223078

Budget: £36 – £0 GBP

We have around 160 clients on GTM/GA4. We need to create a Big Query datawarehouse to report on conversion trends based on
- client type (e.g. industry or company size),
- # of sessions/visits until a user converts,
- events triggered leading up to conversion
- device, location or time of day

This will involve connecting multiple GA4 properties to a single Big Query property, to push through common dimensions and metrics to Data Studio.

All GA4 properties are standardised with the same GTM tags/events, so the work should be focused mainly on BigQuery; connecting all properties, creating appropriate SQL code (if necessary) and making sure the data is available for Data Studio Reporting
Related categories: SQL Google Analytics Analytics BigQuery Big Data