freecourses.digital
Lesson progress: 0 of 3 activities done
All lessons in Digital and Web Analytics Lesson 8.1 of 32

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:

ChannelSessionsAdd to cartPurchasesRevenue (₱)Spend (₱)
Organic search18,0001,440360432,0000
Paid search9,000900270351,00090,000
Paid social15,0006009099,00075,000
Email3,000450150210,0006,000
Direct5,000400130169,0000

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

  1. Measurement plan: objectives, SMART goals, KPIs, targets, segments, and key events. (Modules 1 and 2)
  2. Performance report analysis: conversion rate, add-to-cart rate, average order value, and revenue share by channel. (Module 3)
  3. Traffic and conversion problems: a funnel by device, the largest drop-off, three likely causes, and one A/B test. (Module 5)
  4. Campaign evaluation: CPA and ROAS for paid search, paid social, and email, plus why paid social grew without revenue. (Module 6)
  5. Recommendations: 3 to 5 ideas ranked with ICE, each with data, impact, owner, and timeline. (Modules 5 to 7)
  6. 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

1. What is paid search ROAS for Isla Coffee?
2. Mobile is 68% of sessions but 41% of purchases. This points to...

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.