System and method for managing marketing applications for a website

• US 20030005046A1
• Filed: 06/05/2002
• Published: 01/02/2003
• Est. Priority Date: 06/06/2001
• Status: Abandoned Application

• Current Assignee: Lagniappe Marketing
• Original Assignee: Lagniappe Marketing
• Inventors: Ewry, Ralph, Brohaugh, William, Kavanagh, Lawrence
• Application Number:
  US10/161,603
• Publication Number:
  US 20030005046A1
• Time in Patent Office: Days
• US Class Current: 709/203
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G06Q 30/0212 Chance discounts or incentives
• CPC Class Codes: G06Q 30/0224 based on user history
• CPC Class Codes: G06Q 30/0226 Incentive systems for frequent usage, e.g. frequent flyer miles programs or point systems
• CPC Class Codes: G06Q 30/0255 based on user history
• CPC Class Codes: G06Q 30/0601 Electronic shopping [e-shopping]

Abstract

A system and method for managing marketing applications for a website is disclosed. The website has webpages that perform e-commerce transaction by offering products to users and customers of the website. The website is coupled to a database having database tables. The database tables include information in performing marketing processes and applications. Further, a cookie identification and a customer number may be received or generated that identifies the user to the website. The cookie identification and customer number are used within the database tables along with product numbers and other information to display products or information to the user in a tailored manner, to generate upsell products for display, to deliver abandoned cart emails to the user. Further, the user may click on an embedded URL to provide unique information referenced in the database table. The user registers for e-newsletters on the website and promotional copy that is displayed using the cookie identification, the customer number and the database table. Other marketing applications and features are implemented using customer information, product information and the database tables to increase potential sales.

Claims

1. A method for displaying a webpage in a tailored manner, comprising:

matching a cookie identification to a customer number in a customer database table;

matching a referral URL domain name in a referral URL database table to a source code;

embedding said source code within a referral URL and matching said source code with said customer number;

matching a source code with said customer number;

matching said source code in a source code database table to an offer code;

matching said offer code to corresponding offer text and an offer discount in an offer code database table; and

displaying a webpage with said offer text and said offer discount.

2. The method of claim 1, further comprising receiving said cookie identification at said website.

3. The method of claim 1, further comprising entering said cookie identification corresponding to an email number into said customer database table

4. A method for generating upsell products for display on a webpage, comprising:

measuring a frequency of a combination of a product number and an upsell product number;

entering said combination of said product number and said upsell product number and said frequency into an upsell product database table;

referencing said upsell product database table for said product number;

determining a rank for said upsell product number according to said frequency; and

displaying said upsell product number according to said rank.

5. The method of claim 4, further comprising creating said upsell product database table for a specified time period.

6. A method for delivering abandoned cart emails to a user wherein said user visits a website, comprising:

referencing a visit detail database table for a cookie identification;

creating a list including said cookie identification;

removing said cookie identification from said list when said cookie identification is within a customer order detail database table;

removing said cookie identification from said list according to an email sent flag in a shopping cart database table;

matching said cookie identification to an email address in a customer database table;

populating a template email with text and said email address; and

sending said email to said user.

7. The method of claim 6, further comprising recording said cookie identification into said shopping cart database table for said user during a previous visit to said website.

8. A method for delivering abandoned cart emails to a new user, wherein said user receives a solicitation email and visits a website for the first time, comprising:

referencing an email number embedded in a referral URL enclosed in the solicitation email;

matching said email number to an email address in a prospective customer database table;

populating a customer database table with a cookie identification and said email address;

referencing a visit detail database table for said cookie identification;

creating a list including said cookie identification;

removing said cookie identification from said list when said cookie identification is within a customer order detail database table;

removing said cookie identification from said list according to an email sent flag in a shopping cart database table;

matching said cookie identification to said email address in said customer database table;

populating a template email with text and said email address; and

sending said email to said user.

9. A method for registering a user for an e-newsletter on a webpage, comprising:

displaying a text box for an email address from said user;

recording said email address for a cookie identification and a customer number in a customer database table;

referencing an offer code database table having promotional copy according to an offer code; and

replacing said text box with said promotional copy on said webpage.

10. The method of claim 9, further comprising entering said cookie identification and said customer number into said customer database table.

11. A method for populating categories of products for display within an e-commerce environment, comprising:

determining a time period, wherein orders for said products occur during said time period;

entering a quantity sold and a gross sales into a product sales database table for an order number within said orders;

determining a sales factor rank based upon said gross sales;

referencing a product number in said product sales database table;

entering said sales factor rank for said product number into a category rank in a category database table; and

displaying said product number according to said category rank.

12. The method of claim 11, further comprising sorting said category rank within said category.

14. The method of claim 13, further comprising identifying a category identification number for said at least one product name.

16. The method of claim 15, further comprising matching a cookie identification with said customer number in a customer database table, wherein said cookie identification is received from a computer.

13. A method for ranking products in response to a search on a website, comprising:

entering a search term into a search text box at said website;

matching said search term to at least one product name listed in a category database table; and

displaying said at least one product name according to corresponding category rank within said category database table.

15. A method for displaying an offline promotion on a webpage in an e-commerce environment, comprising:

matching said customer number with a source code in a mailed database table;

matching said source code with an offer code in a source code database table;

matching said offer code with data in an offer code database table; and

displaying said data on said webpage.