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 Data Manager > 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
these steps
.
How to Create a Calculated Metric
1
Enter a name for your Calculated Metric in the
Calculated Metric Name text box.
2
Click on variable
A to open the first Metric selection window. Select the first Data Source and Metric that you want to use in your equation. To manually enter a value into the equation, select
Set a fixed value.
On the right side of the Data Calculations window, you can see a Data Preview for your Calculated Metric. The Date Ranges available for the Calculated Metric are dependent on the Date Ranges available for the individual Metrics used in the calculation.
3
Click on the blue
+ operator to update the equation to add, subtract, multiply or divide the next variable. Parenthesis can be used to adjust the order of operations.
4
Click on variable
B to open the next Metric selection window. Select the next Data Source and Metric that you want to use in your equation. To manually enter a value into the equation, select
Set a fixed value.
5
Repeat steps 4 and 5 with the remaining variables until your equation is complete.
6
Update the Format and Scale for the Calculated Metric at the bottom of the Data Preview. Learn more about Format and Scale
here.
7
Click
Save to save the Calculated Metric in your Account.
How to Add a Calculated Metric to a Databoard
1
Open the selected Databoard in the Databox Designer, or create a new Databoard.
2
Drag and drop a blank Datablock onto the Databoard from the Visualization Library.
3
Select the appropriate Data Source in the righthand Property Manager. This must be the same Data Source that was selected when creating the Calculated Metric. If data from multiple Data Sources are used in the Data Calculation, select any of the Data Sources that were used in the equation.
4
Select the
Calculated tab at the top of the
Metric drop-down list.
5
Select the Calculated Metric name to populate the Datablock.