ODBC Driver for Mailchimp

Build 24.0.9060

EcommerceCustomers

A list of an account's ecommerce customers.

Table Specific Information

Select

The driver 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 driver.

The StoreId can be retrieved by selecting the ECommerceStores view.

  • StoreId supports the '=' operator.
  • Id supports the '=' operator.
For example:
SELECT * FROM EcommerceCustomers WHERE StoreId = 'Test_Store123'

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

Columns

Name Type ReadOnly Description
StoreId [KEY] String False

The StoreId for the table.

Id [KEY] String False

A unique identifier for the customer.

EmailAddress String False

The customer's email address.

OptInStatus Boolean False

The 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.

Company String False

The customer's company.

FirstName String False

The customer's first name.

LastName String False

The customer's last name.

OrdersCount Integer True

The customer's total order count.

TotalSpent Decimal True

The total amount the customer has spent.

Address_Address1 String False

The mailing address of the customer.

Address_Address2 String False

An additional field for the customer's mailing address.

Address_City String False

The city the customer is located in.

Address_Province String False

The customer's state name or normalized province.

Address_ProvinceCode String False

The two-letter code for the customer's province or state.

Address_PostalCode String False

The customer's postal or zip code.

Address_Country String False

The customer's country.

Address_CountryCode String False

The two-letter code for the customer's country.

CreatedAt Datetime True

The date and time the customer was created.

UpdatedAt Datetime True

The date and time the customer was last updated.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060