Email List
Segmentation
Pulled directly from the Mailchimp API and the three ERP customer exports Patrick sent (Pacesetter, Professional, Waste Water), plus the Leadership / Sales / Purchasing segmentation Matt Boehm started building. This is the current state and our recommendation for getting to a real, ongoing segmentation process.
Mailchimp Audiences Today
| Audience | Members | Avg Open | Avg Click |
|---|---|---|---|
| K-Rain Newsletter | 17,691 | 16.5% | 0.7% |
| Sana Store Customer Information | 5,140 | 24.5% | 0.9% |
| K-Rain Distributors | 2,302 | 20.5% | 2.9% |
| Premier Contractor | 1,790 | 24.2% | 1.2% |
| International Distributors | 186 | 40.1% | 4.9% |
| PRO LC Users | 49 | 52.9% | 1.5% |
| South Africa | 51 | 18.2% | 1.2% |
| Direct & Outside Sales | 37 | 78.1% | 9.6% |
| K-Rain Facebook Fan Email Addresses | 1 | 0.0% | 0.0% |
The Premier Contractor list (1,790 members) is the most directly relevant to the new Meta lead gen push, since it is already a warm audience for that exact program.
ERP Lists (Not Yet in Mailchimp)
Sourced from Customer Service / the ERP directly, per Patrick, so these should be more reliable than what is currently in Mailchimp. The Pacesetter list is the same tagging category that caused the July 1 pricing email to miss customers, which confirms this data is worth reconciling against Mailchimp first.
Master Contacts: Role Segmentation
Matt Boehm (Director of Sales) has this segmented into Leadership, Purchasing, and Sales so pricing/margin messaging can stay restricted to Leadership and Purchasing. The 845 unassigned contacts are what Patrick wants a Teams session on, to route each to the right sales rep.
Proposed Path Forward
- 1. Reconcile the three ERP lists against Mailchimp to find genuinely net-new contacts, since these came straight from Customer Service and are more reliable than the current Mailchimp state.
- 2. Mirror the Leadership / Sales / Purchasing tags from the Master Contacts workbook into Mailchimp as actual segment tags, so campaigns can target one group without leaking to the others.
- 3. Resolve the 845 unassigned contacts with Patrick and the sales team in a working session, then push those rep assignments back into Mailchimp.
- 4. Run remaining gaps (missing job titles/regions) through Apollo to fill in role and territory data where LinkedIn presence allows.
- 5. Reconfirm unsubscribed vs. subscribed status across the full list before any future pricing blast, so the July 1 miss does not repeat.