v0.3.0 dbt_reddit_ads

PR #13 includes the following BREAKING CHANGE updates:

Features: Conversion Metrics

• Introduces the following conversion fields to the Reddit Ads reddit_ads__<entity>_report models:
  • conversions (aliased from click_through_conversion_attribution_window_month): Total attributed click-through conversions for the given month-long window.
  • view_through_conversions (aliased from view_through_conversion_attribution_window_month): Total attributed view-through conversions for the given month-long window.
  • total_value: Total monetary value associated with a conversion event.
  • total_items: Total number of items involved in a conversion event.
• Introduces the <entity>_conversions_passthrough_metrics variables to allow additional fields from the source _conversion_report tables. We use the maximum attribution window when considering conversions and therefore retrieve conversions metrics from the click_through_conversion_attribution_window_month (conversions) and view_through_conversion_attribution_window_month (view_through_conversions) fields from the respective source tables. For information on how to configure these variables to bring in additional windows and fields, refer to the README.
• Introduces the reddit_ads__conversion_event_types variable to note which kinds of events should be considered conversions (and therefore be surfaced in conversion metrics). By default, this package considers purchase, lead, and custom events to be conversions. See README for details on how to adjust this.

Upstream Source Package Updates

To support the addition of conversion metrics here, v0.3.0 of reddit_ads_source included the following update:

• Introduces 4 new staging models to bring in conversion metrics (click-through conversions, view-through conversions, total value, and total items) across different dimensions:
  • stg_reddit_ads__account_conversions_report
  • stg_reddit_ads__ad_group_conversions_report
  • stg_reddit_ads__ad_conversions_report
  • stg_reddit_ads__campaign_conversions_report

Note: If you would like to include conversion metrics, please ensure you have the account_conversions_report, ad_group_conversions_report, ad_conversions_report, and campaign_conversions_report source tables syncing in your Reddit Ads connector(s). Otherwise, the package will run successfully but produce null conversion metric values.

Under the Hood

• Coalesces each pre-existing metrics (ie clicks, impressions, and spend) with 0 to avoid the complications of null in aggregations.
• Adds the respective seed data for the new models in addition to updating relevant documentation.
• Adds documentation explaining potential discrepancies across reporting grains.
• Adds new Buildkite run step to test different configurations of the reddit_ads__conversion_event_types variable.

Contributors

• Seer Interactive

Full Changelog: v0.2.1...v0.3.0

v0.2.1 dbt_reddit_ads

PR #8 includes the following updates:

Bug Fixes

• This package now leverages the new reddit_ads_extract_url_parameter() macro for use in parsing out url parameters. This was added to create special logic for Databricks instances not supported by dbt_utils.get_url_parameter().
  • This macro will be replaced with the fivetran_utils.extract_url_parameter() macro in the next breaking change of this package.

Under the Hood

• Included auto-releaser GitHub Actions workflow to automate future releases.

Full Changelog: v0.2.0...v0.2.1

v0.2.0 dbt_reddit_ads

PR #5 includes the following updates:

Feature update 🎉

• Unioning capability! This adds the ability to union source data from multiple reddit_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.
• 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_reddit_ads

🎉 Initial Release 🎉

• Introducing the Reddit Ads package!

📣 What does this dbt package do?

• Produces modeled tables that leverage Reddit Ads data from Fivetran's connector in the format described by this ERD and builds off the output of our Reddit Ads source package.
• Enables you to better understand the performance of your ads across varying grains:
  • Providing an account, campaign, ad group, ad, and URL level reports.
• Materializes output models designed to work simultaneously with our multi-platform Ad Reporting package.
• Generates a comprehensive data dictionary of your source and modeled Reddit Ads data through the dbt docs site.

For more information refer to the README.