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

Эта работа лицензируется в соответствии с лицензией Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported  На посты, размещаемые в Twitter™ и Facebook, условия Creative Commons не распространяются.

Правовые уведомления   |   Политика конфиденциальности в сети Интернет