Show Menu
TOPICS×

Reports on deliveries

Accessing existing reports

Adobe Campaign offers several types of reports, accessible via the customer console or an internet browser.
The following types of report are available:
You can access reports from the client console home page, the reports dashboard or the delivery list. The display mode of a report depends on its context. The list of main reports is available on the home page and lets you access delivery data quickly. This list can be changed to suit your needs. Refer to this section for more information.

Using reports

A search field is available via the report dashboard for quick access to one of the reports on the list.
When the report is generated, you can perform various actions using the icons on the toolbar to the right of the report window.
You can:
  • Export the report to Excel, PDF or Open Document,
  • Print the report,
  • Create the report history,
  • Display different report histories,
  • Update the data in the report.
Some reports feature charts (curve, bar, funnel, etc.). Move your cursor over a chart to display its values.
For more information on these options, refer to this section .

Global reports

These reports concern the activity of the data in the entire database. To view the reports dashboard, go to the Reports tab.
To display reports, click their names. The following reports are available by default:
This section shows only the reports linked to deliveries.

Delivery throughput

This report contains information on the delivery throughput of the entire platform for a given period. To measure the speed at which the messages are delivered, the criteria are the number of messages sent per hour and the size of the messages (in bits per second). In the example below, the first graph shows the successful deliveries in blue, and the number of erroneous deliveries in orange.
You can configure the values displayed by changing the timescale: 1-hour view, 3-hour view, 24-hour view, etc. Click Refresh to confirm your selection.

User activities

This report shows the breakdown of opens, clicks and transactions per half-hour, hour or day, in the form of a chart.
The following options are available:
  • Opens : Total number of messages opened. Emails in text format are not taken into account. For more information on tracking opens, refer to Tracking opens .
  • Clicks : Total number of clicks on links in deliveries. Clicks on unsubscription links and mirror pages are not taken into account.
  • Transactions : Total number of transactions after a message is received. In order for a transaction to be taken into account, a transaction type webtracking tag must be inserted into the matching web page. Webtracking configuration is presented in this section .

Non-deliverables and bounces

This report shows the breakdown of non-deliverables as well as a breakdown of bounces per internet domain.
The Number of messages processed represents the total number of messages processed by the delivery server. This value is lower than the number of messages to be delivered when some deliveries have been stopped or paused (before being processed by the server).
Breakdown of errors by type
The errors shown in this report trigger the quarantine process. For more on quarantine management, refer to Quarantine management .
The first section of this report shows the breakdown of non-deliverables in the form of a table of values and a chart.
For each error type, we have:
  • the number of error messages of this type,
  • the percentage of messages with errors of this type compared to the total number of messages with errors,
  • the percentage of error messages of this type compared to the total number of messages processed.
The following indicators are used:
  • User unknown : Error type generated during delivery to indicate that the email address is invalid.
  • Invalid domain : Error type generated when sending a delivery to indicate that the domain of the email address is wrong or does not exist.
  • Inbox full : Error type generated after five delivery attempts to indicate that the recipients' inbox contains too many messages.
  • Account disabled : Error type generated when sending a delivery to indicate that the address no longer exists.
  • Rejected : Error type generated when an address is rejected by the IAP (Internet Access Provider), for instance following the application of a security rule (anti-spam software).
  • Unreachable : Error type which occurs in the message distribution string: incident on the SMTP relay, domain temporarily unreachable, etc
  • Not connected : Error type to indicate that the recipients' mobile phone is switched off or disconnected from the network at the time of sending.
    This indicator only concerns deliveries on mobile channels. For more on this, refer to this section .
    You can open up each line of the value table by clicking the # symbol. For each error type, you can show the breakdown of error messages by domain.
Breakdown of errors per domain
The second section of this report shows the breakdown of errors per Internet domain in the form of a table of values and a chart.
For each domain name, we have:
  • the number of messages with errors for this domain,
  • the percentage of messages with errors for this domain compared to the total number of messages processed for this domain,
  • the percentage of error messages for this domain compared to the total number of error messages.
You can open up each line of the value table by clicking the # symbol. For each domain type, you can show the breakdown of error messages by error type.
The domain names displayed in this report are defined at cube level. To change theses values, edit the Delivery logs (broadlogrcp) cube. For more on this, refer to this section . The Others category includes domain names that don't belong to a specific class.

Browsers

This report shows the breakdown of internet browsers used by delivery recipients for the concerned period.
The values shown in this report are estimates: only recipients who have clicked in a delivery will be taken into account.
Global statistics
The global statistics on browser use are presented in the form of a table of values and a chart.
The following indicators are used:
  • Visitors : Total number of recipients targeted (per internet browser) and having clicked on a delivery at least once.
  • Pages viewed : Total number of clicks on links in a delivery (per internet browser) for all deliveries.
  • Usage rate : This rate represents the breakdown of visitors (per internet browser) in relation to the total number of visitors.
Statistics per browser
In the table of global statistic values, you can click each browser name to view their usage statistics.
Statistics are presented in the form of a curve, a chart and a table of values.
The History curve represents the attendance rate of this browser per day. The rate is the ratio of the number of visitors per day (on this browser) compared to the number of visitors measured on the day with the highest attendance rate.
The Breakdown per version chart represents the breakdown of visitors per version compared to the total number of visitors (on this browser).
The table of values uses the following indicators:
  • Global rate : This rate represents the breakdown of visitors per version compared to the total number of visitors (on all browsers).
  • Relative rate : This rate represents the breakdown of visitors per version compared to the total number of visitors (on this browser).

