EcommerceCustomers

Stores records of e-commerce customers linked to Mailchimp, used for purchase tracking and segmentation.

Table Specific Information

Select

The connector will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the connector.

The StoreId can be retrieved by selecting the ECommerceStores view.

StoreId supports the '=' operator.
Id supports the '=' operator.
EmailAddress supports the '=' operator.

For example:

SELECT * FROM EcommerceCustomers WHERE StoreId = 'Test_Store123'

SELECT * FROM EcommerceCustomers WHERE EmailAddress = '[email protected]'

SELECT * FROM EcommerceCustomers WHERE StoreId = 'Test_Store123' and Id = '44'

Columns


Name	Type	ReadOnly	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.

Power BI Connector for Mailchimp

EcommerceCustomers

Table Specific Information

Select

Columns