Systems and methods for providing a direct marketing campaign planning environment

• US 10,311,466 B1
• Filed: 01/30/2018
• Issued: 06/04/2019
• Est. Priority Date: 01/31/2007
• Status: Active Grant

• Current Assignee: Experian Information Solutions Incorporated (Experian plc)
• Original Assignee: Experian Information Solutions Incorporated (Experian plc)
• Inventors: DeSoto, Laura J., Pearson, Michele M., Adkinson, Kristi Ann, Achanta, Venkat R., Peng, Felicia
• Primary Examiner(s): Nguyen, Tien C
• Application Number:
  US15/884,027
• Time in Patent Office: 490 Days
• Field of Search: 705 35, 705 26, 705 39, 705 38, 705 37, 705 723, 705 737, 341106, 715205
• CPC Class Codes: G06Q 30/00 Commerce
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G06Q 30/0243 Comparative campaigns
• CPC Class Codes: G06Q 30/0245 Surveys
• CPC Class Codes: G06Q 30/0264 based upon schedule
• CPC Class Codes: G06Q 30/0269 based on user profile or attribute

Abstract

Embodiments of system are disclosed in which selection strategies for a direct marketing campaign that identify consumers from a credit bureau or other consumer database can be planned, tested, and/or refined on a stable subset of the credit database. In some embodiments, once refined, consumer selection criteria may be used to execute the direct marketing campaign on the full consumer/credit database, which is preferably updated approximately twice weekly. In one preferred embodiment, the data for the test database represents a random sampling of approximately 10% of the full database and the sampling is regenerated approximately weekly in order to provide a stable set of data on which campaign developers may test their campaign. For each consumer in the sampling, the environment may allow a client to access and use both attributes calculated by the credit bureau and proprietary attributes and data owned by the client. The system allows for a plurality of clients to use the system substantially simultaneously while protecting the privacy and integrity of the client'"'"'s proprietary data and results.

Claims

1. A computer system for allowing a plurality of clients to plan, test and execute partitioned processing, the computer system comprising:

a firewall separating a first user device associated with a first client and a second user device associated with a second client from a data server and from a testing server;

an access control list configured to authenticate user devices requesting access to the testing server;

the data server comprising;

a plurality of data records corresponding to millions of consumers, each data record associated with one or more consumer data values;

an extraction and data load module stored in a non-transitory computer memory, configured to;

load a first set of custom data records received from the first client, wherein the first set of custom data records are associated with one or more consumers;

load a second set of custom data records received from the second client, wherein the second set of custom data records are associated with the one or more consumers;

load a first set of contact history data received from the first client, wherein the first set of contact history data is associated with the one or more consumers;

load a second set of contact history data received from the second client, wherein the second set of contact history data is associated with the one or more consumers;

load a first set of client response data received from the first client, wherein the first set of client response data is associated with one or more consumers;

load a second set of client response data received from the second client, wherein the second set of client response data is associated with one or more consumers;

create a first set of depersonalized data records from the first set of custom data records, the first set of contact history data and the first set of client response data by removing identification information associated with the one or more consumers and replacing with a first set of anonymous identifier numbers;

create a second set of depersonalized data records from the second set of custom data records, the second set of contact history data and the second set of client response data by removing identification information associated with the one or more consumers and replacing with a second set of anonymous identifier numbers;

the testing server comprising one or more processors which when programmed execute instructions, comprising;

partitioning the testing server into at least a first virtual electronic partition allowing access to the first client, and a second virtual electronic partition allowing access to the second client;

receiving, from the first user device associated with the first client, a first request to access the test server;

receiving, from the second user device associated with the second client, a second request to access the test server;

authenticating the first user device and the second user device requesting access to the test server using the access control list;

accessing a first data set associated with the first client and the first virtual electronic partition, wherein the first data set comprises a subset of the plurality of data records and a subset of the first set of depersonalized data records;

accessing a second data set associated with the second client and the second virtual electronic partition, wherein the second data set comprises the subset of the plurality of data records and a subset of the second set of depersonalized data records;

via the first virtual electronic partition, allowing the first client to query and test for a first campaign using the first data set, while restricting access by the first client to the second virtual electronic partition and the second data set; and

via the second virtual electronic partition, allowing the second client to query and test for a second campaign using the second data set, while restricting access by the second client to first virtual electronic partition and the first data set.

2. The computer system of claim 1, wherein the instructions, further comprising:

receiving a first campaign strategy from the first client;

receiving a second campaign strategy from the second client;

providing a first user interface configured to allow the first client to test for a first marketing campaign test via the first virtual electronic partition using the first campaign strategy; and

providing a second user interface configured to allow the second client to test for a second marketing campaign test via the second virtual electronic partition using the second campaign strategy.

3. The computer system of claim 1, wherein the subset of the plurality of data records in the testing server is between 5% and 25% of the plurality of data records in the data server.

4. The computer system of claim 1, wherein the subset of the plurality of data records in the testing server is substantially 10% of the plurality of data records in the data server.

5. The computer system of claim 1, wherein the identifying information comprises a name and an address of a consumer.

6. A computer-implemented method for allowing a plurality of clients to plan, test and execute partitioned processing, the method comprising:

providing a first computer system for a data storage environment, the first computer system comprising a plurality of data records corresponding to millions of consumers, each data record associated with one or more consumer data values;

loading a first set of custom data records received from a first client, wherein the first set of custom data records are associated with one or more consumers;

loading a second set of custom data records received from a second client, wherein the second set of custom data records are associated with the one or more consumers;

loading a first set of contact history data received from the first client, wherein the first set of contact history data is associated with the one or more consumers;

loading a second set of contact history data received from the second client, wherein the second set of contact history data is associated with the one or more consumers;