Sharing to social networks

Viral marketing lets delivery recipients share information with their contact network: they can add a link to their profile (Facebook, Twitter, etc.) or send a message to a friend. Each share and each access to shared information is tracked within the delivery. For more information on viral marketing, refer to this section .
This report shows the breakdown of shared and opened messages per social network (Facebook, Twitter, etc.) and/or per email.
Email delivery statistics
In the email delivery statistics, two values are displayed:
  • Number of messages to be delivered : Total number of messages processed during delivery analysis.
  • Number of successful deliveries : Number of messages processed successfully.
Sharing activities and mail open statistics
The central table shows the statistics on email shares and opens.
In the Shares column, we have the following indicators:
  • No. of sharing activities : Total number of messages shared on each social network. This value equals the total number of clicks on the icon of the matching Links for sharing to social networks personalization block.
  • Breakdown : This rate represents the breakdown of shares per social network, in relation to the total number of shares.
  • Sharing rate : This rate represents the breakdown of shares per social network, in relation to the number of messages to be delivered.
In the Opens column, we have the following indicators:
  • No. of opens : Total number of messages opened by people whom the message was forwarded to (via the Links for sharing to social networks personalization block). This value equals the number of times the mirror page was displayed. Opens by delivery recipients are not taken into account.
  • Breakdown : This rate represents the breakdown of opens per social network, in relation to the total number of opens.
  • Rate of opens : This rate represents the breakdown of opens per social network, in relation to the total number of shares.
Breakdown of sharing activities and opens
This section includes two charts which represent the breakdown of sharing activities and opens per social network.

Statistics on sharing activities

This report shows the evolution of shares to social networks (Facebook, Twitter, email, etc.) in time.
For more information on viral marketing, refer to this section .
Statistics are presented in the form of a table of values and a chart.
The following indicators are used:
  • New contacts : Number of new subscriptions following the reception of a message shared via email. This value matches the number of people who received a message shared via email, clicked the Subscription link and filled in the subscription form.
  • Opens : Total number of messages opened by people whom the message was transferred to (via the Link for sharing to social networks personalization block). This value equals the number of times the mirror page was displayed. Opens by delivery recipients are not taken into account.
  • Sharing activities : Total number of messages shared via social networks. This value matches the total number of clicks on the icon of the Links for sharing to social networks personalization block.

Operating systems

This report shows the breakdown of operating systems used by delivery recipients for the concerned period.
The values shown in this report are estimates: only recipients who have clicked in a delivery will be taken into account.
Global statistics
The global usage statistics of operating systems are presented in the form of a table of values and a chart.
The following indicators are used:
  • Visitors : Daily average of the total number of targeted recipients (per operating system) who clicked in a delivery at least once.
  • Pages viewed : Daily average of the total number of clicks on delivery links (per operating system) for all deliveries.
  • Rate of use : This rate represents the breakdown of visitors (per operating system) in relation to the total number of visitors.
Statistics per operating system
In the table of global statistics values, click the name of each operating system to view the statistics per operating system.
Statistics are presented in the form of a curve, a chart and a table of values.
The History curve represents the rate of use of this operating system per day. This rate is the ratio of the number of visitors per day (on this operating systems) in relation to the number of visitors measured on the day with the highest attendance.
The Breakdown by version chart represents the breakdown of visitors per version in relation to the total number of visitors on this operating system.
The table of values uses the following indicators:
  • Global rate : This rate represents the breakdown of visitors (per version) in relation to the total number of visitors throughout the operating systems.
  • Relative rate : This rate represents the breakdown of visitors (per version) in relation to the total number of visitors for this operating system.

Subscription tracking

This report lets you monitor subscriptions to information services. It shows subscriptions and unsubscriptions.
It can be displayed for a subscription by clicking the Profiles and targets > Services and subscriptions node of the home page or the explorer. Select the desired subscription, and then click the Reports tab. The Subscriptions tracking report is available by default. It lets you see the subscription and unsubscription trends and the loyalty rate over a period. You can configure the representation of this data via the drop-down list. Click Refresh to validate the selected configuration.
For further information, refer to this page .
The Number subscribed to date represents the total number of people currently subscribed.
Overall evolution of subscriptions
The table of values uses the following indicators:
  • Subscribers : Total number of subscribers for the concerned period.
  • Subscriptions : Number of subscriptions for the concerned period.
  • Unsubscriptions : Number of unsubscriptions for the concerned period.
  • Evolution : Number of unsubscriptions minus the number of subscriptions. The rate is calculated based on the total number of subscribers.
  • Loyalty : Loyalty rate of subscribers for the concerned period.
Subscription evolution curves
This chart shows the evolution of subscriptions and unsubscriptions for the concerned period.

Delivery statistics

This report shows the breakdown by internet domain, of all messages processed and sent, of hard and soft bounces, opens, clicks and unsubscriptions.
The following indicators are used:
  • Emails processed : Total number of messages processed by the delivery server.
  • Delivered : percentage of the number of messages successfully processed compared to the total number of messages processed.
  • Hard bounces : percentage of the number of "hard" bounces compared to the total number of messages processed.
  • Soft bounces : percentage of the number of "soft" bounces compared to the total number of messages processed.
    For more on hard and soft bounces, refer to Quarantine management .
  • Opens : percentage of the number of targeted recipients who opened a message at least once compared to the number of messages processed successfully.
  • Clicks : percentage of the number of people who clicked in a delivery at least once compared to the number of messages processed successfully.
  • Unsubscription : percentage of the number of clicks on an unsubscription link compared to the number of messages processed successfully.

