E-commerce Customer Retention & LTV Dashboard Development

Category: Data Science

Budget: 1675–1675 USDC

We are seeking a seasoned Data Analyst to help us interpret customer behavior from our Shopify and Google Analytics 4 datasets. The primary objective is to build a comprehensive retention dashboard that tracks cohorts, calculates Lifetime Value (LTV), and identifies key churn indicators. You will be responsible for cleaning raw CSV exports, performing exploratory data analysis in Python or SQL, and creating an interactive visualization suite in Tableau or Power BI. Deliverables include a cleaned master dataset, a technical report summarizing trend insights, and a live dashboard with filters for product categories and acquisition channels. We expect the initial exploratory phase to be completed within one week, with the final dashboard delivery in 21 days. The ideal candidate has experience with retail metrics and can translate complex statistical findings into actionable marketing recommendations for our leadership team.

Skills required

Python
Tableau
SQL
Cohort Analysis
Data Visualization

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