Expand my Community achievements bar.

Announcement: Calling all learners and mentors! Applications are now open for the Adobe Analytics 2024 Mentorship Program! Come learn from the best to prepare for an official certification in Adobe Analytics.
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?