Live with your own API key

Pinterest Ads to BigQuery

On Pro and Agency, the same columns (Date (DATE), Campaign (CAMPAIGN_NAME), Times shown (IMPRESSION_1), Clicks (CLICKTHROUGH_1), Amount spent (SPEND_IN_DOLLAR), Conversions (TOTAL_CONVERSIONS)) can land in BigQuery. Free and Starter keep the Sheet and the CSV. The warehouse table uses the report name so an agency can tell clients apart.

Start free See every Pinterest Ads field

Columns in this handoff

• Date · DATE
• Campaign · CAMPAIGN_NAME
• Times shown · IMPRESSION_1
• Clicks · CLICKTHROUGH_1
• Amount spent · SPEND_IN_DOLLAR
• Conversions · TOTAL_CONVERSIONS
• Revenue · TOTAL_CHECKOUT_VALUE

Plan fit

Pro and Agency plans. Free and Starter refresh daily. Pro refreshes hourly. Agency refreshes every 15 minutes on up to 50 accounts.

FAQ

How does Pinterest Ads get to BigQuery?

On Pro and Agency, the same columns (Date (DATE), Campaign (CAMPAIGN_NAME), Times shown (IMPRESSION_1), Clicks (CLICKTHROUGH_1), Amount spent (SPEND_IN_DOLLAR), Conversions (TOTAL_CONVERSIONS)) can land in BigQuery. Free and Starter keep the Sheet and the CSV. The warehouse table uses the report name so an agency can tell clients apart.

Which plan do I need?

Pro and Agency plans.

What if the source is not connected yet?

The report still opens with sample rows and a Sample data label. It switches to live rows after the credential is accepted.

Other ways out of Pinterest Ads

Pinterest Ads to Google Sheets · Pinterest Ads to Looker Studio · Pinterest Ads to AI and MCP · Pinterest Ads to the API · Pinterest Ads to Google Drive