Cafe Reward Analysis

Steps involved in the analysis of Cafe Reward Dataset :-

1. Cleaning the dataset

2. Uploading & analyzing the dataset

Key Findings :-

1. Total 17K Customers visited the Cafe from Year 2013 - 2018.

2. Customers total Income was $970 M.

3. Avg. time taken by the Customers to Avail the Reward was 15 days.

4. 49.91% (8484) Male Customers , 36.05% (6129) Female Customers, 12.79% (2175) Unknown Customers & 1.25% (212) Others visited the Cafe.

5. Min. 18 Yrs & Max. 118 Yrs age Customers are associated with the Cafe.

6. Max. 6469 Customers are associated with the Cafe in Yr 2017 which was 83.47% more in comparison to last Yr 2016 i.e. 3526 in terms of counts.

7. Max. 1830 Customers are associated with the Cafe in Yr 2015 which was 164.83% more in comparison to last Yr 2014 i.e. 691 in terms of %.

8. Males total Income was 53.54% ($519.18 M), Female total Income was 45.07% ($437.04 M), Others total Income was 1.38% ($13.42%).

9. Total 45.52% (76.28 K) offer received, 34.45% (57.73 K) offer viewed & 20.04% (33.58 K) offer completed by Event.

10. Avg. Time taken to received the order is 14 days, Avg. Time taken to viewed the order is 15 days, Avg. Time taken for transaction of order is 16 days, Avg. Time taken for offer completion is 17 days.

11. 16.99K (26.9%) customers received offer for the Event, 16.83K (26.64%) Customers Viewed Offer for the Event, 16.58K (26.24%) Customers done Transactions for Event & 12.77K (20.22%) Customers completed the Events.

12. 40% Offers was sent by all the Channels (Web, E-mail, Mobile, Social).

13. For Discount Offer, avg. 8.5 hrs was taken by customer to avail the 4 No. of discount Offer ID, Avg. reward given $3 & average difficulty face by the customer to avail the Offer is $11.75.

14. For BOGO Offer, avg. 6 hrs was taken by customer to avail the 4 No. of BOGO Offer, Avg. reward given $7.5 & average difficulty face by the customer to avail the Offer is $7.5

15. For Informational Offer, avg. 3.5 hrs was taken by customer to avail the 2 No. of Informational Offer.