Subscription membership marketing application for the internet

• US 7,257,596 B1
• Filed: 11/09/2000
• Issued: 08/14/2007
• Est. Priority Date: 11/09/2000
• Status: Expired due to Fees

• Current Assignee: Integrated Marketing Technology Incorporated
• Original Assignee: Integrated Marketing Technology Incorporated
• Inventors: Wolf, Mace, Williams, Gregg, Tucker, Jim
• Primary Examiner(s): TARAE, CATHERINE MICHELLE
• Application Number:
  US09/709,211
• Time in Patent Office: 2,469 Days
• Field of Search: 705/10, 707/102, 707/104.1, 707/204
• US Class Current: 1/1
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G06Q 30/0201 Market modelling; Market analysis; Collecting market data
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

The present invention provides network based reporting techniques designed to meet the needs of subscription based marketers. Clients access, edit report on, and analyze their subscriber database using the Internet, for example. In a representative embodiment, a plurality of client computers connect to the Internet using a local area network (LAN), for example. The client computers pass security protocols before gaining access to web, application and database servers. Once connected, the client computers are able to retrieve and display information using a web browser. Database contents are denormalized to provide the capability to generate reports based upon relatively large amounts of information. In addition, the data is transformed into a structure specifically to facilitate and enhance multi-channel subscription marketing activities.

Claims

1. A method for analyzing direct marketing subscription information comprising:

receiving a plurality of direct marketing subscription information, wherein the direct marketing subscription information is not structured hierarchically;

archiving the plurality of direct marketing subscription information into a repository;

retrieving from the repository a plurality of selected direct marketing subscription information;

transforming the plurality of selected direct marketing subscription information into a plurality of transition table format information;

populating a facts database with the transition table format information to produce at least one of a plurality of facts tables with a summarization of the transition table format information, wherein the facts tables are structured hierarchically;

denormalizing the summarization of the transition table format information to produce a plurality of denormalized information, wherein denormalizing comprises propagating information from one table to another, wherein each of the tables is at a different level of a hierarchical structure based on the hierarchy of the facts tables; and

providing a report based upon the denormalized information, wherein the report is provided to a user via a browser application.

2. The method of claim 1 wherein the denormalizing comprises:

populating selected information from at least one of a plurality of facts tables to a key table.

3. The method of claim 2 wherein the facts tables are stored in a facts table database.

4. The method of claim 3 wherein the key table is stored in a groupings table database.

5. The method of claim 2 the at least one of a plurality of facts tables comprises a source category table, a source table, a campaign table, and a panels table, wherein the source category table is at a hierarchical level above the source table, which is at a hierarchical level above the campaign table, which is at a hierarchical level above the panels table.

6. The method of claim 1 further comprising:

receiving input of at least one criteria for at least one of a plurality of reports; and

providing the report based upon the denormalized information according to the at least one criteria.

7. The method of claim 1 further comprising:

receiving input of at least one criteria for at least one of a plurality of tables; and

configuring the at least one of the plurality of tables based upon the at least one criteria.

8. The method of claim 1 further comprising:

receiving input of at least one of a username and a password;

verifying whether the input of the at least one of a username and a password corresponds to a user authorized to access reporting procedures; and

providing access to reporting procedures to the user if the user is determined to be authorized.

9. The method of claim 8 further comprising:

verifying whether the input of the at least one of a username and a password corresponds to a user authorized to access administrative procedures; and

providing access to administrative procedures to the user if the user is determined to be authorized.

26. The method of claim 1 further comprising:

receiving additional direct marketing subscription information;

archiving the additional direct marketing subscription information in the repository;

retrieving from the repository selected additional direct marketing subscription information;

transforming the selected additional direct marketing subscription information into a transition table format associated with the transition table format information; and

appending the facts database with the additional direct marketing subscription information in the transition table format.

36. The method of claim 1 wherein when propagating information from one table to another table, the table from which information is being propagated is at a higher level in the hierarchical structure than the table to which information is being propagated to.

