Mailchimp subscriber-level engagement data (opens, clicks, unsubscribes)#1573

We are currently using the Mailchimp connector through Windsor but the available dataset only exposes campaign-level aggregated metrics (open_rate, unique_opens, clicks, etc.).

For analytical and modeling purposes we need access to subscriber-level engagement activity, similar to what is available through the Mailchimp Marketing API report endpoints.

The goal is to analyze engagement behavior on the individual level, for example to measure whether a specific contact has recently opened or clicked a newsletter. This data will be used for behavioral analysis and predictive modeling.

Requested dataset

• Subscriber-level email activity for Mailchimp campaigns.

Suggested fields

• If possible, the following fields would be sufficient:

Identification

• email_address (or subscriber_hash)
• list_id / audience_id
• campaign_id

Engagement events

• open_timestamp
• click_timestamp
• unsubscribe_timestamp
• bounce_timestamp

Additional useful fields

• campaign_send_timestamp
• link_url (for click events)
• campaign_name or campaign_title

Data structure suggestion
Ideally one row per subscriber event, for example:

• email_address
• campaign_id
• event_type (open, click, unsubscribe, bounce)
• event_timestamp

Alternatively separate tables for:

• campaign_open_details
• campaign_click_details
• campaign_email_activity

This structure mirrors the Mailchimp Marketing API endpoints such as:

reports/{campaign_id}/open-details
reports/{campaign_id}/click-details
reports/{campaign_id}/email-activity

Use case
This data will allow us to build engagement features such as:

• opened newsletter in last 90 days
• clicked newsletter in last 180 days
• unsubscribed from newsletter

These signals are used in donor retention and churn modeling.

If needed we are happy to help test the dataset once available.