Breakdown of opens

This report shows the breakdown of opens by operating system, device and browser for the period concerned. For each category, two charts are used. The first displays statistics regarding opens on a computer and mobile devices. The second displays statistics relating only to opens on mobile devices.
The number of opens corresponds to the total number of messages opened. Text format emails are not counted. For more information on Tracking opens, refer to the Tracking opens section.
Browser and operating system names make up part of the information sent by the browser's user agent to which the nail has been opened. Adobe Campaign deduces the type of device using its the device information.

Delivery reports

You can track the execution of deliveries via various reports accessible from the delivery overview. To display reports, apply the following procedure:
  1. Go to the Campaigns universe and click the Delivery link to display the list of deliveries.
  2. Click the name of the delivery you want to display to show its details.
  3. Select the Summary tab and click the Reports link to access the reports specific to the delivery.
    By default, the following reports are available:

Tracking indicators

This report combines the key indicators for tracking the behavior of recipients upon receiving the delivery. It gives access to delivery and reception statistics, open and click-through rates, generated click streams, web tracking as well as sharing activities to social networks.
Values calculated based on message opens are always estimates, due to the margin of error linked to emails in text format. The Distinct opens/Sum of opens for the population reached indicators take this margin of error into account. For more information on tracking opens, refer to Tracking opens .
1. Delivery statistics
  • Messages to deliver : Total number of messages to be delivered after delivery analysis.
  • Success : Number of messages successfully processed.
2. Reception statistics
The related percentages are calculated based on the number of messages forwarded successfully.
  • Distinct opens for the population reached : Estimation of the number of targeted recipients having opened a message at least once. Clicks on unsubscription links and mirror pages are taken into account.
  • Sum of opens for the population reached : Estimation of the total number of opens by targeted recipients.
  • Clicks on opt-out link : Number of clicks on the unsubscription link.
  • Clicks on the mirror page link : Number of clicks on the link to the mirror page. In order to be taken into account, the link must be defined as such in the delivery wizard (tracked URLs). Refer to this page .
  • Estimation of forwards : Estimation of the number of emails forwarded by the targeted recipients. This value is calculated by subtracting the number of distinct people and the number of distinct recipients who clicked in the email.
    For more information on the difference between distinct people and targeted recipients, refer to Targeted persons / recipients .
3. Open and click-through rate
This table of values shows the breakdown of deliveries, opens, clicks and raw reactivity per Internet domain. The following indicators are used:
  • Sent : Total number of messages sent on this domain.
  • Complaints : Number of messages for this domain that have been reported as undesirable by the recipient. The rate is calculated based on the total number of messages sent on this domain.
  • Opens : Number of distinct targeted recipients for this domain who have opened a message at least once. The rate is calculated based on the total number of messages sent on this domain.
  • Clicks : Number of distinct targeted recipients who clicked in the same delivery at least once. The rate is calculated based on the total number of messages sent on this domain
  • Raw reactivity : Percentage of the number of recipient who clicked in a delivery at least once compared to the number of recipients who opened a delivery at least once.
The domain names displayed in this report are defined in the itemized list used at cube level. To change, add or remove default domains, edit the Domains itemized list and modify values and aliases. For more on this, refer to this section . The Others category includes domain names that don't belong to any value of the itemized list.
4. Generated click streams
The related percentages are calculated based on the number of messages forwarded successfully.
  • Distinct clicks for the population reached : Number of distinct people having clicked in a delivery at least once.
  • Cumulated clicks : Total number of clicks by targeted recipients, excluding unsubscription links and mirror pages.
  • Recipient clicks : Number of distinct targeted recipients who clicked in the same delivery at least once.
  • Estimated recipient reactivity : Ratio of the number of recipients having clicked at least once in a delivery compared to the estimated number of recipients having opened a delivery at least once. Clicks on the opt-out and mirror page links are not taken into account.
5. Web tracking
  • Visited pages : Number of web pages visited following message reception.
  • Transactions : Number of purchases following message reception.
  • Total amount : Total amount of purchases following message reception.
  • Average transaction amount : Average purchase made by distinct delivery recipients.
  • Articles : Number of articles purchased by the delivery recipients.
  • Average count of articles per transaction : Average number of items per purchase made by distinct recipients.
  • Average amount per message : Average amount of purchases generated per message.
    In order for a visited page, transaction, amount or article to be taken into account, a webtracking tag must be inserted into the matching web page. Webtracking configuration is presented in this section .
6. Sharing activities to email and social networks
This section shows the number of messages shared on each social network. For more on this, refer to Sharing to social networks .

URLs and click streams

This report shows the list of pages visited following a delivery.
You can configure the contents of this report by selecting: the score chart to be displayed, the time filter (since the action launch, over the first 6 hours following launch, etc.) and the data display mode (by label, by URL, by category - for more on this, refer to this page ). Click Refresh to confirm your selection.
The following rates are displayed in the upper section of the report:
  • Reactivity : Ratio of the number of targeted recipients having clicked in a delivery, in relation to the estimated number of targeted recipients having opened a delivery. Clicks on the opt-out link and on the mirror page are not taken into account.
    For more information on tracking opens, refer to Tracking opens .
  • Distinct clicks : Number of distinct people having clicked at least once (excluding unsubscription link and mirror page) in a delivery. The rate displayed is calculated based on the number of messages delivered successfully.
  • Cumulated clicks : Total number of clicks by targeted recipients (excluding unsubscription link and mirror page). The rate displayed is calculated based on the number of messages forwarded successfully.
