Skip to content

v0.11.0 dbt_pinterest

Latest
Compare
Choose a tag to compare
@fivetran-data-model-bot fivetran-data-model-bot released this 21 Oct 20:30
2700b8a

PR #34 includes the following BREAKING CHANGE updates:

Feature Updates: Native Conversion Support

  • We have added the following conversion metrics to each pinterest_ads end model:
    • total_conversions: The sum of all website conversion events.
    • total_conversions_quantity: The total count of items or units involved in conversions.
    • total_conversions_value (converted from total_conversions_value_in_micro_dollar) Total order value associated with conversions.
  • In the event that you were already passing the above fields in via our passthrough columns, the package will dynamically avoid "duplicate column" errors.

The above new field additions are breaking changes for users who were not already bringing in conversion fields via passthrough columns.

Documentation

  • Added more information about the difference in grains and their relationships in the DECISIONLOG.

Under the hood

  • Created pinterest_ads_persist_pass_through_columns macro to ensure that the new conversion fields are backwards compatible with users who have already included them via passthrough fields.
  • Added integrity and consistency validation tests within integration_tests folder for the transformation models (to be used by maintainers only).
  • Updated seed data to represent an e-commerce customer scenario.
  • Coalesces spend with 0 to ensure proper downstream aggregations.

Full Changelog: v0.10.0...v0.11.0