Sum of Revenue Squared | Community
Skip to main content
3
3638298
May 3, 2019
Solved

Sum of Revenue Squared

  • May 3, 2019
  • 2 replies
  • 2514 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Asheesh_Pandey

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

Asheesh_Pandey
Community Advisor
Asheesh_PandeyCommunity AdvisorAccepted solution
Community Advisor
May 5, 2019

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

E
emmak109
Level 3
August 10, 2023

How should we analyse this metric in Adobe Target activity?

Terms & ConditionsAccessibility statement

Loading footer...