Is your sales team constantly toggling between their CRM and other tools / spreadsheets to get relevant data about their accounts?

Thanks to Actiondesk, you can run automations getting data from anywhere, transforming it and sending it to your CRM.

Let's see in this tutorial how to do that with Mailchimp and Salesforce.

For each subscriber of a specific Mailchimp list, we will get the average open rate and average click rate, match each subscriber with the associated salesforce opportunity and fill up opportunity custom properties with those rates.
We can match an opportunity with a subscriber with the name of the opportunity which is the email of the subscriber.


Let's get started:
Import "Members" from Mailchimp

Import "Members" from Mailchimp

There is a column called stats. You can see the content of this column is a json.

Let's flatten this column to extract the data and make it usable

Import "Opportunities" from Salesforce
With a vlookup, for each subscriber let's retrieve the id of the associated salesforce opportunity

We are now ready to push the data to Salesforce!

Click on Program actions
Choose Sales force / Update / Opportunities
For id column, enter id_opportunities (that is how salesforce will know which opportunity to update)
Now, match the salesforce field with the fields from your actiondesk dataset

You're now done! Run the workflow once if you want to see the result, and you can schedule and publish!
Was this article helpful?
Thank you!