Release Notes

July 2023

We have upgraded our connector from Pinterest Ads API version 4 to version 5 because Pinterest has deprecated version 4. For more information, see .

We have added the following new tables:

AD_REJECTED_LABEL_HISTORY
BOARD_PIN_THUMBNAIL_URL
BOARD_SECTION
CATALOG_FEED
CONVERSION_TAG_CONFIG
PIN_MEDIA
PIN_MEDIA_IMAGE

We have added the following fields to the tables below:

account_permissions, owner_username to the ADVERTISER_HISTORY table
ad_account_id, bid_strategy_type, conversion_learning_mode_type, feed_profile_id, pacing_delivery_type, placement_group, summary_status to the AD_GROUP_HISTORY table
rule to the AUDIENCE_HISTORY table
board_pins_modified_at, collaborator_count, description, follower_count, media_image_cover_url, owner_username, pin_count, privacy to the BOARD_HISTORY table
default_ad_group_budget_in_micro_currency, is_automated_campaign, is_campaign_budget_optimization, is_flexible_daily_budgets to the CAMPAIGN_HISTORY table
description, filters, is_featured to the CATALOG_PRODUCT_GROUPS_HISTORY table
alt_text, board_owner_username, board_section_id, dominant_color, is_standard, media_type, parent_pin_id to the PIN_HISTORY table
ad_account_id, collection_items_destination_url_template to the PIN_PROMOTION_HISTORY table
catalog_product_group_name, is_mdl, slideshow_collections_title, tracking_url to the PRODUCT_GROUP_HISTORY table

Pinterest has deprecated the following fields, so we have removed them from the tables below:

billing_profile_status, billing_type, merchant_id, status from the ADVERTISER_HISTORY table
campaign_budget_optimization_enabled from the CAMPAIGN_HISTORY table
featured_position, merchant_id, product_count from the CATALOG_PRODUCT_GROUPS_HISTORY table
attribution, cacheable_id, comment_count, domain, image_large_url, image_medium_url, image_square_size_*, image_square_url, is_downstream_promotion, is_playable, is_promotable, is_repin, is_uploaded, is_video, not_promotable_reason, pin_stats, price_currency, price_value, promoter, repin_count, tracked_link, tracking_params from the PIN_HISTORY table

We have updated the primary keys for the following tables:

id and updated_time is a new primary key for the CUSTOMER_LIST_HISTORY table

April 2022

We have expanded the and endpoints of our REST API. Now you can authorize the connector by adding the auth section to payloads.

February 2022

We have upgraded our connector from Pinterest Ads API version 3 to version 4, because Pinterest has deprecated version 3. For more information, see .

We have made the following schema changes to support Pinterest Ads API version 4:

We have added two new tables, PRODUCT_ITEM_REPORT and CATALOG_PRODUCT_GROUPS_HISTORY.

We have added the following fields to the tables below:

catalog_product_group_id to the PRODUCT_GROUP_HISTORY table
billing_profile_status, billing_type, merchant_id, and status to the ADVERTISER_HISTORY table
updated_time and created_time to the AUDIENCE_HISTORY table
enhanced_match_status, last_fired_time_ms, status, and version to the CONVERSION_TAG_HISTORY table
summary_status, status_time, end_time, and campaign_budget_optimization_enabled to the CAMPAIGN_HISTORY table

Pinterest has deprecated the following tables:

TAG_HISTORY
APP_EVENT_TRACKING_CONFIG_HISTORY
ITEM_REPORT

Pinterest has deprecated the following fields, so we have removed them from the tables below:

deleted, exclude, and new_match_type from the KEYWORD_HISTORY table
NOTE: The deleted field was removed, but the archived field has similar usage. According to Pinterest, archiving a keyword effectively deletes it. The keywords no longer receive metrics and are no longer visible within the parent entity's keywords list. For more information, see .
valid and active from the PRODUCT_GROUP_HISTORY table
test_account and is_one_tap from the ADVERTISER_HISTORY table
rule from the AUDIENCE_HISTORY table
num_matched_user_records and list_type from the CUSTOMER_LIST_HISTORY table
verification_status, click_window_days, conversion_type, view_window_days, created_time, engagement_window_days, and updated_time from the CONVERSION_TAG_HISTORY table
billing_group, product_filter, measurement_partner_campaign_id, and placement_exclusion from the CAMPAIGN_HISTORY table

