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  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  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)))) Calculated Metrics ScreenShot: 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

2 Replies  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)))) Calculated Metrics ScreenShot: 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  Level 3

How should we analyse this metric in Adobe Target activity? 