Release Notes

October 2024

We've added support for hourly report granulation for our Pinterest Ads connector. You can now choose whether to sync reports with daily or hourly granularity on the connector setup form. This change only applies to new Pinterest Ads connections created after October 11, 2024.

Previously, all reports were synced with daily granularity. For more information, see our Pinterest Ads setup guide.

June 2024

We have added the following new metrics to report tables:

• checkout_roas
• pinterest_checkout_cost_per_action
• pinterest_checkout_roas
• total_checkout_conversion_rate
• total_add_to_cart_conversion_rate
• custom_roas
• total_custom_conversion_rate
• total_custom_value_in_micro_dollar

April 2024

We have added new Quickstart packages for the following connectors:

• Apple App Store
• LinkedIn Company Pages
• Pendo
• Pinterest Ads
• Recurly
• SAP ERP on HANA
• ServiceNow
• Twitter Ads

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

November 2023

We have added a new table, PIN_ANALYTICS_REPORT. The pin_stats column, previously removed in the July 2023 update from the PIN_HISTORY table, is now available in the new table. We will gradually roll out this change to all existing Pinterest Ads connectors by December 20, 2023. For more information on the API used to obtain the data, see Pin analytics API documentation.

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 Pinterest Ads' API documentation. As part of the upgrade, we have made the following schema changes:

• 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 and 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, and 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, and privacy to the BOARD_HISTORY table
  • default_ad_group_budget_in_micro_currency, is_automated_campaign, is_campaign_budget_optimization, and is_flexible_daily_budgets to the CAMPAIGN_HISTORY table
  • description, filters, and is_featured to the CATALOG_PRODUCT_GROUPS_HISTORY table
  • alt_text, board_owner_username, board_section_id, dominant_color, is_standard, media_type, and parent_pin_id to the PIN_HISTORY table
  • ad_account_id and collection_items_destination_url_template to the PIN_PROMOTION_HISTORY table
  • catalog_product_group_name, is_mdl, slideshow_collections_title, and tracking_url to the PRODUCT_GROUP_HISTORY table

• We have removed the following fields from the tables below because Pinterest has deprecated them:

  • billing_profile_status, billing_type, merchant_id, and status from the ADVERTISER_HISTORY table
  • campaign_budget_optimization_enabled from the CAMPAIGN_HISTORY table
  • featured_position, merchant_id, and 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, and tracking_params from the PIN_HISTORY table

• We have updated the primary keys for the CUSTOMER_LIST_HISTORY table. The new composite primary key consists of the id and updated_time columns.

April 2022

We have expanded the Create a connection and Update a connection endpoints of our REST API. Now you can authorize the Pinterest Ads connection 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 Pinterest Ads' API documentation.

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, so we have removed them:

• 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 Pinterest's documentation.

• 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 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 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 priority-first sync documentation.

May 2020

You can now configure your Pinterest Ads connector using the Fivetran REST API. This feature is in BETA and is 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 Pinterest Ads' API documentation.

October 2019

We have upgraded the connector to Pinterest Ads API 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 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 Pinterest Ads connector now syncs the following advertising reports:

• Advertiser
• Campaigns
• AdGroups
• Pin Promotions
• Product Groups

Read our Pinterest Ads connector documentation.

June 2018

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

Read our Pinterest Ads connector documentation.