Platform average : This average rate, displayed under each rate (reactivity, distinct clicks, and cumulated clicks), is calculated for deliveries sent over the previous six months. Only deliveries with the same typology and on the same channel are taken into account. Proofs are excluded.
The central table provides the following information:
  • Clicks : Number of cumulated clicks, per link.
  • Clicks (in %) : Breakdown of the number of clicks per link, in relation to the total number of cumulated clicks.
Breakdown of clicks in time
This chart shows the breakdown of cumulated clicks per day.

Delivery summary

This report provides all the main information on the delivery.
Target population
This section has two indicators:
  • Initial population : Total number of recipients targeted by the delivery.
  • Messages rejected by the rule : Number of addresses ignored during the analysis when applying typology rules: address missing, quarantined, blacklisted, etc. For more information on typology rules, refer to this page .
Causes of exclusion
The middle chart shows the breakdown per rule of messages rejected during the analysis.
Delivery statistics
This section includes the following indicators:
  • Messages to be delivered : Total number of messages to be delivered after delivery analysis.
  • Success : Number of messages processed successfully. The associated rate is the ratio with the number of messages to be delivered.
  • Errors : Total number of errors cumulated during deliveries and automatic rebound processing. The associated rate is the ratio with the number of messages to be delivered.
  • New quarantines : Number of addresses quarantined following a failed delivery (user unknown, invalid domain). The associated rate is the ratio with the number of messages to be delivered.

Hot clicks

This report shows the message content (HTML and/or text) with, on each link, the percentage of clicks on links. Personalization blocks unsubscription links, mirror page links and offer links are taken into account in the total cumulated clicks but are not displayed in the report.
If your delivery contains offers (Interaction), a box appears in the part above the report displaying the percentage of clicks on the offers.

Tracking statistics

This report provides statistics on opens, clicks and transactions.
It lets you track the marketing impact of the delivery. You can configure how values are displayed by changing the timescale (1-hour, 3-hour, or 24-hour view, etc.). Click Refresh to confirm your selection.
This report provides a table of values and a Pareto chart which display the time required for the delivery to reach maximum efficiency. The following indicators are used:
  • Opens : Estimate of the time needed to reach a percentage of the total number of messages opened. Emails in text format aren't taken into account. For more information on tracking opens, refer to Tracking opens .
  • Clicks : Estimate of the time required to reach a percentage of the total number of clicks recorded. Clicks on the opt-out link and the mirror page are not taken into account.
  • Transactions : Time required to achieve a percentage of the total number of transactions following message reception. In order for a transaction to be taken into account, a transaction type webtracking tag must be inserted into the matching web page. Webtracking configuration is presented in this section .

Cumulative reports

You can display cumulated reports on deliveries. To do this, select the deliveries to be compared to obtain the list of reports for these deliveries.
To select non-adjacent deliveries from the list, hold down the CTRL key while making your selection.
To select deliveries saved in a different folder click Display sub-levels (accessible via the toolbar). They will then be displayed in the same list.

Indicator calculation

User activities

Label Field name Indicator description Indicator calculation formula
Opens @opens Sum of all @totalClicks with a URL primary key equal to 1. sum(Iif([@url-id]=1, @totalClicks, 0))
Clicks @clicks Sum of all @totalClicks with a URL type equal to "Email click". sum(Iif([url/@type]=1, @totalClicks, 0))
Transactions @transactions Sum of all @totalClicks with a URL type equal to "Transaction". sum(Iif([url/@type]=5, @totalClicks, 0))
This report is based on the Consolidated tracking table (nms:trackingStats). This aggregate table is used for performance reasons when displaying reports, in the place of the Recipient tracking logs table (nms:trackingLogRcp) and it is not calculated in real-time. The table is generated a few minutes after the tracking logs are retrieved. If the indicators are up-to-date, the results will be the same as for the indicators of the Tracking indicators report. The @totalclicks indicator expresses the total number of clicks over a 5-minute period.

Non-deliverables and bounces

Breakdown by error type
This report is based on the Delivery and tracking statistics table (nms:deliveryLogStats).
Label Field name Indicator description Indicator calculation formula
Total number of processed messages @totalProcessed Sum of messages with a status equal to "Ready", "Sent" or "Failed". @prepared + @error + @success
User unknown @unknownUser Count of all messages with a status equal to "Failed" and a reason equal to "User unknown". Count(@status=2 and msg/@failureReason=1)
Unreachable @unreachable Count of all messages with a status equal to "Failed" and a reason equal to "Unreachable". Count(@status=2 and msg/@failureReason=3)
Rejected @refused Count of all messages with a status equal to "Failed" and a reason equal to "Rejected". Count(@status=2 and msg/@failureReason=20)
Invalid domain @invalidDomain Count of all messages with a status equal to "Failed" and a reason equal to "Invalid domain". Count(@status=2 and msg/@failureReason=2)
Account disabled @disabled Count of all messages with a status equal to "Failed" and a reason equal to "Account disabled". Count(@status=2 and msg/@failureReason=4)
Inbox full @mailBoxFull Count of all messages with a status equal to "Failed" and a reason equal to "Inbox full". Count(@status=2 and msg/@failureReason=5)
Errors @value Number of failed messages for this type of error. Count(@status=2 and msg/@failureReason="Value of the error type")
Contribution - Percentage of errors of this type compared to the total number of error messages. percent(@value,@totalErrors)
Breakdown - Percentage of errors of this type compared to the total number of processed messages. percent(@value,@totalProcessed)
Breakdown by domain
The second part of the report details the breakdown of failed messages by internet domain as opposed to error type. The formula linked to the Error indicator (@value) in this case is: Count(@status=2 and @domain="Value of the domain name"), i.e. a count of all messages with a failed status for this domain.

