Mailchimp Weekly Email Marketing Digest

Overview

This solution produces a weekly Mailchimp email-marketing performance digest. Every Monday morning it reads all Mailchimp campaigns and audiences, aggregates the current 7-day window against the prior 7-day window, and renders an HTML report covering campaigns sent, emails delivered, average open and click rates, week-over-week open-rate change, the top-performing campaign, total audience, and list growth. Highlights are posted to a Teams marketing channel and the full report is emailed to leadership. If the average open rate falls below a configurable threshold, the digest flags declining engagement.

Why it matters: Email performance needs steady attention. A pushed weekly readout keeps marketing and leadership focused on what is working and what is slipping - without anyone opening Mailchimp.

Status: Built via API-first deployment, shipped Off (demo). Going live requires only authorizing the connections and setting environment-variable values.

Use Case

Marketing wants a no-effort weekly readout of email performance and list health, and leadership wants the headline numbers in their inbox. This flow replaces a manual weekly export-and-summarize task with an automatic, scheduled digest.

Flow Architecture

Environment Variables

Connectors & Connections

Connector	API name	Actions used
Mailchimp	shared_mailchimp	GetCampaigns GetLists
Microsoft Teams	shared_teams	PostMessageToConversation
Office 365 Outlook	shared_office365	SendEmailV2

Note — All connections are referenced as solution connection references; the flow is portable between environments as long as a connection is mapped at import time.

Customization Guide

Almost every realistic variant of this flow can be implemented by changing environment variable values. A few cases require small edits inside the flow definition — those are called out explicitly below.

Threshold tuning

Adjust flowlibs_MailchimpOpenRateThreshold (e.g. 0.20 for 20%) to change when declining-engagement is flagged.

Window length

Change flowlibs_MailchimpDigestLookbackDays to run a daily (1), bi-weekly (14), or monthly (30) digest; the prior-window comparison auto-adjusts.

Schedule

Edit the Weekly Recurrence trigger (frequency / day / hour / time zone).

Per-audience digests

Clone and filter campaigns by recipient.list_id to send separate digests per audience.

Power BI

Extend with a Mailchimp to Dataverse to Power BI pipeline for a full historical dashboard.

Key Expressions

The flow is intentionally light on Power Fx / WDL gymnastics — the heaviest expressions are the branch-name concatenation and the approval outcome check. They are listed below in the order they appear in the flow.

and(equals(item()?['status'],'sent'), greaterOrEquals(coalesce(item()?['send_time'],'1970-01-01T00:00:00+00:00'), addDays(utcNow(), mul(-1, variables('varLookbackDays')))))

if(greater(variables('varSentCount'),0), div(variables('varSumOpenRate'), variables('varSentCount')), 0)

sub(outputs('Compute_Avg_Open_Rate'), outputs('Compute_Prior_Avg_Open_Rate'))

formatNumber(mul(outputs('Compute_Avg_Open_Rate'),100),'0.0')

Customize & download