Skip to content

Latest commit

 

History

History
113 lines (90 loc) · 5.69 KB

CHANGELOG.md

File metadata and controls

113 lines (90 loc) · 5.69 KB

dbt_apple_search_ads version.version

Documentation

  • Added Quickstart model counts to README. (#28)
  • Corrected references to connectors and connections in the README. (#28)

dbt_apple_search_ads v0.4.1

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

dbt_apple_search_ads v0.4.0

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.

dbt_apple_search_ads v0.3.0

PR #20 includes the following updates:

Feature update 🎉

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.

dbt_apple_search_ads v0.2.2

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:

dbt_apple_search_ads v0.2.1

Accidental Release

dbt_apple_search_ads v0.2.0

🚨 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 v0.1.0

Initial Release

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