Word reports (Enterprise feature)

With JungleMail Enterprise, you can easily export your newsletter analytics data into a stylish and fully customizable Word report.

Enable the feature

1. In JungleMail, click on the gear icon, then select Settings.

2. Scroll down to the Enterprise Features section and check the Enable Word reports box.

3. Click Save at the bottom of the page.

Generate a report

1. Open JungleMail and go to the Analysis & Reports tab.

2. Select a campaign that you want a Word report on.

3. Click Generate Word report. The file will be downloaded to the default download location in your computer.

Report customization

1. On the site where JungleMail operates, go to Site contents.

2. Click on the JungleMail Report Templates library.

4. In the library, open the AnalyticsJobReport document. This document is used as a template for Word reports and it is fully customizable.

To import newsletter analytics data into a Word document, JungleMail uses content controls. By changing content control properties, you can specify the data that will be imported and displayed.

Adding content controls

1. Click on a place in a document where you want to import analytics data.

2. Go to the Developer tab and click on the Rich Text Content Control button.

3. Once the control is inserted, click Properties.

4. Insert the appropriate formula in the Title and Tag fields. We recommend to copy-paste the Tag value in the Title field: this will allow you to quickly see the formula without opening content control properties.

The result:

You can edit the text inside the content control (highlighted in grey) by changing font, color etc. In the processed document this text will be replaced with data that will inherit this formatting.

Understanding repeated sections

Most JungleMail formulas, used in content control tags, can only return a single value. For example, Analytics:TotalOpens returns the number of total email opens, which is unique per campaign. However, there are some formulas that can return a list of values. For example, Performance:TotalOpens returns a list of total opens for each day of the campaign. To display the list correctly, you need to create what is called a repeated section. This is a section that is automatically repeated as many times as there items in the list.

To create a repeated section

1. Insert a simple table into the report.

2. Select the whole row and add a Rich Text content control to it.

3. Select the control, open its properties and insert a list-compatible formula in the Title and Tag fields. In the example below, we use the Performance formula .

4. Now, you need to tell JungleMail what specific performance metrics you want to include in the table. To do that, select a cell and insert another Rich Text control inside.

5. Open control's properties and insert an appropriate formula, e.g., TotalClicks. Note that you don't need to use the full formula Performance:TotalClicks: since you now have one content control inside another, JungleMail knows that they are related.

Available formulas

Job (single value)

Job:ID (number)

Job:Title (text)

Job:Category (text)

Job:EmailSubject (text)

Job:IsRecurrent (Boolean)*

Job:ScheduledTime (date and time)

Job:SubmittedBy (text, User)**

Job:SubmittedTime (date and time)

Job:Status (text)

Job:SendTime (date and time)

Job:SendStartedTime (date and time)

Job:SendCompletedTime (date and time)

Job:EmailsSent (number)

Job:TotalEmails (number)

Job:ErrorEmails (number)

Job:SkippedEmails (number)

Job:SendSucceeded (Boolean)

Job:SendFailed (Boolean)

Job:SendTerminated (Boolean)

Job:CreatedBy (text, User)

Job:CreatedTime (date and time)

Job:ModifiedBy (text, User)

Job:ModifiedTime (date and time)

Analytics (single value)

Analytics:OpenRate (number)

Analytics:UniqueOpens (number)

Analytics:TotalOpens (number)

Analytics:Unopened (number)

Analytics:ClickRate (number)

Analytics:UniqueClicks (number)

Analytics:TotalClicks (number)

Analytics:NotClicked (number)

Analytics:UnsubscribeRate (number)

Analytics:Unsubscribes (number)

Performance (list)

Date (date and time)

UniqueOpens (number)

TotalOpens (number)

UniqueClicks (number)

TotalClicks (number)

Unsubscribes (number)

ReadingDevicesAvailable (Boolean)

ReadingEnvironment:Available (Boolean)

ReadingEnvironment:NoData (Boolean)

ReadingEnvironment:Desktops (number)

ReadingEnvironment:Phones (number)

ReadingEnvironment:Tablets (number)

ReadingEnvironment:Total (number)

ReadingEnvironment:DesktopRate (number)

ReadingEnvironment:PhoneRate (number)

ReadingEnvironment:TabletRate (number)

ReadingEnvironmentAvailable (Boolean)

ReadingEnvironment (single value)

ReadingEnvironment:Available (Boolean)

ReadingEnvironment:NoData (Boolean)

ReadingEnvironment:Desktops (number)

ReadingEnvironment:Phones (number)

ReadingEnvironment:Tablets (number)

ReadingEnvironment:Total (number)

ReadingEnvironment:DesktopRate (number)

ReadingEnvironment:PhoneRate (number)

ReadingEnvironment:TabletRate (number)

TopLinks (list)

URL (text)

Hyperlink (hyperlink)

UniqueClicks (number)

TotalClicks (number)

ClickstreamsAvailable (Boolean)

Clickstreams (list)

Visitors (number)

Links (list)

URL (text)

Hyperlink (hyperlink)

User (single value)

User:ID (number)

User:Name (text)

User:Login (text)

User:Email (text)

*The Boolean data type is a data type that has one of two possible values (usually denoted true and false). It is useful in scenarios where you want JungleMail to take further actions in the report depending on the value status (for example, to delete an entire row if there is no data to display). However, using Boolean values requires advanced template configuration and is therefore beyond the scope of this article. Please contact us if you need help with this functionality.

**User-related formulas require adding ID, Name or Login at the end, e.g., Job:SubmittedBy:ID or Job:CreatedBy:Email.