Every Monday, emails marketing a table of last week's campaigns with open and click rates.
Uses
Gmail
Mailchimp
Email last week's Mailchimp campaign results
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 emptyYes
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.htmlGmailNo
No steps