ReportSubReports
Lists subreports generated for child or related campaigns.
Table Specific Information
Select
The connector 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 connector.
- CampaignId supports the '=' operator.
SELECT * FROM ReportSubReports; SELECT * FROM ReportSubReports where CampaignId='1121';
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier of the campaign report, used to link subreport data to the parent campaign. |
| CampaignId [KEY] | String | The identifier of the child campaign within the overall campaign report. |
| AbSplitAAbuseReports | Integer | The number of abuse reports submitted by recipients of variant A in an A/B test campaign. |
| AbSplitABounces | Integer | The number of bounced emails for variant A, including both hard and soft bounces. |
| AbSplitAForwards | Integer | The total number of times variant A was forwarded by recipients. |
| AbSplitAForwardsOpens | Integer | The number of opens generated from forwarded messages of variant A. |
| AbSplitALastOpen | String | The timestamp of the most recent open event recorded for variant A. |
| AbSplitAOpens | Integer | The total number of opens recorded for variant A, including multiple opens by the same recipient. |
| AbSplitARecipientClicks | Integer | The number of recipient clicks for variant A across all tracked links. |
| AbSplitAUniqueOpens | Integer | The total number of unique opens recorded for variant A. |
| AbSplitAUnsubs | Integer | The number of recipients who unsubscribed after receiving variant A. |
| AbSplitBAbuseReports | Integer | The number of abuse reports submitted by recipients of variant B in an A/B test campaign. |
| AbSplitBBounces | Integer | The number of bounced emails for variant B, including both hard and soft bounces. |
| AbSplitBForwards | Integer | The total number of times variant B was forwarded by recipients. |
| AbSplitBForwardsOpens | Integer | The number of opens generated from forwarded messages of variant B. |
| AbSplitBLastOpen | String | The timestamp of the most recent open event recorded for variant B. |
| AbSplitBOpens | Integer | The total number of opens recorded for variant B, including multiple opens by the same recipient. |
| AbSplitBRecipientClicks | Integer | The number of recipient clicks for variant B across all tracked links. |
| AbSplitBUniqueOpens | Integer | The total number of unique opens recorded for variant B. |
| AbSplitBUnsubs | Integer | The number of recipients who unsubscribed after receiving variant B. |
| CampaignTitle | String | The title of the child campaign as displayed in Mailchimp. |
| EmailsSent | Integer | The total number of email messages sent for this campaign. |
| AbuseReports | Integer | The total number of abuse reports filed by recipients of this campaign. |
| Unsubscribed | Integer | The number of recipients who unsubscribed after receiving the campaign. |
| BouncesHardBounces | Integer | The number of hard bounces for the campaign, indicating permanent delivery failures. |
| BouncesSoftBounces | Integer | The number of soft bounces for the campaign, typically due to temporary delivery issues. |
| BouncesSyntaxErrors | Integer | The number of bounces caused by syntax errors in recipient email addresses. |
| OpensOpensTotal | Integer | The total number of email opens for this campaign, counting multiple opens per recipient. |
| OpensUniqueOpens | Integer | The total number of unique recipients who opened the campaign at least once. |
| OpensOpenRate | Decimal | The open rate, calculated as the ratio of unique opens to successful deliveries. |
| OpensLastOpen | Datetime | The date and time when the most recent open event occurred. |
| OpensProxyExcludedOpens | Integer | The total number of opens excluding those generated by proxy servers, providing more accurate engagement data. |
| OpensProxyExcludedUniqueOpens | Integer | The total number of unique opens excluding those from proxy servers. |
| OpensProxyExcludedOpenRate | Decimal | The open rate after excluding opens from email clients that use proxies. |
| ClicksClicksTotal | Integer | The total number of link clicks recorded for the campaign, including multiple clicks per recipient. |
| ClicksUniqueClicks | Integer | The number of unique clicks by distinct recipients within the campaign. |
| ClicksUniqueSubscriberClicks | Integer | The number of unique subscribers who clicked at least one link in the campaign. |
| ClicksClickRate | Decimal | The click rate, calculated as the ratio of unique clicks to successful deliveries. |
| ClicksLastClick | Datetime | The date and time of the most recent click recorded in the campaign. |
| ForwardsForwardsCount | Integer | The number of times recipients forwarded the campaign to others. |
| ForwardsForwardsOpens | Integer | The total number of opens generated from forwarded campaign messages. |
| ListId | String | The unique identifier of the mailing list associated with this campaign. |
| ListName | String | The name of the mailing list to which this campaign was sent. |
| ListIsActive | Boolean | Indicates whether the associated list is active ('true') or has been deleted or disabled ('false'). |
| ListStatsSubRate | Decimal | The average monthly subscription rate for this mailing list. |
| ListStatsUnsubRate | Decimal | The average monthly unsubscribe rate for this mailing list. |
| ListStatsOpenRate | Decimal | The average open rate for all campaigns sent to this list. |
| ListStatsClickRate | Decimal | The average click rate for all campaigns sent to this list. |
| ListStatsProxyExcludedOpenRate | Decimal | The average open rate excluding proxy-generated opens across campaigns for this list. |
| DeliveryStatusEnabled | Boolean | Indicates whether delivery status tracking is enabled for this campaign. |
| DeliveryStatusCanCancel | Boolean | Indicates whether this campaign's delivery process can be canceled after initiation. |
| DeliveryStatusEmailsSent | Integer | The number of emails successfully sent as part of this campaign's delivery status. |
| DeliveryStatusEmailsCanceled | Integer | The number of emails canceled or stopped before being sent. |
| DeliveryStatusStatus | String | The current delivery status of the campaign, such as 'sending', 'sent', or 'canceled'. |
| FacebookLikesFacebookLikes | Integer | The total number of Facebook likes the campaign received. |
| FacebookLikesRecipientLikes | Integer | The number of likes generated by campaign recipients on Facebook. |
| FacebookLikesUniqueLikes | Integer | The total number of unique Facebook users who liked the campaign. |
| EcommerceCurrencyCode | String | The three-letter ISO 4217 code representing the currency used for e-commerce tracking in this campaign. |
| EcommerceTotalOrders | Integer | The total number of e-commerce orders attributed to this campaign. |
| EcommerceTotalRevenue | Decimal | The total revenue generated from e-commerce orders linked to this campaign. |
| EcommerceTotalSpent | Decimal | The total amount spent by customers on e-commerce orders resulting from this campaign. |
| IndustryStatsType | String | The industry category associated with this campaign, used for performance comparison. |
| IndustryStatsOpenRate | Decimal | The average open rate across similar campaigns in the same industry. |
| IndustryStatsClickRate | Decimal | The average click rate across similar campaigns in the same industry. |
| IndustryStatsBounceRate | Decimal | The average bounce rate for campaigns in the same industry. |
| IndustryStatsAbuseRate | Decimal | The average abuse report rate for campaigns in the same industry. |
| IndustryStatsUnsubRate | Decimal | The average unsubscribe rate for campaigns in the same industry. |
| IndustryStatsUnopenRate | Decimal | The average percentage of emails not opened in campaigns within the same industry. |
| PreviewText | String | The preview text shown to recipients in their inbox before opening the email. |
| SendTime | Datetime | The date and time when this campaign was sent to recipients. |
| SubjectLine | String | The subject line used for this campaign's email. |
| Timeseries | String | A breakdown of campaign performance metrics over time, showing trends in opens, clicks, and other interactions. |
| Type | String | The campaign type, such as 'regular', 'automation', or 'rss', indicating how it was created and delivered. |
| RssLastSend | Datetime | For RSS campaigns, the date and time of the most recent RSS-triggered send. |
| ShareReportShareUrl | String | The public URL used to share the campaign report with others. |
| ShareReportSharePassword | String | The password required to access the shared campaign report, if password protection is enabled. |
| Timewarp | String | The Timewarp configuration details, used for scheduling campaign sends according to recipient time zones. |