Analytics case study: Isla Coffee Co.
Covered here
- How to apply every module to one business
- Six project tasks from plan to report
- How to work from raw channel data
Short answer
This case study applies the whole course to one business, Isla Coffee Co., a Philippine online coffee retailer aiming to grow revenue 25% in six months. You will write a measurement plan, analyze channels, find funnel problems, evaluate campaigns, prioritize recommendations, and present your findings in a report and dashboard.
The brief
Isla Coffee Co. sells beans, drip bags, and brewing gear online. It wants to grow online revenue 25% over the next 6 months. Last quarter’s data:
| Channel | Sessions | Add to cart | Purchases | Revenue (₱) | Spend (₱) |
|---|---|---|---|---|---|
| Organic search | 18,000 | 1,440 | 360 | 432,000 | 0 |
| Paid search | 9,000 | 900 | 270 | 351,000 | 90,000 |
| Paid social | 15,000 | 600 | 90 | 99,000 | 75,000 |
| 3,000 | 450 | 150 | 210,000 | 6,000 | |
| Direct | 5,000 | 400 | 130 | 169,000 | 0 |
Extra facts: 68% of sessions are mobile, but only 41% of purchases are mobile. Checkout requires account creation. Paid social traffic doubled this quarter while its revenue rose only 10%.
The six projects
- Measurement plan: objectives, SMART goals, KPIs, targets, segments, and key events. (Modules 1 and 2)
- Performance report analysis: conversion rate, add-to-cart rate, average order value, and revenue share by channel. (Module 3)
- Traffic and conversion problems: a funnel by device, the largest drop-off, three likely causes, and one A/B test. (Module 5)
- Campaign evaluation: CPA and ROAS for paid search, paid social, and email, plus why paid social grew without revenue. (Module 6)
- Recommendations: 3 to 5 ideas ranked with ICE, each with data, impact, owner, and timeline. (Modules 5 to 7)
- Performance report: a dashboard and a 5 to 8 slide presentation for the owner. (Module 7)
Download the case study data
Columns: Channel, Sessions, Add to cart, Purchases, Revenue (PHP), Spend (PHP), Conversion rate, AOV, CPA, ROAS
Opens in Excel, Google Sheets, or Numbers.
Quick quiz
Your action
Key terms
- Case study
- A realistic business problem used for practice.
- Average order value
- Revenue divided by purchases.
- Add-to-cart rate
- Add to carts divided by sessions.
- Revenue share
- A channel's share of total revenue.
Questions beginners ask
Can I use my own business instead?
Yes. Swap in your own GA4 data or the GA4 demo account.
How long does the case study take?
Plan for 3 to 5 hours across the six projects.
Related lessons
Want someone to set up your analytics and reporting while you learn? The team at Remar Digital can help.