E-commerce Customer Retention & LTV Dashboard Development

Category: Data Science

Budget: 1650–1650 USDC

We are seeking a seasoned data analyst to help us understand our customer churn and lifetime value (LTV) across our Shopify store. The project involves cleaning three years of raw transactional data, identifying key purchase patterns, and building a dynamic dashboard in Tableau or Power BI. You will be responsible for defining cohort analysis, identifying high-value segments, and providing actionable insights on how to improve retention rates. Deliverables include a fully documented ETL process, a clean dataset, and an interactive dashboard with filters for product category, region, and acquisition channel. The ideal candidate will have strong SQL skills and a background in retail analytics. We expect the project to be completed within 3 weeks, including a handover session to explain the findings and dashboard functionality to our marketing team.

Skills required

• SQL
• Tableau
• Python
• Data Visualization
• E-commerce Analytics

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