Browsers

This report is based on the Internet Browser Statistics table (nms:userAgentsStats).
Global statistics
Label Field name Indicator description Indicator calculation formula
Visitors @totalVisitors Total number of targeted recipients for this browser who clicked in a delivery at least once. Sum(@visitors)
Page views @totalPages Total number of clicks on delivery links using this browser, for all deliveries. Sum(@pages)
Usage rate - Percentage of visitors for this browser compared to the total number of visitors. percent(@totalVisitors, sum(@totalVisitors))
Statistics per browser
Label Field name Indicator description Indicator calculation formula
Usage rate @visitors Percentage of the number of visitors per day using this browser compared to the number of visitors measured on the day with the most visits. percent(sum(@visitors),max(@visitorsOfTheDay))
Global rate - Percentage of visitors for this version compared to the total number of visitors using all browsers. percent(@totalVisitors, @globalVisitors)
Relative weight - Percentage of visitors for this version compared to the total number of visitors using this browser. percent(@totalVisitors, sum(@totalVisitors))

Sharing to social networks

This report is based on the Delivery (nms:delivery), Consolidated tracking (nms:trackingStats), and Web tracking (nms:webTrackingLog) tables.
Label Field name Indicator description Indicator calculation formula
Number of messages to deliver @totalTarget Total number of messages processed during the delivery analysis. sum([properties/@totalTarget])
Number of successful deliveries @success Number of messages processed successfully sum([indicators/@success])
Email @email Sum of all @totalClicks for which the URL category equals "email". Sum(iIf([url/@category]='email',@totalClicks,0))
Facebook @facebook Sum of all @totalClicks for which the URL category equals "facebook". Sum(iIf([url/@category]='facebook',@totalClicks,0))
Twitter @twitter Sum of all @totalClicks for which the URL category equals "twitter". Sum(iIf([url/@category]='twitter',@totalClicks,0))
Delicious @delicious Sum of all @totalClicks for which the URL category equals "delicious". Sum(iIf([url/@category]='delicious',@totalClicks,0))
Digg @digg Sum of all @totalClicks for which the URL category equals "digg". Sum(iIf([url/@category]='digg',@totalClicks,0))
Google @google Sum of all @totalClicks for which the URL category equals "google". Sum(iIf([url/@category]='google',@totalClicks,0))
Linkedin @linkedin Sum of all @totalClicks for which the URL category equals "linkedin". Sum(iIf([url/@category]='linkedin',@totalClicks,0))
Shares
Label Field name Indicator description Indicator calculation formula
Number of shares @forward Total number of messages shared on this social network. Sum(iIf([url/@category]="Value of the social network type",@totalClicks,0))
Breakdown @percent Percentage of the number of shares on this social network compared to the total number of shares. percent(@forward, sum(@forward))
Sharing rate @rate Number of shares on this network compared to the number of messages to deliver. @forward / @totalTarget
Opens
Label Field name Indicator description Indicator calculation formula
Number of opens @open Total number of tracking lines in the web tracking table. Count
Breakdown @percentOpen Percentage of the number of opens on this social network compared to the total number of opens. percent(@open, sum(@open))
Rate of opens @rateOpen Number of opens on this social network compared to the total number of messages to deliver. @open / @totalTarget

Statistics on sharing activities

