IP Library Granted Patent US 11,157,954
Granted Patent B1
US 11,157,954 · App. 14/492,924 · Granted Oct 26, 2021

Forming and using master records based on consumer transaction data

Inventors: John Neumann Belanger (Santa Cruz, CA); Yasha Avshalumov (Dallas, TX); Marvin Renaud (Atlanta, GA); Ivan Michael Chalif (Half Moon Bay, CA); Justin Mahen Mehta (Belmont, CA); Seth Marlatt (Belmont, CA)
Assignee: Quotient Technology Inc.
G06Q30/0255G06Q30/0201G06Q30/0269
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,157,954
App. No.
14/492,924
Granted
Oct 26, 2021
Kind
B1
Abstract

According to an embodiment, a data processing method comprises obtaining a first record associated with a first computer and a second record associated with a second computer that is different than the first computer; in response to determining that the first record has been obtained from a primary source, determining that at least a first set of key information in the first record matches a second set of key information in the second record, and in response thereto: creating and storing a master record comprising a union of the first record and the second record; storing, in a database, a third set of key information in the first record that does not match the second set, and a fourth set of key information in the second record that does not match the first set; using the master record to determine one or more electronic offers to present to any of a user, a computing device, or an account that is associated with the master record.

Claims (39)

1. A computer-implemented data processing method comprising:

using an offer server computing device, obtaining a first consumer record associated with a first computer source and a second consumer record associated with a second computer source, each consumer record comprising key information, source collection data and contextual transaction data, the first computer source comprising a merchant point-of-sale terminal or card reader or a digital receipt source, the second computer source comprising a service provider website or loyalty data source; the first consumer record and second consumer record having been obtained by a retail computer system accessing an API hosted by the offer server computing device directly in real time as transactions occur at the retailer system;

using the offer server computing device, normalizing the key information;

using the offer server computing device, in response to determining that the first consumer record has been obtained from a primary source, determining that at least a first set of key information in the first consumer record matches a second set of key information in the second consumer record, and in response thereto:

using the offer server computing device, identifying a first set of key information in the first consumer record that matches a second set of key information in the second consumer record and separating noncontradictory key information, the noncontradictory key information being the first set of key information from the first consumer record that matches the second set of key information from the second consumer record;

using the offer server computing device, creating and storing a master record in a database, the master record comprising a union of the noncontradictory key information and a plurality of master record key values;

using the offer server computing device, storing a third and fourth set of key data in a database, the third set of key data comprising key data in the first consumer record that does not match the noncontradictory key information and the fourth set of key data comprising key data in the second consumer record that does not match the noncontradictory key information;

using the offer server computing device, creating and storing a score value for the master record based upon a plurality of score values that are assigned to each of the master record key values, the score value indicating a level of confidence that the first set of key information and the second set of key information refer to a same particular consumer and including generating the score value by calculating a proportion of the key information in the first and second consumer records that comprises the first set of key data and the second set of key data, the noncontradictory key information that consists of exclusive values being weighted higher and the noncontradictory key information that consists of demographic values being weighted lower;

using the offer server computing device, increasing or decreasing the score value based on machine learning techniques and either or both of: a determination that the noncontradictory information from the first consumer record and the second consumer record also is in a third consumer record, or a user validating the noncontradictory information;

using the offer server computing device, ranking a plurality of the master records based on trustworthiness of the score values assigned to each of the master record key values and assigning the value of the highest-ranking score to the particular master record key;

using the offer server computing device, sending historical or projected data to an offer provider, the historical or projected data being any of: an impact of the offer on sales of an item, an offer redemption rate, a profit per offer impression, a profit margin, an offer volume, an offer yield, an impact of the offer on other offers, and an impact of the offer on consumer behavior;

using the offer server computing device, receiving a specified goal based on an interaction of the offer provider;

using the offer server computing device, using a target optimizer and the goal to generate a recommendation for which electronic offers to present to the user, computing device, or account associated with the master record;

using the offer server computing device, using the master record and the generated recommendation to determine one or more electronic offers to present to any of a user, a computing device, or an account that is associated with the master record, the determining the one or more electronic offers being based on at least one of: an activity associated with a particular master record or a consumer attribute associated with a particular master record;

using the offer server computing device, generating a webpage comprising an electronic receipt with embedded offer information formatted using one or more of XML, SOAP, or JSON and at least one uniform resource locator (URL);

causing presenting the one or more electronic offers that were determined.

2. The method of claim 1 , further comprising:

obtaining the third consumer record from any of the first computer source, the second computer source, or a third computer source.

3. The method of claim 1 , wherein the first set of key information comprises a first identifier that matches a second identifier in the second set of key information, and further comprising increasing the score value of the master record based upon determining that both the first identifier and the second identifier are in the third consumer record.

4. The method of claim 1 , further comprising increasing the score value of the master record in response to receiving a validation signal indicating that a consumer has validated the first key information or the second key information.

5. The method of claim 1 , wherein the first set of key information comprises a first identifier that matches a second identifier in the second set of key information, and further comprising:

