Data Analyst to Clean WIX Member Data, Build Dashboards & Define KPIs
Budget: $250 – $750 CAD
I’m a small business owner running a fitness studio with about 55 active members. Right now, I’m juggling everything myself and struggling to keep up. Our member and sales data is a mess, and I need immediate help making sense of it. We use Wix-based software for signups, payments, and member tracking, but I need someone to extract, clean, and structure that data so I can actually use it to grow my business.
Scope of Work
- Clean and normalize current data (signups, cancels, Meta ad spend, purchase history).
- Consolidate each member’s history into one continuous customer journey to keep CAC, LTV, and retention accurate.
- Build Google Sheets dashboards with locked formulas for core KPIs.
- Add a simple, sustainable way to log churn/retention going forward.
- Provide a clear report on current CAC and actionable steps to improve it.
- Make dashboards scalable (usable with 50 members or 500).
- Analyze past sales to determine optimal timing for running programs.
- Recommend spend allocation to reduce CAC by focusing on the highest-performing channels.
- Suggest strategies to improve retention and extend membership lifecycles.
- Propose upsell structures and long-term plans to increase LTV.
- Create templates for quarterly reviews to track results and adjust quickly.
KPIs to Track and Report:
- Customer Acquisition Cost (CAC)
- Return on Investment (ROI)
- Lifetime Value (LTV)
- Churn & Retention Rates
- Membership Growth Rate
- Program Timing & Seasonal Sales Trends
Deliverables:
- Clean, accurate, normalized data set (pulled from Wix + ad platforms).
- Google Sheets dashboards with locked formulas.
- Written reports that are simple, useful, and confidence-building.
- A walkthrough + documentation so I fully understand the numbers and how to use them.
What Success Looks Like
- Within 2–4 weeks, I have clean data pulled from Wix and ad accounts.
- A Google Sheets dashboard is live and tracking CAC, LTV, churn/retention, and ROI.
- I receive a walkthrough + report that explains the numbers in plain language.
- I know my current CAC and LTV, what’s driving churn, and what levers I can pull to improve.
- I have a simple system I can maintain going forward without depending on outside help.
Important: Our current data is a MESS — we’ll be starting from scratch. I need someone who can take initiative, work independently, and deliver results without constant hand-holding.
Timeline: 2–4 weeks
When applying, please include:
- Examples of dashboards or reports you’ve built (Google Sheets or similar).
- Experience you have working with CAC, LTV, retention, or ROI reporting.
- A short note on how you’d approach cleaning messy data from Wix or similar platforms.
Bonus: Experience working with membership-based software.
Scope of Work
- Clean and normalize current data (signups, cancels, Meta ad spend, purchase history).
- Consolidate each member’s history into one continuous customer journey to keep CAC, LTV, and retention accurate.
- Build Google Sheets dashboards with locked formulas for core KPIs.
- Add a simple, sustainable way to log churn/retention going forward.
- Provide a clear report on current CAC and actionable steps to improve it.
- Make dashboards scalable (usable with 50 members or 500).
- Analyze past sales to determine optimal timing for running programs.
- Recommend spend allocation to reduce CAC by focusing on the highest-performing channels.
- Suggest strategies to improve retention and extend membership lifecycles.
- Propose upsell structures and long-term plans to increase LTV.
- Create templates for quarterly reviews to track results and adjust quickly.
KPIs to Track and Report:
- Customer Acquisition Cost (CAC)
- Return on Investment (ROI)
- Lifetime Value (LTV)
- Churn & Retention Rates
- Membership Growth Rate
- Program Timing & Seasonal Sales Trends
Deliverables:
- Clean, accurate, normalized data set (pulled from Wix + ad platforms).
- Google Sheets dashboards with locked formulas.
- Written reports that are simple, useful, and confidence-building.
- A walkthrough + documentation so I fully understand the numbers and how to use them.
What Success Looks Like
- Within 2–4 weeks, I have clean data pulled from Wix and ad accounts.
- A Google Sheets dashboard is live and tracking CAC, LTV, churn/retention, and ROI.
- I receive a walkthrough + report that explains the numbers in plain language.
- I know my current CAC and LTV, what’s driving churn, and what levers I can pull to improve.
- I have a simple system I can maintain going forward without depending on outside help.
Important: Our current data is a MESS — we’ll be starting from scratch. I need someone who can take initiative, work independently, and deliver results without constant hand-holding.
Timeline: 2–4 weeks
When applying, please include:
- Examples of dashboards or reports you’ve built (Google Sheets or similar).
- Experience you have working with CAC, LTV, retention, or ROI reporting.
- A short note on how you’d approach cleaning messy data from Wix or similar platforms.
Bonus: Experience working with membership-based software.