Analyse customer churn from a CSV file and recommend actions

Project overview

We run a subscription box business and have a spreadsheet of 8,000 customers with signup dates, orders and cancellations. We want to understand why people leave and what we can do about it.

What you will deliver

• A cleaned dataset with a short data-quality note
• Churn rate by month, plan and customer group
• Analysis of the main factors linked to cancellation
• 5 to 8 charts that are easy to understand
• A written report of 4 to 6 pages with recommendations
• A notebook or spreadsheet showing the calculations

What we are looking for

• Data analysis experience with Python or Excel
• Can explain findings simply to business owners
• Careful not to overstate conclusions
• Organised, reproducible work

Notes on the deliverables

For 'analysis of the main factors linked to cancellation', please send the result in a clearly named file or link so that we can review it easily. For 'a cleaned dataset with a short data-quality note', please send the result in a clearly named file or link so that we can review it easily. If you know a better way to handle 'a notebook or spreadsheet showing the calculations', we are open to hearing your suggestion in your proposal. If you know a better way to handle '5 to 8 charts that are easy to understand', we are open to hearing your suggestion in your proposal. Please confirm in your proposal that 'a written report of 4 to 6 pages with recommendations' is something you have done before.

What is and is not included

The work listed above is the full scope of this analysis job. Please point out anything you believe we have forgotten, so we can settle it before work begins. Extra items can be discussed separately, with their own price and timeline.

Payment

This is a fixed-price job with a budget of USD $150. The price is firm, so please apply only if it works for you. Payment will go through the platform's secure system, and we release it promptly after the work is approved.

Originality and checking

A careful, accurate analysis is more important to us than a rushed one. All work must be original, created for this project and free of copied or unlicensed material. Freelancers who find and fix their own small mistakes are the ones we want to hire again.

How we will choose

We will shortlist freelancers by relevant experience, quality of past work, clarity of the proposal and availability. Price matters only within the fixed budget; reliability and quality matter more. We may ask shortlisted applicants a few questions or for a very small sample.

Who will be a great fit

We are looking for an experienced specialist who can advise us, not just follow instructions. Honesty, curiosity and good manners matter to us as much as technical ability. Reliability, meaning answering messages and keeping promises, makes a big difference on a analysis job.

Revisions

Two rounds of reasonable revisions are included in the fixed price. Our feedback will come as one organised list instead of many separate messages. Errors or missed instructions will be fixed without using up a revision.

Availability and working hours

You can work whenever suits you, provided the agreed dates are kept. Some overlap with our working hours, even a short one, would be very helpful. If your availability changes during the job, tell us straight away so that we can adjust.

Suggested process

We suggest starting with a short kickoff conversation to agree on the details and answer your questions. Next, please share an early version or plan of the analysis so we can confirm you are on the right track. Finally, we will review the finished work against the list, request any small changes, approve it and release payment.

Who we are

Our team is small, so every project matters and we pay close attention to it. We value people who take ownership and are proud of their work. Treating each other with respect always produces the best analysis.

Tips for a strong application

We like proposals that show you have read the whole description. Mention one detail from our description that shows you understood it. Please do not copy and paste the same message to every job.

Keeping in contact

You can expect an answer from us within a working day, and we ask for the same courtesy. Please keep important decisions in the platform chat so both sides have a record. A short call is fine when something is complicated, at a time that suits you.

Deadline

We would like the analysis finished within about a week. Please tell us honestly whether this works for you and when you could start. We would like a short progress update every couple of days so we can give feedback early.

Privacy of our information

Some of the files and business details we share for this analysis are not public. Please do not show this material to other clients or in public places. After delivery, we are normally happy for you to display the final work once sensitive details are removed.

Applying for this job

A good proposal for this analysis is brief and includes:

• Two or three relevant samples or links
• How you would handle the main deliverables
• Your start date and delivery date
• Anything in the brief that is unclear to you

Thank you for reading, and we look forward to your proposal.