dbt_ad_reporting v0.8.0

Happy Tuesday! 🌮

This release of the dbt_ad_reporting package includes the following updates:

🚨 Breaking Changes 🚨

• The api_source variable for the Google Ads package is now defaulted to google_ads as opposed to adwords. The Adwords API has since been deprecated by Google and is now no longer the standard API for the Google Ads connector. Please ensure you are using a Google Ads API version of the Fivetran connector before upgrading this package. (#53)
  • Please note, the adwords version of this package will be fully removed from the package in August of 2022. This means, models under models/adwords_connector will be removed in favor of models/google_ads_connector models.

Features

• By default the ad_reporting models are now materialized in a customer schema named <target_schema> + ad_reporting. This can be adjusted within the models section of your root dbt_project.yml if desired. (#53)

dbt_ad_reporting 0.7.0

Happy Thursday!

This release of the dbt_ad_reporting package includes the following updates:

🚨 Breaking Changes 🚨

• The Google Ads dependency has been updated to now reference the latest version of the dbt_google_ads package (v0.6.0). This version of the package incorporates new and modified tables within the Google Ads API version of the connector. For more information, refer to the relevant dbt_google_ads and dbt_google_ads_source v0.6.0 release notes.

dbt_ad_reporting v0.6.0

🎉 dbt v1.0.0 Compatibility and TikTok Ads Addition 🎉

Feature Additions

• Added the TikTok Ads package to be included in the final ad_reporting model. (#36)

🚨 Breaking Changes 🚨

• Adjusts the require-dbt-version to now be within the range [">=1.0.0", "<2.0.0"]. Additionally, the package has been updated for dbt v1.0.0 compatibility. If you are using a dbt version <1.0.0, you will need to upgrade in order to leverage the latest version of the package.

  • For help upgrading your package, I recommend reviewing this GitHub repo's Release Notes on what changes have been implemented since your last upgrade.
  • For help upgrading your dbt project to dbt v1.0.0, I recommend reviewing dbt-labs upgrading to 1.0.0 docs for more details on what changes must be made.

• Upgrades the package dependencies to refer to the latest individual ad package versions. Additionally, the latest individual ad package versions have a dependency on the latest dbt_fivetran_utils. Further, the latest dbt_fivetran_utils package also has a dependency on dbt_utils [">=0.8.0", "<0.9.0"].

  • Please note, if you are installing a version of dbt_utils in your packages.yml that is not in the range above then you will encounter a package dependency error.

• TikTok Ads has been added as a dependency and is enabled by default. Be sure to disable the models via the README if you do not have a TikTok Ads connector.

• For more information refer to the README.

dbt_ad_reporting 0.6.0-b1

🎉 dbt v1.0.0 Compatibility Pre Release 🎉 An official dbt v1.0.0 compatible version of the package will be released once existing feature/bug PRs are merged.

🚨 Breaking Changes 🚨

• Adjusts the require-dbt-version to now be within the range [">=1.0.0", "<2.0.0"]. Additionally, the package has been updated for dbt v1.0.0 compatibility. If you are using a dbt version <1.0.0, you will need to upgrade in order to leverage the latest version of the package.
  • For help upgrading your package, I recommend reviewing this GitHub repo's Release Notes on what changes have been implemented since your last upgrade.
  • For help upgrading your dbt project to dbt v1.0.0, I recommend reviewing dbt-labs upgrading to 1.0.0 docs for more details on what changes must be made.
• Upgrades the package dependencies to refer to the latest individual ad package versions. Additionally, the latest individual ad package versions have a dependency on the latest dbt_fivetran_utils. Further, the latest dbt_fivetran_utils package also has a dependency on dbt_utils [">=0.8.0", "<0.9.0"].
  • Please note, if you are installing a version of dbt_utils in your packages.yml that is not in the range above then you will encounter a package dependency error.

dbt_ad_reporting 0.5.1

Happy Thursday!

This release of the dbt_ad_reporting package includes the below updates:

Feature Additions

• Added the account_name and account_id to the stg_snapchat_ads model. This will allow for the relevant Snapchat Ads account information to flow downstream into the final ad_reporting model. (#30)

Under the Hood

• Cast the account_id and external_account_id as strings within the stg_google_ads model.

Contributors

• @csoule-shaker (#30)
• @csoule1622 (#30)

Google Ads API Compatibility

Happy Wednesday!

This release includes a breaking upgrade to the Fivetran ad_reporting package. This update features:

• Added functionality to use this package if you have switched to the Google Ads API within your Fivetran Google Ads connector. To make this switch you will leverage the api_source variable detailed within the README. PR #27

Huge shoutout to @DylanBaker for his hard work on the Google Ads API compatibility! 🎉

Add Facebook Account Information

Happy Monday modelers!

This release addresses issue #25 and passes the account_id and account_name from Facebook to be included in the ad_reporting final model.

LinkedIn Ads Hierarchy Fix

LinkedIn Ads Hierarchy Fix

Happy Thursday! Today we are releasing a breaking change for the ad reporting package. This release includes the following changes:

• Switches the LinkedIn Ads hierarchy of campaigns and campaign_groups to align correctly with the other ad platforms. For all other platforms in the ad reporting package a single campaign may contain multiple ad groups. however, LinkedIn hierarchy is structured so a campaign_group may contains multiple campaigns. As such, we have adjusted the hierarchy to allow for correct aggregations across platforms.

Huge shout-out to @andrew-woelfel for catching this and opening PR #23 to apply the fix! 🎉

dbt 0.20.0 Compatibility

🎉 dbt 0.20.0 Compatibility 🎉

🚨 This is a breaking change! 🚨 dbt v0.20.0 or greater is required for this release. If you are not ready to upgrade, consider using a previous release of this package.

Additional considerations when upgrading to this package:

• This package utilizes the latest v0.7.x release of the dbt-labls/dbt_utils package. If your project also utilizes a version of the fishtown-analytics/dbt_utils package then you will receive a duplicate package error. If this is the case you will need to consider upgrading your other packages to be compatible with this update or use a previous release of this package.
• Similar to the above point, all previous Fivetran dbt packages utilize the fishtown-analytics/dbt_utils package and you will need to upgrade all Fivetran dbt packages to the latest dbt 0.20.0 compatibility releases in order for your packages to run without package conflicts.
• For Databricks users this compatibility is currently only available for >=dbt 0.20.1rc1. If you want more information on upgrading your dbt-spark version, you can refer to the dbt-spark release for further details.

Postgres Compatibility

🎉 Postgres Compatibility 🎉

This release incorporates Postgres compatibility changes. These changes are non-breaking and only include changes for integration testing and Postgres specific updates to the package.