Skip to content

v0.8.0 dbt_twitter

Latest
Compare
Choose a tag to compare
@fivetran-data-model-bot fivetran-data-model-bot released this 15 Oct 17:51
· 1 commit to main since this release
afd4974

PR #26 includes the following BREAKING CHANGE updates:

Feature Updates: Native Conversion Support

We have added more robust support for conversions in our data models by doing the following:

  • Created the twitter_ads__conversion_fields and twitter_ads__conversion_sale_amount_fields variables to pass through conversion metrics (total number and monetary value, respectively). Conversion metrics are split into these 2 variables due to the N:1 relationship between Twitter conversions and their conversion value fields.
    • By default, twitter_ads__conversion_fields will include conversion_purchases_metric and conversion_custom_metric.
    • By default, twitter_ads__conversion_sale_amount_fields will include conversion_purchases_sale_amount and conversion_custom_sale_amount.
    • These conversion fields will be included in each end model report. Additionally, they will be summed up into new total_conversions and total_conversions_sale_amount columns.
    • See README for more details on how to configure these variables.

Under the Hood

  • Ensured the above changes maintain backwards compatibility with existing passthrough column variables.
    • Added a new version of the persist_pass_through_columns() macro in which we can include coalesces and properly check between conversion field values and the existing passthrough columns.
  • Added integrity and consistency validation tests within integration_tests for the Twitter Ads transformation models.

Documentation

  • Highlighted all metrics included in the package by default. Previously, url_clicks and spend_micro were missing from this README section.
  • Documented how to configure the new twitter_ads__conversion_fields and twitter_ads__conversion_sale_amount_fields variables here.
  • Added Contributors subsection to README.

Contributors

Full Changelog: v0.7.0...v0.8.0