EcommerceCustomers
Stores records of e-commerce customers linked to Mailchimp, used for purchase tracking and segmentation.
Table-Specific Information
Select
The provider uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| StoreId | = |
| Id | = |
| EmailAddress | = |
SELECT * FROM EcommerceCustomers WHERE StoreId = 'Test_Store123'
SELECT * FROM EcommerceCustomers WHERE EmailAddress = '[email protected]'
SELECT * FROM EcommerceCustomers WHERE StoreId = 'Test_Store123' AND Id = '44'
Note: To retrieve the StoreId, query the EcommerceStores view.
Columns
| Name | Type | ReadOnly | References | Description |
| StoreId [KEY] | String | False |
The unique identifier of the store where the customer record resides. Each store represents an e-commerce integration connected to the Mailchimp account. | |
| Id [KEY] | String | False |
The unique identifier assigned to the customer within the store. This value links customer records to related orders and carts. | |
| EmailAddress | String | False |
The primary email address of the customer, used for communications, segmentation, and marketing automation. | |
| OptInStatus | Boolean | False |
If the value is 'true', the customer has opted in to receive marketing emails. This setting never overrides an existing list member's opt-in status but applies to new contacts added via the e-commerce API. | |
| Company | String | False |
The company name associated with the customer, if applicable. | |
| FirstName | String | False |
The first name of the customer, used for personalization and segmentation. | |
| LastName | String | False |
The last name of the customer, used for personalization and segmentation. | |
| OrdersCount | Integer | True |
The total number of completed orders associated with the customer across all recorded transactions. | |
| TotalSpent | Decimal | True |
The cumulative monetary amount the customer has spent on completed orders. | |
| Address_Address1 | String | False |
The first line of the customer's billing or shipping address, typically the street address or P.O. box. | |
| Address_Address2 | String | False |
An additional address line for apartment numbers, suites, or secondary address details. | |
| Address_City | String | False |
The city where the customer resides or where their order is billed or shipped. | |
| Address_Province | String | False |
The full name of the customer's state or province. | |
| Address_ProvinceCode | String | False |
The two-letter code representing the customer's state or province, following regional postal standards. | |
| Address_PostalCode | String | False |
The customer's postal or ZIP code for billing or shipping. | |
| Address_Country | String | False |
The full name of the customer's country. | |
| Address_CountryCode | String | False |
The two-letter ISO 3166-1 code for the customer's country. | |
| CreatedAt | Datetime | True |
The date and time when the customer record was first created in the store. | |
| UpdatedAt | Datetime | True |
The date and time when the customer's information was last updated. |