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.

Submit your program

  • Hidden