Reports
A list of reports containing campaigns marked as Sent.
Table Specific Information
SELECT is supported for Reports.
Select
The server 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 server.
- Id supports the '=' operator.
- Type supports the '=' operator.
- SendTime supports the '=,<,>,<=,>=' operator.
SELECT * FROM Reports where Id = '45a' SELECT * FROM Reports where Type = 'regular' SELECT * FROM Reports WHERE SendTime = '2024-02-07 00:00:37.0' SELECT * FROM Reports WHERE SendTime >= '2024-02-07 00:00:37.0' SELECT * FROM Reports WHERE SendTime <= '2024-02-07 00:00:37.0' SELECT * FROM Reports WHERE SendTime > '2024-02-07 00:00:37.0' SELECT * FROM Reports WHERE SendTime < '2024-02-07 00:00:37.0'
Columns
| Name | Type | Description |
| Id [KEY] | String | A string that uniquely identifies this campaign. |
| CampaignTitle | String | The title of the campaign. |
| Type | String | The type of campaign (regular, plain-text, ab_split, rss, automation, variate, or auto). |
| EmailsSent | Integer | The total number of emails sent for this campaign. |
| AbuseReports | Integer | The number of abuse reports generated for this campaign. |
| Unsubscribed | Integer | The total number of unsubscribed members for this campaign. |
| SendTime | Datetime | The time and date a campaign was sent. |
| Bounces_HardBounces | Integer | The total number of hard bounced email addresses. |
| Bounces_SoftBounces | Integer | The total number of soft bounced email addresses. |
| Bounces_SyntaxErrors | Integer | The total number of addresses that were syntax-related bounces. |
| Forwards_ForwardsCount | Integer | |
| Forwards_ForwardsOpens | Integer | |
| Opens_OpensTotal | Integer | The total number of opens for a campaign. |
| Opens_UniqueOpens | Integer | The total number of unique subscribers who opened a campaign. |
| Opens_OpenRate | Double | The number of unique subscribers who opened divided by the total number of successful deliveries. |
| Opens_LastOpen | Datetime | The date and time of the last recorded open. |
| Clicks_ClicksTotal | Integer | The total number of clicks for the campaign. |
| Clicks_UniqueClicks | Integer | The total number of unique clicks for links across a campaign. |
| Clicks_UniqueSubscriberClicks | Integer | The total number of subscribers who clicked on a campaign. |
| Clicks_ClickRate | Double | The number of unique subscribers who clicked divided by the total number of successful deliveries. |
| Clicks_LastClick | Datetime | The date and time of the last recorded click for the campaign. |
| FacebookLikes_RecipientLikes | Integer | |
| FacebookLikes_UniqueLikes | Integer | |
| FacebookLikes_FacebookLikes | Integer | |
| IndustryStats_Type | String | |
| IndustryStats_OpenRate | Double | |
| IndustryStats_ClickRate | Double | |
| IndustryStats_BounceRate | Double | |
| IndustryStats_UnopenRate | Double | |
| IndustryStats_UnsubRate | Double | |
| IndustryStats_AbuseRate | Double | |
| ListStats_SubRate | Double | The average number of subscriptions per month for the list. |
| ListStats_UnsubRate | Double | The average number of unsubscriptions per month for the list. |
| ListStats_OpenRate | Double | The average open rate (a percentage represented as a number between 0 and 100) per campaign for the list. |
| ListStats_ClickRate | Double | The average click rate (a percentage represented as a number between 0 and 100) per campaign for the list. |
| AbSplit_A | String | |
| AbSplit_B | String | |
| Timewarp | String | An hourly breakdown of sends, opens, and clicks if a campaign is sent using timewarp. |
| Timeseries | String | An hourly breakdown of the performance of the campaign over the first 24 hours. |
| ShareReport_ShareUrl | String | The URL for the VIP report. |
| ShareReport_SharePassword | String | If password protected, the password for the VIP report. |
| DeliveryStatus | String | Updates on campaigns in the process of sending. |
| ListId | String | The unique list id. |
| ListIsActive | Boolean | The status of the list used, namely if it's deleted or disabled. |
| ListName | String | The name of the list. |
| SubjectLine | String | The subject line for the campaign. |
| PreviewText | String | The preview text for the campaign. |
| RssLastSend | String | For RSS campaigns, the date and time of the last send in ISO 8601 format. |
| Ecommerce | String | E-Commerce stats for a campaign. |
| Opens_ProxyExcludedOpens | Integer | The total number of opens for a campaign, excluding opens from email clients that use proxies. |
| Opens_ProxyExcludedUniqueOpens | Integer | The total number of unique opens for a campaign, excluding opens from email clients that use proxies. |
| Opens_ProxyExcludedOpenRate | Double | The average unique open rate for a campaign, excluding opens from email clients that use proxies. |
| ListStats_ProxyExcludedOpenRate | Double | The average unique open rate (a percentage represented as a number between 0 and 100) per campaign for the list, excluding opens from email clients that use proxies. |