---
schema_version: "1"
id: 4877d499d4629e87fb4bf35e70b5946edcaaa5d3add74eb5be272d96f47eb3e7
title: Builder Calculations in the Query Builder
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.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_dat_builder_calculations.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 37da919cc657a75eeaf4e23ecc19eed0634b98e67c2d90dbdc3b9bd13bea6e36
description: 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.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Builder Calculations in the Query Builder

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

<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: Available in: Intelligence Reports Advanced</td></tr></tbody></table>

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](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_builder_cacluations_create.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_builder_calculations_example.htm&release=264.0.0&type=5)**  
    Use this example to see how data is pulled from connected data extensions (regions) and engagement data (sends, bounces, and clicks).