Skip to main content
karenadornetti
Contributor ⭐️⭐️⭐️
December 20, 2023
Question

CTA for overall health score drop

  • December 20, 2023
  • 2 replies
  • 72 views

I want to create a CTA when the overall healthscore drops but want it to be off of the weekly snapshot not a daily change.  I believe daily I can get from Company → Previous Score and Company → Current Score but I am not sure which object is best for the weekly snapshot drop.

2 replies

keith_mattes
Helper ⭐️⭐️
December 21, 2023

Account Scorecard History object should have the weekly values.  Hope that helps!!

Sr. Customer Success Operations Analyst/Gainsight Admin/Data Nerd
Expert ⭐️
December 22, 2023

There is a time granularity field on the history object you need to filter for WEEKLY. 

 

Other than that should be straight forward, date = Last Week. Then a separate fetch from the fact object to get current score. Merge and filter.