Augmented aggregation of emailed product order and shipping information

• US 9,846,902 B2
• Filed: 01/12/2012
• Issued: 12/19/2017
• Est. Priority Date: 07/19/2011
• Status: Active Grant

• Current Assignee: Nielsen Consumer LLC (Nielsen Holdings plc)
• Original Assignee: Slice Technologies, Inc. (Rakuten Group, Inc.)
• Inventors: Brady, Scott J., Suppe, Benjamin A., Botto, Eric J., Madan, Harpinder Singh, Mastierov, Ievgen, Khosla, Aditya, Mykhaylov, Dmytry B., Verbytskyi, Georgii, Lototsky, Alexander, Mantel, Michael
• Primary Examiner(s): Mejia, Anthony
• Assistant Examiner(s): Nguyen, Linh T
• Application Number:
  US13/349,287
• Publication Number:
  US 20130024525A1
• Time in Patent Office: 2,168 Days
• Field of Search: 709206, 709203, 709217, 709219, 704 9, 704257, 704251, 704E1504, 704276, 704E15026, 704 5, 704E15018, 704E15044, 704 2, 704243, 704 4, 704E15004, 704E15008, 704E15019, 705 35, 705330, 705 1423, 705 1451, 705755, 705 39
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: G06F 16/9558 Details of hyperlinks; Management of linked annotations
• CPC Class Codes: G06F 40/174 Form filling; Merging
• CPC Class Codes: G06F 40/205 Parsing
• CPC Class Codes: G06Q 10/08 Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
• CPC Class Codes: G06Q 10/083 Shipping
• CPC Class Codes: G06Q 10/0833 Tracking
• CPC Class Codes: G06Q 10/0838 Historical data
• CPC Class Codes: G06Q 10/107 Computer-aided management of electronic mailing [e-mailing]
• CPC Class Codes: G06Q 30/0635 Processing of requisition or of purchase orders
• CPC Class Codes: H04L 51/063 Content adaptation, e.g. replacement of unsuitable content
• CPC Class Codes: H04L 51/10 Multimedia information

Abstract

Product order and shipping information received via email messages is automatically aggregated for ready user review. Once the user is authenticated, authorization to access their email mailbox is obtained and the email message headers of their entails are analyzed to identify those messages of interest. The bodies of the email messages of interest are parsed to extract the product order and shipping information which is stored and presented for display to the user typically grouped by individual product thus greatly simplifying user review of orders. The aggregated product order and shipping information can be augmented with additional information such as shipping status, delivery status, a product image, and/or a last date that the product can be returned.

Claims

1. A method, implemented on at least one server having one or more processors and memory storing one or more programs to be executed by the one or more processors, the method comprising:

for each of one or more order confirmation electronic messages,

identifying a respective merchant associated with the order confirmation electronic message,

ascertaining a respective message body format type of the order confirmation electronic message,

from a set of extraction parsers each of which is designed to parse a particular ordering of text elements in an unstructured body portion of a respective type of order confirmation electronic message, selecting a respective one of the extraction parsers in the set that is associated with the identified merchant and corresponds to the ascertained message body format type of the order confirmation electronic message, and

applying the selected extraction parser to an unstructured body portion of the order confirmation electronic message to extract a respective set of one or more product order data items corresponding to product order data types in a set of product order data types;

for each of one or more of the sets of extracted product order data items, retrieving from one or more remote servers one or more product order data items corresponding to one or more of the product order data types missing from the set of extracted product order data items, wherein the retrieving comprises sending to the one or more remote servers a request comprising data determined based on one or more of the extracted product order data items in the set of extracted product order data items;

augmenting the extracted sets of product order data with the retrieved product order data; and

storing the extracted sets of product order data and the retrieved product order data in non-transitory physical data storage.

2. The method of claim 1, wherein each type of order confirmation electronic message is associated with a respective message body format that corresponds to a respective ordering of text elements.

3. The method of claim 1, wherein the ascertaining comprises ascertaining the respective message body format type from a set of message format types comprising a text message body format type and an HTML message body format type.

4. The method of claim 1, wherein the extraction parsers comprise regular expression based parsers.

5. The method of claim 4, wherein the regular expression based parsers implement respective sets of regular expression based pattern matching rules to extract one or more product order data items corresponding to one or more product order data types in the set of product order data types from the unstructured body portion of the order confirmation electronic message.

6. The method of claim 1, wherein the extraction parsers comprise template-based extraction parsers each of which is based on a respective template that defines a respective context-free grammar that describes a respective ordering of text elements corresponding to a respective type of order confirmation electronic message body format.

7. The method of claim 6, wherein each template-based extraction parser is derived from the respective template.

8. The method of claim 1, further comprising:

aggregating the extracted product order data items by product purchased.

9. The method of claim 1, wherein the retrieving comprises retrieving an image of a particular product associated with one or more of the extracted product order data items.

10. The method of claim 9, wherein the one or more extracted product order data items associated with the particular product comprises a hypertext transfer protocol link to the image of the particular product, and retrieving the image comprises sending the hypertext transfer protocol link in the request.

11. The method of claim 9, wherein retrieving the image comprises sending a query comprising one or more of the respective extracted product order data items to an online search engine.

12. The method of claim 1, wherein the retrieving comprises retrieving shipping status information for an order associated with one or more of the extracted product order data items.

13. The method of claim 12, wherein the one or more extracted product order data items associated with the order comprises information associated with delivery of the order, and retrieving the shipping status information comprises sending the information associated with the delivery of the order in the request.

14. The method of claim 12, wherein the one or more extracted product order data items associated with the order comprises information identifying a shipper, and the retrieving comprises sending the information identifying the shipper in the request.

15. The method of claim 14, further comprising mapping the information identifying the shipper to a normalized shipper identifier, wherein the retrieving comprises retrieving the delivery status information for the order based on the normalized shipper identifier.

16. The method of claim 1, wherein the identifying comprises identifying the respective merchant associated with the order confirmation electronic message based on sender information extracted from a header portion of the order confirmation electronic message.

17. The method of claim 1, wherein the order confirmation electronic messages comprise electronic mail order confirmation messages.

20. The method of claim 1, wherein, for each of one or more of the respective sets of one or more extracted product order data items, the retrieving comprises retrieving a respective last date to return an ordered product corresponding to the respective order.

18. A system, comprising

at least one memory storing processor-readable instructions, and

at least one processor coupled to the at least one memory, operable to execute the instructions, and based at least in part on the execution of the instructions operable to perform operations comprising:

for each of one or more order confirmation electronic messages,

identifying a respective merchant associated with the order confirmation electronic message,

ascertaining a respective message body format type of the order confirmation electronic message,

from a set of extraction parsers each of which is designed to parse a particular ordering of text elements in an unstructured body portion of a respective type of order confirmation electronic message, selecting a respective one of the extraction parsers in the set that is associated with the identified merchant and corresponds to the ascertained message body format type of the order confirmation electronic message, and

applying the selected extraction parser to an unstructured body portion of the order confirmation electronic message to extract a respective set of one or more product order data items corresponding to product order data types in a set of product order data types;

for each of one or more of the sets of extracted product order data items, retrieving from one or more remote servers one or more product order data items corresponding to one or more of the product order data types missing from the set of extracted product order data items, wherein the retrieving comprises sending to the one or more remote servers a request comprising data determined based on one or more of the extracted product order data items in the set of extracted product order data items;

augmenting the extracted sets of product order data with the retrieved product order data; and

storing the extracted sets of product order data and the retrieved product order data in non-transitory physical data storage.

21. The system of claim 18, wherein the one or more extraction parsers comprise template-based extraction parsers each of which is based on a respective template that defines a respective context-free grammar that describes a respective ordering of text elements corresponding to a respective type of order confirmation electronic message body format.

19. At least one non-transitory computer readable medium comprising computing instructions comprising:

a code segment to identify a respective merchant associated with an order confirmation electronic message,

a code segment to ascertain a respective message body format type of the order confirmation electronic message,

a code segment to select a respective extraction parser from a set of extraction parsers that is associated with the identified merchant and corresponds to the ascertained message body format type of the order confirmation electronic message, wherein the extraction parsers in the set are designed to parse respective orderings of a text elements in unstructured body portions of respective types of order confirmation electronic messages, and

a code segment to apply the selected extraction parser to an unstructured body portion of the order confirmation electronic message to extract a respective set of one or more product order data items corresponding to product order data types in a set of product order data types;

a code segment to retrieve, for the set of extracted product order data items, one or more product order data items from one or more remote servers, wherein the one or more product data items correspond to one or more of the product order data types missing from the set of extracted product order data items, and the code segment to retrieve comprises a code segment to send to the one or more remote servers a request comprising data determined based on one or more of the extracted product order data items in the set of extracted product order data items; and

a code segment to store the extracted sets of product order data and the retrieved product order data in non-transitory physical data storage.

22. The at least one non-transitory computer readable medium of claim 19, wherein the one or more extraction parsers comprise template-based extraction parsers each of which is based on a respective template that defines a respective context-free grammar that describes a respective ordering of text elements corresponding to a respective type of order confirmation electronic message body format.