v0.12.0 dbt_pinterest

PR #39 includes the following updates:

Schema Changes

9 total changes • 0 possible breaking changes

Data Model	Change type	Old name	New name	Notes
pinterest_ads__campaign_country_report	New Transformation Model			New table that represents the daily performance of ads at the country and campaign level.
pinterest_ads__campaign_region_report	New Transformation Model			New table that represents the daily performance of ads at the region and campaign level.
stg_pinterest_ads__pin_promotion_targeting_report	New Staging Model			Uses pin_promotion_targeting_report source table
stg_pinterest_ads__targeting_geo_region	New Staging Model			Uses targeting_geo_region source table
stg_pinterest_ads__targeting_geo	New Staging Model			Uses targeting_geo source table
stg_pinterest_ads__pin_promotion_targeting_report_tmp	New Temp Model			Uses pin_promotion_targeting_report source table
stg_pinterest_ads__targeting_geo_region_tmp	New Temp Model			Uses targeting_geo_region source table
stg_pinterest_ads__targeting_geo_tmp	New Temp Model			Uses targeting_geo source table
stg_pinterest_ads__campaign_history	New Columns		start_time, end_time, budget_spend_cap, lifetime_spend_cap, objective_type

Features

• Added the following vars to enable/disable the new sources. See the README for more details.
  • pinterest__using_pin_promotion_targeting_report
    • Default is true. Will disable pinterest_ads__campaign_country_report and pinterest_ads__campaign_region_report if false.
  • pinterest__using_targeting_geo
    • Default is true. Will disable pinterest_ads__campaign_country_report if false.
  • pinterest__using_targeting_geo_region
    • Default is true. Will disable pinterest_ads__campaign_region_report if false.
• Added the var pinterest__pin_promotion_targeting_report_passthrough_metrics to allow bringing additional metrics through to the pinterest_ads__campaign_country_report and pinterest_ads__campaign_region_report models. Refer to the README for more details.

Under the Hood

• Added seed data for testing new sources
• Updated the consistency_url_report test to be at the advertiser_id grain instead of keyword_id.

Documentation

• Updated dbt documentation to reflect new tables and column additions.
• Added Quickstart model counts to README. (#38)
• Corrected references to connectors and connections in the README. (#38)

Full Changelog: v0.11.0...v0.12.0