v1.0.0
🎉 Release 1.0.0 🎉
This release offers many new features and multiple breaking changes from v0.1.4. Please read the release notes for more details.
Summary of Enhancements
- Added
user_key
field which is used to aggregate users on eitheruser_pseudo_id
oruser_id
with preference foruser_id
- Support for GA4 BQ exports that only export to the streaming 'intraday' table
- Added
pages
fact table which aggregates common metrics at the URL & hour grain - Added many recommended and ecommerce events
- Added support for user properties and 'derived' user properties which pull from event parameters
Breaking Changes
- #25 introduces
user_key
as the primary method of identifying unique users. Previouslyclient_id
was used but this field has been removed. - #29 introduces
frequency
as the method of determining whether batch or streaming tables will be ingested. Theinclude_intraday_events
variable is no longer used - Hashed keys (user_key, session_key, event_key) are now STRING rather than BYTES data types
Known Issues
- Further updates are necessary to effectively prune the
base_ga4__events
partitions. Building and querying tables will potentially scan more rows than desirable in the meantime. Take this into account when considering this package for high volume installations.
What's Changed
- Prefixed macros with ga4. to simplify replacing models in local project by @dgitis in #20
- Adding sum of engagement time as a session-level fact by @adamribaudo-velir in #26
- Additional pageview dimensions by @adamribaudo-velir in #24
- add campaign and improve sessions traffic sources model by @clemens7haar in #28
- change materialization of user models to 'table' by @adamribaudo-velir in #23
- session_engaged - using string instead of int value by @clemens7haar in #30
- Ecommerce by @dgitis in #21
- fixed in base_ga4__events.sql - BUG #31 by @vibhorj in #32
- Introduce user_key which pulls from user_id or user_pseudo_id depending on which is available by @adamribaudo-velir in #25
- Bug fix 31 static vs dynamic partition by @vibhorj in #35
- Update static incremental load to use table suffix by @adamribaudo-velir in #37
- seed file - removed blank lines by @vibhorj in #39
- Pages Mart by @dgitis in #38
- Basic streaming support by @dgitis in #29
- User key by @dgitis in #42
- 36 handling of user scope dimensions user properties by @adamribaudo-velir in #43
- adding unit test for page conversions by @adamribaudo-velir in #44
New Contributors
- @clemens7haar made their first contribution in #28
- @vibhorj made their first contribution in #32
Full Changelog: 0.1.4...1.0.0