Healthscore Trending Report

It looks like the images you included in your original response is no longer showing. I too am interested in producing a report that shows the overall score for an account by week. This can be found on the C360 section, but is there a report type and way to produce a report that lists each account and the score for each week that has been captured? Essentially a list view of the trend graph shown on the C360?

@jessica_owens We will bump up the priority for this, and will work on it in the near-term. It will most likely be available next quarter.

Regards,

Shantan

@shantan_reddy thanks for the update on this. I look forward to this report becoming available.

So I can set expectations internally while we await this report. The C360 trend report for the overall score shows 18 weeks of data. Is that all that the system holds (last 18 weeks) or does it store all previous week’s data, but only reflects the last 18 weeks in that trend report on the C360.

The reason I ask is that as we wait for this report to become available and the system only stores the last 18 weeks of data, we could lose access to some of the data points reported for Q4 2020. Make sense?

@jessica_owens We store a weekly snapshot of your scorecard data for the entire period from launch.

Also, if all you are interested is in the weekly snapshot in a tabular form, you can already do it by building a report on the scorecard history object for accounts/relationships. Do let me know if this solves your use-case.

Regards,

Shantan

@shantan_reddy that is what I’m looking for, but I’m not getting the expected result.

I want a table view report that for each week of the period (Q4 2020 for example) lists the following: customer name, snapshot date and the overall score of that snapshot date. I built a report off of the Account Scorecard History and it’s showing the CURRENT overall score for all snapshot dates, not the overall score from the particular snapshot date.

Below is the report I have configured, can you recommend any changes that would provide the correct result?

@jessica_owens This should work. It’s strange that current score is being shown for all snapshot dates.

 @silpa1234 Any inputs here?

Regards,

Shantan

Using data designer I created a report that compares the current healthscore of a customer with what it was 60 days ago and displays the info in a bubble chart (filtering out scores that didn’t really change very much). It updates every week so its a quick way to see which accounts have significantly moved in one direction or the other: 

@jlicciardello - that’s a great idea for a different project. Thank you for sharing that!

@shantan_reddy and @silpa1234 - I’m looking at doing a scorecard analysis and comparing the customer’s overall healthscore at the time that a churn event took place in Q4 2020, so we can see if we should make any tweaks to weighting or anything else. When running the report in my previous reply, I was hoping to get a list of customers and the overall score for each snapshot date. Instead I’m getting the current overall score for each of the snapshot dates in the report. Any suggestions I can apply that will give me the desired result? Thanks!

@shantan_reddy and@silpa1234 - after digging into this a bit more. it looks like I’m missing the Overall Score (Account) field on the Account Scorecard History object. Is there simple steps I can take to enable this field on this object in my instance or this is a support matter? Thanks!

@jessica_owens It should ideally be available in the scorecard history object. If unavailable, please raise a support ticket.