ReportSubReports
Lists child campaign reports.
View-Specific Information
Select
The provider uses 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 provider.
| Column | Supported Operators |
| CampaignId | = |
SELECT * FROM ReportSubReports
SELECT * FROM ReportSubReports WHERE CampaignId = '1121'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A unique identifier for the campaign. | |
| CampaignId [KEY] | String | The campaign ID for the child campaign. | |
| AbSplitAAbuseReports | Integer | Number of abuse reports for variant A. | |
| AbSplitABounces | Integer | Number of bounces for variant A. | |
| AbSplitAForwards | Integer | Number of forwards for variant A. | |
| AbSplitAForwardsOpens | Integer | Number of opens from forwards for variant A. | |
| AbSplitALastOpen | String | Timestamp of the last open for variant A. | |
| AbSplitAOpens | Integer | Total number of opens for variant A. | |
| AbSplitARecipientClicks | Integer | Number of recipient clicks for variant A. | |
| AbSplitAUniqueOpens | Integer | Number of unique opens for variant A. | |
| AbSplitAUnsubs | Integer | Number of unsubscribes for variant A. | |
| AbSplitBAbuseReports | Integer | Number of abuse reports for variant B. | |
| AbSplitBBounces | Integer | Number of bounces for variant B. | |
| AbSplitBForwards | Integer | Number of forwards for variant B. | |
| AbSplitBForwardsOpens | Integer | Number of opens from forwards for variant B. | |
| AbSplitBLastOpen | String | Timestamp of the last open for variant B. | |
| AbSplitBOpens | Integer | Total number of opens for variant B. | |
| AbSplitBRecipientClicks | Integer | Number of recipient clicks for variant B. | |
| AbSplitBUniqueOpens | Integer | Number of unique opens for variant B. | |
| AbSplitBUnsubs | Integer | Number of unsubscribes for variant B. | |
| CampaignTitle | String | The title of the child campaign. | |
| EmailsSent | Integer | The total number of emails sent for the campaign. | |
| AbuseReports | Integer | The total number of abuse reports for the campaign. | |
| Unsubscribed | Integer | The total number of recipients who unsubscribed from the campaign. | |
| BouncesHardBounces | Integer | The total number of hard bounces for the campaign. | |
| BouncesSoftBounces | Integer | The total number of soft bounces for the campaign. | |
| BouncesSyntaxErrors | Integer | The total number of syntax errors for the campaign. | |
| OpensOpensTotal | Integer | The total number of opens for the campaign. | |
| OpensUniqueOpens | Integer | The total number of unique opens for the campaign. | |
| OpensOpenRate | Decimal | The open rate for the campaign. | |
| OpensLastOpen | Datetime | The date and time of the last open for the campaign. | |
| OpensProxyExcludedOpens | Integer | The total number of proxy excluded opens for the campaign. | |
| OpensProxyExcludedUniqueOpens | Integer | The total number of proxy excluded unique opens for the campaign. | |
| OpensProxyExcludedOpenRate | Decimal | The proxy excluded open rate for the campaign. | |
| ClicksClicksTotal | Integer | The total number of clicks for the campaign. | |
| ClicksUniqueClicks | Integer | The total number of unique clicks for the campaign. | |
| ClicksUniqueSubscriberClicks | Integer | The total number of unique subscriber clicks for the campaign. | |
| ClicksClickRate | Decimal | The click rate for the campaign. | |
| ClicksLastClick | Datetime | The date and time of the last click for the campaign. | |
| ForwardsForwardsCount | Integer | The total number of forwards for the campaign. | |
| ForwardsForwardsOpens | Integer | The total number of opens from forwards for the campaign. | |
| ListId | String | The list ID associated with the campaign. | |
| ListName | String | The name of the list associated with the campaign. | |
| ListIsActive | Boolean | Whether the list is active. | |
| ListStatsSubRate | Decimal | The subscribe rate for the list. | |
| ListStatsUnsubRate | Decimal | The unsubscribe rate for the list. | |
| ListStatsOpenRate | Decimal | The open rate for the list. | |
| ListStatsClickRate | Decimal | The click rate for the list. | |
| ListStatsProxyExcludedOpenRate | Decimal | The proxy excluded open rate for the list. | |
| DeliveryStatusEnabled | Boolean | Whether delivery status is enabled for the campaign. | |
| DeliveryStatusCanCancel | Boolean | Whether the campaign delivery can be canceled. | |
| DeliveryStatusEmailsSent | Integer | The number of emails sent for the campaign delivery status. | |
| DeliveryStatusEmailsCanceled | Integer | The number of emails canceled for the campaign delivery status. | |
| DeliveryStatusStatus | String | The status of the campaign delivery.
The allowed values are delivering, delivered, canceling, canceled. | |
| FacebookLikesFacebookLikes | Integer | The number of Facebook likes for the campaign. | |
| FacebookLikesRecipientLikes | Integer | The number of recipient Facebook likes for the campaign. | |
| FacebookLikesUniqueLikes | Integer | The number of unique Facebook likes for the campaign. | |
| EcommerceCurrencyCode | String | The currency code for ecommerce transactions in the campaign. | |
| EcommerceTotalOrders | Integer | The total number of ecommerce orders for the campaign. | |
| EcommerceTotalRevenue | Decimal | The total revenue from ecommerce orders for the campaign. | |
| EcommerceTotalSpent | Decimal | The total amount spent in ecommerce orders for the campaign. | |
| IndustryStatsType | String | The industry type for the campaign. | |
| IndustryStatsOpenRate | Decimal | The open rate for the campaign's industry. | |
| IndustryStatsClickRate | Decimal | The click rate for the campaign's industry. | |
| IndustryStatsBounceRate | Decimal | The bounce rate for the campaign's industry. | |
| IndustryStatsAbuseRate | Decimal | The abuse rate for the campaign's industry. | |
| IndustryStatsUnsubRate | Decimal | The unsubscribe rate for the campaign's industry. | |
| IndustryStatsUnopenRate | Decimal | The unopen rate for the campaign's industry. | |
| PreviewText | String | The preview text for the campaign. | |
| SendTime | Datetime | The date and time the campaign was sent. | |
| SubjectLine | String | The subject line of the campaign. | |
| Timeseries | String | Timeseries data for the campaign. | |
| Type | String | The type of the campaign.
The allowed values are regular, plain-text, ab_split, rss, automation, variate, auto. | |
| RssLastSend | Datetime | The date and time of the last RSS send for the campaign. | |
| ShareReportShareUrl | String | The shareable URL for the campaign report. | |
| ShareReportSharePassword | String | The password for the shared campaign report. | |
| Timewarp | String | The timewarp setting for the campaign. |