calculating % uplift

[bsnapool]

Hi,

wondering if anyone could help me out on this... I wanting to calculate an uplift in demand based on a few measures. These being conversion rate, AOV and sales.

If I have a conversion rate of 14.15% for one period and 14.79% (difference is 0.64) how can i calculate uplift in demand on the 0.64.

I would like an automated way excel document to add the conversion rates-orders and AOV to calulate the uplift.

Any ideas?

Any help appreciated

 

[Andrew Poulsom]

If Visits and AOV had remained constant:

=((E3-E2)/E2)*C2*F2

which returns £6,444.33 additional sales.

 

[bsnapool]

=(154210 - 142386) / (8474 - 7748) = $16.29 per additional visit

is this a true reflection on the conversion uplift?

 

[bsnapool]

If Visits and AOV had remained constant:

=((E3-E2)/E2)*C2*F2

which returns £6,444.33 additional sales.

This sounds like a reasonable calculation... I'll have a mess a round and feedback. Thanks for the replies. Much appreciated

 

[bsnapool]

If Visits and AOV had remained constant:

=((E3-E2)/E2)*C2*F2

which returns £6,444.33 additional sales.

Andrew, for some reason im not getting the same value as you...
A B C D E
Page visits Orders Sales Conversion Rate AOV Incremntal demand generated
1 A 7,748 1,096 £142,386.06 14.15% $130
2 B 8,474 1,253 £154,210.72 14.79% $123

Im getting 6,450.33

 

[Andrew Poulsom]

I just copied your data from the Board, with the precision displayed. Your result is returned if there are formulas in columns E and F. In E2:

=C2/B2

and F2:

=D2/C2

copied down.