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
Account disabled
@disabled
count(@failureReason=4)
Blacklisted
@blacklisted
count(@failureReason=8, @failureType=2)
Blacklisted rate
@rateBlacklisted
@blacklisted/@sent
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
Delivered
@delivered
count(@status=1)
Delivered rate
@rateDelivered
@delivered/@sent
Hard bounces
@hardBounces
count(@failureType=2 AND @failureReason=8)
Hard bounces rate
@rateHardBounces
@hardBounces/@sent
Invalid domain
@invalidDomain
count(@failureReason=2)
Mailbox full
@mailBoxFull
count(@failureReason=5)
Mirror page
@mirrorPage
count(@trackingUrlType=6)
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
Quarantine
@quarantine
isQuarantine=true
Quarantine rate
@rateQuarantine
@quarantine/@sent
Refused
@refused
count(@failureReason=20)
Rejected
@rejected
count(@failureReason=20, @failureType=2)
Rejected rate
@rateRejected
@rejected/@sent
Processed/sent
@sent
@delivered + @bounces
Soft bounce
@softBounces
count(@failureType=1)
Soft bounce rate
@rateSoftBounces
@softBounces/@sent
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
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

Esta obra está autorizada con arreglo a la licencia de Reconocimiento-NoComercial-CompartirIgual 3.0 Unported de Creative Commons.  Los términos de Creative Commons no cubren las publicaciones en Twitter™ y Facebook.

Avisos legales   |   Política de privacidad en línea