Solved

Updating historical scorecard data

  • 6 January 2021
  • 5 replies
  • 199 views

Badge

Context

  • We currently have various scorecards set up, all of which are snapshotted weekly
  • Almost all of our metrics that input into scorecards are product usage metrics
  • Our product usage data comes from Snowflake via Data Designer (we have a design set up with the Snowflake connector that pulls data in every night and persists it as an MDA object - we then write rules off this object to set scores)

Question

  • Is it possible to update historical scorecard data?

Example / More details 

  • Let’s take an account and imagine we have 3 snapshot scores:
  • We see that the customer was on 65 for 2 weeks then went up to 90 this week
  • But lets say, for whatever reason, on the 28th our Snowflake Data Design broke and actually the metrics we pulled in were wrong
  • As a result, the score worked out by Gainsight was wrong - it says 65 but it should be 90
  • Further, let’s imagine that we fix the Snowflake issue and update all our historical usage data today

Is it possible for me to tell Gainsight to look back on historical scores and recalculate now that the usage data has been corrected? Or will the score on the 28/12 have to remain as it is?

 

Hope that makes sense! Thanks

icon

Best answer by Anonymous 6 January 2021, 19:36

View original

5 replies

Hi Isaac,

 

Is it possible to update historical scorecard data?

  • Yes, once the data in your source object is corrected, you can create a rule to load historic data to your scorecard history object.
  • Once your measure level data is updated using the rule, the historic overall score is recalculated based on the new score.

Here is the document that’ll help you in creating this rule.

https://support.gainsight.com/Gainsight_NXT/03Rules_Engine/03Set_Up_Rule_Action_Types/Load_to_Scorecard_History_Action_Type

Badge

Hey @syed_altamash , thanks for the response! 

 

Just to check that I understand correctly, if e.g. 5 measures were wrong, we’d create 5 rules (or have 5 actions in 1 rule) to update the history for all 5?

@Isaac Rahman 

 

Having the 5 actions in 1 rule would be the right approach instead of having 5 different rules.

Userlevel 7
Badge +3

@sai_ram can we have the documentation updated to reflect the second point in @syed_altamash’s note above:

 

  • Once your measure level data is updated using the rule, the historic overall score is recalculated based on the new score.
Userlevel 7
Badge +1

@sai_ram can we have the documentation updated to reflect the second point in @syed_altamash’s note above:

 

  • Once your measure level data is updated using the rule, the historic overall score is recalculated based on the new score.

@darkknight thanks, redirected. 

Reply