Sum Rev Squared | Community
Skip to main content
E
emmak109
Level 3
August 10, 2023
Solved

Sum Rev Squared

  • August 10, 2023
  • 1 reply
  • 1357 views

After we create this calculated metric, how should we use this to analyse the numbers by variant in Adobe Target report?

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 yuhuisg

Thanks for the clarification. This is my first time hearing of "Sum Rev Squared". And I've never used this before with calculating lifts and confidences with Target experiments.

The method described at https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/sum-of-revenue-squared/td-p/317549 uses the Column Sum function. This sums up the values in a column. https://experienceleague.adobe.com/docs/analytics/components/calculated-metrics/calcmetrics-reference/cm-functions.html?lang=en#concept_391F04FBC3CC43368CA0C5AACE74D4B1

With that in mind, I suppose you could break down your Target Experience dimension by another dimension, e.g. Day, and apply the calculated metric against that to get a sum per Target Experience value. Note: I don't know if that is really the correct way to perform a proper lift/confidence calculation. I'm just suggesting it based on my understanding of the Column Sum function.

1 reply

yuhuisg
Community Advisor
yuhuisgCommunity Advisor
Community Advisor
August 14, 2023

Did you mean the Coefficient of Determination "R squared"? https://en.wikipedia.org/wiki/Coefficient_of_determination Instead of "Sum Rev Squared".

E
emmak109Author
Level 3
August 14, 2023

Nope, that is completely different from what I have asked. 

I am trying to use Adobe Sheet for analyzing standard deviations of target activities, since that is not available out of the box in Adobe Target. I used this https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/sum-of-revenue-squared/td-p/317549 to create this metric. Now when I use it in A4T reports, there is no way I can break this metric down by control and treatments groups. What is the workaround to see the numbers of this metric for both control and treatment groups? Once I have these numbers, I can use Adobe sheet to calculate standard deviations by using this metric.

yuhuisg
Community Advisor
yuhuisgCommunity AdvisorAccepted solution
Community Advisor
August 14, 2023

Thanks for the clarification. This is my first time hearing of "Sum Rev Squared". And I've never used this before with calculating lifts and confidences with Target experiments.

The method described at https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/sum-of-revenue-squared/td-p/317549 uses the Column Sum function. This sums up the values in a column. https://experienceleague.adobe.com/docs/analytics/components/calculated-metrics/calcmetrics-reference/cm-functions.html?lang=en#concept_391F04FBC3CC43368CA0C5AACE74D4B1

With that in mind, I suppose you could break down your Target Experience dimension by another dimension, e.g. Day, and apply the calculated metric against that to get a sum per Target Experience value. Note: I don't know if that is really the correct way to perform a proper lift/confidence calculation. I'm just suggesting it based on my understanding of the Column Sum function.

Terms & ConditionsAccessibility statement

Loading footer...