Skip to content

v0.4.0 dbt_amazon_ads_source

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

PR #21 includes the following updates:

Feature Update: Conversion support

  • We have added conversion metrics by default to the following staging models:

    • stg_amazon_ads__ad_group_level_report
    • stg_amazon_ads__advertised_product_report
    • stg_amazon_ads__campaign_level_report
    • stg_amazon_ads__targeting_keyword_report
    • stg_amazon_ads__search_term_ad_keyword_report

  • The conversion metrics are the following:

    • purchases_30_d: Number of attributed conversion events occurring within 30 days of an ad click.
    • sales_30_d: Total value of sales occurring within 30 days of an ad click.

  • To bring in other conversion fields (purchases_same_sku_30_d, sales_14_d, etc.), please refer to our passthrough column variables.

Under the hood: Backwards compatibility

  • In the event that you were already passing the above fields in via our passthrough columns, the package will dynamically avoid "duplicate column" errors.
  • This was done via the new amazon_ads_fill_pass_through_columns and amazon_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 fields.

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

Contributors

Full Changelog: v0.3.0...v0.4.0

Assets 2
Loading