# Customer scorecard

**URL:** <https://pug.phocassoftware.com/t/customer-scorecard/598>\
**Category:** Ask the Community\
**Created:** [May 11, 2018, 8:21am UTC](https://pug.phocassoftware.com/t/customer-scorecard/598 "2018-05-11T08:21:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kate](https://avatars.discourse-cdn.com/v4/letter/k/f04885/32.png) [@Kate](https://pug.phocassoftware.com/u/Kate)\
**Post date:** [May 11, 2018, 8:21am UTC](https://pug.phocassoftware.com/t/customer-scorecard/598/1 "2018-05-11T08:21:45Z")

</div>

Hello again. Just wondering if anyone would be willing to share examples of their customer score card with me please. Looking for ideas of what to include and how to lay it out! Thank you.

---

<div class="post-metadata">

**Author:** ![Brendan](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/brendan/32/257_2.png) [@Brendan](https://pug.phocassoftware.com/u/Brendan)\
**Post date:** [May 16, 2018, 9:02am UTC](https://pug.phocassoftware.com/t/customer-scorecard/598/2 "2018-05-16T09:02:15Z")

</div>

Hello @Kate

Currently we use;

**Customer list**  
At the top (so i can then select and ‘focus’ on particular customer - this then updates the rest of the information on the dash). this includes info like the Designated Account manager, etc etc.

**Regularly ordered items**  
Showing top 10 items that are ordered (rather than by value or qty… for repeat sales, we look at how often they order something to ensure we keep getting the repeats!) We have 2 tables side by side for this - one is for all customers (“Is Filterable” - Select ‘No’), then we clone this table and have the other one as “Is Filterable” as ‘Yes’. We can then quickly see if there are any differences and and find opportunities.

**Products By Value**  
Same as above, but with a different variable - just clone the whole line in the dashboard, then you can tweak the variables.

**Products By Volume**  
Same again.

**Drop Offs**  
Product sales - variance of product quantity sales - what a customer bought in the period 12-24 months ago, but not in the last 0-12.

_Ideas in mind for going forward_

- CRM Snapshot/Click through - from the scorecard you can see who/what/why regarding the last contact with the customer, and then click through for more info if you want.
- Suggested Product list - list generated from the above reports (drop-offs, popular lines, etc.) so that the scorecard suggests a list of products for the sales team to target sell to the customer. Not sure if this is possible or not at this stage… will have to consult the team @phocasbot@anon66559099 .

Good luck in getting set up!

Best  
@Brendan

---

<div class="post-metadata">

**Author:** ![phocasbot](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/phocasbot/32/26_2.png) [@phocasbot](https://pug.phocassoftware.com/u/phocasbot)\
**Post date:** [May 16, 2018, 9:02am UTC](https://pug.phocassoftware.com/t/customer-scorecard/598/3 "2018-05-16T09:02:17Z")

</div>

Hi! To find out what I can do, say `@phocasbot display help`.

---

<div class="post-metadata">

**Author:** ![tim.janes](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/tim.janes/32/361_2.png) [@tim.janes](https://pug.phocassoftware.com/u/tim.janes)\
**Post date:** [May 21, 2018, 9:35pm UTC](https://pug.phocassoftware.com/t/customer-scorecard/598/4 "2018-05-21T21:35:33Z")

</div>

Hi @Kate

I have a customer scorecard with the following metrics:

Top - query widgets:  
12-month numbers for Customer sales, branch sales, customer TYPE sales - all with variance from previous 12 months

Next section - summary number widgets:  
Year-to-date numbers for sales invoiced, open sales, bid dollars, GP%, YTD sales difference year-over-year, order conversion rate, avg. sales per order, avg. lines per order

Next - pie graphs and query:  
Top 15 Price Lines YTD, Top 10 order sources, and product types

Finally - query widgets:  
Price line increases/decreases year-over-year, and specific product sales increase/decrease year-over year

It seems like a lot, but between “Focus”-ing in multiple ways, searching, and sorting, a lot of information can be extracted and viewed in this single dashboard.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/03a3c0bf610d39fa686d68f13ca7efe1155daeac.jpg)