System and method for capturing and storing web site visitor profile information in a data warehouse

• US 7,043,497 B1
• Filed: 11/16/2001
• Issued: 05/09/2006
• Est. Priority Date: 11/16/2001
• Status: Active Grant

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: NCR Corporation
• Inventors: Smith, Tucker L., Haddad, Sylvie Feghali, Carty, Scott D.
• Primary Examiner(s): Rones, Charles
• Assistant Examiner(s): AL HASHEMI, SANA A
• Application Number:
  US09/990,541
• Time in Patent Office: 1,635 Days
• Field of Search: 707/104.1, 707/102, 707/103.4, 707/100, 709/219, 705/19
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A customer relationship management system for storing and managing information for an E-Business retailer. The customer relationship system includes a database system for storing and organizing said information, a logical data model defining the manner in which said information is stored and related within the database system, and a subject area within the logical data model defining the manner in which profile information concerning web site visitors to a web site operated by the E-Business retailer is stored and organized within the database system. Visitors may include any individuals, households or organizations that are of interest to the E-Business retailer. The profile information collected and organized within the database system in accordance with the logical data model may include information concerning household and organizational affiliations of said visitors; information concerning occupations of said visitors; information concerning income levels of said visitors; information concerning educational levels of said visitors; marital status information about said visitors; gender information about said visitors; ethnicity information about said visitors; residence information about said visitors; and language information about said visitors. Profile information may further include a customer score associated with each web site visitor, wherein a visitor'"'"'s customer score is determined from previous behavior of the visitor with the E-Business retailer, and is an indication of the visitor'"'"'s future behavior with the E-Business retailer.

Claims

1. A database system for storing profile data related to web site visitors to a web store web site operated by an E-Business retailer, said profile data being organized within said database system in accordance with a logical data model, said logical data model comprising a plurality of entities and relationships defining the manner in which said profile information is stored and organized within said database system, wherein said profile information includes at least one information type selected from the group consisting of:

information concerning occupations of said visitors;

information concerning income levels of said visitors;

information concerning educational levels of said visitors;

marital status information about said visitors;

gender information about said visitors;

ethnicity information about said visitors;

residence information about said visitors; and

language information about said visitors.

2. A customer relationship management system for storing and managing information for an E-Business retailer, said customer relationship management system comprising:

a database for storing and organizing said information;

a logical data model defining the manner in which said information is stored and related within said database; and

a subject area within said logical data model defining the manner in which profile information concerning web site visitors to a web store web site operated by said E-Business retailer is stored and organized within said database;

wherein said profile information includes at least one information type selected from the group consisting of;

information concerning occupations of said visitors;

information concerning income levels of said visitors;

information concerning educational levels of said visitors;

marital status information about said visitors;

gender information about said visitors;

ethnicity information about said visitors;

residence information about said visitors; and

language information about said visitors.

3. In a customer relationship system for an E-Business retailer, a method for managing profile information concerning web site visitors to a web store web site operated by said E-Business retailer, said method comprising the step of establishing a database for storing and organizing said profile information, said profile information being organized within said database in accordance with a logical data model including a plurality of entities and relationships defining the manner in which said profile information is stored and organized within said database system, wherein said profile information includes at least one information type selected from the group consisting of:

information concerning occupations of said visitors;

information concerning income levels of said visitors;

information concerning educational levels of said visitors;

marital status information about said visitors;

gender information about said visitors;

ethnicity information about said visitors;

residence information about said visitors; and

language information about said visitors.