Email last week's Mailchimp campaign results

Campaign numbers are only useful if someone looks at them. Every Monday at 8:00 this gathers the Mailchimp campaigns sent in the previous Monday to Sunday and emails marketing a table of each one's subject, people reached, open rate and click rate, best open rate first. The best campaign is named in the subject line.

In a week with no campaigns, nothing is sent.

Run every Monday at 08:00.Run every Monday at 08:00.

Marketing team's emailSet marketingEmail to blank.

Campaigns sent last weekGet campaign results Save it as results.Mailchimp

If results.campaigns isn't emptyIf results.campaigns isn't empty

Yes

Campaigns, best open rate firstSort results.campaigns by open_rate, largest first and save it as best_first.

Table of campaignsMake a table of best_first Save it as campaign_table.

Email the results to marketingSend an email to marketingEmail. Save it as email. Subject: Last week's campaigns: best was best_first[0].namecampaign_table.htmlGmail

No

No steps