Note: This article has been unpublished - to be deleted after a period of time. Dec 2018

The Campaign Metrics Report allows you to select the containers and date ranges you are interested in and provides a view of all sends from those containers in the time range given.

Note that you need to enable the Email Sent Data Aggregation Scheduled Task to generate data for this report - see this article for details: https://support.vutu.re/hc/en-us/articles/360020706118-Enable-Email-Sent-Data-Aggregation-Scheduled-Task

To access the report, click on "Container" and then select "Activity" from the dropdown menu. Once the pop up window has loaded, select the “Excel Data” tab and then select the Campaign Metrics Report.

The report is returned in the form of an Excel spreadsheet download.

The data columns returned are:

• CampaignId: The ID of the campaign 
• EmailSentId: The internal ID of the email send 
• SitePageId: The emails SitePageId 
• ContainerId: The ID of the container 
• Container: The name of the container 
• EmailFrom: The email address of the sender 
• EmailSubject: The subject line of the sent email 
• Campaign: The name of the campaign 
• EmailName: The name of the email 
• EmailSentDate: Full date and time of the send 
• EmailSentWeekDay: Weekday the send was on 
• EmailSentHour: Hour of the day the send happened (0-23) 
• ListSource: Id of the system containing the email list used 
• ListName: Name of the email list used 
• EmailListId: ID of the list used  
• Sent: Number of emails sent 
• Opens: Number of emails opened 
• Clicks: number of links clicked  
• Unsubscribes: number of users that unsubscribed 
• Bounces: number of emails that bounced 
• OpenPercentage: Excel formula that calculates the percentage of opens 
• ClicksPercentage:Excel formula that calculates the percentage of clicks 
• ClicksPerOpenPercentage:Excel formula that calculates the percentage of clicks per open 
• UnsubscribePercentage:Excel formula that calculates the percentage of unsubscribes 
• BouncePercentage:Excel formula that calculates the percentage of bounces 
• Further columns are generated from the campaign tags used on each campaign.