Reports
Returns reports for campaigns marked as sent, including engagement, bounce, and industry statistics details.
View-Specific Information
Select
The driver 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 driver.
| Column | Supported Operators |
| Id | = |
| Type | = |
| SendTime | =, <, >, <=, >= |
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 | References | Description |
| Id [KEY] | String | The unique identifier of the campaign. | |
| CampaignTitle | String | The title of the campaign. | |
| Type | String | The type of campaign.
The allowed values are regular, plain-text, ab_split, rss, automation, variate, 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 | The total number of times the campaign was forwarded. | |
| Forwards_ForwardsOpens | Integer | The total number of opens generated from forwarded campaign emails. | |
| 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 | The number of campaign recipients who liked the campaign on Facebook. | |
| FacebookLikes_UniqueLikes | Integer | The number of unique Facebook likes recorded for the campaign. | |
| FacebookLikes_FacebookLikes | Integer | The total number of Facebook likes recorded for the campaign. | |
| IndustryStats_Type | String | The industry category used for the comparative statistics. | |
| IndustryStats_OpenRate | Double | The average open rate for the industry category. | |
| IndustryStats_ClickRate | Double | The average click rate for the industry category. | |
| IndustryStats_BounceRate | Double | The average bounce rate for the industry category. | |
| IndustryStats_UnopenRate | Double | The average rate of unopened emails for the industry category. | |
| IndustryStats_UnsubRate | Double | The average unsubscribe rate for the industry category. | |
| IndustryStats_AbuseRate | Double | The average abuse complaint rate for the industry category. | |
| 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 | The campaign statistics for group A of the A/B split test. | |
| AbSplit_B | String | The campaign statistics for group B of the A/B split test. | |
| 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 |
Lists.Id | The unique list Id. |
| ListIsActive | Boolean | Indicates whether the list used is 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 | The e-commerce statistics for the 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. |