Any best practices or suggestions for tracking the value of individual products sold for won opportunities when most deals include a package of different products?
Context:
- we have about 20 products, in 5 different product categories
- the products themselves don't change very often, but the prices for each product may change in a given deal
- our business is content-driven, so the products are things like "article" or "video" or "infographic" - although not sure that matters.
- we have all these products in the Product section of the CRM and reps, when they close a deal, add the appropriate products to the Opportunity record
The issue is that most deals have multiple products. They way we're tracking this captures the fact that the product was included in the deal, but not how many of the product was sold or what the cost breakdown was.
So, if I run a report, I can see: Client, Opportunity, $123,456, Product Category 1, Product X, Product Category 2, Product Y
What I want is to see is, for a given deal, which products were sold, how many of each were sold and what the breakdown of the deal value is between the products.
I'm just not sure of the best way to do this and I'm very concerned about creating too much of an admin burden on my sales team. However, it's unacceptable to the business right now that I can't say, "we made $X on Product Category 1 and $Y on Product Category 2" because our current system doesn't capture enough detailed revenue data.
Any ideas on how to set this up to capture what we need for the least effort/input required by reps?