v0.8.0 dbt_twitter_source

PR #27 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 now populate in the following models:
    • stg_twitter_ads__campaign_report
    • stg_twitter_ads__line_item_keywords_report
    • stg_twitter_ads__line_item_report
    • stg_twitter_ads__promoted_tweet_report
  • See README for more details on how to configure these variables.
  • See the parallel release of twitter_ads for details on how these variables are summed together and leveraged in downstream transformations.

Under the Hood

• Ensured the above changes maintain backwards compatibility with existing passthrough column variables.
  • Created macros to check whether these fields are already being brought in via existing passthrough variables and ensure there are no duplicate column errors.

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.
• Document commonly used conversion fields in yml.

Contributors

• Seer Interactive

Full Changelog: v0.7.1...v0.8.0