Mailchimp Engagement to CRM Activity for Education

# Mailchimp Engagement to CRM Activity - Education

## Purpose
Implement so your sales team can see which prospects are engaging with marketing emails and prioritise warm leads.

## When to Use
Sync Mailchimp email opens, clicks, and unsubscribes back to your CRM contact records to inform sales conversations with email engagement data.

## Instructions
1. Review the template below and familiarise yourself with the structure
2. Replace all [bracketed placeholders] with your education business details
3. Customise the tone and formatting to match your brand
4. Save in your preferred tool (Mailchimp or HubSpot)

---

## Mailchimp Engagement to CRM Activity

### Overview
Sync Mailchimp email engagement data (opens, clicks, and unsubscribes) to your HubSpot CRM contact records in real time, enabling your sales team to see which prospects are actively engaging with marketing emails and prioritise their outreach accordingly.

### Prerequisites
- Mailchimp account (Essentials plan or above)
- HubSpot CRM (Free or above, Sales Hub Starter recommended for activity tracking)
- Zapier account (Starter plan for multiple Zaps)
- Active email campaigns in Mailchimp

### Setup Steps

**Step 1: Create custom HubSpot contact properties**
In HubSpot, go to Settings > Properties > Contact Properties and create:
- "Last Email Opened" (Date, for the most recent email open)
- "Last Email Clicked" (Date, for the most recent link click)
- "Email Engagement Score" (Number, for tracking overall engagement)
- "Last Campaign Name" (Single-line text)
- "Email Engagement Level" (Dropdown: Hot, Warm, Cold, Unsubscribed)

**Step 2: Create the Email Open Zap**
Log in to Zapier and click "Create Zap". Name it "Mailchimp Open to HubSpot".

**Step 3: Configure the Mailchimp trigger (Opens)**
- App: Mailchimp
- Trigger event: "New Campaign Open"
- Account: Connect your Mailchimp account
- Audience: Select your primary audience
- Test: Send a test campaign and open it, then verify Zapier detects the open

**Step 4: Configure the HubSpot action (Update Contact)**
- App: HubSpot
- Action event: "Update Contact"
- Search by: Email address (from Mailchimp subscriber email)

**Step 5: Map fields for email opens**

| Mailchimp Field | HubSpot Property | Notes |
|----------------|------------------|-------|
| Subscriber Email | Contact lookup (email) | Match the CRM contact |
| Open Timestamp | Last Email Opened | Date of the email open |
| Campaign Name | Last Campaign Name | Which campaign they opened |
| (calculated) | Email Engagement Score | Increment by 1 for each open |
| "Warm" | Email Engagement Level | Update engagement level |

**Step 6: Create the Link Click Zap**
Create a second Zap named "Mailchimp Click to HubSpot":
- Trigger: Mailchimp "New Campaign Link Click"
- Action: HubSpot "Update Contact"
- Map subscriber email to contact lookup
- Update: Last Email Clicked to click timestamp
- Update: Email Engagement Score - increment by 3 (clicks are stronger intent signals than opens)
- Update: Email Engagement Level to "Hot"

**Step 7: Create the Unsubscribe Zap**
Create a third Zap named "Mailchimp Unsubscribe to HubSpot":
- Trigger: Mailchimp "New Unsubscriber"
- Action: HubSpot "Update Contact"
- Update: Email Engagement Level to "Unsubscribed"
- Update: HubSpot marketing contact status to "Non-marketing contact"
- This ensures your sales team knows not to reference email content with this contact

**Step 8: Set up engagement scoring logic**
Use the Email Engagement Score to automatically categorise contacts:
- Score 0: Cold (no engagement)
- Score 1-5: Warm (occasional opens)
- Score 6 and above: Hot (multiple opens and clicks)

In HubSpot, create a workflow that:
- Checks Email Engagement Score daily
- Updates Email Engagement Level based on score thresholds
- Notifies the contact owner when a contact moves from Warm to Hot

**Step 9: Create a sales notification (optional)**
Add a Slack notification step to the Link Click Zap:
- Channel: #sales-notifications or DM to the contact owner
- Message: "[Contact Name] just clicked a link in '[Campaign Name]'. They may be ready for outreach. View contact: [HubSpot URL]"

**Step 10: Test the integration**
1. Send a test email campaign from Mailchimp to a small test list
2. Open the email from a test account
3. Wait 1-2 minutes and verify HubSpot updates "Last Email Opened" and engagement score
4. Click a link in the email
5. Verify HubSpot updates "Last Email Clicked" and engagement level changes to "Hot"
6. If Slack notification is enabled, verify the sales team receives the alert

### Error Handling
- **Contact not found:** If the Mailchimp subscriber email does not exist in HubSpot, either create a new contact or skip the update (recommended to skip, as not all subscribers are sales leads)
- **Multiple opens:** The same person may open an email multiple times. The Zap triggers for each open, which is fine as it updates the timestamp and increments the score.
- **Bot opens:** Some email clients pre-fetch links, causing false opens. Mailchimp filters most of these, but engagement scores may be slightly inflated.
- **Campaign exclusions:** Add a Zapier filter to exclude internal test campaigns from triggering engagement updates.

### Maintenance
- Reset Email Engagement Scores quarterly to keep them relevant (create a scheduled Zap or HubSpot workflow)
- Review engagement thresholds monthly and adjust based on your sales team's feedback
- Add new campaign types to your filters as your email marketing programme expands
- Audit the sync monthly to ensure Mailchimp and HubSpot subscriber counts are aligned

---

**Complexity:** intermediate | **Setup time:** 15 minutes | **Tools:** Mailchimp, HubSpot, Zapier

Note: This template has been tailored for education businesses in Australia. Adjust terminology and compliance references to match your specific context.