---
schema_version: "1"
id: 10a2f509014a890ec758861a9f4d192621d8aeb5f822134c70a43f610e1a1c70
title: Click Rate Builder Calculation Example
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_dat_builder_calculations_example.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_dat_builder_calculations_example.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 7dfc74c621c67d7226e00f0c806e86af13baa58b6d2f193ed353238d3df316ce
description: Use this example to see how data is pulled from connected data extensions (regions) and engagement data (sends, bounces, and clicks).
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Click Rate Builder Calculation Example

Use this example to see how data is pulled from connected data extensions (regions) and engagement data (sends, bounces, and clicks).

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Intelligence Reports Advanced</td></tr></tbody></table>

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