Reports
Lists reports containing campaigns marked as Sent.
View-Specific Information
Select
The provider 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 provider.
| 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 | 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).
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 | ||
| 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 |
Lists.Id | 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. |