Upgrowly
← Blog

How to Write an SEO Case Study That Wins Clients (Template)

By Neha

An SEO case study is a short, true story of one client's problem, what you did and what changed, backed by numbers the reader can check. The ones that win clients are written for the next business owner, not for other SEOs: one page, plain words, real screenshots, the client's permission, and an honest note on what you did not control.

Most freelancers in India have done good work that nobody outside the client ever sees. A clinic in Indore gets more calls, a coaching centre in Patna fills a batch, and the proof sits in a Search Console account. This guide shows how to collect that proof as you work, get permission to use it, and turn it into a case study that a prospect reads to the end. There is a copy-and-fill template at the end of the template section.

What is an SEO case study, and why does it win clients?

An SEO case study is evidence that you have solved a problem the prospect has, for a business like theirs, written so they can follow it without SEO knowledge.

A prospect deciding whether to hire you is asking three questions: have you done this before, for someone like me, and can I believe you? A list of services answers none of them. A certificate answers the first only weakly. A case study answers all three, because it shows a real business, a real problem and a real change.

It works best when it matches the prospect's world. A dentist in Pune cares much more about "a dental clinic in Nashik" than about "an e-commerce brand". That is one reason to focus on one trade, as our guide on how to get SEO clients suggests: your second dental client is easier to win once you can show the first.

A case study is not:

  • A list of tasks ("fixed 312 issues, built 40 backlinks").
  • A screenshot of a rising graph with no explanation of what it measures.
  • A story about you. The client and their customers are the subject; you are the person who helped.

Keep it to what one person can read on a phone in three or four minutes. Longer write-ups have their place, but the one-page version is the one that gets forwarded to a business partner.

What should an SEO case study include?

Seven parts, in this order: the client, the problem, the goal, what you did, the results, what the client said, and what it means for the reader.

SectionWhat goes in itLength
1. The clientTrade, city or area, size. Name only with written permission.1–2 lines
2. The problemWhat was wrong, in the owner's words and in yours3–5 lines
3. The goalThe one result the client wanted: calls, admissions, bookings1–2 lines
4. What you did3–6 main actions, in plain language, in the order you did themA short numbered list
5. The resultsBefore and after numbers, the dates compared, where each number comes fromA small table plus screenshots
6. In the client's wordsA short quote the client wrote or approved1–3 lines
7. What this means for youWho else this approach suits, and an invitation to talk2–3 lines

Two details make the difference between believable and doubtful. First, say where every number comes from: "Google Search Console, clicks from Google search", not just "traffic". Second, name the dates: "July to September compared with April to June". A number without a source and a date reads like marketing, and experienced owners have seen plenty of that.

If you write proposals, you will recognise the shape. It is the same structure as a good proposal, told in the past tense. Our guide on how to write an SEO proposal covers the forward-looking version.

Collect the proof while you work, not after

The best time to start a case study is the first week of a project, because the "before" numbers can be hard to rebuild later.

Freelancers often decide to write a case study six months in, then discover they never saved what the site looked like at the start. Search Console keeps a long history of search numbers, so those can usually be recovered, but the old page titles, the broken contact form and the half-filled Google listing are gone once you fix them.

Make this part of onboarding for every client, whether or not you plan to publish:

  1. Screenshot the starting point. The home page on a phone, the Google listing, the page titles as they appear in Google, and anything obviously broken.
  2. Save a dated audit. Run the website audit on day one and keep the result. It gives you a plain-language record of the problems you started with.
  3. Note the baseline numbers. Clicks and impressions from the last three months in Search Console, calls and direction requests from the Google Business Profile, and enquiries the client already gets. The Search Console Rankings report shows real clicks, positions and searches from a connected Search Console.
  4. Agree what counts as a lead. Calls, WhatsApp messages and form enquiries are the usual ones. If you cannot measure leads, your case study will only be able to talk about rankings.
  5. Keep a short work log. One line a week of what you changed. It becomes the "what we did" section later.

