After gathering feedback from you, our users, and seeing what we've achieved with Facebook & Instagram's Calculated Metrics we've decided that the next integration for Calculated Metrics should be Google Ads.

First off, let’s cover some of the basics.
For this to work, you will have to switch from predefined widgets to custom ones.

Click on ADD CALCULATED METRIC(S).

After that, this will pop-up.

Metric Name: is what your new metric will look like on your widgets. You can leave it blank, but in that case, Reportz will automatically generate a string of numbers/letters so it’s recommended to add one before you proceed.
Metric Formula: this is the most important aspect of Calculated metrics. Here you have to define everything. The metric which you want to calculate as well as what you’d like to calculate it with. You can add multiple metrics or you can go with just one, it’s entirely up to you.
Metric type: is how you want your new values to be presented.
You can choose between:

  1. Number
  2. Money
  3. Percent
  4. Average Number
  5. Average Money
  6. Average Percent

Since there are a lot of possible combinations for these calculated metrics - I’ll just cover two of the basic ones.

How to show your agency fee in addition to the ad spend. (Markup feature)

Let’s say that we have an agency fee of 15% for the entire ad spend. 

In the Metric Name, you’re supposed to name your new metric.
For this example let’s name it Cost (Markup).

In the Metric Formula, you’re supposed to provide the metrics you’d like to operate with and your formula. 

All metrics are located in the description tabs of the widget itself!

Also, all of the metrics must be included with  {{ as well as }} at the end of the metric.

And here is what the syntax of the markup formula would look like:
 {{spend}}*1.15  

As a Metric Type, you should choose money because that’s what we want to be shown for this example.

This is what the entire setup should look like before you proceed. 

Click on Next.

Since you’ve created a Custom Widget you will have to rename it since it’s automatically set to be named Custom. Rename it to something like “Spend / Agency fee”. 

We also recommend adding descriptions to your widgets because in the view mode of your dashboards the description will be shown when you hover over the widgets with your pointer. 

Click on Next again, and if you don’t want to change anything else click on Submit

If you’ve set up the formula the right way the resulting widget should look something like this.

Let's move on to the ROI.

In the Metric Name field insert ROI, or Return on Investment.  
For this example, we will calculate ROI for all conversion value.

In the Metric Formula add this:

{{AllConversionValue}}-{{Cost}})/{{Cost}}*100 

So what did we do here? We’ve copied the metric name from the description BUT instead of using the conversions we’ve gone with all conversion values.

So instead of the total amount of conversions, we presented how much value have those conversions generated.
We’ve subtracted that amount with the entire ad spend, divided that number by the entire ad spend and multiplied it with a hundred.

Since ROI is shown in percentages, choose this as your Metric Type.
This is what your setup should look like:

There are a ton of different ways to use these calculated metrics, and we will cover more of them in the days to come.

Don’t forget that the support team is here to help you out with any issue you might have. 

Happy Reporting!

Did this answer your question?