Showing the value of SEO is a vital part of any search professionals role.

While I've written about showing value through SEO reporting, I also wanted to show how you can put an actual commercial value on your SEO activity.

This is more important now than ever for SEO's.

For a large number of industries, the impact of lockdown and COVID-19 has made search-demand either plummet ? or skyrocket ?.

dumbell search interest
Search interest for 'dumbell'
hair clippers search interest
Search interest for 'hair clippers'

During times of high-demand, it can bring into question whether the improvement in organic traffic is due to the SEO you've been doing, or an increase in users searching for a product/service.

And conversely, during times of low-demand, it can make clients question whether you're doing a bad job.

To retain your part of marketing budgets and encourage further investment, performing an analysis that takes demand out of the equation and shows what would have happened to non-brand traffic without your input is essential.

You can then easily show ROI, even if traffic has gone down due to demand dropping.

The end output of this analysis that I'm going to run you through for the rest of this post is summarised into three key stats that you can provide on an ongoing basis.

seo value key stats

By showing these, you can clearly show the value of SEO and your work on the site.

As always, to make this easier I've created a template you can make a copy of which I'll be running through for the rest of this post.

Here is a sneak peek of an example output from the data we'll be pulling.

seo benefit analysis example scaled

Tools required.

A few tools are required to perform this analysis:

  • Google Search Console
  • Google Analytics
  • Google Sheets
  • Supermetrics for pulling the data (you can use alternatives, this is just what I use)

Setting up the template.

Your first step before we get into this is to make a copy of the template via File > Make a copy.

sheets make a copy

1. Extract keyword data.

Next, we use the GSC API to pull all keyword data during the period you've been working on on a site + a little bit before you started.

To do this, head to the 'GSC - Keyword data' sheet, open up the Supermetrics sidebar, then extract the data you want by configuring both the dates and the GSC property.

seo benefit analysis supermetrics sidebar
Supermetrics sidebar site/date options

One additional thing I'd recommend doing is pulling data for commercial non-brand keywords only.

We want non-brand data because it's hard to fully claim an increase in branded traffic due to SEO.

And we want commercial keywords only as for this analysis; I want to put an actual figure on the bottom of funnel value to the client.

To do this, head to the filter section and write some regex to only pull data for commercial URLs.

supermetrics sidebar full url regex matches
Supermetrics sidebar Full URL regex filtering

If you want a hand writing this regex, check out my Google Sheets regex generator tool.

To make sure the non-brand filter works, you will also want to fill in your brand keywords in the 'Options' dropdown.

image 38
Supermetrics sidebar brand keyword filtering

2. Do the same again for GA data.

You'll now want to head to the 'GA - Conversion data' tab, modify the query in Supermetrics again, updating the views, dates and matching any regex you used for pulling the GSC data.

supermetrics sidebar google analytics
Supermetrics sidebar Google Analytics data pull

3. Update the config.

Now you've got all your data, configure the pre-uplift month in the 'Config' tab. You can put this as a pre-working together month if you want to show total value since working on a site.

We'll be using the pre-uplift month as a baseline for what performance would be like if you hadn't been working on the site.

Next, set the time span you want to compare those dates too.

pre post uplift month

This can be the duration of a relationship with a client or just a specific time period you want to analyse, e.g. when you saw an increase in demand due to COVID.


What you could do at this point is set the post-uplift end month far into the future and the get this data to refresh automatically via Supermetrics.

Then you can use this in your monthly reporting to show the total ROI on an ongoing basis ?

Also make sure to tweak the number of keywords to run the analysis on.

By default, the top keywords by clicks are extracted.

4. Check the results.

Data should now be populated in the 'Analysis' tab.

seo value analysis results
SEO value analysis results

The key thing this analysis is doing that you need to understand is the 'Clicks with Jan CTR' column.

All this is doing is taking the impressions over the post-uplift period and multiplying that by the pre-uplift (or pre-working together) period.

pre post analysis explainer

By doing that, it is effectively answering the question 'What would the number of clicks be without our position improvement?'.

From that, we're then just calculating the additional clicks from SEO which is just Actual clicks - Clicks with Jan CTR.

From then on, finding the additional orders/revenue is as simple as applying the Google Analytics data.

There are a few assumptions to be aware of with this method.

The main things that could make this inaccurate are:

  • CTR has changed for reasons other than a position improvement.
    • For example, significant changes in SERP features or paid activity.
  • GSC click data doesn't show all click data; it removes queries with a small number of searches. We're assuming this isn't massively skewing the results.
  • Using overall site conversion-rate (CVR) and average order value (AOV) isn't skewing results massively. It'd be more accurate to apply CVR/AOV on a keyword-by-keyword basis for more accurate results
    • When possible, I tend to use Keyword Hero to restore those metrics and then use the keyword data from that rather than site-level metrics.

Some other points on showing value via SEO

If you head to the '? Summary' tab you'll now see those three key stats I mentioned at the start of this post.

seo value key stats

Whilst this is great information to be able to give to key stakeholders on an ongoing basis. It's also really important to make stakeholders aware the benefit of SEO is wider than just the direct revenue impact.

SEO can also add value via:

  • Increasing brand awareness
  • Enforcing best practices with development
  • Ensuring UX follows best-practices
  • Much more!

One great thing about investing in an SEO strategy is that the value is far-reaching and the impact is wider than what is directly measurable.


There are many different ways of measuring SEO activity. But hopefully this post has given you a new way to think about showing the value of SEO.

Do you have another method of showing the ROI of your SEO work? Let me know via Twitter.