Sentry Page Protection
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.


​Submit your program below:
Fill out my online form.