Issue with calculated metrics

Hi Kamal,

Standard metric attribution for the Site Content> Pages report is linear therefore (see reference info linked below) even though it appears the Orders metric is 0 in the report it actually is a small fraction. Therefore when the calculation is made you have a very high # (Revenue) divided by a fraction (.10 fraction values of Orders for example) which produces a very high 'non-sensical' value. You can verify yourself by creating a calculated metric for orders that allows for decimal places. If it were the case that the Orders metric was truly zero than your calculated metric value would be an error DIV/O since you cannot divide a number by zero.

What analysis question are you trying to evaluate Site Content> Pages? My main question would be what is the intent behind using AOV against linear allocation metrics within the pages report? Since linear allocation is variable depending on the count of pages within a given visitors conversion visit it is very likely not what you are looking to review.

Reference Link:

https://marketing.adobe.com/resources/help/en_US/reference/metrics_calculations.html

When linear allocation is selected, success events are evenly divided across all variable values seen in the visit. For numeric and currency events such as Revenue, the monetary amount is divided. For counter events such as Orders, a fraction of the event is awarded to each variable value in the visit. These fractions in reporting are summed, then rounded to the nearest integer in reporting.

For example, in a visit where four pages are visited prior to a success event, each page would receive credit for 25% of the event. If, in the same visit, campaign had two values, each campaign value would receive 50% of the credit for the event.

Best,

Brian