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.
|
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) |
|
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 |
|
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 |
Twitter™ and Facebook posts are not covered under the terms of Creative Commons.