Skip to main content

Example 4 - Optimizer calculated on discount percentage

Zuora

Example 4 - Optimizer calculated on discount percentage

In this example, the Optimizer Scale field is 0.5  the SSP Band Calc On field is DISC_PCT in the SSP Analyzer template. The Low/Floor% field is 15 and the High/Ceiling% field is 15.

The SSP Analyzer will do the calculations in the following order to derive SSP%.

1. Build the test buckets based on the SSP Band Calc Type field in the SSP Analyzer template.

  • If the SSP Band Calc Type field is PERCENT, use the following formulas:

Low Band% =100 - (100- Median%) * (100 + Low/Floor %)/100

High Band%= 100 - (100 - Median%) * (100 - High/Ceiling% )/100

For example,

Bucket#

Median%

Low Band%

High Band%

1

0

-15.00

15.00

2

0.5

-14.43

15.43

3

1

-13.85

15.85

4

1.5

-13.28

16.28

5

2

-12.70

16.70

6

2.5

-12.13

17.13

  • If the SSP Band Calc Type field is ABSOLUTE, use the following formulas:

Low Band% = Median% - Low/Floor %

High Band%= Median% + High/Ceiling%

For example,

Bucket#

Median%

Low Band%

High Band%

1

0

-15.00

15.00

2

0.5

-14.50

15.50

3

1

-14.00

16.00

4

1.5

-13.50

16.50

33

16

1.00

31.00

34

16.5

1.50

31.50

35

17

2.00

32.00

36

17.5

2.50

32.50

3. Count the number of transactions whose Discount% falls into the range of each test bucket.

In this example, the number of transactions for each bucket is as follows:

Bucket#

Median%

Low Band%

High Band%

Number of Transactions

112

55.50

47.18

63.83

401

113

56.00

47.60

64.40

399

114

56.50

48.03

64.98

400

115

57.00

48.45

65.55

472

116

57.50

48.88

66.13

472

117

58.00

49.30

66.70

472

118

58.05

49.73

67.28

470

4. Identify the bucket with the largest number of transactions.

In this example, buckets 115, 116, and 117 are identified.

5. Calculate Median SSP Discount% based on the following formula by using the transaction data in the identified buckets. (It is supposed the ENABLE_MULTI_PEAK_CALC profile is set to Y.)

Median SSP Discount% = (Bucket From Low Band% + Bucket To High Band%)/2

In this example, 3 buckets are identified. The From value of bucket 115 and the To value of bucket 117 are used.

Median SSP Discount% = (48.45 + 66.70)/2 = 57.58

6. Calculate Low Band SSP Discount% based on the following formula.

Low Band SSP Discount% = Median SSP Discount% - (Low/Floor% * ( 100 – Median SSP Discount%)/100)

In this example, the Low Band SSP Discount% is 51.22.

57.58 - (15 * (100 - 57.58)/100) = 51.22

7. Calculate the High Band SSP Discount% based on the following formula.

High Band SSP Discount% = Median SSP Discount% + (Low/Floor% * ( 100 – Median SSP Discount%)/100)

In this example, the High Band SSP Discount% is 63.94.

57.58 + (15 * (100 - 57.58)/100) = 63.94

8. Determine whether the Discount% of each transaction is compliant within the SSP Discount% range.

In this example, if the Discount% of a transaction is within this range (51.22 ~ 63.94), this transaction is marked as compliant by the Analyzer; otherwise, the transaction is incompliant.

9. Calculate the compliance percentage.

The actual compliance percentage can be calculated by the following formula and then compared to the Compliance% value specified in the SSP Analyzer template or SSP batch.

Compliance Percentage = (Total number of compliant transactions/Total number of transactions) * 100