Background
Customers can be transferred from iPaaS.com to Mailchimp as a member/contact with any associated custom fields.
Matching
The integration will look to see if a member/contact exists by looking at the email address and try to match on that to connect the records before creating a new one.
Customer Custom Fields
Mailchimp Custom Fields
The following fields come with the integration:
FNAME: First Name
LNAME: Last Name
MMERGE11: Sample custom field to be created in MailChimp
USR COMPANY: Company
Creating custom fields in Mailchimp
Custom fields in Mailchimp can be added in iPaaS.com:
If the field is present it will map to it.
If the field is not present, it will be added to Mailchimp and the data will be mapped.
Feild names need to be in all caps and be 10 characters or less.
iPaaS.com Custom Fields
None are supported in this integration.
Customers FROM iPaaS.com
Webhooks (Internal)
In order to enable Customer data to flow FROM iPaaS.com, the following external webhooks need to be enabled:
customer/created
customer/updated
Data Mapping
Customer to Mailchimp
This is used for adding and/or updating member/contact in Mailchimp from iPaaS.com customers.
Mapping Type | Source (iPaaS.com) | Destination (Mailchimp) |
Field | EmailAddress | EmailAddress |
Field | Company | USRCOMPANY |
Field | LastName | LNAME |
Field | FirstName | FNAME |
Static | [user provided] | ListId |
Static | subscribed | Status |
Field | EmailAddress | MMERGE11 |
Notes
In Mailchimp a member/contact can belong to one and only one list/audience. Our default mappings provide for passing that as a static field, but this could be handled via dynamic formulas or multiple mappings with filters to account for different customers being assigned to different lists/audiences.
In order to find the ID used for the list/audience, navigate to Audience>Manage Audience>View audiences.
On the AUdiences screen, for the Audience you want to map to, click the dropdown arrow next to Stats>Settings.
Click on Audience name and campaign defaults.
Select the ID in red under Audience ID and use that in your mapping(s).
Supported Conversion Functions
FormatBirthdayMMDD(object input): Accepts a DateTime, DateTimeOffset, or any string that can be handled by DateTime.Parse and returns a string in the format MM/DD, as needed by Mailchimp.
FormatBirthdayDDMM(object input): Same as above, but returns a string in DD/MM format (this is configurable in Mailchimp)
BuildAddress(object addressResponse): Convert an iPaaS Address object into a valid Mailchimp address. This lets you identify the iPaaS address you want and pass it as-is into the function to get a formatted value. E.g. if we just wanted to use the first address, this would work:
if(Addresses == null || Addresses.Count == 0)
return null;
return BuildAddress(Addresses[0]);
Note: These are not included in the template mappings.