System and method for analyzing marketing efforts
First Claim
Patent Images
1. A system comprising:
- a transaction database configured to store card transaction data regarding purchases made with a transaction card at a point-of-sale received from a transaction card issuer company;
a customer information database configured to store information identifying card holders;
a merchant information database configured to store information identifying merchants;
wherein the transaction database is coupled to and interacts with the customer information database and the merchant information database to append customer data and merchant data to buying behavior data of the card transaction data to create aggregated card transaction data,wherein the aggregated card transaction data are created by aggregating and linking customer data, merchant data, and buying behavior data from different databases based on identification keys, and the aggregating and linking are based on balancing and scaling using a balancing weight, a penetration factor, and a scaling factor by making the card transaction data representatives of general population distribution,wherein the merchant information database periodically receives, from the transaction database, a set of transaction files comprising raw transaction data and updates each file by;
standardizing the raw transaction data based on one or more predetermined protocols,assigning a standardized merchant key for each merchant by retrieving a merchant codebook file and identifying a standardized merchant key for each merchant,generating a set of standardized table files comprising a plurality of cells where each cell contains standardized transaction data and a correspondingstandardized merchant key, whereby the each standardized table file is used to retrieve transaction data;
a market insights resource server comprising;
an analytical module coupled to and interacting with the transaction database storing the aggregated card transaction data;
wherein the analytical module is configured to receive an information need request from a client computing device, the information need request requesting potential customers for one or more products and filter the aggregated card transaction data based on filtering criteria determined from the information need request to determine a subset of card transaction data satisfying the filtering criteria,wherein analysis by the analytical module includes summarizing detailed transaction data on the customers, linking customer data with external datasets, and clustering similar customers into a plurality of segments, wherein each segment comprises customers having at least one common attribute and wherein each segment comprises an identified buying behavior;
a reporting module configured to provide a report based on the analysis of the analytical module, including identifying a sales effect of a campaign, market share based on a geographic segment, demographics of a company'"'"'s customers, or shopping habits of the company'"'"'s customers;
a panel card component configured to generate and send via email communication a questionnaire containing a plurality of questions that are based on the information need request requested by the client computing device and the subset of card transaction data for completion on a website on a customer computing device by a plurality of customers who opted-in to respond to a questionnaire and are selected for the questionnaire based upon a previous transaction,wherein the questionnaire comprises a plurality of questions associated with customer buying behavior not limited to a single transaction, wherein the panel card component is coupled to the transaction database storing the aggregated card transaction data which receive a response to the questionnaire transmitted from the customer computing device; and
a value shopper component coupled to the reporting module, the transaction database and are configured to generate an identification of potential customers based upon the questionnaire, the response to the questionnaire, and the report.
2 Assignments
0 Petitions
Accused Products
Abstract
The present invention relates to a method and system for evaluating the cause and effect of advertising and marketing programs using card transaction data. In one embodiment, access is provided to voluminous card-holder transaction data detailing accurate-to-the-penny transaction amounts, twenty-four hour active customers, and a multi-year transaction history per customer. Furthermore, such data is captured in real-time, and due to the sample size, can provide granular, statistically significant information at a local level for client and merchant coverage.
49 Citations
14 Claims
-
1. A system comprising:
-
a transaction database configured to store card transaction data regarding purchases made with a transaction card at a point-of-sale received from a transaction card issuer company; a customer information database configured to store information identifying card holders; a merchant information database configured to store information identifying merchants; wherein the transaction database is coupled to and interacts with the customer information database and the merchant information database to append customer data and merchant data to buying behavior data of the card transaction data to create aggregated card transaction data, wherein the aggregated card transaction data are created by aggregating and linking customer data, merchant data, and buying behavior data from different databases based on identification keys, and the aggregating and linking are based on balancing and scaling using a balancing weight, a penetration factor, and a scaling factor by making the card transaction data representatives of general population distribution, wherein the merchant information database periodically receives, from the transaction database, a set of transaction files comprising raw transaction data and updates each file by; standardizing the raw transaction data based on one or more predetermined protocols, assigning a standardized merchant key for each merchant by retrieving a merchant codebook file and identifying a standardized merchant key for each merchant, generating a set of standardized table files comprising a plurality of cells where each cell contains standardized transaction data and a corresponding standardized merchant key, whereby the each standardized table file is used to retrieve transaction data; a market insights resource server comprising; an analytical module coupled to and interacting with the transaction database storing the aggregated card transaction data; wherein the analytical module is configured to receive an information need request from a client computing device, the information need request requesting potential customers for one or more products and filter the aggregated card transaction data based on filtering criteria determined from the information need request to determine a subset of card transaction data satisfying the filtering criteria, wherein analysis by the analytical module includes summarizing detailed transaction data on the customers, linking customer data with external datasets, and clustering similar customers into a plurality of segments, wherein each segment comprises customers having at least one common attribute and wherein each segment comprises an identified buying behavior; a reporting module configured to provide a report based on the analysis of the analytical module, including identifying a sales effect of a campaign, market share based on a geographic segment, demographics of a company'"'"'s customers, or shopping habits of the company'"'"'s customers; a panel card component configured to generate and send via email communication a questionnaire containing a plurality of questions that are based on the information need request requested by the client computing device and the subset of card transaction data for completion on a website on a customer computing device by a plurality of customers who opted-in to respond to a questionnaire and are selected for the questionnaire based upon a previous transaction, wherein the questionnaire comprises a plurality of questions associated with customer buying behavior not limited to a single transaction, wherein the panel card component is coupled to the transaction database storing the aggregated card transaction data which receive a response to the questionnaire transmitted from the customer computing device; and a value shopper component coupled to the reporting module, the transaction database and are configured to generate an identification of potential customers based upon the questionnaire, the response to the questionnaire, and the report. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A computer-implemented method comprising:
-
receiving, by a server, an information need request from a client computing device, the information need request requesting potential customers for one or more products; querying, by the server, from a transaction database, card transaction data regarding purchases made with a transaction card at a point-of-sale from a transaction card issuer company; creating, by the server, aggregated card transaction data, wherein the aggregated card transaction data are created by aggregating and linking customer data, merchant data, and buying behavior data from different databases based on identification keys, and wherein the aggregating and linking are based on balancing and scaling using a balancing weight, a penetration factor, and a scaling factor by making the card transaction data representatives of general population distribution, wherein the merchant information database periodically receives, from the transaction database, a set of transaction files comprising raw transaction data and updates each file by; standardizing the raw transaction data based on one or more predetermined protocols, assigning a standardized merchant key for each merchant by retrieving a merchant codebook file and identifying a standardized merchant key for each merchant, generating a set of standardized table files comprising a plurality of cells where each cell contains standardized transaction data and a corresponding standardized merchant key, whereby the each standardized table file is used to retrieve transaction data; filtering, by the server, the aggregated card transaction data based on filtering criteria determined from the information need request requested by the client computing device to determine a subset of card transaction data satisfying the filtering criteria, wherein the filtering criteria comprise identifying information for the subset of card transactions data; analyzing, by the server, the subset of card transaction data; wherein said analysis includes summarizing detailed transaction data on the customers, linking customer data with external datasets, and clustering similar customers into a plurality of segments, wherein each segment comprises customers having at least one common attribute and wherein each segment comprises an identified buying behavior; generating, by the server, a marketing-related report based on the analysis of the subset of card transaction data; generating, by the server, a questionnaire containing a plurality of questions that are based on the information need request requested by the client computing device and the subset of card transaction data, wherein the questionnaire comprises a plurality of questions associated with customer buying behavior not limited to a single transaction; sending, by the server, a request via email communication comprising a website including the questionnaire to each of a plurality of customers to complete the questionnaire on the website on a customer computing device, wherein the plurality of customers opted-in to respond to the questionnaire and are selected for the questionnaire based upon a previous transaction; receiving, by the server, at least a response to the questionnaire transmitted from the customer computing device; and generating, by the server, an identification of potential customers based upon the questionnaire, the response to the questionnaire, and the report. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
Specification