Subaccounts
Returns the subaccounts for the account, including sending statistics and status. Filtering on Id retrieves detailed information for a single subaccount.
View-Specific Information
Select
The connector uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the connector. Filtering on Id returns detailed information for a single subaccount.
| Column | Supported Operators |
| Id | =, LIKE |
| Name | LIKE |
SELECT * FROM Subaccounts
SELECT * FROM Subaccounts WHERE Id = 'cust-123'
SELECT * FROM Subaccounts WHERE Id LIKE 'cust%'
SELECT * FROM Subaccounts WHERE Name LIKE 'Acme%'
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier of the subaccount. |
| Name | String | The optional display name of the subaccount. |
| CreatedAt | Datetime | The date and time the subaccount was created as a UTC string in YYYY-MM-DD HH:MM:SS format. |
| FirstSentAt | Datetime | The date and time the subaccount first sent as a UTC string in YYYY-MM-DD HH:MM:SS format. |
| Status | String | The current sending status of the subaccount.
The allowed values are active, paused. |
| Reputation | Integer | The subaccount reputation on a scale from 0 to 100. |
| SentWeekly | Integer | The number of emails the subaccount has sent so far this week. |
| SentMonthly | Integer | The number of emails the subaccount has sent so far this month. |
| SentTotal | Integer | The number of emails the subaccount has sent since it was created. |
| CustomQuota | Integer | The optional manual hourly quota for the subaccount, if one has been set. |
| Last30Days_Sent | Integer | The total number of messages the subaccount sent in the last 30 days. |
| Last30Days_HardBounces | Integer | The total number of hard bounces for the subaccount in the last 30 days. |
| Last30Days_SoftBounces | Integer | The total number of soft bounces for the subaccount in the last 30 days. |
| Last30Days_Rejects | Integer | The total number of rejected messages for the subaccount in the last 30 days. |
| Last30Days_Complaints | Integer | The total number of spam complaints for the subaccount in the last 30 days. |
| Last30Days_Unsubs | Integer | The total number of unsubscribes for the subaccount in the last 30 days. |
| Last30Days_Opens | Integer | The total number of opens for the subaccount in the last 30 days. |
| Last30Days_UniqueOpens | Integer | The total number of unique opens for the subaccount in the last 30 days. |
| Last30Days_Clicks | Integer | The total number of clicks for the subaccount in the last 30 days. |
| Last30Days_UniqueClicks | Integer | The total number of unique clicks for the subaccount in the last 30 days. |