Traffic Forecasting with BigQuery ML in DBT using GA4 Data

Traffic Forecasting with BigQuery ML in DBT using GA4 Data

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…

GA4 Consent Modeling in BigQuery with the DBT-GA4 Package

GA4 Consent Modeling in BigQuery with the DBT-GA4 Package

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…