10. A method for analyzing direct marketing subscription information comprising:

receiving a plurality of direct marketing subscription information;

archiving the plurality of direct marketing subscription information into a repository;

retrieving from the repository a plurality of selected direct marketing subscription information;

transforming the plurality of selected direct marketing subscription information into transition table format information;

populating a facts database with the transition table format information to produce at least one of a plurality of facts tables with a summarization of the transition table format information, wherein the facts tables are structured hierarchically;

denormalizing the summarization of the transition table format information to produce a plurality of denormalized information, the denormalizing comprising populating selected information from at least one of a plurality of facts tables, stored in a facts table database, to a key table, stored in a groupings tables database, wherein the denormalizing further comprises propagating the selected information from one table to another, each of the tables being at a different level of a hierarchical structure based on the hierarchy of the facts tables; and

providing a report based upon the denormalized information, wherein the report references the key table and not the at least one of the plurality of facts tables, the at least one of the plurality of facts tables includes at least one of a source category table, a source table, a campaign table, or a panels table.

11. The method of claim 10 further comprising:

receiving input of at least one criteria for at least one of a plurality of reports; and

providing the report based upon the denormalized information according to the at least one criteria.

12. The method of claim 10 further comprising:

receiving input of at least one criteria for at least one of a plurality of tables; and

configuring the at least one of the plurality of tables based upon the at least one criteria.

13. The method of claim 10 further comprising:

receiving input of at least one of a username and a password;

verifying whether the input of the at least one of a username and a password corresponds to a user authorized to access reporting procedures; and

providing access to reporting procedures to the user if the user is determined to be authorized.

14. The method of claim 13 further comprising:

verifying whether the input of the at least one of a username and a password corresponds to a user authorized to access administrative procedures; and

providing access to administrative procedures to the user if the user is determined to be authorized.

27. The method of claim 10 wherein the key table is the only table in the facts database used in generating the report.

37. The method of claim 10 wherein when propagating information from one table to another table, the table from which information is being propagated is at a higher level in the hierarchical structure than the table to which information is being propagated to.

15. A computer program product for analyzing direct marketing subscription information, the computer program product comprising:

code that receives a plurality of direct marketing subscription information;

code that archives the plurality of direct marketing subscription information into a repository;

code that retrieves from the repository a plurality of selected direct marketing subscription information;

code that transforms the plurality of selected direct marketing subscription information into transition table format information;

code that populates a facts database with the transition table format information to produce at least one of a plurality of facts tables with a summarization of the transition table format information, wherein the facts tables are structured hierarchically;

code that denormalizes the summarization of the transition table format information to produce a plurality of denormalized information, the denormalization comprising populating selected information from at least one of a plurality of facts tables, stored in a facts table database, to a key table, stored in a groupings tables database, wherein the denormalization further comprises propagating information from one table to another, each of the tables being at a different level of a hierarchical structure based on the hierarchy of the facts tables;

code that provides a report based upon the denormalized information, the code that provides the report being arranged to reference the key table to provide the report; and

a computer readable storage medium for holding the code.

16. The computer program product of claim 15 further comprising:

code that receives input of at least one criteria for at least one of a plurality of reports; and

code that provides the report based upon the denormalized information according to the at least one criteria.

17. The computer program product of claim 15 further comprising:

code that receives input of at least one criteria for at least one of a plurality of tables; and

code that configures the at least one of the plurality of tables based upon the at least one criteria.

18. The computer program product of claim 15 further comprising:

code that receives input of at least one of a username and a password;

code that verifies whether the input of the at least one of a username and a password corresponds to a user authorized to access reporting procedures; and

code that provides access to reporting procedures to the user if the user is determined to be authorized.

19. The computer program product of claim 18 further comprising:

code that verifies whether the input of the at least one of a username and a password corresponds to a user authorized to access administrative procedures; and

