DocumentationCampaign Standard Documentation

Indicator calculation indicator-calculation

Last update: Mon Sep 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Intermediate
  • Leader
NOTE
To better process and manage high volumes and real-time analyses, Dynamic reporting uses approximate aggregations for distinct count estimates. Approximate aggregations offer bounded memory usage and are often faster than exact computations.

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 email-delivery

Label
Field name
Indicator calculation formula
Comments
Account disabled
@disabled
count(@failureReason=4)
On denylist
@blacklisted
count(@failureReason=8, @failureType=2)
Denylist 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
@uniqueOpens
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).
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. For more on this, refer to this example.
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 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. For more on this, refer to this example.
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. For more on this, refer to this example.
Click through rate
@clickthrough
(@interact/@delivered)*100

In-App delivery 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
recommendation-more-help
3ef63344-7f3d-48f9-85ed-02bf569c4fff