Skip to content

Latest commit

 

History

History
47 lines (37 loc) · 4.24 KB

CHANGELOG.md

File metadata and controls

47 lines (37 loc) · 4.24 KB

dbt_reddit_ads_source v0.3.0

PR #7 includes the following BREAKING CHANGE updates:

Feature: Conversion Metrics

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

  • 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 into the stg_<entity>_conversions_report models, refer to the README.

Under the hood

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

Contributors

dbt_reddit_ads_source v0.2.0

PR #5 includes the following updates:

Feature update 🎉

Under the hood 🚘

  • 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 model and applied the fivetran_utils.source_relation macro.
  • 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.

dbt_reddit_ads_source v0.1.0

Initial Release

  • This is the initial release of this package.

📣 What does this dbt package do?

  • Materializes Reddit Ads staging tables which leverage data in the format described by this ERD. These staging tables clean, test, and prepare your reddit_ads data from Fivetran's connector for analysis by doing the following:
    • Names columns for consistency across all packages and for easier analysis
    • Adds freshness tests to source data
    • Adds column-level testing where applicable. For example, all primary keys are tested for uniqueness and non-null values.
  • Generates a comprehensive data dictionary of your Reddit Ads data through the dbt docs site.
  • These tables are designed to work simultaneously with our Reddit Ads transformation package.

For more information refer to the README.