# 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` | `varchar2` | | ☐ | | | `avgRevenuePerOrder` | `int64` | | ☑ | | | `connection` | `int64` | Connection | ☐ | | | `connectionid` | `int64` | Connection ID | ☑ | | | `email` | `varchar2` | Email Address | ☐ | | | `externalid` | `varchar2` | External ID | ☐ | | | `id` | `int64` | ID | ☑ | | | `totalOrders` | `int64` | Total Orders | ☑ | | | `totalProducts` | `int64` | Total Products | ☑ | | | `totalRevenue` | `int64` | Total Revenue | ☑ | | | `tstamp` | `datetime` | | ☑ | |