code that provides access to administrative procedures to the user if the user is determined to be authorized.

20. An apparatus for analyzing direct marketing subscription information comprising:

means for receiving a plurality of direct marketing subscription information;

means for archiving the plurality of direct marketing subscription information into a repository;

means for retrieving from the repository a plurality of selected direct marketing subscription information;

means for transforming the plurality of selected direct marketing subscription information into transition table format information;

means for populating a facts database with the transition table format information to produce at least one of a plurality of facts tables with a summarization of the transition table format information, wherein the facts tables are structured hierarchically;

means for denormalizing the summarization of the transition format information to produce a plurality of denormalized information, the means for denormalizing comprising populating selected information from at least one of a plurality of facts tables, stored in a facts table database, to a key table, stored in a groupings tables database, wherein the means for denormalizing further comprises propagating information from one table to another, each of the tables being at a different level of a hierarchical structure based on the hierarchy of the facts tables; and

means for providing a report based upon the denormalized information, the report being arranged to reference the key table.

21. A system for analyzing direct marketing subscription information comprising:

at least one of a plurality of clients;

a web server connected to the at least one of a plurality of clients by a computer network;

an application server; and

a database server;

connected to the application server and the web server by a communication medium, wherein the at least one client receives a plurality of direct marketing subscription information and forwards the plurality of direct marketing subscription information via the web server and the application server to the database server, which archives the plurality of direct marketing subscription information into a repository, and wherein

the application server retrieves from the repository a plurality of selected direct marketing subscription information and transforms the plurality of selected direct marketing subscription information into transition table format information,

the database server populates a facts database with the transition table format information to produce at least one of a plurality of facts tables with a summarization of the transition table format information, wherein the facts tables are structured hierarchically,

the application server denormalizes the summarization of the transition format information to produce a plurality of denormalized information, the denormalization comprising populating selected information from at least one of a plurality of facts tables, stored in a facts table database, to a key table, stored in a groupings tables database and propagating information from one table to another, each of the tables being at a different level of a hierarchical structure based on the hierarchy of the facts tables, and

the application server provides a report based upon the denormalized information, the report being arranged to reference the key table.

22. The system of claim 21 wherein the at least one of a plurality of clients receives input of at least one criteria for at least one of a plurality of reports;

and forwards the input via the web server to the application server, which provides the report based upon the denormalized information according to the at least one criteria.

23. The system of claim 21 wherein the at least one of a plurality of clients receives input of at least one criteria for at least one of a plurality of tables;

and forwards the input via the web server to the application server, which configures the at least one of the plurality of tables based upon the at least one criteria.

24. The system of claim 21 wherein the at least one of a plurality of clients receives input of at least one of a username and a password;

and forwards the input via the web server to the application server, which verifies whether the input of the at least one of a username and a password corresponds to a user authorized to access reporting procedures; and

provides access to reporting procedures to the user if the user is determined to be authorized.

25. The system of claim 24 wherein the application server verifies whether the input of the at least one of a username and a password corresponds to a user authorized to access administrative procedures;

and provides access to administrative procedures to the user if the user is determined to be authorized.

28. A method of analyzing direct marketing subscription information comprising:

providing a plurality of direct marketing subscription information, wherein the direct marketing subscription information is not structured hierarchically;

transforming a subset of the plurality of direct marketing subscription information into a plurality of transition tables, structured hierarchically, comprising;

using a first set of stored procedures, generating a first lookup table for a lookup database, wherein the first lookup table comprises a first level of a hierarchical structure;

using a second set of stored procedures, generating a second lookup table for a lookup database by propagating at least a portion of information from the first lookup table to the second lookup table, wherein the second lookup table comprises a second level of the hierarchical structure, below the first level; and

using a third set of stored procedures, generating a key table by denormalizing the first and second lookup tables in the facts database, wherein the key table comprises the first and second levels of the hierarchical structure; and

