Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 1st edition of the Target Community Lens newsletter is out now! Click to the right to find all the latest updates
SOLVED

Offline analysis A/B test - sum of revenue squared

Avatar

Level 2

I downloaded the Excel file from adobe that contains detailed calculations for the analysis of offers when conducting an A/B test (or other tests).

There are three parts: conversion rate calculations, revenue per visitor, and average order value calculations.

For the revenue per visitor calculation, the "Sum Rev Squared" is required.

I can't find a detailed explanation of how this number is calculated.

Am I correct if I take the revenue per visitor, then square this, and take the sum of all visitors?

I assume this value can only be calculated if you have the revenue for each visitor being a part of the offer.

I don't have a way to verify is my calculations are correct or not. It would be great if someone can confirm this or give a correct calculation for this.

Kind regards

1 Accepted Solution

Avatar

Correct answer by
Administrator

Hi there and thanks for your question! Below is a basic breakdown:

*Experience A*

```Person A: buys 3 products for a total of $15

Person B: buys 1 product for a total of $100

Person C: buys 9 products for a total of $235```

*Experience B*

```Person 😧 buys 1 product for a total of $150

Person E: buys 3 products for a total of $78

Person F: buys 2 products for a total of $12```

The math is:

Sum of Rev Squared for A:

```(15^2) + (100^2) + (235^2) = 65,450```

Sum of Rev Squared for B:

```(150^2) + (78^2) + (12^2) = 28,728```

Hope this helps!

View solution in original post

4 Replies

Avatar

Correct answer by
Administrator

Hi there and thanks for your question! Below is a basic breakdown:

*Experience A*

```Person A: buys 3 products for a total of $15

Person B: buys 1 product for a total of $100

Person C: buys 9 products for a total of $235```

*Experience B*

```Person 😧 buys 1 product for a total of $150

Person E: buys 3 products for a total of $78

Person F: buys 2 products for a total of $12```

The math is:

Sum of Rev Squared for A:

```(15^2) + (100^2) + (235^2) = 65,450```

Sum of Rev Squared for B:

```(150^2) + (78^2) + (12^2) = 28,728```

Hope this helps!

Avatar

Level 2

Hi Amelia,

Thanks a lot for this clear answer, it really helps me !

Kind regards,

Lara

Avatar

Level 1

Hi -

Is there a way to quickly create the sum of revenue squared as a calculated measure?  Measuring confidence on calculated measures, so getting access to the data to preform this function in Excel - is proving difficult.

Thanks

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now