loading a first set of client response data received from the first client, wherein the first set of client response data is associated with one or more consumers;

loading a second set of client response data received from the second client, wherein the second set of client response data is associated with one or more consumers;

creating a first set of depersonalized data records from the first set of custom data records, the first set of contact history data and the first set of client response data by removing identification information associated with the one or more consumers and replacing with a first set of anonymous identifier numbers;

creating a second set of depersonalized data records from the second set of custom data records, the second set of contact history data and the second set of client response data by removing identification information associated with the one or more consumers and replacing with a second set of anonymous identifier numbers;

providing a second computer system for a test environment, the second computer system comprising one or more processors which when programmed execute instructions, comprising;

partitioning the second computer system into at least a first virtual electronic partition allowing access to the first client, and a second virtual electronic partition allowing access to the second client;

receiving, from a first user device associated with the first client, a first request to access the second computer system;

receiving, from a second user device associated with the second client, a second request to access the second computer system;

authenticating the first user device and the second user device requesting access to the second computer system using an access control list configured to authenticate user devices requesting access to the second computer system;

accessing a first data set associated with the first client and the first virtual electronic partition, wherein the first data set comprises a subset of the plurality of data records and a subset of the first set of depersonalized data records;

accessing a second data set associated with the second client and the second virtual electronic partition, wherein the second data set comprises the subset of the plurality of data records and a subset of the second set of depersonalized data records;

via the first virtual electronic partition, allowing the first client to query and test for a first campaign using the first data set, while restricting access by the first client to the second virtual electronic partition and the second data set; and

via the second virtual electronic partition, allowing the second client to query and test for a second campaign using the second data set, while restricting access by the second client to first virtual electronic partition and the first data set.

7. The computer-implemented method of claim 6, wherein the instructions, further comprising:

receiving a first campaign strategy from the first client;

receiving a second campaign strategy from the second client;

providing a first user interface configured to allow the first client to test for a first marketing campaign test via the first virtual electronic partition using the first campaign strategy; and

providing a second user interface configured to allow the second client to test for a second marketing campaign test via the second virtual electronic partition using the second campaign strategy.

8. The computer-implemented method of claim 6, wherein the subset of the plurality of data records in the testing server is between 5% and 25% of the plurality of data records in the data server.

9. The computer-implemented method of claim 6, wherein the subset of the plurality of data records in the testing server is substantially 10% of the plurality of data records in the data server.

10. The computer-implemented method of claim 6, wherein the identifying information comprises a name and an address of a consumer.

11. A non-transitory computer storage medium which stores executable code, the executable code causing a computing system to perform:

providing a first computer system for a data storage environment, the first computer system comprising a plurality of data records corresponding to millions of consumers, each data record associated with one or more consumer data values;

loading a first set of custom data records received from a first client, wherein the first set of custom data records are associated with one or more consumers;

loading a second set of custom data records received from a second client, wherein the second set of custom data records are associated with the one or more consumers;

loading a first set of contact history data received from the first client, wherein the first set of contact history data is associated with the one or more consumers;

loading a second set of contact history data received from the second client, wherein the second set of contact history data is associated with the one or more consumers;

loading a first set of client response data received from the first client, wherein the first set of client response data is associated with one or more consumers;

loading a second set of client response data received from the second client, wherein the second set of client response data is associated with one or more consumers;

creating a first set of depersonalized data records from the first set of custom data records, the first set of contact history data and the first set of client response data by removing identification information associated with the one or more consumers and replacing with a first set of anonymous identifier numbers;

creating a second set of depersonalized data records from the second set of custom data records, the second set of contact history data and the second set of client response data by removing identification information associated with the one or more consumers and replacing with a second set of anonymous identifier numbers;

providing a second computer system for a test environment, the second computer system comprising one or more processors which when programmed execute instructions, comprising;

partitioning the second computer system into at least a first virtual electronic partition allowing access to the first client, and a second virtual electronic partition allowing access to the second client;

receiving, from a first user device associated with the first client, a first request to access the second computer system;

receiving, from a second user device associated with the second client, a second request to access the second computer system;

authenticating the first user device and the second user device requesting access to the second computer system using an access control list configured to authenticate user devices requesting access to the second computer system;

accessing a first data set associated with the first client and the first virtual electronic partition, wherein the first data set comprises a subset of the plurality of data records and a subset of the first set of depersonalized data records;

accessing a second data set associated with the second client and the second virtual electronic partition, wherein the second data set comprises the subset of the plurality of data records and a subset of the second set of depersonalized data records;

via the first virtual electronic partition, allowing the first client to query and test for a first campaign using the first data set, while restricting access by the first client to the second virtual electronic partition and the second data set; and

via the second virtual electronic partition, allowing the second client to query and test for a second campaign using the second data set, while restricting access by the second client to first virtual electronic partition and the first data set.

12. The non-transitory computer storage medium of claim 11, wherein the executable code further causes the computing system to perform:

receiving a first campaign strategy from the first client;

receiving a second campaign strategy from the second client;

providing a first user interface configured to allow the first client to test for a first marketing campaign test via the first virtual electronic partition using the first campaign strategy; and

providing a second user interface configured to allow the second client to test for a second marketing campaign test via the second virtual electronic partition using the second campaign strategy.

13. The non-transitory computer storage medium of claim 11, wherein the subset of the plurality of data records in the testing server is between 5% and 25% of the plurality of data records in the data server.

14. The non-transitory computer storage medium of claim 11, wherein the subset of the plurality of data records in the testing server is substantially 10% of the plurality of data records in the data server.

15. The non-transitory computer storage medium of claim 11, wherein the identifying information comprises a name and an address of a consumer.