We want to see how many times a CSM had a On Track status for a specific type of CTA and we want to see this YTD, is it possible to see this now? This is to help determine KPIs for our CSMs.
To put it a bit more clearly, the filters would be similar to this:
- Created Date = This Year
- Status = On Track
- CSM = >insert desired name here]
- Type = Tinsert desired type here]
To get the KPI, you can do a distinct count of the CTA GSID to give you the number of CTAs matching your filter criteria, and then you can add necessary fields to the drilldown as needed.
Thanks for the attempt, I used the same filters you provided but it gives me the same records for our report that shows Current On Track VOs by IM. Hopefully in the future Gainsight is able to provide reporting on this historical data.
We would benefit from a report object of Previous Status or Previous Priority.
Hey
- The simplest way would be to have a field on CTA that is “Days spent in On Track status”, where you use a Horizon Rule to bring in On Track CTAs and increment the field by +1. You’d want to likely run the rule more than once per day, but only *update* the field once per day. Or you could just run it daily, and if a CTA shows up you know it was in that status at least once during the day so you get an n+1 still.
- There’s variations of this, but you’re basically snapshotting the data, looking for “CTAs in On Track”, and then incrementing your count for any given CTA if it was in that status, and not incrementing if it wasn’t.
- It’s also important that the rule runs daily, or you would miss out.
- The actual rule build might not be simple, but conceptually less build out than the other idea
- Alternately, you can track *every time* a CTA is moved into On track status using a Real Time rule:
You would need a custom MDA where you would load a record per CTA each time it went *into* the On Track status. This would probably be the most accurate, but you could get some oddly high numbers if users for some reason change it multiple times in a day.
From here, you could build reports on this data grouping those change records by CTA, to see how many records were ever in on track status, and even how many times they moved in and out of the status.
You could also do some combination of the two, depending on what is important to you to know.
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.