BigQuery Connector

Sync Perfit Data to BigQuery

Detrics loads Perfit 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
  date,
  SUM(conversions) AS conversions,
  SUM(conversions_amount) AS conversions_amount,
  SUM(sent) AS sent
FROM `your_project.marketing_data.perfit_monthly_campaign_trends_monthly`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY date
ORDER BY conversions DESC
LIMIT 10

Why send Perfit data to BigQuery?

See which emails sell

Join email campaigns with sales and traffic to see which sends actually drive revenue.

History without limits

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

One warehouse for everything

Join Perfit 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 Perfit in plain language.

Perfit tables in BigQuery

Our team sets these up with you during onboarding: 5 preset tables with scheduled syncs, plus any custom one you define.

Campaign Analytics

deliverability_spam_tracking_all

Monitor bounces, spam complaints, and unsubscribes

campaign namelaunch datesentdelivereddelivered ratebounced+6

monthly_campaign_trends_monthly

Aggregated monthly campaign performance

sentdeliveredopenedclickedopen rateclick rate+2

List Analytics

all_lists_overview_all

Complete contact list analytics

list namelist descriptionlist last mailedtotal contactsactive contactsinactive contacts+4

Automation Analytics

automation_engagement_all

Lifetime email engagement per automation flow

automation nameautomation triggerautomation sentautomation openedautomation clickedautomation open rate+2

automation_funnel_drop_off_all

Automation funnel & drop-off breakdown

automation nameautomation enabledautomation typesautomation triggeredautomation activeautomation completed+3

HOW IT WORKS

From Perfit 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 Perfit in BigQuery, the Detrics MCP server lets you run queries in plain language. MCP access is included with every BigQuery plan.

Which Perfit campaign had the best open rate?

Compare my Perfit conversions against last month

Which campaign responds best to my sends?

Explore the Perfit MCP server

Every Perfit 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

51 metrics

30 dimensions

View Perfit Fields

Get Perfit into your warehouse this week