Provides list of worst/best performing contracts and/or customers based on gross margin.
Provides list of the worst/best offending contracts or customers based on gross margin. We suggest this alert come from your CEO to the VP of Service. We allow you to store a documented action plan to fix the contract and decide on a date to review and until that date the contract will be Snoozed. Tackle just 1 or 2 per week until the list is complete. Contracts that are still a problem after the review date will show back up with details on what your plan was.
Run Schedule: Weekly on Fridays
Type of Output: Email
* * *
Top text in email indicates the number of contracts or customers reviewed and any plan/snooze dates entered, a zero means no one has reviewed any contracts.
* * *
Variable W: Set how many months Revenue/Cost you want the alert to consider. RM12 = looks back 12-months, RM24 = looks back 24 months. Default is RM12 & maximum is RM24.
Variable X: Set specific Contract Type Codes you wish the alert to report only, leave blank for all.
Variable Y: Set minimum months for contract to be active before reporting. Default is 6 as it's likely too soon to do anything sooner until click revenue accumulates.
Variable Z: Custom Property set on Contract Record to "snooze" a contract from reporting, using a date.
Variable 2: Note Type the alert will report, this is your detailed action plan set on the contract.
Variable 1: Set number of contracts alert to report on. Alert fires weekly, we suggest leaving this at the default 10 contracts, and setting Action Plans and using Snooze feature for any contracts to review in the future. Each week it will report the Top 10 Worse Performers, excluding the snoozed contracts until there date to review has passed (if still a problem).
Variable 3: Set minimum number of equipment required linked to contract. Default is 0 and we recommend keeping it as such so none are excluded, i.e. in case someone forgot to link equipment or perhaps you have two contract records but only one contains equipment. If you do elect to indicate something other than 0, please list number as negative (i.e. -1 will require at least one active equipment record linked to contract record). **FYI this is a count of contracted equipment PLUS contracted serviceable items.
Variable 4: Minimum Revenue PER MONTHLY PERIOD for contract to be considered
Variable 5: Max GM % for contract to be considered (don't tell me about contracts over 50% GM, for instance, whether they otherwise qualify as my 'Top X worst' or not)
Variable 6: Branch Numbers to report on individually (separated by comma), or enter 'ALL' for separate email for each Active Branch, or 'Consolidated' for one email covering all Branches
Variable 7: Show worst or best, per the other parameters, enter either 1, 2, 3, or 4
1) Worst by GM Dollars
2) Worst by GM %
3) Best by GM Dollars
4) Best by GM %
Variable 8: Enter 'Customer' to have the alert report at Customer level (not on individual Contracts).
* * *
-This alert DOES NOT report on Deposit Based Contracts
- Ranked - Worst performing contract/customer at top
- Period Margin % = Period Margin / Period Revenue
- Period Profit/Loss Margin = Period Margin - Period Revenue.
- Period Revenue: Period covered is per your VariableW setting and also noted in email text (i.e. RM01 back to RM12). RM01 = last completed month and RM12 = 12 months back from current month. See here for info on details of these labels.
- Contract Lifetime Margin: This shows the life of the contract and not just the period selected.
- All Contracts Lifetime Margin: This show all contracts for the customer, your losing contract may be offset by a profitable one.
- NPS: This shows Net Promoter Score information from our surveys. Knowing how happy a customer is can be an important metric when determining an action plan. Read more here. N/A will show for customers with no responses to the NPS question.
- Report: Link to ID150 Contract Profitability Report, details revenue and costs. Read more here. The link will run the report for a period to match the end periods (RM01-RM12 as this alert fired) per VariableW on your subscription. If you see "No Server" or "No Report", then your company does not have SSRS Reports (No Server) or does not have this report (No Report). See here for more troubleshooting, email us at email@example.com with questions.
This alert can be cloned which means creating multiple subscriptions of the same ID# (ID768). This function will ONLY work if at least ONE of the variables on each subscription is different.
See this link for an overview of cloning features.
To "snooze" a contract:
1. Enter date to snooze (Contract will not report on ID768 until that date is reached) on Contract Record Custom Properties ZCJProfitAlertSnooze:
2. Enter Note on Contract Record indicating action(s) to be taken:
Be sure to use Note Type of Review Action:
* * *
Best Practices & Tips
You can ask the CEO Juice team to tackle a couple from the list and report what we found and how we found it. We won't be as familiar with the nuances of the contract but it's a start. This is included in your monthly fee.
* * *
ID555 - eView CEOJuice Contract and Transactional Analysis
ID150 - Contract Profitability On Demand SSRS Report
* * *