receiving a validation signal indicating that a consumer has validated the first identifier or the second identifier;

increasing the score value of the master record based upon determining that both the first identifier and the second identifier are in the third consumer record.

6. The method of claim 1 further comprising increasing the score value by a greater amount in response to obtaining an explicit user validation of the master record key information.

7. The method of claim 1 wherein the first computer source is associated with a first retailer and the second computer source is associated with a second retailer that is different than the first retailer.

8. The method of claim 1 wherein the key information comprises at least one of: credit card number; one or more payment network credentials; phone number; address;

one or more login credentials; home address; driver's license number or other personally identifying information; store membership number.

9. The method of claim 1 further comprising updating the master record in response to obtaining an updated first consumer record, and in response to determining that the first set of key information in the updated first consumer record is similar to the second set of key information.

10. The method of claim 1 further comprising obtaining the third consumer record; determining that the third consumer record comprises a fifth set of key information that is noncontradictory to at least some of the first set of key information and the second set of key information; updating the master record by merging the third consumer record into the master record.

11. The method of claim 1 , further comprising determining that the third consumer record and a fourth consumer record are associated with different users of the same loyalty card of the same household when a fifth set of key information and a sixth set of key information, from the third consumer record and the fourth consumer record respectively, both include the same loyalty card number and the same address, and in response thereto, assigning a household identifier to both the third record and the fourth record, and storing the third record and the fourth record without creating a second master record.

12. The method of claim 1 wherein the first consumer record is a first master record of a first entity and the second consumer record is a second master record of a second entity.

13. The method of claim 1 wherein the second set of key information indicates that a first user printed, activated or downloaded an offer, and that a second user redeemed the offer.

14. The method of claim 1 further comprising refraining from repeating one or more offers that have been previously offered in connection with either the first consumer record or the second consumer record.

15. The method of claim 1 , wherein determining the one or more electronic offers is based on determining whether an offer has previously been activated in connection with a particular master record.

16. The method of claim 1 , further comprising: in response to a request from a retailer, transmitting a list of offers that have been activated for a particular master record, based upon present contextual transaction data that includes a credential supplied by a consumer during a transaction.

17. The method of claim 1 , further comprising: modifying at least one confidence level associated with the master record based on at least one of: an update from at least one of two sources from which the first consumer record and the second consumer record were obtained, new transaction data, or a field score that indicates a frequency with which a particular value occurs in a data field of the first consumer record and the second consumer record.

18. The method of claim 1 , further comprising:

using the offer server computing device, presenting the generated recommendation to the offer provider;

using the offer server computing device, receiving a confirmation from the offer provider specifying which offers to make in response to at least one of: an activity associated with a particular master record or a consumer attribute associated with a particular master record.

Assignments (7)
RELEASE OF SECURITY INTEREST Recorded Sep 8, 2023
From: PNC BANK, NATIONAL ASSOCIATION
To: QUOTIENT TECHNOLOGY INC.; UBIMO LTD
Reel/Frame 064841/0963 →
RELEASE OF SECURITY INTEREST Recorded Sep 7, 2023
From: BLUE TORCH FINANCE LLC
To: QUOTIENT TECHNOLOGY INC.; UBIMO LTD
Reel/Frame 064834/0950 →
SECURITY INTEREST Recorded Sep 5, 2023
From: CB NEPTUNE HOLDINGS, LLC; ONCARD MARKETING, INC.; QUOTIENT TECHNOLOGY INC.
To: CERBERUS BUSINESS FINANCE AGENCY, LLC
Reel/Frame 064805/0237 →
SECURITY INTEREST Recorded Dec 2, 2022
From: QUOTIENT TECHNOLOGY INC.; UBIMO LTD
To: BLUE TORCH FINANCE LLC, AS COLLATERAL AGENT
Reel/Frame 062040/0140 →
SECURITY INTEREST Recorded Dec 1, 2022
From: QUOTIENT TECHNOLOGY, INC.; UBIMO LTD; SAVINGSTAR, INC.
To: PNC BANK, NATIONAL ASSOCIATION
Reel/Frame 062038/0015 →
CHANGE OF NAME Recorded Nov 19, 2015
From: COUPONS.COM INCORPORATED
To: QUOTIENT TECHNOLOGY INC.
Reel/Frame 037146/0874 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Aug 24, 2015
From: AVSHALUMOV, YASHA; RENAUD, MARVIN; CHALIF, IVAN MICHAEL; MEHTA, JUSTIN MAHEN; MARLATT, SETH; BELANGER, JOHN NEUMANN
To: COUPONS.COM INCORPORATED
Reel/Frame 036396/0438 →
Continuity (3)
Continuation In Part 13944558 · Jul 17, 2013
Provisional Application 61745566 · Dec 22, 2012
Provisional Application 61788009 · Mar 15, 2013
Cited By (11)
US 12,231,428 US 12,242,504 US 12,266,004 US 12,367,268 US 12,375,381 US 12,400,036 US 12,536,157 US 12,579,169 US 12,645,745 US 12,669,979 US 12,718,270