CRM Practice Projects · For freshers building a CRM portfolio
Do the analysis CRM jobs ask for, and walk in with work to show
Three projects on one coffee and tea brand’s data: a campaign report, customer segments and a monthly review, each with a brief and the answers. Even if you’ve never worked in CRM or seen a brand’s data.
Free for the first 100 learners
One honest review in return. ₹399 after that.
of 100 places left · learners already in
No payment, no card. The folder link arrives by email in a minute.
- 3 projects, each with a brief, Excel data and answers
- Self-study: briefs, data files and answer decks
- Score yourself out of 10 on every project
Raviraj Ramavarapu
Founder, Compound Lab · 7 years in D2C and app marketing, most in CRM · has hired for CRM roles
“I built this from the work I do every day for brands. Practise it here before you do it on the job.”
- +79%revenue from lapsed usersHealthify
- 23% to 44%WhatsApp delivery in a monthCumin Co
- 77%of CRM revenue from automationsPNG Jewellers
- 39%of store revenue from CRMHealthify Store
- +43%return pickupsMyGate
- ₹27.6 Crrun-rate across Healthify, PNG Jewellers and DS MillRetention I’ve run
Who it’s for
It’s for you, even if you’ve never seen a brand’s data
- Never worked in CRMEach brief opens with a note from your manager saying what they need.
- Not an Excel expertEverything runs in Excel or Google Sheets with a few common formulas. No SQL, no code.
- Numbers make you nervousThe briefs spell out the formulas, and the answer keys show how each number was worked out.
- Nothing to practise onEach project comes with the brand’s exports: orders, customers, campaigns and journeys.
- Not sure you got it rightCheck against the answer deck and score yourself out of 10.
Built for marketing CRM: campaigns, customer segments and journeys on WhatsApp, email, SMS and push. If you want Salesforce, sales pipelines or video lessons, skip this one.
What you walk in with
Eight things you’ll do before your first CRM job
- Clean data before you count itCatch the duplicate rows, test orders and spelling slips that throw off a pivot table.
- Compare channels fairlyUse revenue per 1,000 messages delivered, so WhatsApp, email and push sit on one scale.
- Build a cohort tableSee when new customers come back for a second order, month by month.
- Pick the right customers to chaseSort everyone into segments, then say which group comes first and why.
- Know what a journey really addedWelcome got credit for 139 orders. Against a group that got no messages, it added about 4.
- Read an A/B test without guessingKnow when a higher number isn’t proof yet, and how long a fair test runs.
- Turn numbers into a decisionEvery finding ends in a change for next month. That’s what managers want.
- Walk in with work to showThree finished reports for your portfolio, checked against ours.
Read one finding
What would you tell the head of growth?
From Project 3 · Monthly review
“Total CRM revenue is down in June. Is that a problem?” June brought in ₹15.0 lakh against ₹17.7 lakh in May, down 15%. Journeys earned ₹12.9 lakh, up 8.9%. One-time campaigns earned ₹2.1 lakh, down 63.8%.
May had a mid-year sale, from 20 to 25 May.
Pick the reply you’d send.
That’s the first mistake the kit warns about: calling June a bad month without seeing that May had a sale.
That’s the answer. It finds where the drop came from and why, before anyone panics.
May’s campaigns had a sale behind them, so June looks weak next to it. Judge July against June, not against a sale month.
What it’s testing
Whether you check what moved and why before calling a number good or bad. A review says what happened, why, and what changes next month.
The kit’s version
“Don’t panic at -15%. All of the fall is one-time campaigns, and May had a mid-year sale. Journeys grew 8.9% and cost less. Judge July against June, not against a sale month.”
That’s one page of the kit. See it as it is:
One full brief
Your first Monday at the brand, start to finish
Project 1 hands you two exports from Compound Lab Beverages and a note from the head of growth. You get five steps, the rates to work out and what to hand in by Friday.
What you get
- The note: ₹8.6 lakh spent on messages, so what did it earn?
- Five steps, from cleaning the data to a one-page report
- The six rates to work out, with the formula for each
- About 3 to 4 hours in Excel or Google Sheets
Look inside
Real pages from the kit
Project 1 brief: ₹8.6 lakh spent on messages, what did it earn?
The channel scorecard, compared on revenue per 1,000 delivered
Why April’s extra WhatsApp sends cut delivery
Project 2 brief: the files and the six segment rules
The cohort table: when new customers come back
Three messages for customers who need a nudge
The A/B test: B looks better, but stopped too soon
Common mistakes, and how to score yourself out of 10
What’s in the folder
Three projects, each with its answers
PDF · 2 pages each
The briefs
The situation, your manager’s note, the steps and what to hand in, for each of the three projects.
Excel · one per project
The data files
The brand’s exports, with a column guide and a few problems left in for you to find.
PDF · 12 to 15 pages each
The answer decks
Our report, slide by slide, with how we got each number. Open it after you finish.
Excel · one per project
The answer keys
Every number with its formula, so you can check your totals line by line.
The data files and answer keys open in Excel or Google Sheets. The answers sit in their own folder, for after you finish.
The founding batch
Free for the first 100, for one honest review
- Get it freeName, email, WhatsApp. The link arrives by email in a minute.
- Use it for a weekOne project over a few evenings, then check.
- Tell me honestlyFour short questions. Good or bad.
After the founding batch, the Practice Projects sells for ₹399.
Questions, answered
I’ve never worked in CRM. Can I do these?
Yes. Each project opens with a note from your manager and numbered steps. A column guide explains every column before you start.
Do I need SQL or Python?
No. Everything is done in Excel or Google Sheets, with pivot tables, SUMIFS and COUNTIFS. Project 3 needs two statistics formulas, and the brief gives you both.
How long does each project take?
About 3 to 4 hours for the first, and 4 to 5 hours each for the other two. A few evenings per project is plenty.
Is the data real?
No. It’s practice data for a made-up brand, Compound Lab Beverages, that sells coffee and tea. It’s sized like a real export: Project 2 alone has 46,950 orders from six months.
How do I use these in an interview?
Put your finished report in your portfolio and walk through it: the finding, the number, and the change you’d make. Score 8 or more out of 10 and you’re ready for an interview case.
What do I get, and in what format?
Three project folders. Each has a 2-page brief (PDF), an Excel data file, and an answer pack with a slide-by-slide answer deck (PDF) and an answer key workbook. The folder link arrives by email.
Is this for sales CRM roles like Salesforce?
No. This is marketing CRM: campaigns, segments and journeys on WhatsApp, email, SMS and push. If the job is about sales pipelines, this isn’t the right kit.
Why is it free right now?
The first 100 learners get it free as the founding batch, in return for one honest review after a week. After that it sells for ₹399.
Do I get a certificate?
No. You get three finished reports you can show and talk through, which is what interviewers judge.
CRM Practice Projects
Open the Project 1 brief and clean the data tonight
Free for the first 100 learners
One honest review in return. ₹399 after that.
of 100 places left · learners already in
No payment, no card. The folder link arrives by email in a minute.
CRM Career Launchpad
CRM Interview Kit
CV, LinkedIn and Portfolio Kit
Journey Blueprints
The Message Museum
CRM Analyst Workbook
How to Learn CRM Tools
The CRM Prompt Pack
CRM Glossary