Patent ID: 8473344
Filing Date: 2013-06-25
Classification: G06Q

Abstract:
1. A computer implemented method for producing a contact history of communications made to a contact comprising information on when and how the communications were made during a marketing campaign, the method comprising: generating by one or more computers a promotion version history table for the marketing campaign, with the promotion version history table recording promotion attribute values for a promotion version; generating by the one or more computers a treatment history table for the marketing campaign, with the treatment history table representing promotion instances assigned to a group; generating by the one or more computers a contact history table for the marketing campaign, with the contact history table recording one or more contact entities assigned to the group; generating a first pointer to link the promotion version history table to one or more of the treatment history table and the contact history table; generating a second pointer to link the contact history table to one or more of the promotion version history table and the treatment history table, wherein the first and second pointers to linking preserve referential integrity among the promotion version history table, the treatment history table, and the contact history table; retrieving by the one or more computers the contact history for a particular contact.