The client onboarding questionnaire builds the questions and access list to send a new client, which is a natural place to ask for the baseline numbers too. Our guide on explaining SEO results to clients covers how to set up lead tracking from day one.

How to get the client's permission

Ask for written permission before you publish anything about a client, and offer an anonymous version as the default.

Some business owners are happy to be named, especially if the result reflects well on them. Others prefer privacy, sometimes because they do not want competitors to know what worked. Both are fine. What is not fine is publishing a client's name, data or screenshots without asking.

A simple way to handle it:

  • Put it in the agreement. Add a clause saying you may describe the work in anonymised form, and will ask separately before naming the client or showing identifiable screenshots. The SEO service agreement generator is a starting point you can edit.
  • Ask at a good moment. After a month where the numbers clearly improved, not at renewal time when it feels like a condition.
  • Show the draft first. Send the finished case study and let the client correct anything. People agree more readily to a text they have seen.
  • Get the yes in writing. An email or WhatsApp reply that says "Yes, you can publish this" is enough for most small businesses. Keep it.

For an anonymous version, describe the business by trade and region ("a physiotherapy clinic in western Mumbai"), blur names, phone numbers and addresses in screenshots, and leave out any number that would identify them on its own.

Some trades need extra care. Doctors and clinics should be careful about how they are presented, because the National Medical Commission restricts how doctors advertise; keep the case study about the website and Google listing, never about patients or treatment results. Lawyers face similar limits from the Bar Council of India. When in doubt, use the anonymous version and let the client check with their own professional body.

Which numbers belong in an SEO case study?

Lead with the numbers the client cares about (enquiries, calls, bookings), then show the search numbers that explain them.

Our guide on SEO KPIs clients care about sorts metrics into business outcomes, leading signals and site health. A case study should follow the same order. Here is what each number means and where it comes from:

NumberWhat it showsWhere it comes from
Enquiries: calls, WhatsApp, formsThe result the client paid forClient's records, Google Analytics key events, call tracking
Calls and direction requests from the listingPeople who acted from Google Maps or SearchGoogle Business Profile performance
Clicks from Google searchVisitors who came from GoogleGoogle Search Console
ImpressionsHow often the site was shown in GoogleGoogle Search Console
Searches the site appears forWhich words now find the businessGoogle Search Console
Average position for key searchesWhere the site usually appearsGoogle Search Console

Search Console's own definitions of clicks and impressions are in Google's Search Console help; link to them if a reader might not know the terms.

Three rules keep the numbers honest:

  1. Compare like with like. Compare the same months year on year where you can, because many Indian businesses are seasonal: coaching centres around admissions, wedding services in the season, shops around Diwali.
  2. Show absolute numbers next to percentages. For example, "calls went from 20 to 35 a month" is clearer than "75% more calls", and harder to misread.
  3. Mention what else changed. If the client also started Google Ads, opened a second branch or ran a festival offer, say so. A reader who later learns you left it out will doubt everything else.

To put a rupee value on the result, the SEO ROI calculator works out whether SEO paid for itself, month by month. Only include a rupee figure if the client agrees to share their average customer value.

A copy-and-fill SEO case study template

Use this template as it is for your first three case studies; change it only once you know what your prospects respond to. The bracketed parts are yours to fill in, and every number must come from the client's real data.

[Trade] in [city or area]: [the result, in one line]

The client. [Business type], [area], [size, such as "two doctors and a receptionist"]. [Name, only with written permission.]

The problem. "[What the owner told you, in their words.]" When we looked, we found [two or three specific problems in plain language, such as "the phone number could not be tapped on a mobile" or "the Google listing showed old opening hours"].

The goal. [One outcome, such as "more calls from people searching nearby".]

What we did.

  1. [First action and why]
  2. [Second action and why]
  3. [Third action and why]

The results. [Start month to end month] compared with [the earlier period]:

