Use a builder calculation to create a custom field, such as click rate and open rate,
directly in the Query Builder without using SQL code.
Required Editions
| Available in: Available in: Intelligence Reports Advanced |
A builder calculation differs from a calculated measurement, which is used in a pivot table,
report, or dashboard. You can use a builder calculation only when using the Query Builder in
the Queries tab. Calculations can be used in a query with attributes from connected data
extensions, thus enabling you to answer questions, such as what is the click rate per
city?
- Create a Builder Calculation
Use a builder calculation to create a custom measurement when you have subscriber-level data and you want more information, such as click rates or open rates. For example, you have geographical location data and you want to see the click rate per city.
- 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).
