Overview: Data Calculations
With Data Calculations you can combine data from any Data Source in an equation to create new Calculated Metrics. Some popular use cases for Data Calculations include calculating Conversion Rates, ROI, ROAS, and more.
How to Access Data Calculations
Navigate to Metrics > Data Calculations to access Data Calculations.
Data Calculations is available in Plus and Business Accounts. Agency Basic Accounts have access to Data Calculations in the Agency Account only. Request a trial of Data Calculations by following
How to Create a Calculated Metric
How to calculate Metrics with Units
Some Metrics are stored with associated units. Typically, these are currency Metrics (like "Amount Spent" from Facebook Ads or "Spend" from Google Ads) where the unit is referencing the currency type (i.e., USD, EUR, AUD, etc.).
How to calculate Attributed Metrics
Attributed Metrics are Metrics that contain Dimensions. Learn more about Attributed Metrics here.
If an Attributed Metric with a Dimension selected is calculated with another Attributed Metric with a Dimension selected, the calculation will be performed on the Dimensions. The Calculated Metric created from this will be a Standard Metric (no Dimensions).
For example, the Organic Session-to-Lead Conversion Rate can be calculated by doing "Leads by Source" with the "Organic" Dimension selected / "Sessions by Source" with the Organic Dimension selected. The resulting Calculated Metric now stores data for "Organic Session-to-Lead Conversion Rate."
If an Attributed Metric with no Dimension selected is calculated with a single value (whether that be a Standard Metric, an Attributed Metric with 1 Dimension selected, or a fixed number), the calculation will be executed individually for every Dimension. The Calculated Metric created from this would be an Attributed Metric.
For example, you may spend $100 on every Facebook Ads Campaign that isn't tracked in Facebook Ads itself. To account for this, you can calculate the following: "Spend by Campaign" (no Dimension selected) + 100. This will add 100 to every Campaign.
If an Attributed Metric with no Dimension selected is calculated with another Attributed Metric with no Dimension selected, the calculation will be performed only between identical Dimensions. If there are Dimensions that are not found in both Attributed Metrics, no calculation will be performed on them.
The Calculated Metric created from this would be an Attributed Metric as well.
For example, you can use this strategy to calculate Email Open Rate for every individual Email. To do this, you would calculate “Emails Opened by Email Title (no Dimension selected)” / “Emails Sent by Email Title (no Dimension selected)“. The calculation will be performed on identical Dimensions, so the resulting Calculated Metric now stores data for “Email Open Rate by Email Title.”
How to view Calculated Metrics
Use the Created By, Tags, and Data Source drop-downs in the top right of the Data Calculations page to view significant Calculated Metrics.
From the Data Source drop-down, you can view the number of Calculated Metrics that have been built for each Data Source.
How to Add a Calculated Metric to a Databoard
- Due to YouTube's API Terms of Service, users are not allowed to create and calculate their own derivated metrics from YouTube's API Data. Therefore, using YouTube Metrics in Data Calculations is not permitted in Databox.