Indicator calculation indicator-calculation
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. .
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)
recommendation-more-help
7167b251-0f24-48cd-a4e0-234fe2acbdea