Skip to content

dbt_google_ads 0.8.0
Compare
Choose a tag to compare
@fivetran-sheringuyen fivetran-sheringuyen released this 02 Sep 20:31
· 152 commits to main since this release
v0.8.0
dae1cb3
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.

🚨 Breaking Changes 🚨

  • The adwords api version of the package has been fully removed. As the Fivetran Google Ads connector now requires the Google Ads API, this functionality is no longer used. (#34)
  • Removal of the google_ads__ad_adapter model. (#34)
  • Major updates have also been applied to the dbt_google_ads_source package which is a dependency of this package. Please refer to the v0.8.0 release notes for more details before upgrading your package.
  • The declaration of passthrough variables within your root dbt_project.yml has changed. To allow for more flexibility and better tracking of passthrough columns, you will now want to define passthrough metrics in the following format:

This applies to all passthrough metrics within the dbt_google_ads package and not just the google_ads__ad_stats_passthrough_metrics example.

vars:
  google_ads__ad_stats_passthrough_metrics:
    - name: "my_field_to_include" # Required: Name of the field within the source.
      alias: "field_alias" # Optional: If you wish to alias the field within the staging model.

🎉 Feature Enhancements 🎉

  • Addition of the following new end models. These models were added to provide further flexibility and ensure greater accuracy of your Google Ads reporting. Additionally, these new end models will be leveraged in the respective downstream dbt_ad_reporting models.

    • google_ads__account_report
      • Each record in this table represents the daily performance at the account level.
    • google_ads__campaign_report
      • Each record in this table represents the daily performance of a campaign at the campaign/advertising_channel/advertising_channel_subtype level.
    • google_ads__ad_group_report
      • Each record in this table represents the daily performance at the ad group level.
    • google_ads__keyword_report
      • Each record in this table represents the daily performance at the ad group level for keywords.
    • google_ads__ad_report
      • Each record in this table represents the daily performance at the ad level.
    • google_ads__url_report
      • Each record in this table represents the daily performance of URLs at the ad level.

  • Added testing for each end model to ensure granularity and accuracy of the modeled data. (#34)

  • README updates for easier navigation and use of the package. (#34)

  • Inclusion of additional passthrough metrics within the respective end state models detailed above: (#34)

    • google_ads__ad_group_stats_passthrough_metrics
    • google_ads__campaign_stats_passthrough_metrics
    • google_ads__keyword_stats_passthrough_metrics
    • google_ads__account_stats_passthrough_metrics

Contributors

Assets 2
Loading