v0.4.1 dbt_apple_search_ads

PR #26 includes the following updates:

Bug Fixes

• Adjusts inner joins in each end model to be left joins.
  • When ads and other entities are deleted from Apple Search Ads, their records are hard-deleted from the <entity>_history source tables, though any associated <entity>_report records persist with new <entity>_id values of -1. This update ensures that the report records persist into the package's end models in these cases.

Note: This will likely increase the row count of your data models. To remove these newly included records, filter out rows where the <entity>_id = -1.

• We have accordingly made sure to select fields, specifically entity IDs, from the left side of these joins (the report tables).

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

v0.4.0 dbt_apple_search_ads

PR #24 includes the following BREAKING CHANGE updates:

Feature Updates: Conversion Support

• Added the conversions source field to each apple_search_ads__*_report model.
• If you are already passing in these fields via the passthrough columns, the package will automatically prevent "duplicate column" errors.

Breaking change: This update impacts users not previously including conversions via passthrough columns.

• Since there is no direct conversion_value field available in Apple Search Ads data, added a DECISIONLOG entry discussing alternatives. See the Conversion Value section for more details.

Under the Hood

• Introduced the apple_search_ads_persist_pass_through_columns macro to maintain compatibility for users already passing conversion fields through passthrough columns.
  • This macro coalesces each passthrough metric with 0.
• Added validation tests for integrity and consistency of transformation models within the integration_tests folder (for maintainers only).

Documentation

• Added missing column descriptions for keyword_id and keyword_text in the apple_search_ads__search_term_report model.

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

v0.3.0 dbt_apple_search_ads

PR #20 includes the following updates:

Feature update 🎉

• Unioning capability! This adds the ability to union source data from multiple apple_search_ads connectors. Refer to the Union Multiple Connectors README section for more details.

Under the hood 🚘

• In the source package, 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 and downstream model and applied the fivetran_utils.source_relation macro.
  • The source_relation column is included in all joins in the transform package.
• Updated tests to account for the new source_relation column.

Full Changelog: v0.2.2...v0.3.0

v0.2.2 dbt_apple_search_ads

Bugfix:

• Updated the dbt_utils.unique_combination_of_columns test for the apple_search_ads__search_term_report to include the following fields. (PR #18):
  - date_day
  - search_term_text
  - keyword_id
  - ad_group_id
  - campaign_id
  - organization_id
  - match_type

Under the Hood:

• Incorporated the new fivetran_utils.drop_schemas_automation macro into the end of each Buildkite integration test job. (PR #15)
• Updated the pull request templates. (PR #15)

Contributors:

• @yuna-tang(PR #17)

Full Changelog: v0.2.0...v0.2.2

v0.2.0 dbt_apple_search_ads

🚨 Breaking Changes 🚨:

PR #14 includes the following breaking changes:

• Dispatch update for dbt-utils to dbt-core cross-db macros migration. Specifically {{ dbt_utils.<macro> }} have been updated to {{ dbt.<macro> }} for the below macros:
  • any_value
  • bool_or
  • cast_bool_to_text
  • concat
  • date_trunc
  • dateadd
  • datediff
  • escape_single_quotes
  • except
  • hash
  • intersect
  • last_day
  • length
  • listagg
  • position
  • replace
  • right
  • safe_cast
  • split_part
  • string_literal
  • type_bigint
  • type_float
  • type_int
  • type_numeric
  • type_string
  • type_timestamp
  • array_append
  • array_concat
  • array_construct
• For current_timestamp and current_timestamp_in_utc macros, the dispatch AND the macro names have been updated to the below, respectively:
  • dbt.current_timestamp_backcompat
  • dbt.current_timestamp_in_utc_backcompat
• packages.yml has been updated to reflect new default fivetran/fivetran_utils version, previously [">=0.3.0", "<0.4.0"] now [">=0.4.0", "<0.5.0"].

dbt_apple_search_ads 0.1.0

Initial Release

• This is the initial release of this package. For more information refer to the README.