Skip to content

v0.10.0 dbt_microsoft_ads_source

Latest
Latest
Compare
Choose a tag to compare
@fivetran-data-model-bot fivetran-data-model-bot released this 21 Oct 18:48
v0.10.0
68ef8cf
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Learn about vigilant mode.

PR #32 includes the following updates:

Feature Updates: Conversion Metrics

  • We have added the following source fields to each stg_microsoft_ads__<entity>_daily_report model:
    • conversions: Number of conversions, measured by completion of an action by a customer after viewing your ad. This will default to conversions_qualified if synced (recommended), but will coalesce with the now-deprecated conversions field.
    • conversions_value: The revenue reported by the advertiser and attributed to conversions.
    • all_conversions: Number of all conversions, measured by completion of an action by a customer after viewing your ad. This will default to all_conversions_qualified if synced (recommended), but will coalesce with the now-deprecated all_conversions field. This field differs from the default conversions field in that it includes conversions associated with a conversion goal in which the ExcludeFromBidding Microsoft Ads property is set to true.
    • all_conversions_value (not in stg_microsoft_ads__account_daily_report): The revenue reported by the advertiser and attributed to all conversions. This field differs from the default conversions_value field in that it includes revenue associated with a conversion goal in which the ExcludeFromBidding Microsoft Ads property is set to true.

The above new field additions are breaking changes.

Under the Hood

  • Created microsoft_ads_fill_pass_through_columns and microsoft_ads_add_pass_through_columns macros to ensure that the new conversion fields are backwards compatible with users who have already included them via passthrough columns.
  • Updated seed files with new fields to test and validate on local data, provided specific casting to numeric (for currency) and integers.
  • We've coalesced metrics in each stg_microsoft_ads__<entity>_daily_report model with 0 to avoid any potential null values that could disrupt aggregate calculations in the dbt_microsoft_ads transformation package.

Documentation Update

  • Updated source and staging yml files with new fields mentioned above.

Contributors

Full Changelog: v0.9.0...v0.10.0

Assets 2
Loading