DATA FOR ROI ANALISYS

image-20210427102234920

To analyze the contribution of different initiatives to the change of total ROI you should modify your dataset as follows:

  • Set the quantity/volume column equal to the investment value of each element.
  • Set the cost/revenue column equal to the return of the investment in amount
  • If the return of the investment is the sum of different revenue and cost flows, add a dimension column called "Metrics" with the names of the different flows. In the cost/revenue column, return flows should be positive, cost flows negative
  • If the return of the investment is the sum of different revenue and cost flows, in the the quantity/volume column you should repeat the value of the investment of each initiative for all the rows that pertain to that initiative.