Data Analyst Needed to Calculate Quarterly Unified User Churn for a Financial Model
Worldwide
We are a coupons and cashback platform looking for an experienced Data Analyst to calculate our quarterly user churn rate for use in our financial model. We want to treat each customer as one unified user, regardless of whether they use coupons, cashback, or both. For example, if a user uses a coupon in one quarter and cashback in the next quarter, they should be considered retained. The analyst will: Combine coupon and cashback user activity. Deduplicate users using their user ID. Calculate historical quarterly retention and churn rates. Recommend the appropriate churn rate to use in our financial model. Provide the calculation in a clear, reusable Excel/Google Sheets file or SQL query. Briefly explain the calculation methodology. We will provide the required user activity data through files or read-only data access. Required experience Experience calculating churn and retention. Strong SQL and data analysis skills. Experience with cohort or user behavior analysis. Experience with e-commerce or consumer apps is preferred. Please share an example of similar work, your proposed approach, estimated timeline, and fixed-price quote.
- Hours to be determinedHourly
- < 1 monthDuration
- ExpertExperience Level
- Remote Job
- One-time projectProject Type
Skills and Expertise
Activity on this job
- Proposals:20 to 50
- Last viewed by client:3 days ago
- Interviewing:0
- Invites sent:0
- Unanswered invites:0
About the client
- SAUKhobar11:20 AM
- $910 total spent2 hires, 1 active
- Tech & ITMid-sized company (10-99 people)
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by