ReportSubReports

Child campaign reports.

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.

For example:

SELECT * FROM ReportSubReports;
SELECT * FROM ReportSubReports where CampaignId='1121';

Columns


Name	Type	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.
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.
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.

Excel Add-In for Mailchimp

ReportSubReports

Table Specific Information

Select

Columns