Mailchimp data reference
Marketing
3 tables
87 columns
Lucen syncs your Mailchimp data (Marketing) to your warehouse and models it into the tables below. You connect Mailchimp with one OAuth sign-in. By default your data refreshes every day at 06:00 Buenos Aires time (UTC-3). Your plan sets how many times a day it can sync, and you can choose the times, see pricing.
Audience history starts at the first sync. Your plan sets how much history the first sync loads, see pricing.
Send Mailchimp data to
Tables
gold_mailchimp_audience_growth_daily
- Grain
- audience + snapshot day (
account_id,list_id,snapshot_date)
gold_mailchimp_campaign_performance
- Grain
- one sent campaign (
account_id,campaign_id)
gold_mailchimp_campaigns_daily
- Grain
- send day in the account's timezone (
account_id,send_date). A day with no send has no row
Columns
Column names match your warehouse exactly. Descriptions come from dbt.
gold_mailchimp_audience_growth_daily columns
16
gold_mailchimp_campaign_performance columns
48
gold_mailchimp_campaigns_daily columns
23
Typical questions
Prompt to try
Which campaigns performed best
gold_mailchimp_campaign_performance
Prompt to try
Sends, opens and clicks by day or week
gold_mailchimp_campaigns_daily
Prompt to try
Is the audience growing, and how fast
gold_mailchimp_audience_growth_daily
Prompt to try
Revenue Mailchimp attributes to email
gold_mailchimp_campaign_performanceecommerce_total_revenue
Starter queries
sql
SELECT send_date, account_id, campaign_id, campaign_title, subject_line
FROM `your-project.your_org_gold.gold_mailchimp_campaign_performance`
WHERE send_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY send_date DESC
LIMIT 100;sql
SELECT send_date, account_id, campaigns_sent, campaigns_without_report, emails_sent
FROM `your-project.your_org_gold.gold_mailchimp_campaigns_daily`
WHERE send_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY send_date DESC
LIMIT 100;sql
SELECT snapshot_date, account_id, list_id, list_name, member_count
FROM `your-project.your_org_gold.gold_mailchimp_audience_growth_daily`
WHERE snapshot_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY snapshot_date DESC
LIMIT 100;