System for collaborative internet competitive sales analysis

• US 8,055,548 B2
• Filed: 06/23/2006
• Issued: 11/08/2011
• Est. Priority Date: 06/23/2006
• Status: Expired due to Fees

• Current Assignee: STB Enterprises
• Original Assignee: STB Enterprises
• Inventors: Staib, William E., Blodgett, Dean Scott
• Primary Examiner(s): HAQ, NAEEM U
• Application Number:
  US11/473,912
• Publication Number:
  US 20070299743A1
• Time in Patent Office: 1,964 Days
• Field of Search: 705/26, 705/27, 705/26.1, 705/26.2, 705/26.25, 705/26.3, 705/26.35, 705/26.4, 705 2641- 2644, 705/26.5, 705 2661- 2664, 705/26.7, 705/26.8, 705/26.81, 705/26.82, 705/26.9, 705/27.1, 705/27.2
• US Class Current: 705/26.1
• CPC Class Codes: G06Q 10/107 Computer-aided management of electronic mailing [e-mailing]
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G06Q 30/0204 Market segmentation
• CPC Class Codes: G06Q 30/0601 Electronic shopping [e-shopping]
• CPC Class Codes: G06Q 30/0603 Catalogue ordering

Abstract

A method for cataloging and reporting Internet merchant data uses a data center for receiving a plurality of site activity messages regarding two or more seller sites and provides a standardized taxonomy schema with a node for each of two or more products. The method derives from the plurality of site activity messages a sales metric for the two or more products and for a specific time period, aggregates the sales metric data for each of the two or more seller sites and the two or more products, then derives a comparative report for the sales metric for the two or more seller sites, by reference to at least one of the two or more products in the standardized taxonomy schema.

Claims

1. A computer-implemented method for cataloging and reporting Internet merchant data comprising:

using a computer processor to execute the steps of

receiving at a data center a plurality of site activity messages regarding two or more seller sites and storing the site activity messages in computer readable memory;

retrieving a standardized taxonomy schema with a node for each of two or more products;

deriving from the plurality of site activity messages a sales metric for the two or more products;

for a specific time period, aggregating the sales metric data for each of the two or more seller sites and the two or more products; and

deriving a comparative report for the sales metric for the two or more seller sites, by reference to at least one of the two or more products in the standardized taxonomy schema, wherein the two or more seller sites in the comparative report are selected based upon similarities of a seller site profile vector calculated for each of the seller sites, wherein the seller site profile vector comprises a distribution of total merchant sales of the seller site for each of at least two nodes of the standardized taxonomy schema over the specific time period.

2. The method of claim 1 wherein the step of receiving at a data center a plurality of site activity messages comprises receiving messages with product identification and sales transaction data.

3. The method of claim 1 wherein the step of retrieving a standardized taxonomy schema comprises retrieving a standardized taxonomy schema in the form of a tree having at least a specific product level with a node for each of two or more products and a product category level with at least one node that encompasses two or more products from the specific product level.

4. The method of claim 3 wherein the step of deriving a comparative report for the sales of the two or more seller sites comprises deriving a report for a specific product or product category in the standardized taxonomy schema in response to having sufficient aggregated data for the at least one specific product or product category.

5. The method of claim 3, wherein:

the step of deriving from the plurality of site activity messages a sales metric for the two or more products comprises computing for each of the two or more seller sites and for each specific product and each product category level in the standardized taxonomy schema a sales metric and associating the computed sales metric with each of the nodes of the standardized taxonomy as applied to each of the two or more seller sites.

6. The method of claim 3 further comprising applying to the activity messages a fraud filter to detect transactions that are not legitimate messages from a seller site that subscribes to activities of the data center.

7. The method of claim 1 wherein the step of receiving at a data center from a plurality of site activity messages comprises receiving messages by a method selected from the group comprising:

Javascript messages from Javascript embedded on website pages;

an HTML image;

a proxy server forwarder or signed browser applet;

server-to-server communications in a CGI application, a SOAP call, an XML message, a Web log, spreadsheet or a proprietary protocol to convey data; and

a persistent browser cookie combined with JavaScript technology.

8. The method of claim 1 wherein the step of deriving from the plurality of site activity messages a sales metric comprises deriving a sales metric from the group comprising:

sales revenue, unit sales, average order size, average shipping charges, average discount;

purchase conversion rate;

profit margin;

profit;

return on advertising spend;

success of various referring channels, peak transaction days and times, most popular promotions, best selling products;

distribution statistics on order size, distribution statistics on shipping charges, distribution statistics on discounts; and

any pricing statistic.

