Connecting Pinterest Ads

Pulling your Pinterest Ads data into Google Sheets takes just a few clicks. Because Metric Might connects directly to the Pinterest API, you can pull live Spend, Saves (Repins), Outbound Clicks, and Conversion data across all your client accounts instantly.

1. Prerequisites (Required Permissions)

Before you can pull data, you must have the correct permissions inside your Pinterest Business account.

• You must have at least Analyst, Campaign Manager, or Admin access to the specific Pinterest Ad Account(s) you wish to query.
• If you manage multiple clients, ensure your personal Pinterest login has been granted access to their respective ad accounts before authenticating in Metric Might.

2. How to Connect

You can connect your Pinterest Ads account without leaving the query builder.

1. Open the Metric Might Web App and navigate to the Queries page.
2. Under the Data source section, click the dropdown and select Add Data Source.
3. Choose Pinterest Ads.
4. A secure popup will ask you to log into Pinterest. Review the permissions and click Grant Access.

3. Available Metrics & Dimensions

When building your query, click into the Metrics or Dimensions dropdowns to open the search overlay. You can search for standard fields like Spend, Impressions, and Outbound Clicks, as well as Pinterest-specific engagement metrics like Saves (Repins), Pin Clicks, and Video Views.

Metric Might’s live compatibility matrix will automatically disable any fields that cannot be queried alongside your current selection.

4. Token Expiry

Pinterest access tokens periodically expire for security reasons, or immediately if you change your Pinterest password or revoke access in your account settings.

You can see the exact expiry date of your Pinterest connection at any time on the Connections page — it is displayed directly on the data source card. This lets you re-authenticate proactively before a scheduled refresh breaks.

If a Pinterest query stops working unexpectedly with an authentication error, go to the Connections page, click the three-dot menu (⋮) next to the Pinterest data source, and select Sign In Again.

5. Pinterest-Specific Quirks & Gotchas

Pinterest operates differently than Facebook or Google because it is a visual discovery engine. If your data looks confusing, it is almost always due to one of the following.

Long Attribution Windows

Pinterest is highly inspirational. Users often click a Promoted Pin, save it to a board, and don’t actually make a purchase until weeks later. Because of this, Pinterest’s default attribution windows are historically much longer than other platforms (e.g., 30-day click, 30-day engagement, 1-day view).

If you pull a report for “Last Month,” those numbers may continue to increase over the next few weeks as delayed purchases finally roll in and are attributed back to the day the user originally clicked or engaged with the Pin.

”Earned” vs. “Paid” Metrics

When a user sees your Promoted Pin and saves it to their own board, their followers might see that repin and click it. Pinterest considers this downstream traffic “Earned” media, as opposed to direct “Paid” media.

In the Metric Might query builder, you will often see metrics split out (e.g., Paid Impressions vs. Earned Impressions, or Paid Outbound Clicks vs. Total Outbound Clicks). If you are trying to match the total numbers you see in the main Pinterest dashboard, ensure you are selecting the correct aggregated or paid-specific metric in your query.

Conversion Processing Delays

Like many modern ad platforms, Pinterest’s conversion tracking can take up to 24–48 hours to fully process and deduplicate conversion events. Always allow 48 hours for conversion and ROAS data to fully settle.

What’s Next?

• Why Doesn’t My Data Match? — a deeper dive into attribution and timezone discrepancies.
• Custom Metrics — build a custom “Cost per Save” or “Earned Media Ratio” formula using your Pinterest data.