Patent Application
20130091148
1. Field of the Invention
The present invention relates to predictive modeling, and specifically to reducing the time and resources required for developing, deploying, and executing a model.
2. Background of Invention
Direct marketing campaigns involve targeting a set of existing customers for a promotional offer. For example, credit card customers that charge a certain amount on travel purchases per month can be offered a credit card with travel rewards, because it is likely that they will accept the offer. Decision sciences and predictive modeling are used to estimate the likelihood (referred to herein as a score) that a particular customer will accept an offer. Thus, the effectiveness of a direct marketing campaign is related to the robustness of the predictive model on which it was based.
Because models are so integral to direct marketing campaigns, it is desirable to execute multiple models efficiently while reducing the time and effort it takes for model development and model deployment. In existing systems, there are deficiencies in model development, model deployment, and model execution. These deficiencies increase the time and cost of developing a model and how effectively a model can be executed.
In existing systems, data is stored in multiple disparate sources of customer data each having their own unique definitions and access requirements. When data is stored in multiple disparate sources, a modeler needs to standardize data and create data tables before data can be analyzed. This results in inconsistent results, compliance risks, and an overall low confidence in the outcomes.
In existing systems, implementing the model logic in the development phase is not a seamless process. In existing systems, models are often developed in one programming language and deployed in another programming language. Thus, implementing a model requires converting logic code into system compatible code. Converting model logic into a model that can be implemented requires using resources with high technical skills to translate logic into system compatible code. This can result in numerous errors and prolonged implementations which increases the time it takes for the deployment phase to be completed.
In some existing systems, model execution occurs at a mainframe location and is based on billing cycles. That is, customers are scored at the end of their billing cycle. Because customer billing cycles vary across a month (e.g. customer A's billing cycle ends the 15th and customer B's billing cycle ends the 30th), it takes a full month to score a customer base. This is problematic because customer scores may change daily. Further, scores for the customers at the beginning of the billing cycle may be obsolete by the time the entire customer base is scored.
What is needed is an end-to-end integrated process of model development, model deployment, and model execution for customer marketing campaigns that enables rapid development and dynamic execution of models.
An infrastructure and architecture according to an embodiment of the present invention enables the rapid development and execution of predictive models. Exemplary embodiments provide solutions in the system design and process flow integration of model development, implementation, and execution for customer marketing campaigns.
Exemplary embodiments enable the rapid implementation of customer marketing models, rules, and segmentation strategies by logically integrating the three phases of customer marketing modeling. This enables significant reduction in the time-to-market of new strategies by reducing model deployment time. This reduced time-to-market allows companies to learn and respond to marketplace changes faster (e.g. adjust balance-transfer pricing to reflect reduction in prime rate).
In the execution phase, rapid assessments can occur using current data readily usable on demand. Further, exemplary embodiments can execute multiple models in a short time period using the most current customer data. This ensures ever-ready “scores” for customer marketing solutions. Exemplary embodiments can include quality controls built into the execution process that proactively track and notify input data anomalies and model volatility. Increases in model coverage across various channels/products complemented by rich, fresh, and accurate data provide major improvements in response rates and ultimately generate higher returns. For example, models may incorporate customer contact and product preferences enabling customized offers that generate higher response. Execution in exemplary embodiments allows businesses to respond immediately to changes in customer behavior. For example, customers who start showing an improved credit profile can be targeted selectively, in a much faster manner, for line increase offers.
In an embodiment, a system that enables development and execution of predictive models includes a centralized data management system, a data extraction tool, a model validation tool and a model execution tool.
In an embodiment, a data management system includes a data management server that can be accessed via a web browser that stores data in the form of a flat file. Further, a flat file may be a SAS data set.
In an embodiment, the data management system includes a data warehouse that stores data in the form of SQL variables.
In an embodiment, data to be extracted by the extraction tool appears in the form of a SAS data set and the extraction tool converts a SQL variable to a SAS variable.
In an embodiment, the extraction tool includes a privacy protection function that restricts user access to extracted data.
In an embodiment, the extraction tool includes a data filter adapted to filter data based on a population criteria, a sample size, and a date range criteria. Further, the data filter may filter data by combining criteria using logical operands. The data filter may also include a searchable data dictionary. The data filter can filter data based on the contents of an uploaded file.
In an embodiment, the model validation tool includes an intelligent code parser that checks a model for errors. Further, the model validation tool can validate a model by scoring an analytical environment data set and a production environment data set, and compare scores using a report. The model validation tool can validate a model using a pre-defined test case.
In an embodiment, the model execution tool allows a user to select when and how often a model is scored. The model execution tool can include an expiry date function that allows a user to specify how long a model will run. The model execution tool can score models using a SAS score engine.
In an embodiment, the model execution tool creates a plurality of variable files, each variable file referencing data variables used in models, wherein the variables referenced in a variable file are determined by a number of models that use a particular variable.
In an embodiment, the execution tool tracks model behavior against a baseline measure and alerts a user if model behavior deviates from the base line.
Further embodiments, features, and advantages of the invention, as well as the structure and operation of the various embodiments of the invention are described in detail below with reference to accompanying drawings.
The present invention is described with reference to the accompanying drawings. In the drawings, like reference numbers indicate identical or functionally similar elements.
While the present invention is described herein with reference to illustrative embodiments for particular applications, it should be understood that the invention is not limited thereto. Those skilled in the art with access to the teachings provided herein will recognize additional modifications, applications, and embodiments within the scope thereof and additional fields in which the invention would be of significant utility.
Model development occurs in what is called the analytic environment and involves building a model from customer data. Model development involves, without limitation, gathering customer data, analyzing customer data, creating model logic based on the analysis, and implementing the model logic. Gathering customer data typically involves generating and maintaining variables (e.g., household size, wallet size, income, travel expenses, etc.) using customer records. Systems may employ thousands of customer variables for tens of millions of customers. Analyzing customer data may involve analyzing customer variables to determine trends in customer behavior (e.g. customers with a higher income spend a greater percentage of their income on travel). Creating model logic may involve determining which of the thousands of variables will be used in a model and how they will be used to determine the likelihood a customer will behave in a certain way. For example, in a simple model, the likelihood of acceptance could be determined by the weighted average of a dozen variables. Implementing the model logic may involve putting the model into a form such that the model can be implemented in the development phase.
Model deployment may occur in what is called the production environment and involves testing the accuracy of the model against customer data to determine if the model contains any bugs and if the model achieves the expected results. Model deployment may involve actual customer scoring using previously-received marketing results.
Model execution involves using the model on live customer variable values where the results of the model are used to determine if an offer should be sent to a customer.
Network 100 is a communication network that allows communication to occur between the elements in the system. In the exemplary embodiment of
Data sources 200 include systems that are sources of customer data. For example, data sources 200 may include data from the following exemplary systems: authorization systems, risk management systems, demographic systems, spend/bill systems, etc. In the exemplary embodiment of
Data management system 300 processes and standardizes the data received from the various data sources 200. Processing and standardizing data may involve validating received data to insure the data does not contain errors, aggregating the received data to create aggregated data, and profiling the aggregated data so data trends across the customer base can be recognized. In one exemplary embodiment, data management system 300 uses software developed by the Ab Initio Software Corporation of Lexington, Mass. to perform the data processing and standardization. Data management system 300 provides centralized data that can be distributed across the system.
In the exemplary embodiment of
In an embodiment where a data warehouse 304 is used, data management server 302 may send the flat file to data warehouse 304. Data warehouse 304 converts the flat file into, for example, relational database table elements for storage. Data warehouse 304 can store thousands of data parameters for tens of millions of customers. In an exemplary embodiment, data is stored in data warehouse 304 in the form of SQL (Structured Query Language) variables. Data management system 300 can also include metadata dictionaries.
User station 400 provides an interface through which a modeler can develop, deploy, and execute a model. In the exemplary embodiment of
Extraction tool 500 is used by a modeler to complete the development phase of a model. In the exemplary embodiment of
Extraction tool 500 provides a modeler with a user interface 502 that allows a modeler to develop a model. In the exemplary embodiment, user interface 502 is a standard GUI (Graphical User Interface). Model development involves gathering customer data, analyzing customer data, creating model logic based on the analysis, and implementing the model logic.
As described above, data gathering may be completed by data management system 300. Thus, in an exemplary system, data gathering is transparent to the modeler. As such, the modeler need not standardize data nor create data tables before data can be analyzed. In an exemplary embodiment, variables on extraction tool 500 appear in the form of SAS datasets. The SAS variable names are standardized and consistent.
It should be noted that in some embodiments where data in the data management system 300 exists in the form of SQL variables on data warehouse 304, extraction tool includes a processing SQL macro 504 that converts SQL variables to SAS variables. This allows the end-user to work with SAS variables and avoid performing complex queries and joins. Thus, the modeler works with SAS datasets that can be directly plugged into a model.
In an embodiment where data is stored on data management server 302 as flat files, the flat files can be SAS flat files. Thus, SAS dataset extracts can be delivered directly to modelers on demand. The flat file architecture enables the optimization of system resources and provides improvements in the performance, efficiency, scalability, and user-experience of the extraction process compared to existing systems.
Further, the fiat file architecture enables faster implementation of new data by removing the need to transform native data elements to relational database elements. In addition, there is no need to predefine all fields that will be stored. If the full source dataset is stored, new fields can be easily added by adding them to the extraction tool 500.
Flat file data storage typically costs less than data storage in a warehouse due to compression and lower indexing overhead. In addition, data warehouse 304 can be eliminated and all extracts run on data management server 302.
The ability to retain data in its native format without transforming it into relational database tables also enhances data compliance and security. Data does not have to be transferred from the data management server 302 to the data warehouse 304. Also, restrictions on accessing data directly on the data management server 302 may be in place, to increase data security for sensitive and confidential customer information. Management Information System (MIS) tools can also be embedded into data management server 302 to track capacity usage by data source, market, variable, organization, and/or modeler to allow management of the platform for maximum return. Further, an issue tracking database (not shown) may provide transparency reporting metrics to manage and optimize the performance and efficiency of extraction tool 500.
it should be noted that when a flat file architecture is used, the system does not significantly degrade as the amount of data it holds increases. In contrast, relational database warehouse performance may deteriorate as new amounts of data increases in the aggregate.
Privacy protection function 506 may be included to protect the privacy of the consumers. In an embodiment, privacy protection function 506 gives the modeler a temporary password when a modeler requests access to a data set. The temporary password allows access to the specific dataset and the ability to copy it to a user directory. Further, only authorized modelers may be able to access extraction tool 500.
Extraction tool 500 may be equipped with parallel processing and intelligent partitioning, prioritization, and routing capabilities. This is an alternative to data extraction processes that follow a sequential loading paradigm, which causes congestion and delays in the data extraction process. With parallel processing, multiple jobs can run at the same time and not create a backlog of requests. In addition, intelligent partitioning, prioritization, and routing capabilities allocate jobs based on estimated size, targeted population, and variables selected so multiple jobs can run against the database simultaneously and optimize CPU throughput.
Filtering function 508 allows a modeler to analyze a subset of the data stored by data management system 300. As noted above, data management system 300 may store thousands of variables for tens of millions of customers. Filtering function 508 may allow a modeler to filter data based on a population criteria. For example, a user can filter based on a credit card type, credit limit, household size, etc. Filtering function 508 may allow a modeler to filter data based on a sample size criteria. For example, a modeler can select a sample size of 0.1%, 1%, 5%, 10%, 20%, or 100% of the customer base. Further, a modeler may be able to upload a customer file of customers, allowing the filtering function 508 to return data for the customers in the file.
Filtering function 508 may have the ability to perform mathematical and logical operands on variables to segment a population in the data extract. For example, a modeler may specify all users with a credit limit of less than $10,000 and with a household size of less than two. Filtering function 508 may provide the modeler the ability to select history and date ranges. For example, a modeler may specify all users that charged over $1000 from September 2003-October 2003.
Filtering function 508 may also include a searchable online data dictionary with policy usage criteria for each variable. Further, filtering function 508 may provide advanced searching features for variables. A modeler may also upload variables from a file and save variables to a file.
Once a modeler analyzes data, the modeler may create model logic based on the analysis using model building function 510. A modeler can create model logic by selecting the variables to be included in the model and specify how the variables will be used in the model to score a customer. Model logic may be created by a modeler writing model code for a model. In an exemplary embodiment, the model code is SAS code.
Model building function 510 allows a modeler to run a simulation of a model on customer data before the model is complete. Further, model building function 510 may allow a modeler to see a sample output of a model before the model is complete. Model building function 510 may allow a modeler to terminate a simulation or rerun a simulation while it is in progress. Further, simulations may be stored and shared. Model building function 510 may provide a modeler the ability to, for example and without limitation, save jobs as drafts, create a summary and a confirmation before submittal, extract jobs across multiple months and return in one dataset, estimate the size of output at job submission time, estimate the time of when a job will be completed, track the percent of completion, and/or upload and filter scrambled information. Further, in model building function 510, scored and rescored datasets may be combined into one consolidated dataset. Once a modeler is satisfied with a model, a modeler may submit the model. At this point, the model development phase is complete and the model deployment begins.
Validation tool 600 may be used by a modeler to complete the development phase of a model. In the exemplary embodiment of
User interface 602 provides a modeler with an interface that allows a modeler to complete deployment of a model. In an exemplary embodiment interface 602 is a standard GUI interface.
Intelligent code parser 604 checks for and rejects erroneous code prior to deployment.
Model validation process 606 may provide all independent variables and “scores” for sign-off. Model validation process 606 allows a modeler to run a validation dataset against up to 100% of the data prior to deployment. This allows the modeler to validate the model and scores produced by the model prior to execution in the production environment. Further, model validation process 606 may allow the modeler to specify parameters on which customers should be scored, where the scores should be sent, and how frequently the scores should be updated. Further, a modeler can change priorities, and/or set limits on others wishing to use a model. Once these parameters are entered, then the model may run automatically without the need of manual intervention.
In an exemplary embodiment, model validation process 606 uses Syncsort software available from Syncsort Incorporated, of Woodcliff Lake, N.J., as an ETL (Extract Transform Load) tool that provides joining and loading of data from multiple files into one dataset for model logic deployment.
In an embodiment, model validation provides model scores in mainframe and warehouse variables in one dataset.
In an embodiment, validation reports are automated. That is, model validation process 606 captures the logs and profile reports of the validation datasets in both the production environment and the analytical environment. The two validation datasets are then measured to validate and ensure consistency across environments. Automating this eliminates the need for the modeler to manually validate a model.
In an embodiment, model validation process 606 includes advanced transparency tools to dissect model code logic in order to ensure best practices and optimize efficiencies. That is, model validation process 606 may give the modeler the capability to automatically obtain the code log and process steps. This allows economies of both time and scale to be achieved through standardization and sharing/leveraging best practices.
Validation process 606 may allow a modeler to create a list of pre-defined User-Acceptance Testing (UAT) cases that may be used by other modelers, thereby accelerating and automating the testing process.
Model validation process 606 may include a standardized list of validation rules to ensure comprehensive data testing procedures prior to implementation. Model validation process 606 may also include a request initiation, requirement gathering and data management checklist processes. Further, model validation process 606 may also include pre-approved policy approval for bulk data sources to eliminate manual steps and remove policy approval from a critical path. Model validation process 606 may allow creation of an audit trail and approval for requests. Once a modeler is satisfied with the results from validation tool 600, the modeler may deploy the model.
Model library 700 stores models that have been deployed by various modelers. In the exemplary embodiment of
Execution tool 800 scores deployed models based on the customer data stored in data management system 300.
Score engine 802 is used to score models. In an exemplary embodiment, SAS is used as an engine to score models. When a model is being scored, execution tool 800 allows modelers to select when and how often their models will be scored. In an embodiment, a modeler can select when and how often their models are scored at any time during execution. The model can then run on an automated “lights-out” schedule. In general, “lights-out” refers to operation that is constantly occurring.
Problems can arise when obsolete models continue to run and consume massive amounts of system resources. Thus, in an embodiment, rather than models running lights-out on pre-defined automated intervals, a modeler may call models as needed to run for use in campaigns. Further, an expiry date function can be implemented. An expiry date function allows modelers to specify how long they want their model to run in the production environment.
In an embodiment where score engine 802 uses SAS, SAS parallelization allows multiple jobs to run in parallel as opposed to sequentially. This increases the performance and speed of model execution. Using the system of the exemplary embodiment, model scoring may occur using current data readily available on demand. Further, execution tool 800 may use resource utilization via parallel scheduling, intelligent data pivoting and optimization.
Data pivoting function 802 is targeted towards optimizing how data feeds are accepted from data management system 300. In an embodiment, during execution, execution tool 800 accepts the entire input file of all the variables for all of the customers in the data management system 300. However, most models use only a small portion of all of the variables. Further, the combination of the models being executed use only a small portion of all the variables. Thus, in an embodiment, data pivoting function 802 is used to improve the cycle time to score a large population by only utilizing active variables.
Data pivoting function 802 is structured on a self-learning process. When the data feeds are received from the data management system 300 (e.g. daily/weekly), data pivoting function 802 looks at all the “lights out” models in production and determines how many models need a particular variable from a given feed. Based on this information, the process breaks the input feed into multiple data files. The determination of how many split files need to be created and how many variables need to be placed in each split file is dynamically controlled through a configuration file.
An example configuration file may specify storing variables from a particular feed into split files as follows: storing all unused variables in a first split file, storing all variables used less than 9 times in a second split file, storing all variables used between 10 and 50 times in a third split file, and storing all variables used more than 50 times from a feed in a fourth split file.
If a particular file is not yielding expected results, then the parameters in the configuration file can be changed to change the split process for the next time data is received from data management system 300. Because the manner in which a feed is split for optimization is dependent upon the usage by models, data reflecting the number of split tiles and the variables residing on each split file at any given time may be maintained.
In the exemplary embodiment, model scores reside in a flat file architecture. Further, data related to model performance may be maintained for speed, accuracy, flexibility, and optimal maintenance. Data pivoting function 802 may allow only active variables in the metadata to be passed to the production environment to allow greater speed and execution.
Population Stability Index (PSI) tool 900 allows users to analyze and track the behavior and performance of models over time. In the exemplary embodiment of
The present invention (i.e., system 102 or any part(s) or function(s) thereof) may be implemented using hardware, software or a combination thereof and may be implemented in one or more computer systems or other processing systems. However, the manipulations performed by the present invention were often referred to in terms, such as adding or comparing, which are commonly associated with mental operations performed by a human operator. No such capability of a human operator is necessary, or desirable in most cases, in any of the operations described herein which form part of the present invention. Rather, the operations are machine operations. Useful machines for performing the operation of the present invention include general purpose digital computers or similar devices.
In fact, in one embodiment, the invention is directed toward one or more computer systems capable of carrying out the functionality described herein. An example of a computer system 1000 is shown in
The computer system 1000 includes one or more processors, such as processor 1004. The processor 1004 is connected to a communication infrastructure 1006 (e.g., a communications bus, cross over bar, or network). Various software embodiments are described in terms of this exemplary computer system. After reading this description, it will become apparent to a person skilled in the relevant art(s) how to implement the invention using other computer systems and/or architectures.
Computer system 1000 can include a display interface 1002 that forwards graphics, text, and other data from the communication infrastructure 1006 (or from a frame buffer not shown) for display on the display unit 1030.
Computer system 1000 also includes a main memory 1008, preferably random access memory (RAM), and may also include a secondary memory 1010. The secondary memory 1010 may include, for example, a hard disk drive 1012 and/or a removable storage drive 1014, representing a floppy disk drive, a magnetic tape drive, an optical disk drive, etc. The removable storage drive 1014 reads from and/or writes to a removable storage unit 1018 in a well known manner. Removable storage unit 1018 represents a floppy disk, magnetic tape, optical disk, etc. which is read by and written to by removable storage drive 1014. As will be appreciated, the removable storage unit 1018 includes a computer usable storage medium having stored therein computer software and/or data.
In alternative embodiments, secondary memory 1010 may include other similar devices for allowing computer programs or other instructions to be loaded into computer system 1000. Such devices may include, for example, a removable storage unit 1022 and an interface 1020. Examples of such may include a program cartridge and cartridge interface (such as that found in video game devices), a removable memory chip (such as an erasable programmable read only memory (EPROM), or programmable read only memory (PROM)) and associated socket, and other removable storage units 1022 and interfaces 1020, which allow software and data to be transferred from the removable storage unit 1022 to computer system 1000.
Computer system 1000 may also include a communications interface 1024. Communications interface 1024 allows software and data to be transferred between computer system 1000 and external devices. Examples of communications interface 1024 may include a modem, a network interface (such as an Ethernet card), a communications port, a Personal Computer Memory Card International Association (PCMCIA) slot and card, etc. Software and data transferred via communications interface 1024 are in the form of signals 1028 which may be electronic, electromagnetic, optical or other signals capable of being received by communications interface 1024. These signals 1028 are provided to communications interface N24 via a communications path (e.g., channel) 1026. This channel 1026 carries signals 1028 and may be implemented using wire or cable, fiber optics, a telephone line, a cellular link, an radio frequency (RF) link and other communications channels.
In this document, the terms “computer program medium” and “computer usable medium” are used to generally refer to media such as removable storage drive 1014, a hard disk installed in hard disk drive 1012, and signals 1028. These computer program products provide software to computer system 1000. The invention is directed to such computer program products.
Computer programs (also referred to as computer control logic) are stored in main memory 1008 and/or secondary memory 1010. Computer programs may also be received via communications interface 1024. Such computer programs, when executed, enable the computer system 1000 to perform the features of the present invention, as discussed herein. In particular, the computer programs, when executed, enable the processor 1004 to perform the features of the present invention. Accordingly, such computer programs represent controllers of the computer system 1000.
In an embodiment where the invention is implemented using software, the software may be stored in a computer program product and loaded into computer system 1000 using removable storage drive 1014, hard drive 1012 or communications interface 1024. The control logic (software), when executed by the processor 1004, causes the processor 1004 to perform the functions of the invention as described herein.
In another embodiment, the invention is implemented primarily in hardware using, for example, hardware components such as application specific integrated circuits (ASICs), implementation of the hardware state machine so as to perform the functions described herein will be apparent to persons skilled in the relevant art(s).
In yet another embodiment, the invention is implemented using a combination of both hardware and software.
While various embodiments of the present invention have been described above, it should be understood that they have been presented by way of example, and not limitation. It will be apparent to persons skilled in the relevant art(s) that various changes in form and detail can be made therein without departing from the spirit and scope of the present invention. Thus, the present invention should not be limited by any of the above described exemplary embodiments, but should be defined only in accordance with the following claims and their equivalents.
In addition, it should be understood that the figures and screen shots illustrated in the attachments, which highlight the functionality and advantages of the present invention, are presented for example purposes only. The architecture of the present invention is sufficiently flexible and configurable, such that it may be utilized (and navigated) in ways other than that shown in the accompanying figures.
Further, the purpose of the foregoing Abstract is to enable the U.S. Patent and Trademark Office and the public generally, and especially the scientists, engineers and practitioners in the art who are not familiar with patent or legal terms or phraseology, to determine quickly from a cursory inspection the nature and essence of the technical disclosure of the application. The Abstract is not intended to be limiting as to the scope of the present invention in any way.
This application is a continuation of, claims priority to and the benefit of, U.S. Ser. No. 12/100,219 filed Apr. 9, 2008, entitled “INFRASTRUCTURE AND ARCHITECTURE FOR DEVELOPMENT AND EXECUTION OF PREDICTIVE MODELS,” which is incorporated herein in its entirety.
| Number | Date | Country | |
|---|---|---|---|
| Parent | 12100219 | Apr 2008 | US |
| Child | 13687858 | US |
