top of page

Online Business Marketing Campaign Analysis
(SQL, Power BI, Python)

Project Introduction

ShopEasy, an online retail business, is facing reduced customer engagement and conversion rates despite launching several new online marketing campaigns. I'm tasked  to help conduct a detailed analysis and identify areas for improvement in their marketing strategies.

Business Analysis Dimensions

Customer Engagement

  • Engagement behavior funnel analysis:

       view-click-like

  • Platform engagement: social media, blog, newsletter, video

Customer Journey

  • Customer journey funnel analysis:

     view - click - dropoff - purchase

Customer Review

  • Customer review rating

  • Customer review sentiment score

Product Detail

  • Customer behavior count and % by product

Data Cleaning and Transformation (SQL)

sql 1.png
sql 2.png

Generate Sentiment Score  (Python)

python.png

Full code click here

Visualization Dashboard 

cover.png
campaign engagement.png
purchase conversion.png
customer review.png
1750104868686.png

Other Projects

Computer Hardware Business Report

(Power BI)

Click here

Jewelry Sales Report

(Power BI)

Click here

bottom of page