This is an old revision of the document!
The goal of this is story is to create a method of extracting Key usage data for export and graphical representation in Salesforce. The first output is data to form a graph that looks like this (below) that can be emailed monthly to the customer with personalized info. It serves two purposes, encourage regular contact and acceptance of emails and also to drive contact to our site, particularly the available web apps and encourage their usage.
The graph above represent the number of keys the company owns and the monthly day average over the the past year. A monthly average over 20 days represents keys being used thoroughly and potential opportunities to sell more. It's necessary to represent the total keys on the graph as well because new purchases tend to dilute numbers if they aren't done at the beginning of a month.
For instance, the graph above shows TopGrade starting with two keys in 2017, buying four more in July, another in October, and finally two more in January of 2018. The supporting spreadsheet data that generates this graph looks like this:
| #keys 2017 | 2017 avg key days | #keys 2018 | 2018 avg key days | |
| Jan | 2 | 19.5 | 9 | 18.4 |
| Feb | 2 | 25.5 | 9 | 18.2 |
| Mar | 2 | 28 | 9 | 21.9 |
| April | 2 | 22 | 9 | 19.4 |
| May | 2 | 25.5 | ||
| June | 2 | 24.5 | ||
| July | 6 | 13.7 | ||
| Aug | 6 | 19.2 | ||
| Sept | 6 | 17.5 | ||
| Oct | 7 | 15.9 | ||
| Nov | 7 | 19.4 | ||
| Dec | 7 | 19 |
We may also want to build this graphing in to the website for reporting option
