• Version 6 [2024-02-29]
  • Added support for the GA360 Fresh Daily export option.

• Version 5 [2023-11-21]
  • Refined wildcard query logic to target 'events_20*' prefix, reducing the inclusion of views and enhancing query specificity.
  • Updated all date format specifiers in BigQuery queries from %Y (four-digit year) to %y (two-digit year) to align with the revised wildcard filter logic, ensuring accurate table selection and data querying consistency.
  • Implemented the boosted tree regressor algorithm for BigQuery Machine Learning models. Hyperparameters have been optimized, including setting BOOSTER_TYPE to DART and adjusting SUBSAMPLE to 0.7 for improved generalizability.

• Version 4 [2023-11-07]
  • Remove session_id and engagement_time_msec from GA4 measurement protocol payload.
  • Remove session_id calculations from Calculate Fields query.

• Version 3 [2023-10-24]
  • Updated the Event & Churn propensity training, prediction, and value-based bidding logic to include a regular expression filter. This filter omits events with names ending in '_iBQML' or '_vertex', which are associated with propensity score calculations, ensuring they are not included in the analysis.
  • Set data split method to `AUTO_SPLIT` in BigQuery ML training query hyperparameters.

• Version 2 [2023-08-07]
  • Updated audience boundaries job to define boundaries based on AUDIENCE_SEGMENTS variable, not user counts.

• Version 1 [2023-06-27]
  • Create Version Changelog to manage pipeline upgrades.
  • Remove conversion event creation from non-Event Propensity marketing objectives.