eComCustomers: ActiveCampaign eCommerce Customers |
Catalog: ActiveCampaign
Schema: V3
Primary Keys: id
Label: eCommerce Customers
Can retrieve data and change data using insert, update and delete.
Table Columns
The columns of the table eComCustomers are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
acceptsMarketing |
int64 |
|
☑ |
|
avgProductCategory |
string |
|
☐ |
|
avgRevenuePerOrder |
int64 |
|
☑ |
|
connection |
int64 |
Connection |
☐ |
|
connectionid |
int64 |
Connection ID |
☑ |
|
string |
Email Address |
☐ |
|
|
externalid |
string |
External ID |
☐ |
|
id |
int64 |
ID |
☑ |
|
totalOrders |
int64 |
Total Orders |
☑ |
|
totalProducts |
int64 |
Total Products |
☑ |
|
totalRevenue |
int64 |
Total Revenue |
☑ |
|
tstamp |
datetime |
|
☑ |
|
22-12-2022 20:43 Version 22.1.101-BETA+3681