Snowplow dbt Attribution v0.3.0 released

We are happy to announce the release of dbt-snowplow-attribution v.0.3.0!

Summary

This release introduces a new user stitching logic when the snowplow__conversion_stitching variable is not enabled to avoid the need of having to enable both view and conversion stitching in the unified package to get the most accurate user journeys and conversions. The package will rely on one more source from the Unified Digital dbt package, the snowplow_unified_user_mapping table to accomplish this.

Features

Change stitching logic

Upgrading

Bump the snowplow-attribution version in your packages.yml file.

:rotating_light: Breaking Changes :rotating_light:

Due to the new user mapping table join in the paths_to_conversions() macro it may be that your snowplow__conversion_clause variable would need to be changed by adding the ev table alias to the fields it references (for user_identifier or user_id).

The package by default will now rely on the snowplow_unified_user_mapping table. Although most users would use the Unified package as a source already (therefore this should not be a breaking change), for those users where it is not available, the paths_to_conversion() macro will have to be overwritten in the dbt project where the package is referenced. Similarly, the optional paths_to_non_conversion model is also changed, it would need to be disabled and overwritten in that case, too.

1 Like