01
True cost per signup
Join spend with signups from your own database instead of trusting platform-reported conversions.
CPA by campaign
Marketing
Mailchimp + Kimo
Campaigns, opens, clicks and audiences. Pull spend, reach and conversions into one model and see which campaigns actually turn into revenue.
- Auth
- OAuth 2.0
- Sync
- Hourly
- Setup
- ≈ 2 min
Live demo workspace with fictional data · no signup, no credentials needed
kimo / connectors / mailchimpSyncing
Sync loghourly
- Succeeded:campaigns+690 rowsnow
- Succeeded:conversions+2,309 rows2m ago
- Succeeded:campaign_stats_daily+2,252 rows4m ago
- Succeeded:campaigns+1,471 rows6m ago
Rows synced · 30 days
120.6M
Workspaces
10%
What you can do
What teams build with Mailchimp
Mailchimp on its own answers half the question. Joined with the rest of your stack in Kimo, it answers the other half.
02
Blended ROAS, every morning
One number across every ad network, with the same attribution window for all of them.
ROAS · 7-day window
03
Spend anomaly alerts
Get pinged when a campaign burns budget 2× faster than its trailing average.
Alert → Slack
Objects & tables
Exactly what gets synced
Kimo maps Mailchimp into clean, typed tables with primary keys and incremental cursors, so syncs stay fast and joins just work.
3 tables · 14 fields
Tables
campaigns
Incremental≈ 3,280,000 rows| Field | Type | Notes |
|---|---|---|
| campaign_id | id | Primary key |
| name | string | |
| status | enum | Low-cardinality dimension |
| budget | decimal | Measure |
| start_date | date | Incremental cursor |
Custom fields and extra objects are discovered automatically on each sync. Row counts are illustrative.
Sample model
From raw Mailchimp tables to a certified metric
A starter model Kimo suggests the moment Mailchimp is connected. Every join is editable.
Mailchimp · Paid acquisition
Spend and clicks joined with signups and revenue on UTM campaign and date.
- Mailchimpcampaigns
- Google Analytics 4sessions
- PostgreSQLusers
Model
utm_campaign · date
Measuresspendsignups
Ad spend · last 30 days
$2.2K-0.9% wk/wk
Fictional data · hover the chart for daily values
Setup
Connect Mailchimp in 2 min
No engineers, no pipelines to maintain. Kimo asks for the minimum access it needs and tells you exactly what it will read.
- 1
Click “Connect Mailchimp”
You are redirected to Mailchimp to sign in. Kimo never sees your password.
- 2
Approve read-only scopes
Kimo requests the narrowest scopes available. You can revoke access at any time.
- 3
Pick accounts
Choose which accounts to sync. Add more later without reconnecting.
- 4
First sync and schema mapping
Kimo backfills history, maps campaigns and suggests joins with your other sources.
Read-only, encrypted, revocable. Credentials are encrypted with a per-workspace key, never logged, and can be rotated without breaking your models.
Connect Mailchimp
Step 2 of 3 · Kimo demo workspace
Kimo wants read-only access to your Mailchimp account
read-only accessread
Accounts
- Northwind · Mailchimp
- Northwind EU · Mailchimp
Read-only access
Illustration only · placeholder values, never real secrets
Works great with
Pair Mailchimp with the rest of your stack
Kimo suggests these joins automatically when both sources are connected.
FAQ
Mailchimp questions, answered
By default Kimo syncs Mailchimp hourly. You can change the schedule per table, or trigger a sync manually from the connector page.
Mailchimp · OAuth 2.0 · Hourly
See your Mailchimp data in Kimo in 2 min.
Try it on the live demo workspace first, then connect your own account when you are ready.