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. 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.