Use this example to see how data is pulled from connected data extensions (regions) and engagement data (sends, bounces, and clicks).
Required Editions
| Available in: Intelligence Reports Advanced |
| Region | Sends | Bounces | Clicks |
|---|---|---|---|
| EMEA | 100 | 5 | 50 |
| AMER | 150 | 15 | 65 |
| APAC | 90 | 10 | 20 |
Builder Calculations
Logic
Delivered = Sends - Bounces
Formula
[email__sends_[engagement__data]] - [email_bounces_[engagement_data]]Logic
Click Rate = Clicks/(Sends - Bounces)
Formula
[email_unique_clicks_[engagement_data]] / ([email_sends_[engagement_data]] - [email_bounces_[engagement__data]]) Query Results
The builder calculations produce these query results.
| Region | Delivered | Click Rate |
|---|---|---|
| EMEA | 95 | 0.52 |
| AMER | 135 | 0.48 |
| APAC | 80 | 0.25 |