Skip to main content
karenadornetti
Contributor ⭐️⭐️⭐️
Dec 20, 2023 6:22 PM UTC
Question

CTA for overall health score drop

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 ⭐️⭐️
Dec 21, 2023 3:16 PM UTC

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

Translate
Sr. Customer Success Operations Analyst/Gainsight Admin/Data Nerd
Expert ⭐️
Dec 22, 2023 10:24 PM UTC

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.

Translate