Skip to main content
meenal_shukla
Gainsight Employee ⭐️⭐️
Jan 27, 2021 3:12 PM UTC

Quick tip: Multiple scores and how do you know which scores applies to a customer

A customer has multiple scorecards applied at different stages (Adopting, Implementation, New Customer etc.). They want to create a rule that can copy the current score of different measures to the appropriate field in Salesforce.

Problem is that it hard to know which scorecard is currently applied to the customer. 

1. Unified Scorecard fact - company: This object holds data at the scorecard level. So for a given account, multiple scorecards might be applied at different stages and hence this object holds all the details of corresponding scorecards.

2. Company: Whereas Company object holds data for a given company and the current scorecard that is applicable for it.

Hence I have added a filter to the transformation task in the rule where it says Unified's scorecard name = company's scorecard name this will let us filter the current scorecard's measures.

@minh_phan , please consider adding this information in the documentation so that it is easily searchable.

Thanks @shivani for the help here!

4 replies

sai_ram
Expert ⭐️⭐️
Jan 28, 2021 2:55 PM UTC

@meenal_shukla Thank you for writing here. Redirected to documentation team too.

 

Translate
shantan_reddy
Gainsight Employee ⭐️
Gainsight Employee ⭐️
Jan 29, 2021 10:36 AM UTC

@meenal_shukla you can use the is_active flag in unified scorecard fact to filter for records from only the current scorecard.

Translate
meenal_shukla
Gainsight Employee ⭐️⭐️
Jan 29, 2021 5:52 PM UTC

What happens if more than one scorecard are active though? I was getting multiple rows for different scores if I did not add that filter.

Translate
Outplay. Outwit. Outlast.
shantan_reddy
Gainsight Employee ⭐️
Gainsight Employee ⭐️
Feb 1, 2021 6:53 AM UTC

For a particular account, there can only be once active scorecard at a given point in time. When you use this filter, the corresponding scorecard for the account is shown.

 

Regards,

Shantan

Translate