v0.4.0 dbt_amazon_ads

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

v0.3.0 dbt_amazon_ads

PR #11 includes the following updates:

Feature update 🎉

• Unioning capability! This adds the ability to union source data from multiple amazon_ads connectors. Refer to the Union Multiple Connectors README section for more details.

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.

Full Changelog: v0.2.0...v0.3.0

v0.2.0 dbt_amazon_ads

PR #6 includes the following updates:

🚨 Breaking changes

• This release is labeled breaking since changes made in dbt_amazon_ads_source are breaking. Note that columns in this package are unchanged.
• Further details are available in the dbt_amazon_ads_source CHANGELOG.

🎉 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.

Full Changelog: v0.1.0...v0.2.0

v0.1.0 dbt_amazon_ads

Happy Year of the Rabbit! 🐇 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.