Pinterest Ads Data Connector User Guide

Pinterest Ads Data Connector User Guide

Info
Pinterest Ads is a powerful advertising platform that allows businesses to promote their products and services to Pinterest's vast user base. This guide will walk you through the process of connecting your Pinterest Ads account to Power My Analytics, creating reports in Data Studio, and understanding key metrics and considerations for your Pinterest Ads data.



Prerequisites

Before you begin, ensure you have:
  1. A Pinterest account with at least Ad Account Admin or Campaign access

Granting Required Permissions to a User

To grant a user Ad Account Admin or Campaign access:
  1. Go to Pinterest Business Manager and click on Employees.
  2. Select Add employees and enter the user's email address.
  3. Choose Ad account admin or Campaign and click Assign permissions.

Adding Pinterest Ads as a Data Source

  1. Log in to your Power My Analytics hub.
  2. Navigate to the Sources section in the menu.
  3. Click on + Add new source.
  4. Select Pinterest from the gallery of available sources.
  5. Sign in to your Pinterest account to authenticate.

Creating a Data Studio Report

Follow these steps to create a Data Studio report using your Pinterest Ads data:
  1. In your Power My Analytics hub, go to Reports > Data Studio
  2. Select Pinterest Ads under Create Data Studio Report (this will open the official Data Studio application in a new window)
  3. Google Data Studio Configuration:
    1. Step 1:
      1. Name your data source (e.g., "Pinterest Ads - Company Name")
      2. Select your Power My Analytics hub from the dropdown
      3. Optional: Keep "Use report template for new reports" checked
      4. Click Next
    2. Step 2:
      1. User Account: Choose your Pinterest Ads account or "Sample Account" for sample data
      2. Click Next
    3. Step 3:
      1. Select "Advertisers," "Conversion window," and "Conversion date for daily reporting" for your reports
      2. Optional: Allow “Advertisers”, “Conversion window”, “Conversion date for daily reporting” modification in reports
      3. Click Connect in the top right corner
    4. Step 4:
      1. Click Create Report in the top right corner
For a quick start, use our pre-built Pinterest Ads demo template.

Understanding Conversion Windows in Pinterest Ads

A conversion window tells Pinterest how long after someone interacts with your ad an action (such as a purchase) still counts as a conversion. When you set up your Pinterest Ads source, you choose a conversion window from a dropdown on the connector configuration screen, and every option matches one that Pinterest accepts.

On April 1, 2025, Pinterest retired the separate "engagement" part of the conversion window and moved to the industry-standard model of click and view attribution only. To match this, the connector offers 13 conversion window options (including the Default, 30/30), shown as days after click / days after view. For example, 60/30 counts a conversion within 60 days of a click or 30 days of a view, and 7/0 counts clicks only within 7 days (the 0 means view conversions are turned off).

Select Allow "Conversion window (days after click / days after view)" to be modified in reports if you want to change the window inside your charts later.



There are 2 options for conversion date for daily reporting and they are the same as the options available in the Pinterest Ads UI. Select Allow Conversion date for daily reporting to be modified in reports to modify conversion date options within charts.

The options for conversion date in the Pinterest Ads connector configuration.
Notes
A note on historical data: because Pinterest removed the engagement portion of the calculation, conversion figures reported before April 1, 2025 may not match what you see if you re-pull or backfill that period. Backfilling older data re-aligns it to the current click and view behavior, so previously reported engagement-inclusive numbers can change.
Notes
Already connected? If you connected before this update and picked an option that is no longer listed, your reports keep working: Pinterest automatically resolves older settings to their click and view equivalents. If numbers ever look off, re-select a current option from the dropdown. You will also no longer see the "Invalid attribution windows combination" error, because only accepted options are offered.

Key Reports and Fields

Popular metrics for Pinterest Ads include:
  • Performance Metrics: Spend, Paid impressions, CPC, Checkouts, Paid Pin clicks
  • Campaign Metrics: Spend, Impressions, CPM, Paid Pin clicks, CTR, Outbound Clicks, Gross impressions, Gross Pin clicks
  • Ad Group Metrics: Spend, Impressions, CPM, Paid Pin clicks, CTR, Outbound Clicks, Gross impressions, Gross Pin clicks
  • Ad Metrics: Spend, Impressions, CPM, Paid Pin clicks, CTR, Outbound Clicks, Gross impressions, Gross Pin clicks
For a complete list of available Pinterest Ads fields, refer to the Schema Explorer.

Reporting with Breakdowns by Targeting Type

Our Pinterest Ads connector provides breakdowns by targeting type at the account, campaign, ad group, and pin promotion levels. Each of these breakdowns will only return data if it has been used as a targeting type.

Info
Only one of these breakdowns can be selected at a time.

The following breakdowns are available:

  • Audience Include: The audience targeted by the campaign or ad group.
  • Country: The country targeted by the campaign or ad group.
  • Gender: A list of the genders targeted by the campaign or ad group.
  • Keyword: The user’s search term that triggered the ad.
  • Location: The user metropolitan areas or regions targeted by the campaign or ad group.
  • Pinner Interest: The user’s interests.
  • Placement: The placement of the campaign or ad group.
  • Targeted Interest: The user interests targeted by the campaign or ad group.
  • Targeting App Type: A list of the app types targeted by the campaign or ad group.
  • Targeting Geo: A list of the geolocations targeted by the campaign or ad group.

Notes
Note: Reach and Frequency metrics cannot be used with these breakdowns.

Limitations and Important Considerations

  1. Cached Data Requests with Unique Metrics and Date Dimension: When a unique metric is paired with the date dimension, this will result in a request for cached data instead of a request for live data. For more information, please see Understanding Cached and Live Data Requests.
  2. Backfilling: Backfilling is limited to 90 days. Historical data beyond 90 days will be collected starting when you create a report.
  3. Reach and Frequency: Reach and Frequency data is only available for the past 185 days. Requests for longer date ranges will return inaccurate values.
  4. Data refresh time: Pinterest Ads data refreshes at midnight Universal Time (UTC-0) and cannot be adjusted for your local time zone.

Unavailable Data

  1. Custom fields

Troubleshooting

For problems with Reach or Frequency, please see Reach And/or Frequency Not Working in Pinterest Ads Report. For all other concerns, see our article Basic Troubleshooting for information on issues that may affect the Pinterest Ads connector.

    • Related Articles

    • How to Connect to Pinterest Ads

      Looking to bring your Pinterest Ads data into a single, automated reporting workflow? This guide will walk you through connecting Pinterest Ads as a data source in Power My Analytics, so you can centralize your campaign, ad group, and ad performance ...

    • Pinterest Organic Data Connector User Guide

      Pinterest Organic provides valuable insights into your Pinterest account's performance, audience engagement, and content effectiveness. This guide will walk you through the process of setting up and utilizing Pinterest Organic as a data source in ...

    • Google Ads Data Connector User Guide

      Google Ads is a powerful online advertising platform that allows businesses to reach potential customers across Google's vast network. This guide will walk you through how to connect your Google Ads data to Power My Analytics, create reports in Data ...

    • Apple Ads Data Connector User Guide

      The following article is a guide to automating reports with your Apple Search Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Apple Search Ads reports. To ...

    • LinkedIn Ads Data Connector User Guide

      LinkedIn Ads is a powerful platform for B2B marketing, lead generation, brand awareness campaigns, and revenue attribution. This guide will help you connect your LinkedIn Ads account to Power My Analytics, enabling you to create comprehensive reports ...