BeforeAfterSource
[Enquiries or calls][number][number][source]
[Clicks from Google][number][number]Google Search Console
[Listing calls or directions][number][number]Google Business Profile

[One line on anything else that changed during the period.]

In the client's words. "[Short quote, written or approved by the client.]"

Is this you? If you run a [trade] in [region] and [the problem], [one-line invitation to talk].

Here is how a filled-in results line might read, as an illustration with made-up numbers rather than a real client: "Calls from the Google listing went from 18 a month to 31 a month, comparing July to September 2026 with the same months a year earlier, from the clinic's Google Business Profile." The point is the shape: the number, the before and after, the dates and the source in one sentence.

Where to use your case studies

Put each case study where a prospect is deciding: in your proposals, your cold messages, your website and your first meeting.

  • In proposals. Add one case study from the same trade as the prospect, after your findings and before your price. The SEO proposal generator turns your findings into a printable proposal you can attach it to.
  • In cold messages. One line is enough, along the lines of "Last quarter I helped a [trade] in [area] get more calls from Google; happy to show you how." Link the case study rather than attaching a file. Our cold email templates show where that line fits.
  • On your website. Give each case study its own page, with the trade and city in the title, such as "SEO for a physiotherapy clinic in Pune: case study". A page about one trade in one city is what a business owner in that trade is looking for, and it gives Google a clear page to show for those searches.
  • In the first meeting. Print the one-page version. Owners who will not read a PDF on WhatsApp often read a page you hand them.
  • In renewals. Turn the case study back to the client it is about. It is a clear record of what the year achieved.

Once you have three or four, update them every few months with fresh numbers, or mark them with the period they cover so nobody thinks a 2025 result is from this year.

Common mistakes that make case studies backfire

The case studies that lose clients are the ones that look exaggerated, so err on the side of plain and checkable.

  1. Cherry-picked keywords. "Ranked number 1 for 'best orthodontist near Ram Nagar main road'" impresses no one who knows that nobody searches it. Show the searches that actually brought visits.
  2. Percentages from tiny numbers. "Traffic up 400%" from 5 visits to 25 is technically true and quietly misleading. Give the real numbers.
  3. Taking credit for everything. If the client also ran ads or opened a new branch, say so. Owners talk to each other.
  4. Promises disguised as results. "We guarantee page one in 90 days" turns a case study into a red flag. No one can guarantee rankings, and serious owners know it.
  5. Invented or borrowed results. Never use another agency's case study, a "composite" client presented as real, or numbers you cannot show. It only takes one prospect asking to see the Search Console screenshot.
  6. Jargon. "We improved topical authority and fixed canonicalisation" means nothing to a salon owner. Say "we fixed the pages Google was confused about".

Before publishing, read it as the prospect would. If any sentence makes you think "would I believe this?", rewrite it or cut it.

Frequently asked questions

How long should an SEO case study be?

For winning local clients, about one page: 300 to 600 words plus a small results table and two or three screenshots. A prospect should be able to read it on a phone in a few minutes. You can keep a longer version on your website for people who want the detail.

Can I write an SEO case study without naming the client?

Yes. Describe the business by trade and region, blur identifying details in screenshots, and keep the real numbers. Anonymous case studies are common and still persuasive, as long as the numbers have a source and a date.

What if my results are small?

Small, honest results still win clients, especially from businesses of the same size. A line such as "calls from Google went from 8 to 14 a month" means a lot to a clinic owner who gets 8. Explain what the change meant for the business, and do not inflate it with percentages.

How do I write an SEO case study for my first client?

Start collecting proof in week one: screenshots, a dated audit and three months of baseline numbers. Agree with the client up front that you may write up the work, anonymously by default. After three to six months, fill in the template above with what really happened.

Should I include screenshots from Search Console?

Yes, they are the strongest proof you have because readers know the numbers come from Google. Crop to the chart and totals, show the date range, and blur anything the client has not agreed to share, such as their name or website address.