Notify at time of service call placement when it may be better to send sales rather than or in addition to sending the tech.
This alert is designed to advise you as soon as a new service call has come in and you might be more interested in sending a Sales Rep rather than/in addition to a Technician. The classic example is when a customer places a service call and the lease is almost up. Could your sales person say "instead of us putting money to fix this how about you move on that quote?" But also works if the equipment is old, service discontinued, excessively high volume etc. It will advise of: excessive of service calls in the past year, excessively low or high volume in clicks, excessive age of equipment, parts or service discontinued, lease approaching completion, contract approaching completion or that the machine has been targeted for upgrade. Suggest it go direct to Sales Rep, can also send to technician. It also can be a tool for evaluating contracts and problems in service.
Run Schedule: every 10-minutes
Type of Output: Email
* * *
The top line of the alert shows which variable triggered the alert.
In the example above the alert triggered for excessive service calls, for contract at 92% its completion, for lease at 87% completion. This is all triggered from the variable settings you apply.
* * *
The purpose of the variables is to indicate minimum trigger values:
Variable W: Custom Property on Equipment Record indicating targeted for upgrade (User-Defined Lookup:Yes/No)
Variable X: Quantity of days between alerting on same equipment, regardless of changes. Helps avoid excessive repeating on same equipment.
Variable Y: Equipment is in Top/Excessive % of Service Calls compared to other like models ('.1' for top 10%)
Variable Z: Equipment is in Top/Bottom Average Volume % to other like models ('.1' for top 10% or bottom 10%)
Variable 1: Equipment Age is over years old . Considers the EARLIEST of either first Install date OR first recorded service call OR first recorded supply sales order.
Variable 2: Consider either:
Manufacturer Discontinued Date (enter Mfg)
Service Discontinue Date (enter Serv)
Manufacturer & Service Discontinue Date (enter Mfg,Serv)
Variable 3: If contract is more than Var3% complete ('0.8' for 80%)
Variable 4: If lease is more than Var4% complete ('0.8' for 80%)
Variable 5: Branch Number(s) to trigger on, separated by comma, or left blank for ALL
* * *
-This alert looks at ALL call types not just your Corrective Maintenance:
Technician / Work Phone: shows tech name assigned to service call and phone number of tech so sales can quickly easily call tech if needed
Bill Code: Bill Code associated with service call (i.e. can indicate if billable)
Lease Completed %: will show how far into the lease the equipment is and lease term per Service Lease Record in eAuto
Lease Data: Details of lease per Service Lease Record in eAuto
Lease Company / Code: Lease Company and Lease Type listed on eAuto Service Lease Record
Equip Years: will show the age of the equipment from the first date of install and if that field is empty, then the date the equipment record was created. Alert uses the first service call date (if machine has been resold) since that's more accurate as to how old the machine is and how long it's been in the field which relates to when it needs to be upgraded.
Volume Percentile: shows where that machine stands within it's model as far as volume is concerned. The logic looks at average volume for all active Equipment Records under contract, finds their average volume and divides that by total # of equipment and then ranks. If it is an excessively high volume machine, then it would fall within the top 10% of that model. Meaning it's volume percentile would be 10% or lower and the alert trigger line at the top would say "This service call has triggered for the following reason(s): Excessively High Vol = Y." If it is an excessively low volume machine, then it would fall in bottom 10% of that model. Meaning it's volume percentile would be 10% or below and the alert trigger line at the top would say "This service call has triggered for the following reason(s): Excessively High Vol = Y." This can help to spot machines that were installed in an environment where their suggested monthly volume is being exceeded. Machines placed in those scenarios can cost a lot of extra labor and parts because they aren't specified for that kind of volume. It can also help you spot low volume machines that possibly need their contract increased.
# of Calls in Past Year: number of service calls in past year. 2nd number listed is the average for that model
Avg Monthly Volume (Total BW + Color): The average monthly volume is based on the average 'Total' copies for the machine and the 2nd number listed is the average for that model).
So if it's a color machine, then the average monthly volume is based on the average color volume + the average black volume. (It's the sum of all meters which track back to a MeterTypeCategory of 'B/W', assuming there are any with a non-zero total, or else the sum of all meters which track back to a Category of 'Total.' To that is added the sum of all meters which track back to a Category of 'Color'. Doesn't matter whether it's required or whether it's active meter or not.). The average presented for the specific equipment will be 3-month if there is a non-zero value, else 6-month, else 12-month, else since-install (assuming equipment has an Install Date) matching eAuto's AMV seen in Meter Reading Console.
MFG Discontinued?: contains value listed on Model Record containing Mfg discontinued date (as shown below)
Service Discontinued?: contains value listed on Model Record containing Mfg discontinued date (as shown below)
Service Contract Completion %: Shows service contract completion %, contract # and expiration date of contract.
* * *
Best Practices & Tips
Best Practices & Tips
1. When there are only a few pieces of equipment for a model, calculating the Volume Percentile works differently. With large model population, our logic will post percentage values across the spectrum (1%-99% with 50th percentile being the average). But when the number of models is very small, then the Volume Percentile shows an extreme percentage (%) since the dataset is so small. For example, a machine producing 5 more clicks higher than the rest could post a radically high Volume Percentile like 80%.
For this reason, machines in small comparative groups (less than 8) will ONLY post a Volume Percentile of 13, 25, 38, 50, 63, 75, or 88, regardless of their true Volume Percentile. The order is determined by the average monthly volume.
The example below, shows machine with 75% Volume Percentile which seems low since it is doing nearly three times the volume of the model average (8788 machine average volume / 3782 model average volume).
If we used standard percentile calculation, you get:
EQ1 – (4 / 5) x 100 =80% this volume is 9289 clicks
EQ2 – (3 / 5) x 100 =60% this volume is 5277 clicks
EQ3 – (2 / 5) x 100 =40% this volume is 2801 clicks
EQ4 – (1 / 5) x 100 =20% this volume is 1157 clicks
EQ5 – (0 / 5) x 100 =0% this volume is 888 clicks
Our formula rounds to nearest, giving EQ1 the Volumte Percentile of 75%.
2. We can also tell sales when a piece of equipment they have forecasted to upgrade has a service call, perhaps they call with "instead of us putting money in to fix this, how about I get you an incentive to move on that quote".
Setting the Custom Property listed in VariableW (ZCJUpgradeTarget) to 'Yes' will cause the alert to trigger whenever a service call is placed for this piece of equipment.
3. A suggested best practice is when sales turn in their forecasts they also list equipment/customers/contracts to be upgraded and admin then updates eAutomate and sets that custom property. This setting also helps avoid parts being put into a machine that you know is going away soon. i.e. being returned to the leasing company soon (use ID799 to notify tech), being replaced with new equipment, contract termination is in the near future. This way you are not putting money into a piece of equipment that will not return on your investment before it is removed from service. If you do not see this custom property on your system after this alert is installed for you then please email us at firstname.lastname@example.org and we will get it installed for you.
Missing the Custom Property?
To create Custom Property in eAuto:
Lists & Codes / Attributes:
Create new attribute:
Description: Equipment targeted for Upgrade?
Data Type: Yes/No
Then add attribute to Custom Properties (Configuration):
Too many emails from the alert?
If you are getting too many emails from ID593 we suggest you tweak the variables to only focus on the most important ones. Typically, that would be a service call on a lease-end machine; here is how you would tweak the variables to just get notified for equipment at the end of lease.
VariableY - Enter 0 to stop the alert from triggering for calls that are in the top % of service calls for like models.
VariableZ - Enter 0 to stop the alert from triggering for the average volume on the machine being in either the top or bottom percentage for the model.
Variable1 - Enter a high number like 35 to only trigger the alert for equipment that is more than 35 years from the earliest of the install date, first service call or first supply sale.
Variable2 - Enter Neither to stop the alert from triggering on the manufacturer's discontinued date or the service discontinued date.
Variable3 - Enter 4 to stop the alert from triggering based on the percentage completion of the contract.
Variable4 - Enter 4 to stop the alert from triggering based on the percentage completion of the lease.
* * *
ID64 - Preview of lease end information for admin to ensure accuracy
ID101 - Excessive Service Calls
ID519 - Ensuring new leases get entered in eAutomate
ID667 - App to Update Equipment Leases in eAuto
ID799 - Service call for a lease end machine
ID911 - Supply Order placed against Contract due to Expire
* * *
Please see THIS LINK for review.
* * *