9. A computer-implemented method for cataloging and reporting Internet merchant data comprising:

using a computer processor to execute the steps of;

receiving at a data center a plurality of site activity messages regarding two or more seller sites and storing the site activity messages in computer readable memory;

retrieving a standardized taxonomy schema in the form of a tree having at least a specific product level with a node for each of two or more products and a product category level with at least one node that encompasses two or more products from the specific product level;

computing from the plurality of site activity messages, for each of the two or more seller sites and for each specific product and each product category level in the standardized taxonomy schema a sales metric wherein the computed sales metric is associated with each of the nodes of the standardized taxonomy as applied to each of the two or more seller sites;

for a specific time period, aggregating the sales metric data for each of the two or more seller sites and each of the two or more products;

deriving a site profile vector by selecting specific product or product category nodes by identifying at least one node and an associated computed sales metric for each of the two or more seller sites that exceeds a materiality threshold M % and defining a profile vector with reference to such at least one node and

deriving a comparative report for the sales metric for the two or more seller sites, by reference to the sales metric of at least one of the two or more products in the standardized taxonomy schema wherein the two or more seller sites that are compared share similar seller site profile vectors.

10. The method of claim 9 wherein the step of deriving a profile vector further comprises deriving a profile vector in the form:

{product/category1/X₁%, product/category2/X₂%, product/category3/X₃%, . . . product/categoryN/X_N%}where, product/categoryN is a product or product category node label in the standardized taxonomy and X_N is a associated sales metric greater than or equal to M %.

11. A computer-implemented method for cataloging and reporting Internet merchant data comprising:

defining a contribution threshold C;

using a computer processor to execute the steps of;

receiving at a data center a plurality of site activity messages regarding two or more seller sites and storing them in computer readable memory;

retrieving a standardized taxonomy schema in the form of a tree having at least a specific product level with a node for each of two or more products and a product category level with at least one node that encompasses two or more products from the specific product level;

computing from the plurality of site activity messages, for each of the two or more seller sites and for each specific product and each product category level in the standardized taxonomy schema a sales metric wherein the computed sales metric is associated with each of the nodes of the standardized taxonomy as applied to each of the two or more seller sites;

responsive to a computed sales metric associated with one of the nodes of the standardized taxonomy exceeding contribution threshold C, applying a dampening algorithm to the computed sales metric;

for a specific time period, aggregating the sales metric data for each of the two or more seller sites and the two or more products;

deriving a seller site profile vector by selecting specific product or product category nodes by identifying at least one node and an associated computed sales metric for two or more seller sites and defining a profile vector with reference to such at least one node; and

deriving a comparative report for the sales metric for the two or more seller sites, by reference to the sales metric of at least one of the two or more products in the standardized taxonomy schema wherein the two or more seller sites that are compared share similar seller site profile vectors.

12. The method of claim 11 wherein the dampening algorithm uses a reduction factor applied iteratively to the computed sales metric until the computed sales metric value associated with the one of the nodes of the standardized taxonomy that exceeds the contribution threshold C no longer exceeds C.

13. A method for characterizing data organized in a standardized taxonomy schema in the form of a tree having a lowest level with a node for two or more categories for that lowest level and at least one higher level with at least one node that encompasses the two or more categories from the lowest level, the method comprising:

defining a common metric for use at each node;

using a computer processor to execute the steps of;

for a reporting entity selected from the group consisting of an on-line seller of products, using a standardized hierarchical taxonomy schema of product categories, an investment portfolio, using a standardized hierarchical taxonomy schema of investment asset categories, and an accounting entity using a standardized hierarchical taxonomy schema of accounting categories, computing for data associated with each of a plurality of nodes in the standardized taxonomy schema the common metric; and

deriving a profile vector for the reporting entity by selecting at least one node from the lowest level or at least one higher level with an associated computed common metric for a specified reporting entity that exceeds a materiality threshold M % and defining a profile vector with reference to such at least one node that reflects the magnitude of the computed common metric for each node.

14. The method of claim 13 wherein the step of deriving a profile vector comprises defining a profile vector in the form:

{category 1/X₁%, category2/X₂%, category3/X₃% . . . categoryN/X_N%} where, categoryN is a node label in the standardized taxonomy and X_N is the corresponding computed common metric greater than or equal to M %.

15. The method of claim 13 wherein the reporting entity is an investment portfolio, the standardized taxonomy schema is a hierarchical set of investment asset categories and the computed common metric is the value of the assets in the portfolio that are in the category of any node.

