Why this project existed
This engagement involved a business running Dynamics 365 Sales that needed outbound email marketing, engagement tracking, and subscription compliance—while keeping CRM data authoritative and clean.
The full Microsoft marketing solution (Dynamics 365 Customer Insights – Journeys, formerly Dynamics 365 Marketing) delivers deep journey orchestration but introduces a fixed monthly cost that did not align with this organization’s size or marketing maturity.
Cost comparison: Enterprise marketing vs. targeted integration
| Solution | Primary Capabilities | Approx. Monthly Cost |
|---|---|---|
| Dynamics 365 Customer Insights – Journeys (Base) | Full journey orchestration, multi‑channel campaigns, Dataverse‑native segmentation | ~$1,700 / tenant / month |
| Dynamics 365 Customer Insights – Journeys (Attach) | Same platform with discounted licensing for qualifying Dynamics tenants | ~$1,000 / tenant / month |
| Mailchimp + Power Automate (This Solution) | Email campaigns, open/click tracking, two‑way CRM sync, unsubscribe compliance | Typically < $200 / month |
The annual cost delta—often exceeding $10,000—was the deciding factor in pursuing a targeted integration rather than a full marketing platform deployment.
Architecture and design principles
- Dynamics 365 Sales remains the system of record
- Mailchimp operates as the marketing execution engine
- Email address is the authoritative join key
- Power Automate handles orchestration, validation, and compliance
Automation #1 — Dynamics → Mailchimp (New contacts)
This flow triggers when a contact record is created in Dataverse. The trigger is scoped at the organization level and filtered to fire only on Add events to avoid unnecessary executions.
Key mapped fields include primary email address, first name, and last name. New contacts are added to the Mailchimp master audience with a default status of Subscribed, ensuring they are immediately eligible for marketing communication.
This automation eliminates manual list exports and ensures marketing always starts with CRM‑approved data.
Automation #2 — Mailchimp → Dynamics (Inbound subscribers)
Marketing activities frequently introduce contacts before sales does (web sign‑ups, events, imported lists). This flow triggers when a new Mailchimp audience member is added.
Before creating a Dynamics record, the flow performs a Dataverse query using the subscriber’s email address. A conditional check evaluates the result count and only creates a new contact if no existing record is found.
This pattern prevents duplication while allowing marketing to operate independently without contaminating CRM data quality.
Automation #3 — Dynamics opt‑out → Mailchimp unsubscribe
Compliance must remain consistent across systems. This flow triggers when a Dynamics contact is modified and evaluates the Do Not Email field.
If the flag is set to true, the corresponding Mailchimp subscriber is updated to an Unsubscribed state. The flow explicitly enables “update existing member” behavior to avoid failed runs or duplicate entries.
Automation #4 — Mailchimp unsubscribe → Dynamics compliance
Mailchimp does not currently expose a native Power Automate trigger for unsubscribe events. To solve this, unsubscribe notifications are routed to a shared mailbox.
Power Automate monitors incoming messages, converts HTML content to plain text, extracts the email address, and performs a Dataverse lookup to identify the corresponding contact.
The contact is updated with Do Not Email = true, ensuring unsubscribe actions initiated by recipients are reflected back into CRM.
Operational considerations and lessons learned
- Always map existing Dataverse fields during update actions to avoid data loss
- Use one authoritative Mailchimp audience list
- Monitor flow run history for connector throttling and parsing errors
- Establish governance for email address changes and shared inboxes
When this approach makes sense
This model fits organizations that need reliable outbound email marketing, clean CRM data, and predictable costs—without the overhead of enterprise journey orchestration.
Conclusion
By combining Dynamics 365 Sales, Mailchimp, and Power Automate, this solution delivered measurable marketing capability at a fraction of the cost of full Dynamics marketing tooling—while preserving compliance and long‑term maintainability.