April 2022link
We have expanded the Create a Connector and Modify a Connector endpoints of our REST API. Now you can authorize the Pinterest Ads connector by adding the auth
section to payloads.
February 2022link
We have upgraded our connector from Pinterest Ads API version 3 to version 4, because Pinterest has deprecated version 3. For more information, see Pinterest Ads’ API documentation.
We have made a number of schema changes to support Pinterest Ads API version 4.
We have added the following tables:
PRODUCT_ITEM_REPORT
CATALOG_PRODUCT_GROUPS_HISTORY
Pinterest has deprecated the following tables:
TAG_HISTORY
APP_EVENT_TRACKING_CONFIG_HISTORY
ITEM_REPORT
We have added the following fields to the tables below:
catalog_product_group_id
to thePRODUCT_GROUP_HISTORY
billing_profile_status
,billing_type
,merchant_id
,status
to theADVERTISER_HISTORY
tableupdated_time
,created_time
to theAUDIENCE_HISTORY
tableenhanced_match_status
,last_fired_time_ms
,status
,version
to theCONVERSION_TAG_HISTORY
tablesummary_status
,status_time
,end_time
,campaign_budget_optimization_enabled
to theCAMPAIGN_HISTORY
table
Pinterest has deprecated the following fields, so we have removed them from the tables below:
deleted
,exclude
,new_match_type
from theKEYWORD_HISTORY
table
Although the
deleted
field was removed thearchived
field has the similar meaning. An excerpt from the official documentation: “Archiving a keyword effectively deletes it - keywords no longer receive metrics and no longer visible within the parent entity’s keywords list.” See more details in Pinterest’s documentation.
valid
,active
from thePRODUCT_GROUP_HISTORY
tabletest_account
,is_one_tap
from theADVERTISER_HISTORY
tablerule
from theAUDIENCE_HISTORY
tablenum_matched_user_records
,list_type
from theCUSTOMER_LIST_HISTORY
tableverification_status
,click_window_days
,conversion_type
,view_window_days
,created_time
,engagement_window_days
,updated_time
from theCONVERSION_TAG_HISTORY
tablebilling_group
,product_filter
,measurement_partner_campaign_id
,placement_exclusion
from theCAMPAIGN_HISTORY
table
We updated primary keys for the following tables:
id
,updated_time
,advertiser_id
,audience_type
is a new primary key for theAUDIENCE_HISTORY
tabledate
,product_group_id
,advertiser_id
,targeting_type
,targeting_value
is a new primary key for thePRODUCT_GROUP_TARGETING_REPORT
table
October 2021link
We now sync the pin_stats
and influencer_pin_stats
extra properties for the PIN_HISTORY
table.
September 2021link
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 2020link
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 2020link
We have released pre-built, dbt Core-compatible data models for Pinterest Ads. Find the models in Fivetran’s dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.
* 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 2020link
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 of data from the reporting tables.
To learn more, see our priority-first sync documentation.
May 2020link
You can now configure your Pinterest Ads connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
April 2020link
We have added a new table, KEYWORD_REPORT
.
February 2020link
When setting up your connector, you can now select which advertisers you’d like to sync. Previously, Fivetran synced all advertisers by default.
January 2020link
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 Pinterest Ads’ API documentation.
October 2019link
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 Pinterest Ads’ API documentation.
We have made a number of schema changes to support Pinterest Ads API version 3.
-
The new
objective_type
field has replaced theoptimization_goal
field in theCAMPAIGN_HISTORY
table. We will support theoptimization_goal
field for the next three months, and then it will be deprecated. -
The deprecated
bid_type
field has been reformatted and renamed tobillable_event
in theAD_GROUP_HISTORY
table. -
We have added the following fields to the tables below:
billable_event
to theAD_GROUP_HISTORY
tablecreative_type
to thePIN_PROMOTION_HISTORY
table
-
Pinterest has deprecated the following fields, so we have removed them from the tables below:
bid_type
from theAD_GROUP_HISTORY
tablecampaign_type
,bid_type
,is_one_tap
, andupgrade_status
from theCAMPAIGN_HISTORY
tableupgrade_status
from thePIN_PROMOTION_HISTORY
table
July 2019link
-
We released a new version of our Pinterest Ads connector, service version 1. You can now select how many months 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 2018link
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 2018link
The Pinterest Ads connector now syncs ITEM
and PIN_PROMOTION_TARGETING
reports.
June 2018link
The connector syncs Pinterest advertising meta-data related to Campaigns, AdGroups, Pin Promotions etc.