Visual discovery tool for automotive manufacturers with network encryption, data conditioning, and prediction engine
A visual discovery tool for automotive manufacturing with network encryption, data conditioning, and prediction can include an extraction device configured to receive data records from application-specific file source databases. The tool can further include a vehicle alert database that receives the vehicle records from the plurality of extraction databases. The visual discovery tool can include at least one hardware processor in communication with the extraction device and the vehicle alert database. The tool can be configured to selectively restrict access to an interactive display based on whether a client device receives authorization credentials.
1. A visual discovery system for automotive manufacturing with network encryption, data conditioning, and prediction, the system comprising:
an extraction device comprising a plurality of extraction databases that store vehicle records, each of the extraction databases configured to receive data records from application-specific file source databases;
a vehicle alert database that receives the vehicle records from the plurality of extraction databases;
at least one hardware processor in communication with the extraction device and the vehicle alert database, the at least one hardware processor configured to execute computer-executable instructions to at least:
receive, over a network, vehicle records from the application-specific file source databases, wherein the vehicle records from the application-specific file source databases are associated with source data headings;
based on the source data headings of the vehicle records, load the vehicle records into one or more of the plurality of extraction databases;
selectively modify, based on second qualifying criteria, one or more vehicle records in one or more of the plurality of extraction databases;
transfer the vehicle records to the vehicle alert database, wherein the vehicle data records comprise:
a customer name for a previously sold vehicle and that customer's contact information, the customer name comprising a name of a past customer not currently shopping or looking for a new vehicle;
a vehicle identification number of the previously sold vehicle; and
data from a deal that resulted in a previous sale to the customer;
analyze the vehicle records relating to deals that resulted in the previous sales to past customers and analyze a new deal proposal for each of a set of past customers to determine which past customers are good prospects to offer a new vehicle on favorable terms, where the favorable terms comprise at least the same or lower monthly payment for the replacement vehicle;
identify at least one specific and available new favorable deal proposal relating to a specific new suggested vehicle;
transmit display instructions to a client device configured for use by a vehicle manufacturer, the display instructions configured to initiate a display comprising:
a number of the determined good prospects to offer a new vehicle on favorable terms;
a budget adjustment tool configured to allow a user to input a maximum allowed budget for making deals, wherein in response to manipulation of the budget adjustment tool, the display is updated to include an updated number of good prospects while preventing access by the user to any customer name or contact information;
a geographic display associated with a plurality of geographic regions, each of the plurality of geographic regions associated with a corresponding alert indicator representing a number of available new favorable deal proposals in the corresponding geographic region; and
selectively restricted access to the initiated display based on whether the client device receives authorization credentials.
2. The system of claim 1 , wherein the display instructions are further configured to display a slider configured to allow a viewer to select a range.
3. The system of claim 1 , wherein the display instructions are further configured to automatically display newly identified favorable deal proposals.
4. The system of claim 1 , wherein the computer-executable instructions are configured to cause the hardware processor to automatically calculate or set an expiration date for identified new favorable deal proposals, and the display instructions are further configured to notify vehicle manufacturer personnel of the expiration of the new revenue opportunities.
5. The system of claim 4 , wherein expiration dates are calculated by determining that a new favorable deal proposal depends on a particular vehicle manufacturer incentive, and the expiration date corresponds to the end of that incentive.
6. The system of claim 1 , wherein the display instructions are further configured to allow vehicle manufacturer personnel to set a number of favorable deal proposals.
7. The system of claim 1 , wherein the display instructions are further configured to automatically display visual representations associated with a location of the favorable deal proposals.
8. The system of claim 1 , wherein the estimated trade value is obtained by using the vehicle identification number, the make, model, and year, of the previously sold vehicle, and the date it was sold.
9. The system of claim 8 , wherein the estimated trade value is automatically obtained from a database of third-party industry valuation data, and price of the new suggested vehicle and currently-available rate information are also automatically obtained from external databases.
10. The system of claim 1 , wherein the computer-executable instructions are configured to cause the hardware processor to automatically calculate the estimated payoff amount by multiplying the customer's current payment with the number of remaining payments derived from information in the large database of records.
11. The system of claim 1 , wherein the computer-executable instructions are configured to cause the hardware processor to automatically calculate the estimated payoff amount by:
obtaining from the alert database a capitalized cost comprising an amount financed for the previously-sold vehicle;
determining the amount paid so far by the customer toward the capitalized cost; and
determining the remainder by subtracting the amount paid so far from the capitalized cost, the remainder comprising the estimated payoff amount, analyze the vehicle records.
12. The system of claim 1 , wherein analyzing the vehicle records comprises:
receiving changed internal data and changed external data on a periodic basis wherein the period comprises receiving the changed data dynamically, the changed data comprising data relating to new suggested vehicles for past customers and values related to the previously sold vehicles for past customers;
automatically determining for each of the past customers the new suggested vehicle for the previously sold vehicle, wherein the determining comprises algorithmically associating the previously sold vehicle with one or more new suggested vehicles based on category, classification, or grouping;
searching an inventory of an automotive dealer for the new suggested vehicle for the customer, thereby limiting use of computer resources by analyzing one new suggested vehicle for the determination of whether that customer is a candidate for outreach;
determining a new proposed payments by:
obtaining a price of the new suggested vehicle;
obtaining a net trade-in equity by combining the estimated trade value with the estimated payoff amount of the previously sold vehicle, wherein the trade-in equity may be either negative equity or positive equity;
determining an amount to be financed by combining the price of the new suggested vehicle with any obtained net trade-in equity, whether positive or negative;
using the amount to be financed and currently-available rate information for a loan duration to determine the new proposed payment;
comparing the customer's current payment and the new proposed payment to determine one or more differences; and
analyzing the differences to determine if at least one of them meets a criterion to identify the customer for outreach because a new favorable deal proposal has been identified to get that customer into an upgraded vehicle comprising at least one of the new suggested vehicles;
the computer system being configured to adjust at least one changed data parameter for suggested new vehicles; and
iteratively analyzing whether the at least one changed data parameter increases the number of customers who can favorably get into an upgraded new suggested vehicle.