Exercise

Restaurant Spending Promotion

​In addition to the Sephora promotion, your company has also decided to launch a restaurant-spending promotion.

Use your xyz credit card at your favourite restaurants 5 times this month and receive a $20 McDonald's coupon!

Below are the tasks for this project:

1. Calculate how many customers made at least three restaurant transactions in January. The MCC codes for restaurant spending are 5812 and 5813.
   ​
2. We'd like to raise the restaurant spending of customers who have not used our credit card in a restaurant often. Build a target base with the following criteria:
   
   - Customers who have had less than three restaurant transaction in January, and
   - Customers who have an income greater than $80,000.
   
3. Finalize the target base by excluding:
   - Do-not-call customers and
   - Inactive customers and
   - Customers who have not given consent to receive marketing messages, and
   - Customers who have received our marketing promotion at least six times in January.
   
4. Set aside 10% of the customer base as a control group. (Note: use the Ranuni function with seed=100 when creating the control group.)
   
5. Create the leads in a text file and save it in the shared folder.
   
6. Review the spending in February and conclude whether or not the promotion was effective.