Use derived fields to report on goals

This use case describes how to use the power of derived fields to set goals for a specific dimension and then use these goals in your Workspace project.

If you are not familiar with derived fields, refer to the tutorial and documentation for an introduction.

Define goals

To define goals, create a new derived field where you explicitly set custom numeric values directly or indirectly using the values resulting from rules earlier in your derived field definition.

Monthly Gift Certificate Orders Goals

You want to explicitly set goals for your gift certificate orders for four months, ranging from July 2023 - October 2023. To do this:

  1. Create a new derived field with the name Monthly Gift Certificate Orders Goal (Incremental).

  2. Set static values, using a CASE WHEN RULE, for each month, by setting a Custom numeric value. See the Monthly Product Goals rule below.

    Monthly Product Goals

Marketing channel revenue goals

You want to set a monthly revenue goal for each of your marketing channels. To do this:

  1. Create a new derived field, using the Marketing channels function template with the name Monthly Marketing Channel Revenue Goal (Incremental).

  2. Define all rules to properly identify each of the marketing channels based on a combination of URL PARSE and CASE WHEN rules. For example:

    Definition of rules for marketing channel derived field

  3. Explicitly set static values, representing monthly revenue goals, for the specific marketing channels in a final CASE WHEN rule, by setting a Custom numeric value. See the Monthly Goal rule below.

    Monthly Goals

Use goals

To use goals in your Workspace project, you use the calculated metric functionality to ‘normalize’ the derived field back to its original static value. This normalization is required as the static values you set for the derived fields defining goals, are incremented with every event.

Monthly Gift Certificate Orders Goals

  1. Create a calculated metric field named Monthly Gift Certificate Orders Goal, defined as:

    Orders Goal

  2. You can create additional calculated fields, for example % of Monthly Gift Certificate Orders Goal, to show actual progress against goals, for example:

    Orders Goal Percentage

You can use these calculated metrics to report on progress in freeform tables and visualizations. For example:

Freeform table showing marketing revenue goals

Marketing channel revenue goals

  1. Create a calculated metric field named Marketing Channel Revenue Goal, defined as:

    Revenue Goal

  2. You can create additional calculated fields, for example % of Marketing Channel Revenue Goal, to show actual progress against goals, for example:

    Revenue Goal Percentage

You can use these calculated metrics to report on progress in freeform tables and visualizations. For example:

Freeform table showing marketing revenue goals

recommendation-more-help
080e5213-7aa2-40d6-9dba-18945e892f79