Follow

ID587 - Contracts Lost & Won (SSRS) Overview & Sample

Tracking your contracts won and lost can give you great insight on your trends. This SSRS version of ID582/Metered Contract Customers Lost/Added Last 12 Months will provide you graphs and trending information based on Termination Codes used on eAuto Contract Records.  

Click HERE for instructions on running an eView based on Termination Codes.

Sample:

Overview:

This report determines a "Lost" customer when a contract is terminated for a customer and that customer (nor the parent account) has any other active metered contracts at the time this report runs. An "Added" contract customer is determined by looking back one month and if there were no active metered contracts for that Customer (or it's parent), then this report considers that to be an Added Customer Contract. Another caveat is that this reports on "live" data. So it's possible that a contract customer "Lost" 6 months ago has since opened a new contract..in which case that "Lost" contract will disappear from this report and the new contract will show up as an "Add". However, if a contract drop/add crosses, then it's possible for the "Lost" to dissappear and the "Add" to not show up since the report looks back one month for an active contract. 

The intention is to give you a trend as to the net impact on your customer base.

**METERED CONTRACTS ONLY! Not for connectivity contracts etc.

Please understand this report looks at your data at the time the report is run, so due to changing contract coverage etc, the "historical" data on this report might change and differ from the previous month(s) reports. It is a snapshot point in time that is accurate as of "Today"..but it cannot recreate contract conditions historically. So please use it as a temperature gauge metric only that uses contract termination dates / start dates etc. as of today and it's accurate for today. It is not something you can compare this months report to another from five months ago because data conditions could have changed. And please note: previous months could vary slightly if you make a practice of backdating contract start dates and/or terminations.

Please also note the report will only show the termination code for dropped contracts that were terminated. So if you have no "dropped contracts", then you won't see termination details.

 

Variable Explanation:

VariableW - #Months Back to for previous active contract (sorry no more than 12 months available)

VariableX - is for when you have multiple Branches and you want us to send a separate report to each branch "Role" specified in the subscription for that branches data only. Select "Enable" for VariableX to send each branch their individual data.

VariableY - select "Customer" to display the salesrep assigned to customer record, or "Contract" to display the customer associated with the contract

Filter settings available:

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk