Word reports (Enterprise feature)

With JungleMail Enterprise, you can generate comprehensive campaign reports in Word document format. The steps are simple:

1. Go to  Analysis & Reports tab and select a campaign that you want a Word report on.

2. Click Export, then click Generate Word report.

Note: before you can use this feature, you have to enable it in JungleMail settings.

Enabling Word report functionality

1. Go to Site settings and click EnovaPoint JungleMail Settings (look for Site Collection Administration column). 

2. Head down to Enterprise Features and check the Enable Word reports box. Then, click Save.

3. Go to Site contents and you will see the new JungleMail Report Templates library.

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

Configuring report

JungleMail exports campaign analytics data a Word report  through  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 campaign data.

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

3. Once the control is inserted, click Properties (displayed next to the control button). 

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.

You can edit the text inside the content control (highlighted in grey) to suit your needs 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 to title and tag fields. In the example below, we  use  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.

Note: some formulas can not only return lists but also lists within lists. For example, you can set up a report to display the links opened for each campaign day. To do that, you need to create a repeated section from a row and then create another repeated section in a cell.

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 IDName or Login at the end, e.g., Job:SubmittedBy:ID or Job:CreatedBy:Email.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us