Lucen

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;

Integration page