×

System and method for analyzing marketing efforts

  • US 10,192,225 B2
  • Filed: 04/14/2011
  • Issued: 01/29/2019
  • Est. Priority Date: 06/10/2003
  • Status: Active Grant
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.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×