Word report formulas
Generate Word report, on a newsletter’s report, downloads its results as a Word document. JungleMail 365 makes the document from a template: its own, or one uploaded for your JungleMail site under Settings > Analytics, in Word report template (Export results to CSV or Word). In the template, every place JungleMail fills in is a Word content control whose tag holds a formula from this page.
Make a template
Section titled “Make a template”- Under Word report template, select the default template’s file name to download it, and open it in Word.
- Where a value should go, insert a Rich Text Content Control from Word’s Developer tab, open its Properties and type the formula in Tag. Typing the formula in Title too shows it in the template while you work on it.
- Format the text inside the control as the value should look: JungleMail replaces the text and keeps its formatting.
- Save the template, then select Upload and choose it. JungleMail selects Use a custom template; select Save to start using it.
The template can be a .docx, .docm, .dotx or .dotm file of up to 10 MB.
Some formulas give a list, such as the results of each day. To show one, make a table row, put a content control with
the list’s formula, such as Performance, around the whole row, and in its cells put content controls with the list’s
fields, such as TotalClicks, without the list’s name. JungleMail repeats the row for every item.
To leave something out when there is no data, wrap it in a content control with DeleteControlIf(…): for example
DeleteControlIf(ReadingEnvironment:NoData) removes the device table of a newsletter whose opens have no device data.
The other functions in Formulas and functions work too, except those for SharePoint content and
translation.
The newsletter
Section titled “The newsletter”| Formula | Gives |
|---|---|
Job:Title |
The newsletter’s name |
Job:EmailSubject |
Its subject |
Job:Status |
Its status |
Job:IsRecurrent |
True for a recurring newsletter |
Job:ScheduledTime |
When it was scheduled to be sent |
Job:SubmittedTime, Job:SubmittedBy:Name, Job:SubmittedBy:Email |
When it was sent or submitted, and by whom |
Job:CreatedTime, Job:CreatedBy:Name, Job:CreatedBy:Email |
When it was created, and by whom |
Job:ModifiedTime, Job:ModifiedBy:Name, Job:ModifiedBy:Email |
When it was last changed, and by whom |
Job:SendTime |
Its send time |
Job:SendStartedTime, Job:SendCompletedTime |
When sending started and finished |
Job:TotalEmails |
The emails it was to send |
Job:EmailsSent, Job:ErrorEmails, Job:SkippedEmails |
The emails sent, failed and skipped |
Job:SendSucceeded, Job:SendFailed, Job:SendTerminated |
True if sending finished, failed or was stopped |
Job:ID |
Its ID |
Job:[Property name] |
A newsletter custom property, by its name |
Dates and times are in your site’s time zone.
Results
Section titled “Results”Analytics: and one of these. Rates are percentages of the emails sent, with two decimals.
| Formula | Gives |
|---|---|
Analytics:OpenRate |
The open rate |
Analytics:UniqueOpens, Analytics:TotalOpens |
Recipients who opened it, and all opens |
Analytics:Unopened |
Recipients who didn’t open it |
Analytics:ClickRate |
The click rate |
Analytics:UniqueClicks, Analytics:TotalClicks |
Recipients who clicked, and all clicks |
Analytics:NotClicked |
Recipients who didn’t click |
Analytics:VoteRate, Analytics:Voted, Analytics:TotalVotes, Analytics:NotVoted |
The same for its survey |
Analytics:UnsubscribeRate, Analytics:Unsubscribes |
Unsubscribes |
Analytics:BounceRate, Analytics:Bounces |
Bounces |
Devices
Section titled “Devices”ReadingEnvironmentAvailable is True when the newsletter’s results are available. Then:
| Formula | Gives |
|---|---|
ReadingEnvironment:Desktops, ReadingEnvironment:Phones, ReadingEnvironment:Tablets |
Opens on each kind of device |
ReadingEnvironment:DesktopRate, ReadingEnvironment:PhoneRate, ReadingEnvironment:TabletRate |
Their share, as percentages |
ReadingEnvironment:Total |
All of them |
ReadingEnvironment:NoData |
True if there are none |
Lists you can repeat
Section titled “Lists you can repeat”| List | One item per | Fields |
|---|---|---|
Performance |
Day with opens, clicks or unsubscribes | Date, UniqueOpens, TotalOpens, UniqueClicks, TotalClicks, Unsubscribes |
TopLinks |
Link, up to 10 | URL, Hyperlink (the link itself), UniqueClicks, TotalClicks |
Clickstreams |
Path through the links, up to 10 | Visitors, and Links, a list with URL and Hyperlink |
Departments, JobTitles, Offices, Companies |
Segment | The segment fields below |
Countries |
Country | Id, Alpha2Code, Alpha3Code, NumericCode, HasCountryStates, IsNotResolved, and the segment fields except IsGroup and IsUngrouped |
For each segment list, DepartmentsAvailable (and so on) is True when the site collects that segment, and
DepartmentsVisible when the breakdown is shown in Analytics. Countries includes blank and unrecognized countries; CountriesResolved lists only the
countries JungleMail recognized. GetCountryStates("<country ID>") and GetCountryStatesResolved("<country ID>") list
a country’s states in the same two ways.
The segment fields:
| Field | Gives |
|---|---|
Title |
The segment’s name |
TitleIsEmpty |
True for the segment of blank values |
IsGroup, IsUngrouped |
True for a group, or for the ungrouped values |
EmailsSent |
Emails sent to the segment |
OpenRate, UniqueOpens, TotalOpens, Unopened |
Its opens |
ClickRate, UniqueClicks, TotalClicks, NotClicked |
Its clicks |
UnsubscribeRate, Unsubscribes, BounceRate, Bounces |
Its unsubscribes and bounces |
DeviceDesktopRate, DevicePhoneRate, DeviceTabletRate |
Its devices, as percentages |