16. The method of claim 13 wherein the reporting entity is an accounting entity, the standardized taxonomy schema is a hierarchical set of accounting categories and the computed common metric is the value assigned to the accounting category of any node.

17. The method of claim 13 further comprising limiting the number of elements in the profile vector to a value N that is at least an order of magnitude less in size that total number of nodes in the standardized taxonomy schema.

18. The method of claim 13 further comprising limiting the number of elements in the profile vector to a value N that is 100 or less.

19. The method of claim 13 further comprising:

limiting the number of element in the profile vector to a value N that is 20 or less; and

outputting to a computer display or printer the elements of the profile vector in a form selected from the group comprising a pie chart, a bar graph and a tabular listing .

20. The method of claim 13 further comprising correcting the magnitude of the computed common metric of a parent node of a selected node by removing from the magnitude of the computed common metric of the parent node the magnitude of the computed common metric of the selected node.

21. A method for characterizing data organized in a standardized taxonomy schema in the form of a tree having a lowest level with a node for two or more categories for that lowest level and at least one higher level with at least one node that encompasses the two or more categories from the lowest level, the method comprising:

defining a common metric for use at each node;

using a computer processor to execute the steps of;

for a reporting entity, selected from the group consisting of;

an on-line seller of products, using a standardized hierarchical taxonomy schema of product categories, an investment portfolio, using a standardized hierarchical taxonomy schema of investment asset categories, and an accounting entity using a standardized hierarchical taxonomy schema of accounting categories, computing for data associated with each of a plurality of nodes in the standardized taxonomy schema the common metric; and

deriving a profile vector for the reporting entity by selecting more than one node from the lowest level or at least one higher level which is responsive to the magnitude of the computed common metric for each node, whereby the profile vector has multiple elements and further comprising placing the elements in an ordered list.

22. The method of claim 21 wherein the ordered list is based on the magnitude of the computed common metric.

23. A computer-implemented method for collecting sales data from Internet merchant data comprising:

using a computer processor to execute the steps of;

receiving at a data center a plurality of site activity messages regarding two or more seller sites, said messages generated by at least one internet web-page of the two or more seller sites in response to a user viewing the web-page or purchasing a product offered for sale on the web-page, and containing sales data from one or more channels and search string information used by a user of the internet web-page to locate the internet web-page that generated the site activity message;

storing the site activity messages in computer readable memory;

deriving from the plurality of site activity messages sales data for at least one product category in a taxonomy schema; and

for a specific time period aggregating the sales data for the two or more seller sites and deriving an inferred product sales data report that includes information on the search string information contained in the site activity messages.

24. The method of claim 23 wherein the step of receiving at a data center a plurality of site activity messages comprises receiving product view activity messages that include or reference product sales prices.

25. The method of claim 23 wherein the step of receiving at a data center a plurality of site activity messages comprises receiving sales activity messages that include or reference product sales prices.

26. The method of claim 23 wherein the step of receiving at a data center a plurality of site activity messages comprises receiving activity messages that include referring source information from two or more referring sources and sorting the sales data responsive to the two or more referring sources.

27. The method of claim 26 wherein the two or more referring sources are price comparison sites.

28. A computer-based system for cataloging and reporting Internet merchant data comprising:

database configured to receive a plurality of site activity messages regarding two or more seller sites;

a computer processor coupled to computer readable memory and programmed to;

retrieve a standardized taxonomy schema with a node for each of two or more products;

derive from the plurality of site activity messages a sales metric for the two or more products;

aggregate for a specific time period the sales metric data for each of the two or more seller sites and the two or more products; and

derive a comparative report for the sales metric for the two or more seller sites, by reference to at least one of the two or more products in the standardized taxonomy schema wherein the two or more seller sites in the comparative report are selected based upon similarities of a seller site profile vector calculated for each of the seller sites, wherein the seller site profile vector comprises a distribution of total merchant sales of the seller site for each of at least two nodes of the standardized taxonomy schema over the specific time period.

29. The system of claim 28 wherein the database receives messages with product identification and sales transaction data.

30. The system of claim 28 wherein the standardized taxonomy schema comprises a standardized taxonomy schema in the form of a tree having at least a specific product level with a node for each of two or more products and a product category level with at least one node that encompasses two or more products from the specific product level.

31. The system of claim 30 wherein the comparative report for the sales of the two or more seller sites comprises a report for a specific product or product category in the standardized taxonomy schema in response to having sufficient aggregated data for the at least one specific product or product category.

32. The system of claim 30, wherein:

the computer processor is further programmed to derive from the plurality of site activity messages a sales metric for each of the two or more seller sites and for each specific product and each product category level in the standardized taxonomy schema and associate the computed metric with each of the nodes of the standardized taxonomy as applied to each of the two or more seller sites.

33. The system of claim 28 wherein the a data center is configured to receive messages by a method selected from the group comprising:

Javascript messages from Javascript embedded on website pages;

an HTML image;

a proxy server forwarder or signed browser applet;

server-to-server communications in a CGI application, a SOAP call, an XML message, a Web log, spreadsheet or a proprietary protocol to convey data; and

a persistent browser cookie combined with JavaScript technology.

34. The system of claim 28 wherein the computer processor is further programmed to derive the sales metric from the group comprising:

sales revenue, unit sales, average order size, average shipping charges, average discount;

purchase conversion rate;

profit margin;

profit;

return on advertising spend;

success of various marketing channels, peak transaction days and times, most popular promotions, best selling products;

distribution statistics on order size, distribution statistics on shipping charges, distribution statistics on discounts; and

any pricing statistic.

35. The system of claim 28 wherein the computer processor further is programmed to apply to the activity messages a fraud filter to detect transactions that are not legitimate messages from a seller site that subscribes to activities of the data center.

36. The system of claim 28 wherein the computer processor is further programmed to map a product and a product category schema of a seller site into and out of the standardized taxonomy schema for configuring reports using the product and a product category schema of the seller site.

37. A computer-based system for cataloging and reporting Internet merchant data comprising:

a data center configured to receive a plurality of site activity messages regarding two or more seller sites;

a computer processor coupled to computer readable memory and programmed to;

retrieve a standardized taxonomy schema in the form of a tree having at least a specific product level with a node for each of two or more products and a product category level with at least one node that encompasses two or more products from the specific product level;

derive from the plurality of site activity messages a sales metric for each of the two or more seller sites and for the two or more products and for each product category level in the standardized taxonomy schema;

aggregate for a specific time period the sales metric data for each of the two or more seller sites and the two or more products;

associate the computed metric with each of the nodes of the standardized taxonomy as applied to each of the two or more seller sites;

derive for at least one seller site a profile vector by selecting specific product or product category nodes by identifying at least one node and an associated computed metric for the at least one seller site that exceeds a materiality threshold M % and defines a profile vector with reference to such at least one node responsive to the level of the computed metric for each product or product category node; and

derive a comparative report for the sales metric for the two or more seller sites, by reference to at least one of the two or more products in the standardized taxonomy schema wherein the two or more seller sites that are compared share similar seller site profile vectors.

38. The system of claim 37 wherein the profile vector takes the form:

{product/category1/X₁%, product/category2/X₂%, product/category3/X₃%, . . . product/categoryN/X_N%} where, product/categoryN is a product or product category node label in the standardized taxonomy and X_N is a associated sales metric greater than or equal to M %.

39. A computer-based system for cataloging and reporting Internet merchant data comprising:

a data center configured to receive a plurality of site activity messages regarding two or more seller sites;

a computer processor coupled with computer readable memory and programmed to;

retrieve from the computer readable memory a standardized taxonomy schema in the form of a tree having at least a specific product level with a node for each of two or more products and a product category level with at least one node that encompasses two or more products from the specific product level;

derive from the plurality of site activity messages a sales metric for each of the two or more seller sites and for the two or more products and for each product category level in the standardized taxonomy schema;

retrieve from computer readable memory a contribution threshold C;

apply a dampening algorithm to the computed sales metric when a computed sales metric associated with one of the nodes of the standardized taxonomy exceeds the contribution threshold C ;

aggregate for a specific time period the sales metric data for each of the two or more seller sites and the two or more products;

associate the computed metric with each of the nodes of the standardized taxonomy as applied to each of the two or more seller sites;

derive a profile vector by selecting specific product or product category nodes by identifying at least one node and an associated computed metric for the two or more seller sites and defining a profile vector with reference to such at least one node that reflects the level of the computed metric for each product or product category node; and

derive a comparative report for the sales metric for the two or more seller sites, by reference to at least one of the two or more products in the standardized taxonomy schema wherein the two or more seller sites that are compared share similar seller site profile vectors.

40. The system of claim 39 wherein the dampening algorithm uses a reduction factor applied iteratively to the computed metric until the computed metric associated with the one of the nodes of the standardized taxonomy that exceeds the contribution threshold C no longer exceeds C.

41. The system of claim 39 wherein the dampening algorithm removes from a report the identity of a seller site that exceeds the contribution threshold C.

42. The system of claim 39 wherein the dampening algorithm reduces for reporting purposes the computed metric of a seller site that exceeds the contribution threshold C.