JDBC Driver for Mailchimp

Build 22.0.8462

EcommerceCustomers

A list of an account's ecommerce customers.

Columns

Name Type ReadOnly Description
StoreId [KEY] String True

The StoreId for the table.

Id [KEY] String True

A unique identifier for the customer.

EmailAddress String True

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 False

The customer's total order count.

TotalSpent Decimal False

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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462