Skip to content

v0.4.0 dbt_amazon_ads

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

PR #16 includes the following updates:

Feature Update: Conversions Support

  • We have added conversion metrics to each of the end models by default.
  • 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.

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

Under the Hood

  • Created amazon_ads_persist_pass_through_columns macro to ensure that the new conversion fields are backwards compatible with users who have already included them via passthrough columns . The package will dynamically avoid "duplicate column" errors.
  • Added integrity and consistency validation tests within integration_tests folder for the transformation models (to be used by maintainers only).
  • Added documentation explaining potential discrepancies across reporting grains. See the DECISIONLOG.md.

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

Assets 2
Loading