Skip to main content
Gainsight Inc.

Use Scorecard 2.0 Data in Rules and Reports

This article is the fifth item in a series of Scorecard 2.0 configuration articles. Gainsight recommends you to refer the initial articles of the series and then start with this article.

This article explains how an admin can use Scorecard data in Rules Engine and Reporting. Scorecards in Rules Engine allow you to extract relevant Scorecard data and then perform required actions on the segmented data. Scorecard Reports allow you to extract required data and visualize it in the various graphical formats, thus facilitating you to make quick decisions. Users can also edit Scorecards from a Mass edit report.

Use Scorecards in Rules Engine

This section demonstrates a scenario to use Scorecard data in Rules Engine. When a Customer’s score decreases, a new CTA is created to intimate the CSM about the same.  

Create Rule

  1. Navigate to Administration > Operations > Rules Engine.

  2. Click + RULE. The New Rule window is displayed.

  3. Select Account or Relationship option from the Rule For field.

  4. Enter a name in the Rule Name field.

  5. (optional) Enter a description in the Description field.

  6. Click NEXT.

Use Scorecards.png

Create Dataset

  1. Click DATASET.

  2. Enter a name in the Task Name field.

  3. Select Company as the Source Dataset.

Use Scorecards1.png

  1. Drag and drop the following fields to the Show section:

  • Name

  • GSID

  • Current Score -> Score

  • Previous Score -> Score

Showme fields.png

Note: If you wish to create the CTA only for selected customers, you can add filters accordingly.

  1. Click SAVE.

  2. Click <-.

Create Transformation Task

  1. Click + TASK and select Transformation.

  2. Enter a name for the Transformation task.

  3. Select your source dataset from the drop down menu.

Transformation task.gif

  1. Drag and drop GSID field and Numeric Expression formula field to the Show section.

Numeric expression.gif

  1. Perform the actions as shown in the following image.

Configure numeric expression.gif

A new field called Decreased Score is created. This field stores negative values if the Current Score is less than the Previous Score. This field can be used in the Criteria section of the Create CTA Action type.

Create Rule Action

  1. Click SAVE.

  2. Click Setup Action.

  3. Click + ACTION and select Transformation Task.

  4. Select Call to Action 2.0 as the Action Type.

Scorecard rule.gif

  1. Enter the details for the new CTA.

Create CTA.png

  1. Click + CRITERIA, in the Criteria section.

  2. Set the criteria to evaluate if Decreased Score field has a negative value, as shown in the image below (after step 8).

  3. Click SAVE.

Advanced logic.gif

This rule uses Scorecard data and creates a CTA whenever there is a drop in Customer Health score.

Use Scorecards in Reporting

This section demonstrates how you can use the Scorecard data in reporting. In this section, a report is created for one of the Scorecard.

Types of Scorecard Reports

You can create two types of Reports in a Scorecard:

  1. Standard Report: A Standard report is similar to other report types. It is a view only report, and you cannot edit any data on it. You can create a Scorecard Fact object or Scorecard history object. The Standard report does not display the colors associated with a Score.

Scorecard_report.png

  1. Mass Edit Report: A Scorecard Mass edit report is a Custom report which is designed to allow admins to modify scores. Admins can create a report on all measures and edit the required measures. For more information about the Mass Edit Report, refer the Edit a Scorecard with Mass Edit Report article. The Scorecard Mass Edit report displays Colors associated with scores. However, when you export the Mass edit report, the colors associated with scores are not present in the exported file.  

Objects used in Scorecard Report

The two most important objects used in Scorecard reporting are:

  1. Scorecard Fact Object: A Scorecards Fact object is automatically created when you create a new Scorecard. Every Account or Relationship Scorecard has a corresponding fact Object. This object mainly stores two important fields. Current Score and Previous Score. The Current Score is the latest score which is visible to CSMs on the C360/R360 page. The Score which existed before the Current Score is called the Previous Score. Scorecard Standard and Mass edit report are applicable only when you select Scorecard Fact as the source Object.

  2. Scorecard History Object: As the name suggests, the Scorecard History object holds historical scores for all the Scorecards. There exists only one history object for all the Company Scorecards, regardless of the presence of the multiple scorecards and one for all the Relationship Scorecards. The history Object maintains scores for each week and month. When the Scorecard scheduler runs, the score for the current week is updated. This happens up to the end of the week, and at the end of the week, the score is frozen, for that week. This finalized score is the weekly Snapshot score for that week. Similarly, monthly snapshot is taken at the end of every month and stored in this Object. For more information about Scorecard Snapshot, refer the Scorecard Snapshot article.

Create Standard Scorecard Report

  1. Navigate to Administration > Analytics > Report Builder.

  2. Click + REPORT.

  3. Enter a name for the Report.

  4. Select a Scorecard fact object.

When you select the Scorecard Fact object, you can see that a new dropdown menu is displayed on the top right corner. This menu allows you to select a Standard or Mass Edit report.

Select standard report.gif

  1. Include the following fields in the Show me section.

  • Company -> Name

  • Current Score

  • Label (for Current Score)

  • Previous Score

  • Label (for Previous Score)

Show me sections.gif

  1. (Optional) Modify the field names as shown in the below image.

Chnage names of show me fields.gif

 

  1. In the Filter section:

    1. Select the Measure Id -> Name field.

    2. Select the Contains operator

    3. Type the Overall Score (Account)

Report filtwr.gif

  1. Click RUN.

Report result.png

 

  • Was this article helpful?