Skip to content

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.

  1. Under Word report template, select the default template’s file name to download it, and open it in Word.
  2. 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.
  3. Format the text inside the control as the value should look: JungleMail replaces the text and keeps its formatting.
  4. 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.

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.

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

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
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