v0.7.0 dbt_reddit_ads_source

PR #18 includes the following updates:

Schema & Data Updates

5 total changes • 5 possible breaking changes

Data Models	Change Type	Old	New	Notes
stg_reddit_ads__account_report stg_reddit_ads__ad_group_report stg_reddit_ads__ad_report stg_reddit_ads__campaign_country_report stg_reddit_ads__campaign_report	Column datatype	spend (INT)	spend (NUMERIC)	Updated the datatype of the spend fields from INT to NUMERIC to avoid rounding when converting to dollars and ensure full decimal precision is preserved.

Features

• Added macro convert_microcurrency to convert microcurrency fields (e.g. INT) to NUMERIC dollar values. Casts both the input and constants to dbt.type_numeric() to preserve fixed-point precision.

Under the Hood

• Updated conditions in .github/workflows/auto-release.yml.
• Added .github/workflows/generate-docs.yml.
• Added +docs: show: False to integration_tests/dbt_project.yml.
• Migrated flags (e.g., send_anonymous_usage_stats, use_colors) from sample.profiles.yml to integration_tests/dbt_project.yml.
• Updated maintainer_pull_request_template.md with improved checklist.
• Updated Python image version to 3.10.13 in pipeline.yml.
• Updated .gitignore to exclude additional DBT, Python, and system artifacts.

Full Changelog: v0.6.1...v0.7.0

v0.6.1 dbt_reddit_ads_source

PR #16 includes the following updates:

Bug Fixes

• Fixed a bug where freshness tests were still run for source BUSINESS_ACCOUNT even if var ad_reporting__reddit_ads_enabled is set to false.

Full Changelog: v0.6.0...v0.6.1

v0.6.0 dbt_reddit_ads_source

PR #14 includes the following updates:

Breaking Change

• To align with the Fivetran Reddit Ads Connector schema, updated the source referenced by stg_reddit_ads__account_tmp from ACCOUNT to BUSINESS_ACCOUNT.
• Added the reddit_ads__using_business_account variable to control which source is used.
  • For Quickstart users, this variable is set automatically.
  • For dbt Core users, this variable is true by default, but you can set the variable to false in your dbt_project.yml to fall back to using ACCOUNT instead of BUSINESS_ACCOUNT.

Documentation

• Added documentation for BUSINESS_ACCOUNT.

Under the Hood

• Added seed file reddit_ads_business_account_data.
• Updated the seed column types in integration_tests/dbt_project.yml.

Full Changelog: v0.5.0...v0.6.0

v0.5.0 dbt_reddit_ads_source

PR #13 includes the following updates:

Breaking Change for dbt Core < 1.9.6

Note: This is not relevant to Fivetran Quickstart users.

Migrated freshness from a top-level source property to a source config in alignment with recent updates from dbt Core. This will resolve the following deprecation warning that users running dbt >= 1.9.6 may have received:

[WARNING]: Deprecated functionality
Found `freshness` as a top-level property of `reddit_ads` in file
`models/src_reddit_ads.yml`. The `freshness` top-level property should be moved
into the `config` of `reddit_ads`.

IMPORTANT: Users running dbt Core < 1.9.6 will not be able to utilize freshness tests in this release or any subsequent releases, as older versions of dbt will not recognize freshness as a source config and therefore not run the tests.

If you are using dbt Core < 1.9.6 and want to continue running Reddit Ads freshness tests, please elect one of the following options:

1. (Recommended) Upgrade to dbt Core >= 1.9.6
2. Do not upgrade your installed version of the reddit_ads_source package. Pin your dependency on v0.4.1 in your packages.yml file.
3. Utilize a dbt override to overwrite the package's reddit_ads source and apply freshness via the old top-level property route. This will require you to copy and paste the entirety of the src_reddit_ads.yml file and add an overrides: reddit_ads_source property.

Under the Hood

• Updated the package maintainer PR template.

Full Changelog: v0.4.1...v0.5.0

v0.4.1 dbt_reddit_ads_source

PR #11 includes the following updates:

Bug Fix

• Updates the uniqueness test of the recently introduced stg_reddit_ads__campaign_country_conversions_report model to include event_name. This is aligned with the other *_conversions_report tables in this package.

Full Changelog: v0.4.0...v0.4.1

v0.4.0 dbt_reddit_ads_source

PR #10 includes the following updates:

Schema Changes

4 new models • 0 possible breaking changes

Data Model	Change type	Old name	New name	Notes
stg_reddit_ads__campaign_country_report	New Staging Model			Uses CAMPAIGN_COUNTRY_REPORT source table
stg_reddit_ads__campaign_country_conversions_report	New Staging Model			Uses CAMPAIGN_COUNTRY_CONVERSIONS_REPORT source table
stg_reddit_ads__campaign_country_report_tmp	New Temp Model			Uses CAMPAIGN_COUNTRY_REPORT source table
stg_reddit_ads__campaign_country_conversions_report_tmp	New Temp Model			Uses CAMPAIGN_COUNTRY_CONVERSIONS_REPORT source table

Features

• Added the following vars to enable/disable the new sources. See the README for more details.
  • reddit_ads__using_campaign_country_report
    • Default is true.
    • Will disable stg_reddit_ads__campaign_country_report and stg_reddit_ads__campaign_country_conversions_report if false.
  • reddit_ads__using_campaign_country_conversions_report
    • Default is true.
    • Will disable stg_reddit_ads__campaign_country_conversions_report if false.
• Added the following vars to allow bringing additional metrics. Refer to the README for more details.
  • reddit_ads__campaign_country_passthrough_metrics
    • Passes additional metrics to stg_reddit_ads__campaign_country_report
  • reddit_ads__campaign_country_conversions_passthrough_metrics
    • Passes additional metrics to stg_reddit_ads__campaign_country_conversions_report

Under the Hood

• Added get_*_columns macros for new sources
• Added seed data for testing new sources

Documentation

• Updated dbt documentation to reflect new tables and column additions.
• Corrected references to connectors and connections in the README. (#9)

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

v0.3.0 dbt_reddit_ads_source

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

• Seer Interactive

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

v0.2.0 dbt_reddit_ads_source

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 🚘

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

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

v0.1.0 dbt_reddit_ads_source

🎉 Initial Release 🎉

• Introducing the Reddit Ads source 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.