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 metrics, create comprehensive reports, and make data-driven decisions to optimize your Pinterest advertising spend.
Prerequisites
Before you begin, make sure you have:
- A Pinterest account with at least Ad Account Admin or Campaign access on the ad account you want to connect
If you do not yet have one of the required roles, follow Step 1 below to grant it before continuing.
Step 1: Grant Required Permissions in Pinterest Business Manager
To grant Ad Account Admin or Campaign access to a user in Pinterest Business Manager:
- Log in to Pinterest Business Manager and click on Employees.
- Select Add employees and enter the user's email address.
- Choose Ad account admin or Campaign.
- Click Assign permissions.
- Have the invited user accept the invitation before continuing.
Power My Analytics' connector will never edit, create, or delete anything in your Pinterest Ads account. Ad Account Admin or Campaign access is the minimum role required for the connector to read your reporting data.
Step 2: Add Pinterest Ads as a Data Source in Power My Analytics
- Log in to your Power My Analytics hub at https://hub.powermyanalytics.com.
- Navigate to Sources from the main menu.
- Click + Add new source.
- Select Pinterest from the list of available sources.
- Sign in to your Pinterest account using credentials with Ad Account Admin or Campaign access from Step 1.
- Authorize the requested permission scopes to complete the connection.
Once connected, Pinterest Ads will appear in your list of active data sources. Your Pinterest Ads data will automatically begin syncing to your Power My Analytics data warehouse, and you can then use it in Data Studio reports, Google Sheets, Microsoft Excel, or export it to your preferred data destination.
Backfill window: Pinterest's API limits backfilling to 90 days. Historical data beyond 90 days will be collected starting from the day you first create a report. Reach and Frequency metrics are only available for the past 185 days — requests for longer date ranges will return inaccurate values.
Data refresh time zone: Pinterest Ads data refreshes at midnight Universal Time (UTC) and cannot be adjusted for your local time zone in the Hub. Plan reports and date ranges with this in mind.
Targeting type breakdowns: When using breakdowns by targeting type (Audience Include, Country, Gender, Keyword, Location, Pinner Interest, Placement, Targeted Interest, Targeting App Type, Targeting Geo), only one breakdown can be selected per chart, and Reach and Frequency metrics cannot be combined with these breakdowns.