We are going to use the BigQuery ML Arima Plus model, using the dbt_ml package, to create a daily forecast of traffic. We will use GA4 data from the raw, BigQuery export processed through the dbt-GA4 package as the data source for these traffic forecasts. BigQuery ML simplifies the creation and running of machine learning…
While reviewing an issue with null event keys in the dbt-GA4 package, it occurred to me that one of the potential fixes would also enable modeling of non-consented data generated by Google’s consent mode. We decided to not include this by default in the dbt-GA4 package, you can read our discussion here, but it’s still…
The raw GA4 Bigquery export includes event-scoped attribution data. On the first page of a visit, the referrer will be from a different site from your own, or blank, and any UTM codes will be present on that page. When someone clicks through to a subsequent page, the referrer will be the previous page and…
