Skip to main content

Setting up value tracking

You need to set up value tracking so that Transformation Hub understands how to quantify the value realized from your value opportunities. For common types of value opportunities, Transformation Hub provides recommended value tracking formulas to help you quantify value based on KPI improvements (such as in the first approach below).

Common approaches to quantifying value are:

  1. Tracking how a KPI improved from its baseline, then converting that improvement into actual value realized.

    1. For example, if you wish to realize more cash discounts offered by vendors from paying invoices earlier, you can change the payment policy to pay invoices with cash discounts earlier. Then implement a Celonis app that highlights invoices with cash discounts that should be paid earlier.

    2. You can record your current baseline of 15% cash discounts realized from the last fiscal year and start tracking the improved cash discounts realization rate after the change.

    3. If you improve this rate to 60% in the current fiscal year, that’s a 45% improvement.

    4. To understand how much actual value this represents, multiply this improvement by the available cash discounts in this fiscal year, which in this example is $10,000.

    5. This means that you have realized (45% * $10,000) = $4,500 of P&L value due to the solutions implemented to improve cash discounts realization.

  2. Track usage of implemented solutions and their associated value.

    1. For example, if you want to prevent duplicate invoice payments, see: Installation Guide.

    2. In the app, review invoices marked as duplicate, verify if they are real duplicates, and then prevent payments for any invoices verified as duplicates.

    3. You can quantify how much working capital value this frees up by aggregating the total value of the duplicate payments prevented.

    4. You can also understand how many hours of productivity are saved by multiplying the number of prevented duplicate payments by the estimated effort required to retrieve each duplicate payment.

Before you begin, ensure you have completed the following steps or meet the requirements listed below:

  • You must have Admin permissions to use Transformation Hub.

  1. Locate your value opportunity on the Opportunities screen and click the name link in the Opportunity name column.

    Note

    You can also add the realized value by clicking the “Add” link in the Realized value column.

    Screenshot showing the Opportunities screen in Transformation Hub.
  2. On the value opportunity details screen, click the Set up value tracking link to access the guided wizard.Step 1 - Select Data

    Screenshot showing the opportunities details screen in Transformation Hub.
  3. Select the Space and Knowledge Model containing the KPIs that you want to use to track value for this value opportunity.

    Note

    If you are on Object Centric Process Mining and don’t have a Knowledge Model, you can create a Knowledge Model for this step.

  4. On the Value tracking setup screen, use the dropdown to select the Space containing the KPIs you want to use.

    Note

    If you are unable to access the Value tracking setup screen, verify with your team admin that you have the correct user permissions assigned for creating a value opportunity.Transformation Hub

    Screenshot showing step one of the Value tracking set up window.
  5. Once the space has been selected, use the Knowledge model dropdown to select the model you want to use to track value for this value opportunity.

    Screenshot showing step 1 of the Value tracking setup window with the Knowledge model dropdown expanded to show options.
  6. Click Save & Continue to finish.

In the Set up formula step, you can scope the value opportunity by choosing a date column to use in your filters and then by selecting one or more applicable filters from your Knowledge Model, such as filtering by company code or vendor. You then use this filtered data to create your value tracking formula by selecting KPIs or creating a custom statement using PQL.

  1. Use the Date column dropdown to select a date column from your Knowledge Model to use for time filters.

    Screenshot showing step two of the Value tracking setup window where users can select the data column to use and create a filter.

    For example, if “Creation Date” is selected as the Date column, then only invoices with a date value in the “Creation Date” column that falls between <Tracking start date> to <Latest date> will be used when calculating value realized and KPIs.

  2. In the Filter your opportunity section, use the dropdown to select one or more filters from your Knowledge Model to apply. (optional)

    Screenshot of the Value tracking setup screen showing the available options users can select to create a filter for this opportunity.
  3. In the Set up Formula section, choose one of the two options for setting up your value tracking formula: "Select KPIs to track value using the formula" or "Write PQL formula to track value".

  4. Choose "Select KPIs to track value using the formula" to use the recommended option, which provides a formula in business terms and then asks you to select the KPIs or constants to use in that formula.

    Screenshot showing the Set up Formula options on step two of the Value tracking setup window.
    1. Baselines: Provide a baseline value for the KPI that you are trying to improve. This baseline can be from the last fiscal year, the last 12 months, or another value. You may want 12 months of data for your baseline if your data is cyclical. If your data is relatively consistent, then you may feel that 6 months of data better represents your baseline.

      Note

      We strongly recommend that the same KPI be used for calculating your baseline and for monitoring KPI improvements after implementing solutions.

      Screenshot showing the Value tracking options for setting up a formula based on specified baseline values.
    2. KPIs: Use the dropdown to select the KPI you are trying to improve, as well as any other associated KPIs needed for quantifying value.

      Screenshot showing the Value tracking options for setting up a formula based on selected KPIs.
    3. Estimates: Some formulas require you to provide estimates to quantify value, such as the estimated effort per manual activity or the estimated cost per minute to manually carry out an activity.

  5. Select "Write PQL formula to track value" to use a custom formula, which requires you to reference a KPI containing the complete formula.

    Screenshot showing the Value tracking options for setting up a custom formula using PQL.
  6. Click Save. You can now add historical realized value or review and finalize your setup.

Historical value can be added to an opportunity to account for value that was realized prior to the opportunity being set to Live. You can add, edit, or remove historical value for an opportunity at anytime when the opportunity is in Draft or Live status.

An opportunity's historical value is then displayed on the opportunity details page which shows both the historical value and tracked value. This historical value will also be shown on the Value Report page for this opportunity.

  1. On the value opportunity details page, click the Add link in the "Would you like to include historical realized value?" panel.

    Screenshot of the opportunity details screen with the Would you like to include historical realized value link highlighted.
  2. In the Historical realized value window, enter the value that this opportunity realized prior to being turned Live.

    Note

    The currency is set to the default value for this opportunity and cannot be changed.

    Screenshot of the Historical realized value window where users can add previously realized values and the date range in which they were realized.
  3. Use the date field to select the estimated time frame during which this historical value was realized. Select both a start and end date to indicate the full time frame and then click Apply.

    Screenshot of the Historical realized value window with the date selection mechanism opened.
  4. On the Historical realized value window, click Save. The Historical realized value is now displayed on your value opportunity details page.

    Screenshot of the opportunity details screen with the newly added historical realized value highlighted.
  5. Next, you need to review and finalize your setup.

Your value opportunity is now “100% Ready to start tracking” but is still in Draft status. Review your framed value and realized value setups before you begin tracking. Click the Edit (pencil) icon to make changes to any of your setup configurations.

Screenshot of an opportunity in Transformation Hub that is ready to begin value tracking.

Use the Notes field at the bottom of the page to enter any additional information regarding this value opportunity or add any relevant links.

Once a value opportunity turns Live, Transformation Hub will take the KPIs linked in your value tracking formula, apply the filters you have selected, and then calculate the value realized and the KPIs between <Tracking Start Date> to <Latest date>. This data will be shown on a Live value opportunity’s details page with the date column you selected during tracking setup as the applied time filter.

Related topics