Mailchimp reporting in Monday.com

Yep you can use the “Campaign Report” action step to pull data from a previously-sent campaign and then send it to Monday.
 

I can imagine an answer that would need to go into several different layers depending on what daily reporting you need. Like, do you want daily updates on the last X-amount of campaigns, which also entails updating that information over time, or do you just want a snapshot on that specific date for a single campaign?

Either way, it will start with a scheduler trigger, set to trigger every day at whatever time you give it.

Then you will have to going in through the MailChimp API. First, if you don’t know the campaign ID, you’re going to have to do some work to get the campaign IDs you’re interested. (I suggest setting up a separate Zap(s) that push campaign data and ID into a Zapier table.)

Assuming you know, or can get, the campaign IDs, then you just need to send a GET request via the API to get the campaign information:

• https://mailchimp.com/developer/marketing/api/campaigns/get-campaign-info/

And/or loop through the multiple campaigns you want.

Once you have it/them, you can just map those fields into your Monday board.

Hey ​@Ian.Gargan,

As you are only after click through and open rates, Campaign report action should be able to suffice your needs. Store the campaign id in Google Sheets/ Zapier tables.

Your workflow will look like this-

• Schedule by Zapier trigger- Set it to daily
• Get Many Spreadsheet Row action- Google Sheets
• Looping by Zapier
• Campaign Report action- Mailchimp
• Update item action- Monday

Here is a helpful article about Looping in Zapier- https://help.zapier.com/hc/en-us/articles/8496106701453-Loop-your-Zap-actions. Hope it helps!

Hi there ​@Ian.Gargan 👋

How did you get on with the suggestions from Andrew, David and Sparsh? Were you able to get it sorted, or did you get stuck at all?

Keep us posted on your progress here, want to make sure you’re all set! 🙂