Tutorial: Trigger CTA Based on Health Score Change
This tutorial walks you through the process of creating a rule that triggers a CTA based on a change in a Scorecard measure.
The data of Scorecards 1.0 is stored in the Usage Data object. For this tutorial, we will use Usage Data as the source object for tracking the scores. The Habits Score field in this object is used for current (latest) scores. A custom field Habits Score Last Month is created for the purposes of this tutorial so that past scores (specifically a month before) can be stored.
Two rules are created in this tutorial:
- In the first rule, we will map the Habits Score field with Habits Score Last Month (custom field) so that past scores are stored.
- In the second rule, both the score fields (Habits Score and Habits Score Last Month) are searched for scores that were 80 (or above) and dropped to 30 (or below).
Habits Score = This measure is based on the customer’s Gainsight usage.
Habits Score Last Month = A custom field called Habits Score Last Month is created on the Usage Data object in SFDC. The Habits Score field in the Usage Object will be used for current scores. The Week Label field in Usage Data is used to get the week data in which the score was set.
Assumptions
This tutorial is created using Account Scorecards (1.0). The data from Account Scorecards is stored in the Usage Data object.
Create a Rule to store past scores
Follow these steps to store past scores in the Habits Score Last Month field.
- Create a custom rule with Usage Data as the source object.
- Add the following fields to the Show me section
- Account
- Account Name
- Habits Score
- Week Label
- Habits Score Last Month
- Date
- In the Filters section, configure the following filters, these look for data within a range of a month.
- Week Label greater than or equal to Subtract 35 days from Rule Date.
- Week Label less than Subtract 28 days from Rule Date.
- Set the Advanced Logic to A AND B.
- Click NEXT. The Setup Action screen appears.
- Select Load to Usage as the Action Type and map the following fields:
- Account with Account
- Account Name with None
- Habits Score with Habits Score Last Month. This is to store past scores in this field.
- Week Label with Week Label
- Habits Score Last Month with None
- Date with Date.
- Schedule and run the rule. This rule needs to be run before the second rule (to trigger CTAs, so that the custom field Habits Score Last Month has scores).
Rule to trigger CTAs
In this rule, we will use the Habits Score Last Month field (which is loaded with the score of the previous month) and also use the Habits Score (current score) field and look for scores that were 80 (or above) and dropped to 30 (or below) - Green and dropped to Red. After filtering the scores, the rule will create CTAs for these accounts.
- Create a custom rule with Usage Data as the source object.
- Add the following fields to the Show me section:
- Account
- Habits Score
- Company
- Week Label
- Habits Score Last Month
- Date
- In the Filters section, add the following:
- Habits Score Last Month greater than or equal to 80.
- Status equals to Active.
- Habits Score less than or equal to 30
- Week Label equals First Day of Previous Week.
- Set the advanced logic to A AND B AND C AND D.
- Click NEXT. The Setup Action screen appears.
- Select Load to Usage as the Action Type and map the following fields:
- Account with Account
- Account Name with None
- Habits Score with Habits Score Last Month. This is to store past scores in this field for comparison.
- Week Label with Week Label
- Habits Score Last Month with None
- Date with Date.
- Schedule and run the rule. This rule needs to be run after the first rule (rule to store past scores) is run so that the Habits Score Last Month field will have scores of the previous month.