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

How to Access Data Calculations

add_user_popup@2x

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

add_user_popup@2x

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.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us