- Campaign Standard documentation
- Latest Updates
- Release Notes
- Getting started
- Profiles and audiences
- Communication channels
- Get started with communication channels
- About communication channels
- Delivery best practices
- Email messages
- SMS messages
- Push notifications
- In-App messaging
- Direct mail
- Transactional messaging
- Landing pages
- Designing email content
- Testing and Sending
- Reporting
- Integrating with other solutions
- Get started with Campaign integrations
- Campaign and Experience Manager
- Campaign and Target
- Campaign and Analytics
- Campaign and Audience Manager or People core service
- Campaign and Analytics for Mobile
- Campaign and Triggers
- Campaign and Microsoft Dynamics 365
- Campaign and Adobe Experience Platform
- Managing processes and data
- Get started with data and processes management
- Workflow general operation
- Executing a workflow
- Calling a workflow with external parameters
- Targeting activities
- Execution activities
- Channel activities
- Data management activities
- Filtering data
- Importing and exporting data
- Use cases
- About workflow use cases
- Deliveries
- Creating deliveries with a complement
- Creating deliveries on profiles’ creation date
- Creating a weekly delivery
- Creating a cross-channel delivery
- Identifying duplicates before a delivery
- Birthday delivery
- Coupling email and direct mail deliveries
- Sending an email with enriched fields
- Personalizing an email with additional data
- Sending a recurring push notification
- Segmentation and targeting
- Data management
- Reconcile a File audience with the database
- Deduplicating the data from an imported file
- Enriching profile data with data contained in a file
- External signal activity and data import
- Updating the database with external data
- Updating data based on an automatic file download
- Data reconciliation using relations
- Data update using reconciliation
- Exporting profiles in an external file
- Updating multiple subscription statuses from a file
- Subscribing profiles from a file to a specific service
- Developing
- Administrating
- Get started with Campaign Standard administration
- Monitoring guidelines
- Audit Trail
- Configuration guidelines
- Users and security
- Configuring channels
- Configuring mobile channels
- Implementing Push tracking
- Adding images and videos iOS
- Understanding push notifications payload structure
- Implementing local notification tracking
- Tags in Adobe Experience Platform synchronization FAQ
- Experience Platform SDK integration FAQ
- Configuring tag rules to support Adobe Campaign Standard use cases
- Mobile use cases supported in Adobe Campaign Standard
- How to migrate your mobile application from SDK v4 to Adobe Experience Platform SDK
- Configuring SMS channel
- Application settings
- Working with APIs
- Get started with Campaign Standard APIs
- About Campaign Standard APIs
- Global concepts
- Interacting with custom resources
- Managing profiles
- Managing services and subscriptions
- Interacting with marketing history
- Privacy management
- Managing transactional messages
- Managing workflows
- Managing organizational units
- Managing geographical units
- Troubleshooting
- Campaign Control Panel
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
| 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
| 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
| 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 |
Business.Adobe.com resources
Resources
Adobe Account
Change language
Copyright © 2023 Adobe. All Rights Reserved.
