Strategies to Combat Shopping Cart Abandonment

1.Project Title & Company Overview

Project title: Strategies to Combat Shopping Cart Abandonment & Boost Sales

Industry: E-commerce

Business Introduction: The company is a leading UK e-commerce retailer. Their core products include smartphones, laptops, smart home devices, clothing, footwear, and accessories. Their focus in on customer experience, competitive pricing, and innovative technology.

Role: Business Analysis Consultant

2. Business Problem

The ecommerce company was facing key challenges:

High cart abandonment
Untargeted marketing strategies
Low Customer Experience

3. Objectives

Increase conversions
Enhance customer experience
Optimize Marketing Strategies.

4. My approach and Tools Used

Data importation into MSSQL
Data Cleaning & Transformation
Data Querying & Manipulation
Data Analysis & User Segmentation
Data visualization
Reporting and Recommendations

Tools used: MSSQL, Power BI and PowerPoint.

5. Key Deliverables

Delivered a Power BI dashboard to identify demographics, key trends and make data-driven decisions.

6. Recommendations

Enable Guest Checkout
Streamline the Checkout Process
Optimize Mobile Experience
Retarget High-Value Carts
Enhance Abandoned Product Pages
Align Social Ads with On-Site Messaging