v0.7.0 dbt_snapchat_ads

PR #28 includes the following BREAKING CHANGE updates:

Feature Updates: Conversion Support

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

• Added a conversion_purchases_value field to each _report end model, representing the value of conversions that occurred on each day for each account, ad, ad squad, campaign and url in your Ad Account's currency.
• Introduced the snapchat_ads_conversion_fields variable to configure which conversion fields (reflecting the total number of conversions) to include in each end model.
  • By default, snapchat_ads_conversion_fields will include the most commonly used conversion field, conversion_purchases. See README for details on how to configure this variable to include other conversion events.
  • The individual conversion fields specified by snapchat_ads_conversion_fields are summed together into a total_conversions field in each end model as well.

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

Documentation Update

• Documented how to use the new snapchat_ads__conversion_fields variable here.
• Documented new default conversion fields in yml.

Under the Hood

• 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 column.
• Added data validation tests to verify this release.

Contributors

• Seer Interactive

Full Changelog: v0.6.2...v0.7.0