I am trying to fix some reporting issues we’re seeing regarding our CSM’s and their accounts. For example, Account1 has 2 CSM’s assigned to it because CSM1 deals with product1 and CSM2 deals with product2. The ACV for product1 is $100k but the ACV for product2 is $200k. In the reports for CSM’s total ACV, we are seeing all the ACV assigned to CSM1. Account1 doesn’t even show up on the list of customers in the report for CSM2.
There are separate opportunities with their names assigned and correct ACV for their products in Account1’s gainsight C360.
Is there a way I can separate these two opportunities to show what I actually want in the report?
Please let me know if you need more specifics but this would be so helpful in fixing these reports.