Metrics are a central concept in Funnel. They contain the numerical measures from your connected data sources. You can also create your own custom metrics that are based on the fields from your data sources or other custom metrics. These can be used just like any other metric in Funnel.

Creating a new custom metric

To create a new metric you have the following choices available in the metrics page:

  • New - Create a new metric from scratch
  • Copy from other account - Re-use one or more metrics from other accounts that you can later adjust in this account
  • Create from template - Create a new metric that uses Funnel's standard rules (e.g. account wide totals for Cost, Clicks and Impressions). These can be overridden to create the logic you need in this account

Then you can see and adjust attributes common to all metrics:

  • Id - A unique identifier for the metric, used in exports etc.
  • Name - A name used in metric listings, tables etc.
  • Description - A longer description explaining the metric's use case
  • Unit - Monetary, number, percentage, or duration describe how to display and interpret the value
  • Precision - The number of decimals to display

After this you need to decide how the calculation should be done:

  • Formula - Simple math. For example Cost / Clicks
  • Rules - Based on conditions. For example, varying definition of Cost depending on data source

Examples of these are detailed below. Once the definition is saved you can use it in Funnel's Data Explorer, Data Warehouse exports, Dashboards etc.

Formula

If you, for instance, want to create a metric that shows cost per session, which you define as cost divided by sessions, it would be expressed as a simple math expression: Cost / Sessions 

This can be typed in as formula in the input field that will help searching for what underlying fields that can be used. Other common examples are:

  • Client cost  Cost * 1.1 
  • Net revenue Revenue - Cost 
  • Revenue per Session  Revenue / Sessions 
  • Client ROAS Revenue / (Cost * 1.1) 

Other formula metrics (custom or from data sources) cannot be re-used in a formula. Nor can one use any conditions. So, in order to express more advanced logic or to simplify and re-use concepts, you can use rule based metrics.

Rules

If you, for instance, want to create a metric that varies the definition of Conversions depending the data source that could be expressed as:

For Adwords data, set the value to Adwords All conv.
 For Facebook Ads data, set the value to Website Conversions.
 For Google Analytics data, set the value to Goal 1 + Goal 6 

This is done by adding rules in the Rule editor. One can also add multiple conditions and do other transformation on the selected values. The order of the rules can be important as the first match is used. Other examples of rule based metrics are:

  • Billed cost
    if Campaign contains "_A1_" then Cost * 1.1,
     if Campaign contains "_A2_" then Cost * 1.2,
     otherwise Cost
     
  • AppsFlyer installs if Event name is "install" use Count  
  • Revenue ex tax
    if Market contains "US" then Revenue * 0.8,
    if Market contains "UK" then Revenue * 0.75,
     ...   
  • Calculated Revenue
     if Campaign contains "|c7" then Total Conversions * 1.07,
     if Campaign contains "|c20" then Total Conversions * 1.2,
     ...
     

Read more about Formulas and Rules in How are custom metrics calculated?

Did this answer your question?