Mailchimp Integration

Start here, start strong. Find your people, build your audience, and establish your brand from day one with Mailchimp’s all‑in‑one Marketing Platform.”

The Mailchimp integration brings in Customer, Product and Purchase History datasets. The standard set of attributes that are brought for this integration are shown in the table below. If you have made any customisations to your Mailchimp setup then bringing these in can be discussed during Supported Onboarding.

Customer Attributes

Distil.ai AttributeMapped Mailchimp AttributeMailchimp Attribute Description
Customer Id/ecommerce/stores/{store_id}/customers.idA unique identifier for the customer.
First Name/ecommerce/stores/{store_id}/customers.first_nameThe customer’s first name.
Last Name/ecommerce/stores/{store_id}/customers.last_nameThe customer’s last name.
Email Address/ecommerce/stores/{store_id}/customers.email_addressThe customer’s email address.
Mobile Phone Number
GDPR Status – Marketing Subscribed/ecommerce/stores/{store_id}/customers.opt_in_statusThe customer’s opt-in status. This value will never overwrite the opt-in status of a pre-existing Mailchimp list member, but will apply to list members that are added through the e-commerce API endpoints.
GDPR Status – Right of Access Requested
GDPR Status – Anonymise Data
Facebook Slug
Twitter Handle
Instagram Handle
LinkedIn Slug
Postal Address Line 1/ecommerce/stores/{store_id}/customers/address.address1The mailing address of the customer.
Postal Address Line 2/ecommerce/stores/{store_id}/customers/address.address2An additional field for the customer’s mailing address.
Postal Address Town/ecommerce/stores/{store_id}/customers/address.cityThe city the customer is located in.
Postal Address Region/ecommerce/stores/{store_id}/customers/address.provinceThe customer’s state name or normalized province.
Postal Address Country/ecommerce/stores/{store_id}/customers/address.countryThe customer’s country.
Postal Address Postcode/ecommerce/stores/{store_id}/customers/address.postal_codeThe customer’s postal or zip code.
Billing Address Line 1
Billing Address Line 2
Billing Address Town
Billing Address Region
Billing Address Country
Billing Address Postcode

Additional Customer Attributes available from Mailchimp can be found here. These may added as Custom Attributes into the Distil.ai Customers dataset.

Product Attributes

Distil.ai AttributeMapped Mailchimp AttributeMailchimp Attribute Description
Product Id/ecommerce/stores/{store_id}/products/variants.idA unique identifier for the product variant.
Product Name/ecommerce/stores/{store_id}/products/variants.titleThe title of a product variant.
Precis/ecommerce/stores/{store_id}/products.descriptionThe description of a product.
Thumbnail URL
Image URL/ecommerce/stores/{store_id}/products/variants.image_urlThe image URL for a product variant.
Shop URL/ecommerce/stores/{store_id}/products/variants.urlThe URL for a product variant.
Available/ecommerce/stores/{store_id}/products/variants.visibilityThe visibility of a product variant.
List Price – Excluding Tax/ecommerce/stores/{store_id}/products/variants.priceThe price of a product variant.
List Price – Including Tax/ecommerce/stores/{store_id}/products/variants.priceThe price of a product variant.
Price Breaks Description
Category/ecommerce/stores/{store_id}/products.typeThe type of product.

Additional Product Attributes available from Mailchimp can be found here. These may added as Custom Attributes into the Distil.ai Products dataset.

Purchase History Attributes

Purchase History attributes in Distil.ai are aligned to Order Lines in Mailchimp.

Distil.ai AttributeMapped Mailchimp AttributeMailchimp Attribute Description
Id/ecommerce/stores/{store_id}/orders/lines.idA unique identifier for the order line item.
Customer Id/ecommerce/stores/{store_id}/orders/customer.idA unique identifier for the customer.
Order Id/ecommerce/stores/{store_id}/orders.idA unique identifier for the order.
Product Id/ecommerce/stores/{store_id}/orders/lines.product_variant_idA unique identifier for the product variant associated with the order line item.
Order Timestamp UTC/ecommerce/stores/{store_id}/orders.processed_at_foreignThe date and time the order was processed in ISO 8601 format.
Quantity/ecommerce/stores/{store_id}/orders/lines.quantityThe quantity of an order line item.
Line Value Excluding Tax/ecommerce/stores/{store_id}/orders/lines.priceThe price of an order line item.
Line Value Including Tax/ecommerce/stores/{store_id}/orders/lines.priceThe price of an order line item.
Payment method
Currency/ecommerce/stores/{store_id}/orders.currency_codeThe three-letter ISO 4217 code for the currency that the store accepts.
Postal Address Line 1/ecommerce/stores/{store_id}/orders/shipping_address.address1The shipping address for the order.
Postal Address Line 2/ecommerce/stores/{store_id}/orders/shipping_address.address2An additional field for the shipping address.
Postal Address Town/ecommerce/stores/{store_id}/orders/shipping_address.cityThe city in the order’s shipping address.
Postal Address Region/ecommerce/stores/{store_id}/orders/shipping_address.provinceThe state or normalized province in the order’s shipping address.
Postal Address Country/ecommerce/stores/{store_id}/orders/shipping_address.countryThe country in the order’s shipping address.
Postal Address Postcode/ecommerce/stores/{store_id}/orders/shipping_address.postal_codeThe postal or zip code in the order’s shipping address.
Billing Address Line 1/ecommerce/stores/{store_id}/orders/billing_address.address1The billing address for the order.
Billing Address Line 2/ecommerce/stores/{store_id}/orders/billing_address.address2An additional field for the billing address.
Billing Address Town/ecommerce/stores/{store_id}/orders/billing_address.cityThe city in the billing address.
Billing Address Region/ecommerce/stores/{store_id}/orders/billing_address.provinceThe state or normalized province in the billing address.
Billing Address Country/ecommerce/stores/{store_id}/orders/billing_address.countryThe country in the billing address.
Billing Address Postcode/ecommerce/stores/{store_id}/orders/billing_address.postal_codeThe postal or zip code in the billing address.

Additional Purchase History Attributes available from Mailchimp can be found here. These may added as Custom Attributes into the Distil.ai Purchase History dataset.