Level 1

0% to

Level 2

Tip /

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

View all

## Offline analysis A/B test - sum of revenue squared

larav34689834
Level 1

Likes

4 likes

Total Posts

4 posts

0 solutions
View profile

larav34689834
Level 1

Likes

4 likes

Total Posts

4 posts

0 solutions
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)

Amelia_Waliany
Employee

Likes

182 likes

Total Posts

440 posts

72 solutions
View profile

Amelia_Waliany
Employee

Likes

182 likes

Total Posts

440 posts

72 solutions
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!

melissag7357285
Level 2

Likes

23 likes

Total Posts

2 posts

0 solutions
View profile

melissag7357285
Level 2

Likes

23 likes

Total Posts

2 posts

0 solutions
View profile
melissag7357285
Level 2

16-07-2019

How do you do this in Workspace?

cainej77377828
Level 1

Like

1 like

Total Posts

2 posts

0 solutions
View profile

cainej77377828
Level 1

Like

1 like

Total Posts

2 posts

0 solutions
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

larav34689834
Level 1

Likes

4 likes

Total Posts

4 posts

0 solutions
View profile

larav34689834
Level 1

Likes

4 likes

Total Posts

4 posts

0 solutions