topic Re: Offline analysis A/B test - sum of revenue squared in Adobe Target Questions
https://experienceleaguecommunities.adobe.com/t5/adobe-target-questions/offline-analysis-a-b-test-sum-of-revenue-squared/m-p/302470#M4489
<HTML><HEAD></HEAD><BODY><P>Hi Amelia, </P><P></P><P>Thanks a lot for this clear answer, it really helps me ! </P><P></P><P>Kind regards, </P><P>Lara</P></BODY></HTML>Wed, 25 Apr 2018 06:26:29 GMTlarav346898342018-04-25T06:26:29ZOffline analysis A/B test - sum of revenue squared
https://experienceleaguecommunities.adobe.com/t5/adobe-target-questions/offline-analysis-a-b-test-sum-of-revenue-squared/m-p/302468#M4487
<HTML><HEAD></HEAD><BODY><P>I downloaded the Excel file from adobe that contains detailed calculations for the analysis of offers when conducting an A/B test (or other tests). </P><P>There are three parts: conversion rate calculations, revenue per visitor, and average order value calculations.</P><P>For the revenue per visitor calculation, the "Sum Rev Squared" is required.</P><P></P><P>I can't find a detailed explanation of how this number is calculated.</P><P>Am I correct if I take the revenue per visitor, then square this, and take the sum of all visitors?</P><P>I assume this value can only be calculated if you have the revenue for each visitor being a part of the offer.</P><P></P><P>I don't have a way to verify is my calculations are correct or not. It would be great if someone can confirm this or give a correct calculation for this.</P><P></P><P>Kind regards</P></BODY></HTML>Wed, 14 Mar 2018 12:19:36 GMThttps://experienceleaguecommunities.adobe.com/t5/adobe-target-questions/offline-analysis-a-b-test-sum-of-revenue-squared/m-p/302468#M4487larav346898342018-03-14T12:19:36ZRe: Offline analysis A/B test - sum of revenue squared
https://experienceleaguecommunities.adobe.com/t5/adobe-target-questions/offline-analysis-a-b-test-sum-of-revenue-squared/m-p/302469#M4488
<HTML><HEAD></HEAD><BODY><P>Hi there and thanks for your question! Below is a basic breakdown: </P><P></P><P><STRONG>*Experience A*</STRONG></P><P>```Person A: buys 3 products for a total of $15</P><P>Person B: buys 1 product for a total of $100</P><P>Person C: buys 9 products for a total of $235```</P><P></P><P><STRONG>*Experience B*</STRONG></P><P>```Person <span class="lia-unicode-emoji" title=":anguished_face:">ðŸ˜§</span> buys 1 product for a total of $150</P><P>Person E: buys 3 products for a total of $78</P><P>Person F: buys 2 products for a total of $12```</P><P></P><P><SPAN style="text-decoration: underline;"><STRONG>The math is: </STRONG></SPAN></P><P><STRONG>Sum of Rev Squared for A:</STRONG></P><P>```(15^2) + (100^2) + (235^2) = 65,450```</P><P><STRONG>Sum of Rev Squared for B:</STRONG></P><P>```(150^2) + (78^2) + (12^2) = 28,728```</P><P></P><P>Hope this helps!</P></BODY></HTML>Tue, 24 Apr 2018 23:01:13 GMThttps://experienceleaguecommunities.adobe.com/t5/adobe-target-questions/offline-analysis-a-b-test-sum-of-revenue-squared/m-p/302469#M4488Amelia_Waliany2018-04-24T23:01:13ZRe: Offline analysis A/B test - sum of revenue squared
https://experienceleaguecommunities.adobe.com/t5/adobe-target-questions/offline-analysis-a-b-test-sum-of-revenue-squared/m-p/302470#M4489
<HTML><HEAD></HEAD><BODY><P>Hi Amelia, </P><P></P><P>Thanks a lot for this clear answer, it really helps me ! </P><P></P><P>Kind regards, </P><P>Lara</P></BODY></HTML>Wed, 25 Apr 2018 06:26:29 GMThttps://experienceleaguecommunities.adobe.com/t5/adobe-target-questions/offline-analysis-a-b-test-sum-of-revenue-squared/m-p/302470#M4489larav346898342018-04-25T06:26:29ZRe: Offline analysis A/B test - sum of revenue squared
https://experienceleaguecommunities.adobe.com/t5/adobe-target-questions/offline-analysis-a-b-test-sum-of-revenue-squared/m-p/302471#M4490
<HTML><HEAD></HEAD><BODY><P>Hi -</P><P></P><P>Is there a way to quickly create the sum of revenue squared as a calculated measure? Measuring confidence on calculated measures, so getting access to the data to preform this function in Excel - is proving difficult.</P><P></P><P>Thanks</P></BODY></HTML>Mon, 06 May 2019 14:14:18 GMThttps://experienceleaguecommunities.adobe.com/t5/adobe-target-questions/offline-analysis-a-b-test-sum-of-revenue-squared/m-p/302471#M4490cainej773778282019-05-06T14:14:18ZRe: Offline analysis A/B test - sum of revenue squared
https://experienceleaguecommunities.adobe.com/t5/adobe-target-questions/offline-analysis-a-b-test-sum-of-revenue-squared/m-p/302472#M4491
<HTML><HEAD></HEAD><BODY><P>How do you do this in Workspace? </P></BODY></HTML>Tue, 16 Jul 2019 15:18:04 GMThttps://experienceleaguecommunities.adobe.com/t5/adobe-target-questions/offline-analysis-a-b-test-sum-of-revenue-squared/m-p/302472#M4491melissag73572852019-07-16T15:18:04Z