Skip to content

v1.10.0 dbt_ad_reporting

Latest
Compare
Choose a tag to compare
@fivetran-data-model-bot fivetran-data-model-bot released this 20 Nov 16:25
ab30c27

PR #122 introduces the following BREAKING CHANGES:

Feature Updates: Native Conversion Support

  • Added conversions and conversions_value fields to each Ad Reporting end model.
    • BREAKING: In the event that you were already including conversions through passthrough variables and called your field(s) conversions and/or conversions_value, your old fields will still be included, but they will be suffixed with a _c, while the new default conversion fields will take precedence as conversions and conversions_value
    • For some platforms, conversions data is sent along with the type of event the metrics are attributed to (ie purchases, leads, sign ups). We have largely chosen to consider purchases, leads, and custom-defined events to be conversions. However, you may configure this at each individual platform level for the following packages:
Platform Variable Default Values How to Use
Facebook Ads facebook_ads__conversion_action_types offsite_conversion.fb_pixel_custom + offsite_conversion.fb_pixel_lead + onsite_conversion.lead_grouped + offsite_conversion.fb_pixel_purchase + onsite_conversion.purchase Configuring Conversion Action Types
LinkedIn Ad Analytics linkedin_ads__conversion_fields external_website_conversions + one_click_leads Adding in Conversion Fields
Reddit Ads reddit_ads__conversion_event_types lead + purchase + custom Configure Conversion Event Types
Snapchat Ads snapchat_ads__conversion_fields conversion_purchases Configuring Conversion Fields
Twitter Ads twitter_ads__conversion_fields AND twitter_ads__conversion_sale_amount_fields conversion_purchases_metric + conversion_custom_metric AND conversion_purchases_sale_amount + conversion_custom_sale_amount Customizing Types of Conversions

Under the Hood

  • Created data validation tests to be used by package maintainers to verify this and future releases.

Contributors

Full Changelog: v1.9.0...v1.10.0