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