We have updated the primary keys for the following tables:

id, updated_time, advertiser_id, and audience_type is a new primary key for the AUDIENCE_HISTORY table
date, product_group_id, advertiser_id, targeting_type, and targeting_value is a new primary key for the PRODUCT_GROUP_TARGETING_REPORT table

October 2021

We now sync the pin_stats and influencer_pin_stats extra properties for the PIN_HISTORY table.

September 2021

We now sync the PRODUCT_GROUP_TARGETING report.

We now sync the following Targeting type tables:

TARGETING_AGE_BUCKET
TARGETING_APP_TYPE
TARGETING_GENDER
TARGETING_GEO
TARGETING_GEO_METRO
TARGETING_GEO_REGION
TARGETING_INTEREST
TARGETING_LOCALE
TARGETING_LOCATION

December 2020

The Pinterest Ads connector now supports the 0-day conversion attribution window. You can sync your data based on your custom Pinterest click, engagement, or view attribution windows, such as 1-day click/0-day engagement/0-day view, or 7-day click/0-day engagement/0-day view.

September 2020

We have released pre-built, dbt Core-compatible data models for Pinterest Ads. Find the models in or . Learn more about our dbt Core integration in our *.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

July 2020

The Pinterest Ads connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Pinterest Ads's priority-first syncs fetch the most recent thirty days' worth of data from the reporting tables.

To learn more, see our .

May 2020

You can now configure your Pinterest Ads connector using the . This feature is in BETA and available only for Standard and Enterprise accounts.

April 2020

We have added a new table, KEYWORD_REPORT.

February 2020

When setting up your connector, you can now select which advertisers you'd like to sync. Previously, Fivetran synced all advertisers by default.

January 2020

We have deprecated the optimization_goal field in the CAMPAIGN_HISTORY table. This change is required to migrate our Pinterest connector to the Pinterest Ads API V3. For more details, see .

October 2019

We have upgraded the Pinterest Ads API to version 3, since versions 1 and 2 of the API have been deprecated. For more details, see .

We have made a number of schema changes to support Pinterest Ads API version 3.

The new objective_type field has replaced the optimization_goal field in the CAMPAIGN_HISTORY table. We will support the optimization_goal field for the next three months, and then it will be deprecated.
The deprecated bid_type field has been reformatted and renamed to billable_event in the AD_GROUP_HISTORY table.
We have added the following fields to the tables below:
- billable_event to the AD_GROUP_HISTORY table
- creative_type to the PIN_PROMOTION_HISTORY table
Pinterest has deprecated the following fields, so we have removed them from the tables below:
- bid_type from the AD_GROUP_HISTORY table
- campaign_type, bid_type, is_one_tap, and upgrade_status from the CAMPAIGN_HISTORY table
- upgrade_status from the PIN_PROMOTION_HISTORY table

July 2019

We released a new version of our Pinterest Ads connector, service version 1. You can now select how many months' worth of data you'd like to include in your initial sync. Choose from the following options:
- 3 months
- 6 months
- 12 months
- 24 months
- All time

October 2018

We no longer process ITEM reports for advertisers who are not running shopping campaigns, because Pinterest only allows advertisers who are running shopping campaigns to access these reports.

July 2018

The Pinterest Ads connector now syncs ITEM and PIN_PROMOTION_TARGETING reports.

The connector syncs the following Pinterest advertising reports: Advertiser, Campaigns, AdGroups, Pin Promotions, and Product Groups.

June 2018

The connector syncs Pinterest advertising meta-data related to Campaigns, AdGroups, Pin Promotions etc.