BigQuery Connector

Sync Mailchimp Data to BigQuery

Detrics loads Mailchimp 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
  list_name,
  SUM(member_count) AS member_count,
  SUM(list_unsubscribe_count) AS list_unsubscribe_count,
  SUM(cleaned_count) AS cleaned_count
FROM `your_project.marketing_data.mailchimp_list_health_overview`
GROUP BY list_name
ORDER BY member_count DESC
LIMIT 10

Why send Mailchimp 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 Mailchimp sync is stored across its 7 tables, so you accumulate years of your own history.

One warehouse for everything

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

Mailchimp tables in BigQuery

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

Campaign Analytics

campaign_performance_overview

Key campaign metrics including opens and clicks

campaign namecampaign statuscampaign send dateemails sentunique opensopen rate+4

campaign_details_with_subject

Campaign details with subject line and timing

campaign namesubject linepreview textemails sentopen rateclick rate+1

industry_benchmark_comparison

Compare open and click rates against industry averages

campaign nameindustry typeopen rateindustry open rateclick rateindustry click rate+4

+1 more table in this group

List & Deliverability

delivery_health_tracking

Monitor bounces, unsubscribes, and abuse reports

campaign namecampaign send dateemails sentemails delivereddelivery ratebounces+4

list_health_overview

Monitor audience list health and subscription rates

list namelist ratingmember countlist unsubscribe countcleaned countcampaign count+4

list_growth_over_time

Monthly subscriber growth and churn

growth list namegrowth monthsubscribedunsubscribedoptinsimports+2

HOW IT WORKS

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

Which campaign responds best to my sends?

How many subscribers did I gain and lose in Mailchimp this quarter?

Build a Mailchimp summary for Monday's meeting

Explore the Mailchimp MCP server

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

56 metrics

24 dimensions

View Mailchimp Fields

Get Mailchimp into your warehouse this week