I assumed you wanted to understand the calculations (although it is not clear from your question).
1. 10 million (1 crore) impressions, leading to 4,800 checkout completions - I arrived at this by multiplying all the baseline percentages (2%, 10%, 40% and 60%). At an AOV of Rs 1,000, the total value is Rs 48,00,000.
2. The first lever has an upside of 24,00,000 - this is arrived by taking click through rate of ads from 2% to 3%, which essentially is 1.5x sessions (assuming all other funnel metrics remain the same). With 1.5x sessions, you get 1.5x revenue, thereby the upside is 0.5x of Rs 48,00,000 = Rs 24,00,000.
This can be applied to other line items in the table to calculate upside.
Could you please elaborate upon the calculation of upside (in the table above)
I assumed you wanted to understand the calculations (although it is not clear from your question).
1. 10 million (1 crore) impressions, leading to 4,800 checkout completions - I arrived at this by multiplying all the baseline percentages (2%, 10%, 40% and 60%). At an AOV of Rs 1,000, the total value is Rs 48,00,000.
2. The first lever has an upside of 24,00,000 - this is arrived by taking click through rate of ads from 2% to 3%, which essentially is 1.5x sessions (assuming all other funnel metrics remain the same). With 1.5x sessions, you get 1.5x revenue, thereby the upside is 0.5x of Rs 48,00,000 = Rs 24,00,000.
This can be applied to other line items in the table to calculate upside.