Custom Formulas

  • 1 minute(s) read
Prev Next

Formulas can be built to calculate own metrics. Setup is done at Custom Figures > Custom Formulas

The permission to create custom metrics must be set in the user management.

This can be done at User Management > Roles and within a role at Rights Management > Configuration Access.

1 Configuration

  • Clicking on Create formula opens the formula editor.

  • In a formula, you can use metrics, formulas, operators, and numbers.
     

  • Metrics and formulas can be edited directly in the formula. This way, you can create custom metrics that are only available in this formula.

  • Changes to existing formulas are applied across the entire account (e.g., in reports, "My Analyses," or other formulas).

  • Hint: Unicode characters can be entered by typing the corresponding number combination on the numeric keypad while pressing ALT.
     

  • Example: Input of the average symbol

    1. Hold „ALT“.

    2. Enter „0 2 1 6“.

    3. Release „ALT“.

2 Use Cases

Examining origin

  • Visits via Google %
    What is the share of access via Google on the overall number of visits?
     

    Filtering of the metric:

  • Visits via tablet %
    What is the share of tablet access on the overall number of visits?
     

    Filtering of the metric:

Examining user activity

  • Newsletter registration (value)
    Each newsletter registration is worth 5 Euros. What was the total value of newsletter registrations?
     

    Filtering of the metric:

    You should filter on the page that is shown when a newsletter registration is successful.

  • Visits without product interaction %
    In how many visits there was no product interaction?
     
    Filtering of the metric:
     
    Product interaction means viewing a product in a list, viewing a product in detail, adding a product to a cart, or purchasing a product.

Examining products and orders

  • Share of viewed sale items %
    What share of viewed products belongs to the product category „Sale“?
     
    Filtering of the metric:
     

    „PC1 – Product Category 1“ is a custom-created category.

  • Share of orders with sale item %
    What is the share of orders with at least one product of the product category „Sale“?
     

    Filtering of the metric:

    „PC1 – Product Category 1“ is a custom created category.