When calculating something like standard deviation and z-score for a customer's usage, I would like compare their most recent usage to their usage historically– for things like health score and CTAs.
If I can calculate a customer's average usage for the past X number of weeks and standard deviation for the distribution and weekly usage, I can compare the most recent week's usage to their historical average and know how significant the delta is for that customer.
The reason I would want to do this on a per-customer basis as opposed to calculating the stdev across all customers, is that we have (as I would imagine is the same as a lot of Gainsight customers) such a wide-range of usage patterns across customers. And I wouldn't necessarily want to compare, for instance, low-tier customer's usage against the aggregated average and stdev of all customers.
What's helpful to know, is "is a customer's most recent usage, in-line with what they usually do?" and if not, how significant is the change– positive or negative both good to know.
We do calculate stdev and z-score currently for some of our customers of product lines that we've had in Gainsight for a long time, but as we've added new product lines to our instance I thought I had a shorter route to getting this data with the new stat formulas available. Without being able to use GroupBy in conjunction with the stdev formula, there's just a bunch of additional steps needed to get to this.
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 firstname.lastname@example.org and we'll help you get started from where you left.
Else, please continue with the registration below.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.