This short article describes how to use and implement Contact History in SAS Marketing Optimization (M0), and provides examples.
SAS Marketing Optimization (MO) can take into account historical offers made to customers when applying max/min or blocking contact policies.
If you had a contact rule that says “Only send one email per customer in three consecutive days”, and let’s assume an email was sent to the customer on Monday, then the next time that the customer could receive an email would be Thursday.
Because of this capability, it is possible to implement in MO a variety of contact policies. For example: ‘Send to a customer at most 1 email every 7 days”, “Send to a household at least 2 letters for communication X in a period of 6 months”, “If an agent contacts a customer with an investment offer, do not send emails to that customer in the next two months”
What data is needed?
Appendix I of the SAS Marketing Optimization 6.1 User’s Guide mentions in detail the characteristics of the additional three tables needed. The screen shots below describe an implementation where the time period is month, and the campaigns to optimize correspond to the period January up to April, and 4 months is the longest period of the max/min contact policies. For this example, I added these three tables to the MO Sample input data that is included with every MO installation.
Time Period Table
Establishes a sequence of the time periods that are contained in the Communication AND Communication History tables. Two columns are required: time_period and order_no. Additional user columns can be added to be used later on as communication filters. For example, a column named quarters could have the values Qtr1, Qtr2, etc.
Communication History Table
This table must contain all of the required and user-defined columns that are in the Communication table. It must also contains one additional column that is required and does not exist in the Communication table called unique_comm_mapping_id, which must be unique. The same column must also exist in the Contact History table
Contact History table
MO matches the values in the Contact History table to those that are listed in the Communication History table to determine which offers a customer has already received. It contains one row for each contact that has already been made to each customer. This table contains two required columns. The customer ID column matching the customer ID in the Customer table. The second column is called unique_comm_mapping_id.
Notice in the Communications table (below) the values of the time_period column, they are for future campaigns starting on January up to April. Notice in the Communication History table that the time periods correspond to past campaigns ran from September to December. Notice that the Time Period table has values from September up to April.
Settings in the User Interface
If the input data for the scenario uses contact history then select the Objective Page, select Advanced and check the box for “Include contact history in optimization.” This selections is only available if you have contact history tables.