The Mailing 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 "Admin" and "Reports" and then select "Mailing Metrics Report" from the dropdown.

Enter the required date range and containers.

Selecting no containers will return data for all containers.

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

 

The data columns returned are:

• EmailSentDate: date and time the email was sent
• Container: full name of the container
• Campaign:name of the email campaign
• EmailName: page name of the email
• EmailSubject: subject of the mailing
• ListName: name of the list
• TotalSent: total recipients sent to
• Opens: total number of opens for that mailing
• Clicks: total number of clicks for that mailing
• Unsubscribes: total number of unsubscribes for that mailing
• Bounces: total number of bounces for that mailing
• Open Percentage: open rate for that mailing
• Clicks percentage: percentage of total clicks per email sent
• Clicks per open percentage: percentage of total clicks per opened emails
• Average Unsubscribes: unsubscribe rate for that mailing
• Average Bounces: bounce rate for that mailing
• EmailFrom: From Address of the mailing
• ListSource: source of the email list (0 = Vx, 1 = InterAction 1 etc.)
• EmailListId: list id (for InterAction lists this is the IA folder id)
• Tags: one column per Tag Category with a semi-colon separated list of Tags. The separator character can be changed if required by your Vuture Administrator using the setting "Admin.System.Reports.Tag Separator Character"
• EmailSentId: id of that mailing
• SitePageId: page id of the email that was sent
• ContainerId: container id that the email was sent from

---

Download the Mailing Metrics Report using Vuture's API

See this article for general information about the Vuture Reporting API

This report can be downloaded using one of  the following APIs to get the data in either JSON or CSV format.

POST /api/reports/235.json 

or

POST /api/reports/235.csv

 

You need to be an authorised user to download the data. If you are not logged in to the platform (e.g. if you are scripting this) you will need to pass the following two HTTP headers with an authorised Vuture user. We recommend you create a Vuture user with the correct access level specifically for this purpose to avoid password resets.

 

Vx-Auth-Name: {userEmail}

Vx-Auth-Password: {userPassword}

 

You will need to pass a date range filter as the body of the POST. We recommend pulling down data one day at a time since there is likely to be very large number of records. See this example which get the data for January 1st 2019.

 

{ "filter": { "conditions": [{ "attribute": "DateStart", "value": "2019-01-01", "oprtr": "ge" }, { "attribute": "DateEnd", "value": "2019-01-01", "oprtr": "le" }] } }

 

---

Vuture API Explorer

You can test this in Vuture's API explorer by browsing to:

{Your Vx URL}/api#!/Reports/ExecuteReport_post_0

You role will need to have API access - your Account Manager can enable that using "Admin->Roles->API->User Has Access"

Here enter:

ReportId = 235Filter = date range filter in the format above. Use a small date range (e.g. one day) for testing since this report will typically return a large amount of data

Limit = 0

Start = 0

responseFormat = json OR csv  (xml will not return any data). 

Click "Try it out" to make the API call.