/
Average Invoice Price per Customer Revenue Class Last 12M

Average Invoice Price per Customer Revenue Class Last 12M

  • (1) = Invoice Price of Product / Qty of Product (per customer Last 12M)
    -> In CI_AggregatedData (Customer Insights Aggregated Data Data Source), this field is called “Product Avg Price By Customer“ (ProductAvgPriceByCustomer)

  • (2) = (1) of Product Y of all customers in class A / Number of customers in class A that have product Y
    Do the same with class B, C , D.

  • (6) Overall per product = Average { (2),(3),(4),(5) }