E-commerce Attribution Dashboard & Predictive LTV Model

Category: Data Science

Budget: 3000–3000 USDC

We are seeking an experienced data analyst to build a comprehensive analytics suite for our Shopify-based brand. The primary goal is to move beyond basic reporting by implementing a multi-touch attribution model (Linear and Time-Decay) using BigQuery and dbt. You will be responsible for aggregating data from Google Ads, Meta Ads, and Klaviyo to create a unified customer view. Key deliverables include a Looker Studio dashboard visualizing CAC/ROAS by channel and a Python-based predictive model to estimate Customer Lifetime Value (LTV) for new cohorts. The ideal candidate has a strong command of SQL and experience with marketing API integrations. We expect the initial setup, data cleaning, and dashboard deployment to be completed within a 4-week timeline, including one week of post-launch validation and documentation.

Skills required

• SQL
• BigQuery
• Python
• Looker Studio
• Data Modeling

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