Create a Custom Measure in Data Studio
With Custom Measures you are able to focus on metrics that are not exportable from our ROIVENUE's Data Exports.
ROIVENUE Data Exports 2.0 are great, but sometimes you might want to make your own calculation. That is where custom measures come in handy.
List of all exportable metrics from ROIVENUE
After this tutorial you will be able to create metrics like these:
Metrics in ROIVENUE
Calculation in Data Studio
Cost per Acquisition
sum(marketingInvestment)/sum(conversions)
Click Through Rate
sum(clicks)/(sum(impressions))
Conversion Ratio
sum(conversions)/sum(visits)
Conversions per Click
sum(conversions)/sum(clicks)
Conversions per Impression
sum(conversions)/(sum(impressions))
Cost per Click
sum(marketingInvestment)/sum(clicks)
Cost per Delivery
sum(marketingInvestment)/sum(deliveries)
Cost per Impression
(1000*sum(marketingInvestment))/(sum(impressions))
Cost per Visit
sum(marketingInvestment)/sum(visits)
Cost per Visitor
sum(marketingInvestment)/sum(visitors)
Deliveries per Click
sum(deliveries)/sum(clicks)
Deliveries per 1 Million Impressions
(1000000*sum(deliveries))/(sum(impressions))
Delivery Ratio
sum(deliveries)/sum(conversions)
Gross Margin
sum(grossProfit)/sum(netRevenue)
Margin Return on Marketing Investment
(SUM(grossProfit)-sum(marketingInvestment))/(SUM(marketingInvestment))
Margin on Marketing Investment Ratio
sum(marketingInvestment)/sum(grossProfit)
Marketing Investment Ratio(Cost of Sales
sum(marketingInvestment)/sum(netRevenue)
New Customer Ratio
sum(newConversions)/sum(netRevenue)
Profit per Click
sum(grossProfit)/sum(clicks)
Profit per Conversion
sum(grossProfit)/sum(conversions)
Profit per Impression
sum(grossProfit)/(sum(impressions)
Profit per Order
sum(grossProfit)/sum(deliveries)
Profit per Visit
sum(grossProfit)/sum(visits)
ROMI
(netRevenue-sum(marketingInvestment))/marketingInvestment
Revenue per Click
sum(netRevenue)/sum(clicks)
Average Prder Value
sum(netRevenue)/sum(conversions)
Revenue per Impression
sum(netRevenue)/impressions
Revenue per Order
sum(netRevenue)/sum(conversions)
Revenue per Visitor
sum(netRevenue)/sum(visits)
Visit Ratio
sum(visits)/(sum(clicks)
Visits per Delivery
sum(visits)/sum(deliveries)
Visits per Impression
sum(visits)/sum(impressions)
Visits per Unit
sum(visits)/(sum(impressions)

What are custom measures?

Custom measures allow you to create any possible metric by performing calculations on the current ones. For example, the list above provides us with clicks and impressions. So we can easily calculate click-through rate by dividing clicks by impressions.
CTR=clicks/impressionsCTR = clicks/impressions

How to Create one in Data Studio

1. Go to Data Studio and open the desired report in Edit mode.
2. Click on the component where you would like to see your new custom measure.
3. Choose "Add metric" on the right menu and then on "CREATE FIELD".
4. A new menu where you will create the custom measure has opened up. Let's say we want to create Margin Return on Marketing Investment.
5. Name the field accordingly and insert the calculation from the table above.
6. Hit apply, and you are done. The desired measure will calculate and then show up in the component.

Make it Universal!

You probably want to reuse the same custom metric(s) across multiple components. This doesn't mean you have to create a certain field X times to create your custom report.
To make custom measures easy to use across different tables and charts, you can easily insert them in the data set in the Data Studio.
  1. 1.
    Click "ADD A FIELD" in the left menu.
Now, a similar window has opened up, and you can insert the same formula here. The difference is that after you save it, it will appear in the list of "Available Fields", and you can easily drag & drop the measure into different components.
Last modified 5mo ago