v1.11.0 dbt_ad_reporting

Breaking Changes

LinkedIn Ads

• The dbt_linkedin dependency has been updated to [">=0.10.0", "<0.11.0"], and the dbt_linkedin_source dependency has been updated to [">=0.10.0", "<0.11.0"]. These upstream versions introduce breaking changes. For details, refer to the dbt_linkedin_source v0.10.0 and dbt_linkedin v0.10.0 release notes. (PR #120)
  • Added the click_uri_type field to the following models. This field allows users to differentiate which click uri type (text_ad or spotlight) was used to populate the click_uri field.
    • stg_linkedin_ads__creative_history
    • linkedin_ads__creative_report
    • linkedin_ads__url_report
    • Note: Only text_ad and spotlight click URI types are supported. To request support for additional types, submit a Feature Request.
  • The click_uri field now populates values using a COALESCE of text_ad_landing_page, spotlight_landing_page, and click_uri. For details, refer to the dbt_linkedin_source v0.10.0 release notes. (PR #120)
    • This change aligns with the LinkedIn Ads API migration and Fivetran LinkedIn Ads connector update, which moved click_uri data to text_ad_landing_page or spotlight_landing_page based on creative type.

TikTok Ads

• The dbt_tiktok_ads dependency has been updated to [">=0.7.0", "<0.8.0"], and the dbt_tiktok_source dependency has been updated to [">=0.7.0", "<0.8.0"]. These upstream versions introduce breaking changes. For details, refer to the dbt_tiktok_ads_source v0.7.0 and dbt_tiktok_ads v0.7.0 release notes. (PR #127)
• The age column in the ADGROUP_HISTORY table was renamed to age_groups in the July 2023 TikTok update. (PR #127)
  • Previously, the stg_tiktok_ads__ad_group_history model coalesced age and age_groups to handle legacy data. Due to incompatible data types (string and JSON), this coalesced field has been removed in favor of solely the age_groups column.
  • To populate historical data in the age_groups column, perform a resync of the ADGROUP_HISTORY table. TikTok provides all data regardless of the previous sync state.
  • For more details, see the Tiktok Ads DECISIONLOG.

Documentation Changes

• Improved README structure by moving the Ad Reporting heading above the README tags and aligning it to the left. (PR #124)

Under the Hood

• Added consistency validation tests for the following models to enhance integration testing (used internally by Fivetran maintainers) (PR #127):
  • ad_reporting__ad_report
  • ad_reporting__url_report

Contributors

• @conrad-mal (PR #124)

Full Changelog: v1.10.0...v1.11.0