Skip to content

Latest commit

 

History

History
51 lines (42 loc) · 4.17 KB

CHANGELOG.md

File metadata and controls

51 lines (42 loc) · 4.17 KB
Raw

dbt_amazon_ads v0.4.0

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.

dbt_amazon_ads v0.3.0

PR #11 includes the following updates:

Feature update 🎉

Under the hood 🚘

  • In the source package, updated tmp models to union source data using the fivetran_utils.union_data macro.
  • To distinguish which source each field comes from, added source_relation column in each staging and downstream model and applied the fivetran_utils.source_relation macro.
    • The source_relation column is included in all joins in the transform package.
  • Updated tests to account for the new source_relation column.

dbt_amazon_ads v0.2.0

PR #6 includes the following updates:

🚨 Breaking changes

🎉 Features

  • Updated documentation to reference changes in the source package.

🚘 Under the Hood

  • Updated testing seed data to reflect the source seed changes.

PR #4 includes the following updates:

  • Incorporated the new fivetran_utils.drop_schemas_automation macro into the end of each Buildkite integration test job.
  • Updated the pull request templates.

dbt_amazon_ads v0.1.0

🎉 This is the initial release of this package! 🎉

📣 What does this dbt package do?

  • Produces modeled tables that leverage Amazon Ads data from Fivetran's connector in the format described by this ERD and builds off the output of our Amazon Ads source package.
  • Provides insight into your ad performance across the following grains:
    • Account, portfolio, campaign, ad group, ad, keyword, and search term
  • Materializes output models designed to work simultaneously with our multi-platform Ad Reporting package.
  • Generates a comprehensive data dictionary of your source and modeled Amazon Ads data through the dbt docs site.