Project Details

Project information

  • Category: Rewards
  • Client: Cafe
  • Project date: 27 October, 2024
  • Report: One Page
  • Creation Time: 10 Hours
  • Tools: Python, Power Bi
  • Project URL: https://lnkd.in/d7kZsw4n

Watch this Video

Project information

Customer Data Analysis and Promotional Messaging Strategies Report.

Age Distribution by Offer Type

The age distribution among customers who participated in different offers was analyzed.

Result: Clear differences were observed in the ages of participating customers by offer type. Offers targeting Middle age groups were more popular, while other offers targeted older and younger age groups.

Effect of Gender on Offer Success

The number of completed offers was calculated for each gender.

Result: The data showed that men achieved a higher rate of successful completed offers than women, indicating that promotional messages targeted at men may be more effective.

Most Popular Offers

TThe number of completed offers was analyzed for each type of offer.

Result: Offers for Discount were the most popular among customers, indicating the need to focus more on promoting these offers.

Relationship between Income and Offer Success

The success of the offers was analyzed based on the channels used.

Result: The results showed that channels such as ['web', 'email', 'mobile', 'social'] were the most successful in promoting offers, which recommends continuing to use them and intensifying marketing efforts through these channels.

The most effective channels for promoting offers

The number of completed offers was calculated for each gender.

Result: The data showed that men achieved a higher rate of successful completed offers than women, indicating that promotional messages targeted at men may be more effective.

Recommendations

1- Focus on developing promotional messages tailored to mens, given their high success in offers.

2- Strengthen the promotion of the most popular offers among the targeted age groups [50:70].

3- Invest in channels that have proven effective to achieve better results ['web', 'email', 'mobile', 'social'].

Working time .. The project was completed in about 10 hours over 2 days.

======= >>>>>>> parent of b1b0eec (add video):omar.html