E-commerce Customer Retention Analysis and Dashboard Development

Category: Data Science

Budget: 1525–1525 USDC

We are seeking a data analyst to analyze our Shopify store's historical sales data to improve customer retention. The project involves cleaning three years of transaction data, performing a detailed cohort analysis to identify churn patterns, and calculating Customer Lifetime Value (CLV) across different acquisition channels. The final deliverable should be an interactive dashboard built in Tableau or Power BI that allows our marketing team to filter performance by region, product category, and discount usage. We expect a deep dive into repeat purchase behavior and recommendations on which customer segments are most profitable. The project timeline is three weeks, with a midpoint check-in to review initial data cleaning and exploratory analysis. You must be comfortable working with CSV exports and joining disparate datasets to create a unified customer view.

Skills required

• Python
• SQL
• Tableau
• Cohort Analysis
• Data Visualization

Milestones are funded into USDC escrow on Polygon before work begins.