Reports
A list of reports containing campaigns marked as Sent.
Table Specific Information
SELECT is supported for Reports.
Select
The add-in 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 add-in.
- 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. |