BigQuery Connector

Sync Pinterest Ads Data to BigQuery

Detrics loads Pinterest Ads into Google BigQuery on the schedule you set. The tables arrive clean, the history keeps growing, and you can query everything from SQL, Looker Studio, or Claude. We run the pipeline so you don't have to.

Book a Demo

*Free 30-minute consultation

SELECT
  campaign_name,
  SUM(spend_in_dollar) AS spend_in_dollar,
  SUM(total_impression) AS total_impression,
  SUM(total_video_3_sec_views) AS total_video_3_sec_views
FROM `your_project.marketing_data.pinterest_ads_video_performance_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY campaign_name
ORDER BY spend_in_dollar DESC
LIMIT 10

Why send Pinterest Ads data to BigQuery?

Ad creatives that never expire

Creative URLs expire. Detrics archives your campaign images and videos permanently.

History without limits

Platform APIs cap how far back you can query. In BigQuery every Pinterest Ads sync is stored across its 13 tables, so you accumulate years of your own history.

One warehouse for everything

Join Pinterest Ads with the rest of your platforms in one place, no copy-pasting between sheets.

Ask Claude about it

With your data in BigQuery, Claude can answer business questions about Pinterest Ads in plain language.

Pinterest Ads tables in BigQuery

This is what Detrics creates for Pinterest Ads: 13 preset tables with scheduled syncs, plus any custom one you define.

Campaign Performance

account_overview_daily

Pinterest advertising campaign metrics overview

ad account IDad account namespend in dollartotal impressiontotal clickthroughtotal engagement+3

campaign_performance_daily

Audience engagement data analysis

ad account namecampaign namecampaign objective typespend in dollartotal impressiontotal clickthrough+4

ad_group_performance_daily

Ad group level performance with campaign context

campaign namead group IDad group namespend in dollartotal impressiontotal clickthrough+5

+3 more tables in this group

Conversions & Engagement

video_performance_daily

Video completion rates and quartile views analysis

campaign namead group namead namespend in dollartotal impressiontotal video 3 sec views+7

e_commerce_funnel_daily

Full e-commerce conversion funnel from clicks to checkout

ad account namecampaign namespend in dollartotal clickthroughtotal page visittotal add to cart+3

lead_generation_daily

Lead and signup conversion tracking

ad account namecampaign namespend in dollartotal clickthroughtotal leadtotal click lead+5

Targeting & Settings

targeting_breakdown

Performance breakdown by targeting type and value

campaign namead group namead namespend in dollartotal impressiontotal clickthrough+4

utm_tracking

Ad performance with UTM parameter breakdown

campaign namead namedestination URLspend in dollartotal impressiontotal clickthrough+6

ad_group_settings

Ad group optimization goals and bid settings

campaign namead group IDad group namespend in dollartotal impressiontotal clickthrough+7

+1 more table in this group

HOW IT WORKS

From Pinterest Ads to your warehouse

Connect your account once. Detrics handles schemas, syncs, and backfills.

First step

Connect your first datasource

Link any of 32+ marketing and ecommerce platforms in a couple of clicks.

Connect a source

Second step

Set up your destination

Point Detrics at your BigQuery project and dataset. We write the SQL and handle the setup for you.

Set up destination

Third step

Create your transfer

Choose what to sync and how often. Detrics builds and runs the pipeline for you.

Create a transfer

And that's it

Real-time data, forever

Your data lands in the warehouse and stays fresh automatically. We handle the syncing, the maintenance, and every API update for you.

Book a demo

In the demo we set everything up for you and save you hours.

Then ask Claude about it

With Pinterest Ads in BigQuery, the Detrics MCP server lets you run queries in plain language. MCP access is included with every BigQuery plan.

Which Pinterest Ads campaigns should I pause this quarter?

What was my Pinterest Ads spend last month vs. the month before?

Which campaign performed best on Pinterest Ads this week?

Explore the Pinterest Ads MCP server

Every Pinterest Ads field, on demand

Preset tables curated by our team
Custom tables with any field combination
Incremental syncs that only load new data
Automatic backfill of up to 12 months of history

345 metrics

88 dimensions

View Pinterest Ads Fields

Get Pinterest Ads into your warehouse this week