Cafe Reward Promotion Program

ပန္း ခ်ယ္ရီ Avatar

ပန္း ခ်ယ္ရီ

undefined

Additional project images

ပန္း ခ်ယ္ရီ Avatar

ပန္း ခ်ယ္ရီundefined

More projects by ပန္း

US Candy Distributor Analysis

0 Likes

0 Comments

Airbnb Rental Price Prediction for Singapore

0 Likes

0 Comments

Mobile Game Analysis - FP20 Challenge

0 Likes

0 Comments

Discussion and feedback(4 comments)

comment-1661-avatar

Murilo Evangelista

5 months ago

Hi Cherry, Well done. Have some questions 😊 How could you "calculate" membership tenure without more specific information about períod? And also about the channels, there is no specification about the channel on the events, I mean, how can I know if the offer arrives from social or e-mail for a specific customer? Maybe I´m missing something (🤔😅). Many thanks, Murilo

comment-1665-avatar

Walid Hussein

5 months ago

Nice job, Cherry! Hi Murilo, for the membership tenure, you can use the "Became Member On" column in the customer table to get this information. Also, you can split the marketing channels in the offer table to get binary values for each channel. That's what I did.

comment-1666-avatar

Cherry Aye Mya Mya Tun

Project owner

5 months ago

Project owner

Hi @Walid Hussein, thanks for answering to Murilo. Yes, this is the same that I did for membership tenure and channels.

comment-1681-avatar

Murilo Evangelista

5 months ago

Hi Walid, thanks for the answer. But you know, I mean there is no clear information to take these assumptions (my point of view). I understand what you´ve done, but for example, the offer id: ae264e3637204a6fb9bb56bc8210ddfd (bogo) there are 3 different channels, did the customer receive it on all of them? Which one he/she used to see and converted in a transaction? 🤔 And about the tenure I got it (if we consider that these transactions occurs in 2024 😁).