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
BedrockMission!

Learn More

View all

Sign in to view all badges

Offline analysis A/B test - sum of revenue squared

Avatar

Avatar
Validate 1
Level 1
larav34689834
Level 1

Likes

4 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 1
larav34689834
Level 1

Likes

4 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile
larav34689834
Level 1

14-03-2018

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 250
Employee
Amelia_Waliany
Employee

Likes

191 likes

Total Posts

452 posts

Correct Reply

73 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile

Avatar
Validate 250
Employee
Amelia_Waliany
Employee

Likes

191 likes

Total Posts

452 posts

Correct Reply

73 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile
Amelia_Waliany
Employee

24-04-2018

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!

Answers (3)

Answers (3)

Avatar

Avatar
Boost 5
Level 2
melissag7357285
Level 2

Likes

23 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 2
melissag7357285
Level 2

Likes

23 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
View profile
melissag7357285
Level 2

16-07-2019

How do you do this in Workspace?

Avatar

Avatar
Boost 1
Level 1
cainej77377828
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
cainej77377828
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
cainej77377828
Level 1

06-05-2019

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

Avatar

Avatar
Validate 1
Level 1
larav34689834
Level 1

Likes

4 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 1
larav34689834
Level 1

Likes

4 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile
larav34689834
Level 1

24-04-2018

Hi Amelia,

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

Kind regards,

Lara