This report is based on the Delivery (nms:delivery), Consolidated tracking (nms:trackingStats), and Web tracking (nms:webTrackingLog) tables.
Label Field name Indicator description Indicator calculation formula
New contacts @newContacts Count of the number of visitors linked to a recipient. Formula: count(@id) Filter: @recipient-id != 0
Opens @opened Count of all @ids with a URL type equal to "Open". count (Iif([url/@type] = 2, @id, 0))
Shares @shared URL category included in 'email' , 'facebook' , 'twitter' , 'delicious' , 'digg' , 'google' , 'linkedin' Count of all @totalClicks with a URL category that equals "email", "facebook", "twitter", "delicious", "digg", "google" or "linkedin". count (Iif([url/@category] IN (email' , 'facebook' , 'twitter' , 'delicious' , 'digg' , 'google' , 'linkedin'), @totalClicks, 0))

Operating systems

This report is based on the Internet Browser Statistics table (nms:userAgentsStats).
Global statistics
Label Field name Indicator description Indicator calculation formula
Visitors @totalVisitors / @days Daily average of the total number of recipients targeted by the operating system who clicked in a delivery at least once. Sum(@visitors)
Pages viewed @totalPages / @days Daily average of the total number of clicks on the delivery links per operating systems for all deliveries. Sum(@pages)
Usage rate - Breakdown of visitors per operating system compared to the total number of visitors. percent(@totalVisitors, sum(@totalVisitors))
Statistics per operating system
Label Field name Indicator description Indicator calculation formula
Usage rate @visitors Percentage of the number of visitors per day on this operating system compared to the number of visitors measured on the day with the most visits. percent(sum(@visitors), max(@visitorsOfTheDay))
Global rate - Percentage of visitors per version compared to the total number of visitors on all operating systems. percent(@totalVisitors, @globalVisitors)
Relative rate - Percentage of visitors per version compared to the total number of visitors using this operating system. percent(@totalVisitors, sum(@totalVisitors))

Subscription tracking

This report is based on the Services table (nms:service).
Label Field name Indicator description Indicator calculation formula
Registered @_subscriber Count of registered people on the previous day. sum(Iif(@created < addDays(getDate(), (-1)), 1, 0))
Subscriptions @_subscription count of subscriptions (@action = 1) on the previous day. sum(Iif(@action = 1 and @date > addDays(getDate(), (-1)), 1, 0))
Unsubscriptions @_unsubscription count of unsubscriptions (action = 0) on the previous day. sum(Iif(@action = 0 and @date > addDays(getDate(), (-1)), 1, 0))
Evolution - Number of subscriptions minus the number of unsubscriptions. The rate is calculated in relation to the total number of subscribers. Iif(number(@_subscription) > number(@_unsubscription), '+', '')+format(@_subscription - @_unsubscription, 'number', '# ##0')+ Iif(@_subscriber>0,' (' + format(100*percent(@_subscription - @_unsubscription, @_subscriber), 'number', '#,##0.00')+ '%)','')
Loyalty - Subscriber loyalty rate for the related period. 1-percent(@_unsubscription,@_subscriber+@_subscription-@_unsubscription)

Tracking indicators

This report is based on the Delivery and tracking statistics (nms:deliveryLogStats) and Consolidated tracking (nms:trackingStats) tables.
Label Field name Indicator description Indicator calculation formula
Messages to deliver @toDeliver Count of the number of broadLogs after target analysis. sum([properties/@toDeliver])
Success @successWithoutSeeds Count of messages for which the "seed address" field equals "No" and with a status equal to "Taken into account by the service provider" or "Sent" or "Received on the mobile". sum([indicators/@success])
Distinct opens on the population reached @estimatedRecipientOpen Extrapolation of the number of distinct opens for all emails based on the number of distinct opens for emails in html format. Iif(([@toDeliver] - [@text]) = 0, 0, round(toDouble(@recipientOpen) * [@toDeliver] / ([@toDeliver] - [@text]), 0))
Sum of opens on the population reached @estimatedTotalRecipientOpen Extrapolation of the total number of opens for all emails based on the total number of opens of emails in html format. Iif(([@toDeliver] - [@text]) = 0, 0, round(toDouble(@totalRecipientOpen) * [@toDeliver] / ([@toDeliver] - [@text]), 0))
Clicks on the unsubscription link @optOut Count of all @ids with a URL category equal to "Opt-out". count(Iif([url/@type]=3, @id, 0))
Clicks on the link to the mirror page @mirrorPage Count of all @ids with a URL category equal to "Mirror page". count(Iif([url/@type]=6, @id, 0))
Estimation of forwards @forward Difference between the number of distinct people and the number of distinct recipients who clicked in the email at least once. @personClick - @recipientClick
Sends @successWithoutSeeds Count of the messages for which the "seed address" field equals "No" and with a status equal to "taken into account by the recipient" or "Sent" or "Received on mobile". sum([indicators/@success])
Complaints @complaints Count of messages with a status equal to "Failed" and a reason equal to "blacklisted address". Count(@status=2 and msg/@failureReason=8)
Opens @recipientOpen Count of all @broadLog-ids in all tracking logs. Countdistinct ([@broadLog-id])
Clicks @recipientClick Distinct count of @broadLog-ids with a URL type equal to "Email click". Countdistinct(Iif([url/@type]=1, @broadLog-id, 0))
Raw reactivity - Percentage of the number of recipients who clicked in a delivery at least once compared to the number of recipients who opened a delivery at least once. percent(@recipientClick,@recipientOpen)
Distinct clicks on the population reached @personClick Count of all @source-ids with a URL category equal to "Email click". Countdistinct(Iif([url/@type]=1, @source-id, 0))
Cumulated clicks @totalRecipientClick Count of all @ids with a URL category that equals "Email click". count(Iif([url/@type]=1, @id, 0))
Recipient clicks @recipientClick Distinct count of the @broadLog-ids with a URL type that equals "Email click". Countdistinct(Iif([url/@type]=1, @broadLog-id, 0))
Estimated reactivity - Ratio of the number of recipients who clicked in a delivery at least once compared to the estimate of recipients who opened the delivery at least once. percent(@recipientClick, @estimatedRecipientOpen
Visited pages @totalWebPage Count of all @ids with a URL type equal to "Web" or "Transaction". count(Iif([url/@type]=4 or [url/@type]=5, @id, 0))
Transactions @transaction Count of all @ids with a URL type equal to "Transaction". count(Iif([url/@type]=5, @id, 0))
Total amount @amount Sum of webTrackingLog/@amounts with a URL type equal to "Transaction". Sum(Iif([url/@type]=5, webTrackingLog/@amount, 0))
Average transaction amount - Ratio of the total amount compared to the number of transactions. div(@amount, @transaction)
Items @article Sum of webTrackingLog/@articles with a URL type that equals "Transaction". Sum(Iif([url/@type]=5, webTrackingLog/@article, 0))
Average number of items per transaction - Ratio of the number of items compared to the number of transactions. div(@article, @transaction)
Average amount per message - Ratio of the total amount compared to the number of messages to deliver. div(@amount, @toDeliver)
Email @email Sum of all @totalClicks with a URL category that equals "email". Sum(iIf([url/@category]='email',@totalClicks,0))
Facebook @facebook Sum of all @totalClicks with a URL category that equals "facebook". Sum(iIf([url/@category]='facebook',@totalClicks,0))
Twitter @twitter Sum of all @totalClicks with a URL category that equals "twitter". Sum(iIf([url/@category]='twitter',@totalClicks,0))
Delicious @delicious Sum of all @totalClicks with a URL category that equals "delicious". Sum(iIf([url/@category]='delicious',@totalClicks,0))
Digg @digg Sum of all @totalClicks with a URL category that equals "digg". Sum(iIf([url/@category]='digg',@totalClicks,0))
Google @google Sum of all @totalClicks with a URL category that equals "google". Sum(iIf([url/@category]='google',@totalClicks,0))
Linkedin @linkedin Sum of all @totalClicks with a URL category that equals "linkedin". Sum(iIf([url/@category]='linkedin',@totalClicks,0))

URLs and click streams

This report is based on the Delivery table (nms:delivery).
Label Field name Indicator description Indicator calculation formula
Reactivity @reactivity Ratio of the number of targeted recipients who clicked in a delivery at least once compared to the estimated number of targeted recipients who opened a delivery at least once. percent([indicators/@recipientClick], [indicators/@estimatedRecipientOpen])
Distinct clicks @distinctClicks Ratio of the number of distinct people who clicked in a delivery at least once compared to the number of messages delivered with success. percent([indicators/@personClick], [indicators/@success])
Cumulated clicks @totalClicks Ratio of the total number of clicks by targeted recipients compared to the number of messages delivered with success. percent([indicators/@totalRecipientClick], [indicators/@success])
Clicks @_click Count of all @totalClicks with a URL primary key different from 1 count(Iif([@url-id] != 1, @totalClicks, 0))
Clicks (%) - Percentage of the number of clicks compared to the total number of cumulated clicks. percent(@_click, @_total)

Delivery summary

This report is based on the Delivery table (nms:delivery).
Label Field name Indicator description Indicator calculation formula
Initial population @totalTarget Total number of recipients targeted by the delivery. sum([properties/@totalTarget])
Messages rejected by the rule @reject Number of addresses ignored during the analysis in keeping with typology rules: address not specified, quarantined, blacklisted, etc. sum([properties/@reject])
Messages to deliver @toDeliver Total number of messages to deliver after delivery analysis. sum([properties/@toDeliver])
Success @success Number of messages processed with success. sum([indicators/@success])
Errors @error Total number of errors cumulated during deliveries and automatic bounce processing. sum([indicators/@error])
New quarantines @newQuarantine Number of quarantined addresses following a delivery fail (user unknown, invalid domain). sum([indicators/@newQuarantine])

Hot clicks

This report is based on the Delivery(nms:delivery) and Consolidated tracking (nms:trackingStats) tables.
This report shows the message content (HTML and/or text) with, on each link, the percentage of clicks on links. Personalization blocks unsubscription links and mirror page links are taken into account in the total cumulated clicks but are not displayed in the report.

Tracking statistics

This report is based on the Delivery table (nms:delivery).
Label Field name Indicator description Indicator calculation formula
Transactions @transactions Sum of all @totalClicks with a URL type that equals "Transaction". sum(Iif([url/@type] = 5, @totalClicks, 0))
Clicks @clicks Sum of all @totalClicks with a URL type that equals "Email click". sum(Iif([url/@type] = 1, @totalClicks, 0))
Open @opens Sum of all @totalClicks with a URL primary key that equals 1. sum(Iif([@url-id] = 1, @totalClicks, 0))

Delivery statistics

This report is based on the Delivery and tracking statistics table (nms:deliveryLogStats).
Label Field name Indicator description Indicator calculation formula
Emails processed @processed Total number of messages with a status that equals "Ready", "Sent" or "Failed". @prepared + @error + @success
Delivered @success Number of messages processed successfully. indicators/@success
Hard bounces @hardBounce Total number of messages with a status that equals "Failed" and a reason that equals "User unknown". @unknownUser
Soft bounces @softBounce Total of all messages with a status that equals "Failed" and a reason that equals "unreachable", "inbox full", "invalid domain", "disabled account", "not connected" or "rejected" @unreachable + @mailBoxFull + @invalidDomain + @disabled + @notConnected + @refused
Opens @recipientOpen Total number of @broadLog-ids in the tracking logs. Countdistinct ([@broadLog-id])
Clicks @personClick Total number of @source-ids for which the URL category equals "Email click". Countdistinct(Iif([url/@type]=1, @source-id, 0))
Unsubscriptions @optOut Total number of @ids for which the URL category equals "Opt-out". count(Iif([url/@type]=3, @id, 0))

Breakdown of opens

This report is based on Deliveries (nms:delivery) and Tracking logs (nms:trackingLogRcp) tables.
Label Field name Indicator description Indicator calculation formula
Opens @totalRecipientOpen Sum of all @id with a URL primary key equal to 1 (open). count(Iif([@url-id] = 1, @id, 0))

Other indicators

The Sent indicator (@sent), accessed via the Deliveries (nms:delivery) > Indicators node corresponds to the total number of SMS sent to the service provider. This indicator is only used for SMS deliveries and must not be used for other types of deliveries (not to be confused with the @success and @processed indicators).

Indicator synchronization

If you experience desynchronization or inconsistency for certain indicators, select the concerned delivery in the Adobe Campaign explorer, right-click and choose Action>Recompute delivery and tracking indicators . Click Next , then click Finish .

Tracking opens

In order for Adobe Campaign to detect message opens, the recipient must download the images in the email. HTML and Multipart/Alternative emails include a 0 pixel image, which enable you to detect messages which have been opened. Since messages in text format do not include any images, it is impossible to detect whether they have been opened or not. Values calculated based on message opens are always estimates, due to the error margin linked to image display.

Targeted persons / recipients

In some reports, Adobe Campaign differentiates targeted persons and targeted recipients.
Targeted recipients are all the recipients whom the delivery was sent to.
The number of persons includes targeted recipients plus all persons whom the email was forwarded to. Each time there is an open or a click in a new browser (which the message has not yet been opened in), another person is added to the statistics.
For instance, if you receive an email (sent by Adobe Campaign) at work and open or click in it, you will be counted as a targeted recipient (i.e. recipient=1, person=1). If you forward this email to two friends, the number of targeted recipients will still equal one, while the number of persons will equal three. Value 3 coincides with each open/click in a new browser.

Person/people and recipients

This sample will help you understanding the difference between a person/a people and a recipient in Adobe Campaign. We will send a delivery to several people to highlight the difference between people and recipients while detailing the calculation method for the following indicators:
  • Clicks
  • Distinct clicks for the population reached
  • Distinct opens for the population reached
  • Estimation of forwards
  • Raw reactivity
These indicators are used in the Tracking indicators report. For more on this, refer to Tracking indicators .
Three links are added to a delivery. It is sent to 4 recipients:
  • John Davis : this recipient does not open the email (and therefore does not click any links).
  • Marie Stuart : opens the email but does not click any links.
  • Florian David : opens the email and clicks the links 9 times. He also forwards the email to someone who opens it and clicks twice.
  • Henry Macdonald : this recipient has configured their internet browser to reject cookies. He opens the email and clicks the links 4 times.
The following tracking logs are returned:
To get a clearer idea of how people and recipients are counted, we are going to analyze the logs of each profile.

Step 1: John

John Davis does not open the email (and therefore does not click any links).
Since John neither opened nor clicked in the email, he doesn't appear in the logs.
Intermediate calculation:
Recipients who clicked
People who clicked
Recipients who opened
John
-
-
-
Intermediate total
0
0
0

Step 2: Marie

Marie Stuart opens the email but does not click any links.
Marie's open is displayed in the following log:
The open is assigned to a recipient: Marie. Adobe Campaign therefore adds a new recipient to the count.
Intermediate calculation:
Recipients who clicked
People who clicked
Recipients who opened
John
-
-
-
Marie
-
-
+1
Intermediate total
0
0
1

Step 3: Florian

Florian David opens the email and clicks the links 9 times. He also forwards the email to someone who opens it and clicks twice.
Florian's actions (one open and 9 clicks) appear in the following logs:
Recipients : the open and the clicks are assigned to the same recipient (Florian). Since this recipient is different from the previous one (Marie), Adobe Campaign adds a new recipient to the count.
People: Since this recipient's browser accepts cookies, we can see that the same identifier (UUID) is assigned to all click logs: fe37a503 [...] . Adobe Campaign correctly identifies these clicks as belonging to the same person. A new person is added to the count.
Intermediate calculation:
Recipients who clicked
People who clicked
Recipients who opened
John
-
-
-
Marie
-
-
+1
Florian
+1
+1
+1
Intermediate total
1
1
2
The following logs coincide with the open and two clicks carried out by the person whom Florian forwarded the email to:
Recipients : its open and clicks are assigned to the recipient who forwarded the email (Florian). Since this recipient has already been counted, the recipient count remains the same.
People : concerning clicks, we can see that the same identifier (UUID) is assigned to all logs: 9ab648f9 [...] . This identifier hasn't been counted yet. A new person is therefore added to the count.
Intermediate calculation:
Recipients who clicked
People who clicked
Recipients who opened
John
-
-
-
Marie
-
-
+1
Florian
+1
+1
+1
Unknown person
-
+1
-
Intermediate total
1
2
2

Step 4: Henry

Henry Macdonald has configured his internet browser to reject cookies. He opens the email and clicks the links 4 times.
The open and 4 clicks carried out by Henry appear in the following logs:
Recipients : the open and clicks are assigned to the same recipient (Henry). Since this recipient hasn't been counted yet, Adobe Campaign adds a recipient to the count.
People : Since Henry's browser does not accept cookies, a new identifier (UUID) is generated for each click. Each of the 4 clicks is interpreted as coming from a different person. Since these identifiers haven't been counted yet, they are added to the count.
Intermediate calculation:
Recipients who clicked
People who clicked
Recipients who opened
John
-
-
-
Marie
-
-
+1
Florian
+1
+1
+1
Unknown person
-
+1
-
Henry
+1
+4
+1
Intermediate total
2
6
3

Summary

At the delivery level, we have the following results:
  • Clicks (recipients who clicked): 2
  • Distinct clicks for the population reached (people who clicked): 6
  • Distinct opens for the population reached (recipients who opened): 3
Raw reactivity and estimation of forwards are calculated as follows:
  • Estimation of forwards = B - A (thus 6 - 2 = 4)
  • Raw reactivity = A / C (thus 2 / 3 = 66,67%)
In the following formulas:
  • A represents the Clicks indicator (recipients who clicked).
  • B represents the Distinct clicks for the population reached indicator (people who clicked).
  • C represents the Distinct opens for the population reached indicator (recipients who opened).