Email & Messaging
Mailchimp schema
SightShark syncs Mailchimp into a data warehouse you own. It creates 2 tables holding 32 fields, refreshed daily. Campaigns and list members.
2 tables / 32 fields / Provisional
Provisional
The table names below follow this site’s naming convention rather than a production sync, and the field names follow the documented Mailchimp schema. Confirm both against your own dataset before you rely on them.
Tables and fields
Every table this connector creates. Field lists come from the production sync where we publish it, and otherwise from the documented schema, marked on the table.
mailchimp_campaigns
8 fields
- campaign_id
- subject_line
- send_time
- emails_sent
- opens
- unique_opens
- clicks
- subscriber_clicks
mailchimp_list_members
24 fields, documented schema
- id
- list_id
- country_code
- dstoff
- email_address
- email_client
- email_type
- gmtoff
- ip_opt
- ip_signup
- language
- last_changed
- latitude
- longitude
- member_rating
- source
- status
- timestamp_opt
- timestamp_signup
- timezone
- unique_email_id
- unsubscribe_reason
- vip
- web_id
Where it lands
Into a warehouse you already own, in a region you pick. The modelling runs inside that project, so nothing leaves your cloud to be transformed and we keep no copy of your history.
- Google BigQuery
- Snowflake
- Databricks
- AWS Redshift
- Azure Synapse
Email results sit outside the reporting everything else is in, so its contribution is argued about rather than measured.
Questions people ask
What tables does SightShark create from Mailchimp?
2 tables, including mailchimp_campaigns, mailchimp_list_members. mailchimp_campaigns is one row per campaign. Every one is listed on this page, with its fields.
Which Mailchimp fields can I get?
The 32 fields on this page, table by table. Lists marked documented schema follow the published schema for Mailchimp, and your own warehouse may carry a few more or fewer.
How often does Mailchimp data refresh?
Daily. A sync adds to the tables rather than replacing them, so when a platform restates a figure for a day that has already closed, both the original number and the correction stay on record.
Can I join Mailchimp data to my other platforms?
Yes. Every metric is modelled to one name, one type, one grain and one currency, so a query across Mailchimp and another source needs no reconciling of field names first.
Related connectors
Reporting on this data
- 6 min read
What a first-party data strategy actually involves.
Less a strategy than an inventory, a home and a set of permissions.
Read it - 7 min read
A UTM naming convention that holds across clients.
UTMs are the join between what a client spent and what happened. Get them wrong and no amount of tooling recovers it.
Read it - 6 min read
How to set up alerts across client accounts, and keep them worth reading.
An alert that fires every day becomes a filter rule. Four things are worth interrupting somebody for.
Read it
Get started
Want Mailchimp in your own warehouse?
A call with someone who can answer the schema questions.