header
Solved

Reporting on manual scorecard measures

  • 23 July 2020
  • 8 replies
  • 116 views

Userlevel 7
Badge +2

Hoping that I’m just missing something and someone has a solution for this.  We have several manual sentiment measures on our scorecard.  We need to build a report that shows 1. Accts that haven’t been updated in X days (easy enough) 2. Accts that have never been updated. (This is where I’m running into issues)

From what I can tell, if the score has never been added, technically, there’s not a measure for it.  I can see the Nulls in the Scorecard Mass Edit report, but I can’t seem to get a report that would show both the last modified date of the individual score and the nulls.  If I select Standard report instead of Scorecard Mass Edit, I can get to the specific measure and modified date, but not if I choose Scorecard Mass Edit.  

Anyone have a solution or a suggestion?  I’ve tried getting to them from the Rules Engine to mark them as NA so that I can pick them up.  I’ve tried Data Designer.  Thanks for the help!

icon

Best answer by jean.nairon 26 July 2020, 19:31

Good trick. Thanks @meenal_shukla! This option might be your easiest bet if you are just looking to create the report. If you are looking to trigger something like a CTA to CSMs, you will need the rule so I’ll give you the steps for that as well. 

For the rule, you mentioned: 

So, when I do the merge, I keep all accounts from the left dataset, and then, for the actions, try to set the filters to look for accounts where the input type is MANUAL and the measure name doesn’t equal Sentiment.  (So, I don’t overwrite any that do have a score). When I do that, I get 0 even though I know there should be about 200.

 

I’m not sure I fully follow what you mean here but here’s what I would recommend. For the first data set, you should have a list of all companies filtered down to just your customers. This should include Let’s use that as the left dataset in the merge. 

For the second data set, I recommend to pull the score and the Company GSID. You will need to filter down the query to just one measure. If you want to check multiple measures, you can do that but you will need multiple separate queries. This data set will be the right data set. 

In the merge task, retain all records on the left. So in the end you will have a table that includes theses fields: 

  • Company GSID (or you can use any other UID you like)
  • Manual Measure 1 Score
  • And you can add additional measures if you do a 3rd or 4th query.

Let’s say you have a 1000 customers and only 600 have scores filled out. The end results of your query should include all 1000 customers and 600 of them will have the scores. The other 400 will have empty fields. 

If you want to trigger a CTA from here, you can filter down to the score = Null in the Action tab. 

Hope this makes sense and helps you find the right solution for your challenge. 

 

View original

8 replies

Userlevel 7
Badge

@heather_hansen, I’ve done this using the rules engine in the past. If you query all your customers and query all health scores, you can merge the data together and pull a list of companies with and without the manual scores. From there, you can add a flag or the actual score on all customer company records. If you want to pull in the date it was last updated, I would recommend bringing that in with the rule as well onto the company. Once you have the data, you should be able to pull it all into a report. 

Would love to hear if anyone has any easier solutions for this.

 

Userlevel 7
Badge +1

I would use Data Designer here considering that your end result is a report.

First dataset: All customers (Left)

Second dataset: All accounts with an update on Sentiment dataset (Right)

Merge: Left join

Resultant records will have a null entry on activist id (So filter on activity id = Null).

Userlevel 7
Badge

@darkknight created an idea for this that might help. Here it is: 

 

 

Userlevel 7
Badge +2

Thanks, @jean.nairon and @meenal_shukla!  I was able to get it to work finally!  I really appreciate it!

Userlevel 5
Badge +1

Great conversation @heather_hansen. I didn’t even know that I needed to know this!  

*Bookmarked* :sunglasses:

Userlevel 7
Badge +2

Thanks, @jean.nairon!  I’m still struggling with the rules engine.  So, I have one dataset that’s a list of companies and then a second dataset from the scorecard with measure names and scores.  So, let’s say my measure that I need to add to accounts with NULL is Sentiment.  The Sentiment measure (name or score) doesn’t show up in the scorecard dataset for accounts that don’t have one.  So, when I do the merge, I keep all accounts from the left dataset, and then, for the actions, try to set the filters to look for accounts where the input type is MANUAL and the measure name doesn’t equal Sentiment.  (So, I don’t overwrite any that do have a score). When I do that, I get 0 even though I know there should be about 200.

Userlevel 7
Badge

Good trick. Thanks @meenal_shukla! This option might be your easiest bet if you are just looking to create the report. If you are looking to trigger something like a CTA to CSMs, you will need the rule so I’ll give you the steps for that as well. 

For the rule, you mentioned: 

So, when I do the merge, I keep all accounts from the left dataset, and then, for the actions, try to set the filters to look for accounts where the input type is MANUAL and the measure name doesn’t equal Sentiment.  (So, I don’t overwrite any that do have a score). When I do that, I get 0 even though I know there should be about 200.

 

I’m not sure I fully follow what you mean here but here’s what I would recommend. For the first data set, you should have a list of all companies filtered down to just your customers. This should include Let’s use that as the left dataset in the merge. 

For the second data set, I recommend to pull the score and the Company GSID. You will need to filter down the query to just one measure. If you want to check multiple measures, you can do that but you will need multiple separate queries. This data set will be the right data set. 

In the merge task, retain all records on the left. So in the end you will have a table that includes theses fields: 

  • Company GSID (or you can use any other UID you like)
  • Manual Measure 1 Score
  • And you can add additional measures if you do a 3rd or 4th query.

Let’s say you have a 1000 customers and only 600 have scores filled out. The end results of your query should include all 1000 customers and 600 of them will have the scores. The other 400 will have empty fields. 

If you want to trigger a CTA from here, you can filter down to the score = Null in the Action tab. 

Hope this makes sense and helps you find the right solution for your challenge. 

 

Userlevel 7
Badge

You’re welcome @heather_hansen!

Reply