generating a first report by using the key table, without referring to the first or second lookup tables, whereby generating the first report without referring to the first or second lookup tables reduces disk access, thereby improving performance.

29. The method of claim 28 wherein the first lookup table is a source table, and the second lookup table is a campaign table.

30. The method of claim 29 wherein information in a product identification field, source category name field, and source name field are propagated from the source table to the campaign table.

31. The method of claim 28 further comprising:

forming a third lookup table by propagating at least a portion of information from the second lookup table to the third lookup table, wherein the lookup database also comprises the third lookup tables, and the generating the key table further comprises denormalizing the third lookup table.

32. The method of claim 28 wherein when generating the first report, the first and second lookup tables are not used.

33. The method of claim 28 further comprising:

receiving a request to generate a second report after generating the first report, wherein the second report will be different from the first report; and

generating the second report by using the key table, without referring to the first or second lookup tables, whereby generating the second report without referring to the first or second lookup tables reduces disk access, thereby improving performance.

34. The method of claim 33 wherein the second report comprises at least one hyperlink to the first report.

35. The method of claim 28 further comprising:

providing a web browser interface through which a plurality of reports may be requested; and

when receiving a report request through the web browser interface, generating a report by using the key table, where the key table has not been regenerated between report requests.

38. The method of claim 28 further comprising:

updating the key table via an on-line administrative interface from a browser program executing on a client device.

39. The method of claim 28 further comprising:

revising the first lookup table; and

regenerating the key table using the revised first lookup table, without regenerating the second lookup table using the revised first lookup table.

40. The method of claim 28 further comprising:

saving the first report in a saved reports table; and

upon receiving a second report request from a client device, generating a second report using the key table, wherein the second report comprises at least one hyperlink to the first report in the saved reports table.

41. The method of claim 28 wherein

saving the first report in a saved reports table;

and

upon receiving a second report request from a client device, generating a second report using the key table, wherein the second report comprises a plurality of hyperlinks, wherein at least one hyperlink is to the first report and at least one hyperlink will cause generating a third report using the key table.

42. A method of analyzing direct marketing subscription information comprising:

providing a plurality of direct marketing subscription information;

transforming a subset of the plurality of direct marketing subscription information into a plurality of transition tables;

using the plurality of transition tables, generating a first lookup table, wherein the first lookup table comprises a first level of a hierarchy of the transition tables;

creating a second lookup table by propagating at least a portion of information from the first lookup table to the second lookup table, wherein the second lookup table comprises a second level of the hierarchy of the transition tables, which is below the first level of the hierarchy;

creating a third lookup table by propagating at least a portion of information from the second lookup table to the third lookup table, wherein the third lookup table comprises a third level of the hierarchy of the transition tables, which is below the second level of the hierarchy;

creating a fourth lookup table by propagating at least a portion of information from the third lookup table to the fourth facts table, wherein the fourth lookup table comprises a fourth level of the hierarchy of the transition tables, which is below the third level of the hierarchy;

generating a key table by denormalizing the first, second, third, and fourth lookup tables; and

upon receiving a first report request from a client device, generating a first report using the key table without using to the first, second, third, and fourth lookup tables.

43. The method of claim 42 wherein a lookup tables database comprises the first, second, third, and fourth lookup tables.

44. The method of claim 42 wherein a first stored procedure is used to create the second facts table.

45. The method of claim 42 wherein contents of the second, third, and fourth facts tables are user customizable.

46. The method of claim 42 further comprising:

displaying the first report on the client device.

47. The method of claim 42 further comprising:

saving the first report in a saved reports table; and

upon receiving a second report request from a client device, generating a second report using the key table, wherein the second report comprises at least one hyperlink to the first report in the saved reports table.

48. The method of claim 42 wherein

saving the first report in a saved reports table;

and

upon receiving a second report request from a client device, generating a second report using the key table, wherein the second report comprises a plurality of hyperlinks, wherein at least one hyperlink is to the first report and at least one hyperlink will cause generating a third report using the key table.