v0.8.0 dbt_facebook_ads_source

PR #36 includes the following updates:

Breaking Changes

• Incorporates the basic_ad_actions and basic_ad_action_values pre-built reports in order to grab conversion data. They are both child tables of the already-required basic_ad report, broken down by action_type.
  • Addition of the new stg_facebook_ads__basic_ad_actions and stg_facebook_ads__basic_ad_action_values (and their _tmp counterparts) staging models. Given that this is a schema change for the package, this is a breaking change.

Feature Updates: Conversion Metrics

• With the inclusion of the basic_ad_actions and basic_ad_action_values source tables, we have added the facebook_ads__basic_ad_actions_passthrough_metrics and facebook_ads__basic_ad_action_values_passthrough_metrics variables to pass through additional conversion value metrics to downstream models.
  • By default, the package includes only the conversion value calculated using the default attribution window, but your report may include calculations using the other windows defined here. See README for details on how to use the new variables.
• Adds the optimization_goal field to stg_facebook_ads__ad_set_history model. This is defined as the optimization goal this ad set is using, possible values of which are defined here.
• Adds the conversion_domain field to stg_facebook_ads__ad_history model. This is defined as the domain you've configured the ad to convert to.

Documentation

• Documents the ability to transform metrics provided to the new facebook_ads__basic_ad_passthrough_metrics and facebook_ads__basic_ad_action_values_passthrough_metrics variables. See README for details.

Under the Hood

• Creates facebook_ads_fill_pass_through_columns macro to make passthrough column logic in the new staging models DRYer.

Contributors

• Seer Interactive

Full Changelog: v0.7.4...v0.8.0