ReportSubReports
Lists subreports generated for child or related campaigns.
Table Specific Information
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.
- 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. |