Expand my Community achievements bar.

Check out the November edition of the Analytics Community Lens newsletter to see what's been trending in the last two months!
SOLVED

Sum of Revenue Squared

Avatar

Level 1

Performing some offline A/B confidence testing using calculated measures.  Therefore, can't use Target lift and confidence.

Found an Excel calculator that uses Sum of Revenue Squared as an input.  Is there a way to use calculated measures to create Sum of Revenue Squared?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

Yes! we can certainly get this in calculated metrics.

Calculated metrics for Variance A -

Summary:

fx (column sum ( fx ( Power operator (metric_X (Revenue) metric_Y (2))))

1746985_pastedImage_40.png

Calculated Metrics ScreenShot:

1746984_pastedImage_35.png

Note: You may need to apply a segment on top of it get Sum of Revenue for Variance A. only if using segment for Variance A Total Revenue and Variance A number of Uniques.

Thanks,

Asheesh

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi,

Yes! we can certainly get this in calculated metrics.

Calculated metrics for Variance A -

Summary:

fx (column sum ( fx ( Power operator (metric_X (Revenue) metric_Y (2))))

1746985_pastedImage_40.png

Calculated Metrics ScreenShot:

1746984_pastedImage_35.png

Note: You may need to apply a segment on top of it get Sum of Revenue for Variance A. only if using segment for Variance A Total Revenue and Variance A number of Uniques.

Thanks,

Asheesh

Avatar

Level 3

How should we analyse this metric in Adobe Target activity?