Show Menu
TOPICS×

Indicator calculation

The tables below give you the list of indicators used in the different reports and their calculation formula depending on the delivery type.

Email delivery

Label
Field name
Indicator calculation formula
Comments
Account disabled
@disabled
count(@failureReason=4)
Blacklisted
@blacklisted
count(@failureReason=8, @failureType=2)
Blacklisted rate
@rateBlacklisted
@blacklisted/@sent
Denominator for rate calculation is based on Sent count (Delivered + Bounces).
Bounces + Errors
@bounces
count(@status=2)
Bounce + Error rate
@rateBounces
@bounces/@sent
Click
@clicks
count(@trackingUrlType=1 or 10 or 11)
Click through rate
@clickthrough
@uniqueclicks/@delivered
Denominator for rate calculation is based on Delivered only.
Delivered
@delivered
count(@status=1)
Delivered rate
@rateDelivered
@delivered/@sent
Denominator for rate calculation is based on Sent count (Delivered + Bounces).
Hard bounces
@hardBounces
count(@failureType=2 AND @failureReason=8)
Hard bounces rate
@rateHardBounces
@hardBounces/@sent
Denominator for rate calculation is based on Sent count (Delivered + Bounces).
Invalid domain
@invalidDomain
count(@failureReason=2)
Mailbox full
@mailBoxFull
count(@failureReason=5)
Mirror page
@mirrorPage
count(@trackingUrlType=6)
Denominator for rate calculation is based on Delivered only.
Mirror page rate
@rateMirrorPage
@mirrorPage/@delivered
Not connected
@notConnected
count(@failureReason=6)
Open
@opens
count(@trackingUrlType=2 + unique(@trackingUrlType=1,2,3,6,10,11) - unique(@trackingUrlType=2))
Open rate
@rateOpens
@opens/@delivered
Denominator for rate calculation is based on Delivered only.
Quarantine
@quarantine
isQuarantine=true
Quarantine rate
@rateQuarantine
@quarantine/@sent
Denominator for rate calculation is based on Sent count (Delivered + Bounces).
Refused
@refused
count(@failureReason=20)
Rejected
@rejected
count(@failureReason=20, @failureType=2)
Rejected rate
@rateRejected
@rejected/@sent
Denominator for rate calculation is based on Sent count (Delivered + Bounces).
Processed/sent
@sent
@delivered + @bounces
Soft bounce
@softBounces
count(@failureType=1)
Soft bounce rate
@rateSoftBounces
@softBounces/@sent
Denominator for rate calculation is based on Sent count (Delivered + Bounces).
Unique clicks
@uniqueclicks
Unique clicks is calculated using ThetaSketch concepts.
Unique opens
@uniqueopens
unique(@trackingUrlType=1,2,3,6,10,11)
Unreachable
@unreachable
count(@failureReason=3)
Unsubscribe
@unsubscribes
count(@trackingUrlType=3)
Unsubscribe rate
@rateUnsubscribes
@unsubscribes/@delivered
Denominator for rate calculation is based on Delivered only.
User unknown
@unknownUser
count(@failureReason=1)

Push notification delivery

Label
Field name
Indicator calculation formula
Processed/sent
@sent
@count(status=sent)
Delivered
@delivered
@count(status=delivered)
Delivered rate
@rateDelivered
(@delivered/@sent)*100
Bounce + Error rate
@rateBounces
(@delivered/@sent)*100
Open
@opens
@count(status=open)
Open rate
@rateOpens
(@opens/@delivered)*100
Unique opens
@uniqueopens
Unique opens is calculated using ThetaSketch concepts of unique RecipientIds.
Impressions
@impressions
@count(status=delivered)
Unique impressions
@uniqueimpressions
@unique(@count(status=view))
Click
@clicks
@count(status=interact)
Unique clicks
@uniqueclicks
Unique clicks is calculated using ThetaSketch concepts.
Click through rate
@clickthrough
(@interact/@delivered)*100

In-App delivery

Label
Field name
Indicator calculation formula
Comments
Processed/sent
@sent
@count(status=sent)
sent=delivered
Delivered
@delivered
@count(status=delivered)
delivered=sent
Impressions
@impressions
@count(status=view) or @count(status=button 1 click + button 2 click + dismissals)
Unique impressions
@uniqueimpressions
@unique(@count(status=view))
For
Target users based on their Campaign profile (inAppProfile)
template, user = Recipient Id. For
Target all users of a Mobile app (inAppBroadcast)
and
Target users based on their Mobile profile (inApp)
templates, user = MC Id or equivalent that represents a unique combination of user, mobile app and device.
In-App clicks
@inappclicks
@count (status=click)
Unique In-App clicks
@uniqueinapp
@unique(@count (status=clicks))
For
Target users based on their Campaign profile (inAppProfile)
template, user = Recipient Id. For
Target all users of a Mobile app (inAppBroadcast)
and
Target users based on their Mobile profile (inApp)
templates, user = MC Id or equivalent that represents a unique combination of user, mobile app and device.
In-App click through rate
@inappclickthrough
Total clicks on Button 1 or Button 2/total impressions*100
In-App dismissal
@dismissal
@count (status=close)
Unique In-App dismissals
@uniquedismissal
@unique(@count (status=close))
For
Target users based on their Campaign profile (inAppProfile)
template, user = Recipient Id. For
Target all users of a Mobile app (inAppBroadcast)
and
Target users based on their Mobile profile (inApp)
templates, user = MC Id or equivalent that represents a unique combination of user, mobile app and device.
In-App dismissal rate
@dismissalrate
Total close/total impressions*100