How to Create 10x SEO Reports – Whiteboard Friday

How to Create 10x SEO Reports – Whiteboard Friday

How to Create 10x SEO Reports – Whiteboard Friday 1920 1080 Cyrus Shepard

New year, new you — when it comes to SEO reporting, at least! We’re kicking off 2020 with a comprehensive yet gloriously simple recipe from Cyrus Shepard for creating truly effective SEO reports. From tying KPIs to business metrics to delivering bad news effectively, your reports have never looked so good.

Click on the whiteboard image above to open a high resolution version in a new tab!

Video Transcription

Okay, so we have 400 broken pages. Ah, we rank number 7 for best plumbers in Idaho. Oh, hey, Moz fans. I’m Cyrus Shepard. Today I’m talking about SEO reports, specifically how to create 10x SEO reports.



I’ve gotten hundreds of SEO reports like this in my career, and I’ve got to tell you that’s useless. No one is reading those. This is unfortunate because this is your direct way to communicate the value of what you’re doing, drive action, and essentially make more money with your job. Now a good SEO report tries to accomplish three things:

  1. You want to tie the report directly to your business metrics
  2. You want to show the value of SEO, what you’re doing, how SEO is delivering to those business metrics. 
  3. Finally, you want to drive action. When people read your SEO report, you want them to take action on specific things, fix site issues, those sorts of things, etc.

But people make a lot of mistakes. Typically, if you’ve created SEO reports, if you’ve read SEO reports, you’ve seen these mistakes over and over and over again: 

  • It’s not a site audit. It’s not a list of every single thing that is wrong, every single traffic metric. It’s usually just the top things, the things that we want to focus people’s attention on. 
  • It’s not something that only delivers good news. You see these time and time again, SEO reports, they paint a rosy picture. But people aren’t dumb. They know that if their business is not improving and you’re continually delivering good news, you’re not really tying SEO to the business.

So we want to create even reports. 

5 things to include in every SEO report

Now over the years, with the reports I’ve created, I find that there are generally five key things that you want to include in every SEO report that help you drive action and show the value of SEO and ultimately help you make more money. 

1. 2–4 KPIs

The first thing that you want to include in every SEO report is KPIs. These are key performance indicators. These tie directly to your business metrics. Generally, you want to include about two to four of these. You want to keep them top of mind. 

A) Conversions, goals, sign-ups, downloads, etc.

Now, generally in SEO, these can be conversions, goals, e-commerce, how many things are you selling. It can be sign-ups for your email newsletter. It can be downloads.

Generally, anything having to do with money, your business metrics, or your key performance indicators, these are good things to include. 

Pro tip: When reporting on your key performance indicator, organic traffic, the SEO work that you do is often the last conversion channel that people will use. So it’s good to use assisted conversions.

This is often found in Google Analytics or whatever analytics program that you use. This will set a look-back window and show how organic traffic, how your SEO efforts contributed even if their last visit was direct. So it’s good researching that and understanding how you can use assisted conversions in your reporting. 

B) Traffic MoM, YoY

Another key performance indicator that is very common in SEO reports is traffic. In fact, some people like to lead with it. I like to lead with the business metrics. But it’s inevitable that if you’re doing an SEO report, you’re going to include traffic. 

Now if you want to make that traffic report a little more valuable, you need comparisons, generally month-to-month comparisons or more useful year-over-year comparisons. This helps avoid the problem of like traffic was down because of Christmas or a certain holiday or regional event.

So when you compare year-over-year, you can show actual performance that varies a little more reasonably. 

2. Search visibility & share of voice

Second, and this is where a lot of people stumble, search visibility or share of voice (SOV). Now where people stumble is this is not a rankings report.

A lot of SEO reports include rankings. Rankings, I’ve got to say, really aren’t the best thing to include in your reports. Rankings fluctuate. They are so personalized from country, device, and individuals. So including rankings for individual keywords is not very informative. Fortunately, there are many great alternatives that you can include that are much superior to rankings. 

A) Search visibility (click estimates)

Search visibility, you’ll find this in many SEO tools. Moz has it. Different SEO tools have it. It’s basically an estimation of clicks for all your tracked keywords. So if you’re tracking hundreds or thousands of keywords, search visibility can show you an estimation of how much traffic you’re actually getting from those keywords based on rank and search volume and things like that.

B) Share of voice (visibility & volume)

Share of voice is very similar to that, but it’s not based on clicks. It’s based on visibility and volume. For enterprise, STAT does an excellent job with share of voice. What’s cool about share of voice is it tracks all of your keywords against all of your competitors for those keywords. So if you have 200 keywords ranking for best plumbers in Wisconsin, it will show you where all your competitors are and how much of that traffic you are actually gaining, whether it’s 13% or 30%. That way you can track against your competitors. It’s a much better metric than those individual keywords that don’t tell you much. 

C) Rank index (grouped keywords)

Finally, if you don’t have access to the premium SEO tools, you can do something which is called a rank index. A.J. Kohn has an excellent post on this. It’s a little older, but still very relevant.

A rank index is basically grouping all of your keywords by type. For example, maybe they all have the word “plumber” in them. You track their rankings together as a group, hundreds or thousands of keywords, and you can see fluctuations. That gives you a much better performance indicator than those individual keywords.

3. Site health

This is your on-page work, your technical SEO. Again, where most people stumble, this is not an audit. You don’t want to list every issue on your site, all the 404s, all the 500s, and things like that because no one really wants to read those things. They get very repetitive.

Focus on your most important issues

Instead you want to focus only on your most important issues. Generally, when I create an SEO report, that’s three to five issues. If people want more information, you can deliver it to them. You can give them in-depth downloads, site stats, and all that. But for the report, we only want to focus people’s attention on three to five issues, that they can actually fix, that you want them to work on. We’re going to list the most important issues on there that we want them to take action on. 

Pro tip: When you’re writing your site health report, use the word “because.” When you use the word “because,” it helps people take action. For example, “We have a lot of 404 pages on the site because we introduced some new broken links.” That tells people that we have a problem, this is why, and they want to take action. 

Show progress

Also, if you’ve made any progress since the last time you showed the report, you fixed those 404s, this is a good place to include it. 

4. Content performance

One thing I like to include, that often isn’t, is content performance. This is your top content, whether it’s a blog or whatever content you produce, by links, shares, and traffic.

Drive actions through recommendations

Now the reason I like to point out to the site owners content performance is because I want to show them what’s performing well to encourage them to create more of it. I want to drive action through recommendations. This content, this blog post that Britney wrote did very, very well. We should have Britney write another one on this.

Suggest topics, keywords, and authors

By doing this, you’re helping your client or your boss or whatever help you by creating that content that’s going to do well. 

Highlight low-performing content

Also, if you want to highlight low-performing content or content that has gone stale and is going down, this is also a helpful place to do that, just to help inform the decisions of your content team.

5. Opportunities

This is probably the most important one. This is the crux of the SEO report — opportunities. Opportunities is the key that you’re trying to drive here. These are recommendations. 

4–5 recommendations per month

Based on everything that we talked about here, what are the four or five most important things that we can do right now to improve SEO next month?

Prioritize

You want to prioritize. This is the most important. This is the second. 

Keep it simple

We want to employ KISS. If you’re not familiar with KISS, it’s an acronym, keep it simple, stupid. You’re not stupid. You’re just going to keep it simple.

You want to make your recommendations as simple and easy to follow as possible. One, two, three, four, that’s it. We’re not going to include everything. A lot of SEO reports want to list dozens of things. We want to hold those back. If you have dozens of fixes that you need fixed on the site, it’s probably not a great thing to put them in there because you’re going to overwhelm your clients and bosses and people taking action.

Provide exact steps monthly

Again, four to five a month or whatever sort of cadence you’re on, weekly, monthly, and how many things you think your client can reasonably tackle. Next month you’ll give them four to five more, and you’ll stay employed and you’ll continually have a new list of things to work on. 

Tie fixes to KPIs

You want to make sure they’re tied to the KPIs.

We want to fix these because they directly influence these. In fact, I want to shake things up a little bit. I know we listed number five as opportunities. Don’t end your report with that. Make opportunities the number one thing in your report. Open it up, here are the opportunities, and then here are KPIs, search visibility, etc., so they know exactly what they should be working on. 

We just released a new guide on SEO reporting. You should check it out:

Read the Guide to SEO Reporting

We released some new functionality in Moz Pro too if you’re into that sort of thing. If you have any questions, let me know in the comments below. If you like this, please share. Thanks, everybody.

Video transcription by Speechpad.com

* Checkbox GDPR is required

*

I agree

Will you like to book a consultation today?

We promise you’ll be glad to have us as the only premium website developer you’ve ever had!

Will you like to book a consultation today?

We promise you’ll be glad to have us as the only premium website developer you’ve ever had!

Bear Design - WordPress Development

Bear Design provides website development and design, creating content uploaded websites and improving web page placements and web traffic. Bear Design websites are unique, easy to use and responsive. Site owners can easily edit the content, or can trust the Bear Design & Communications to keep them up to date and supply quality content regularly.


GET IN TOUCH
160 City Road, EC1V 2NX London, United Kingdom
Monday – Thursday: 9:00 AM – 5:00 PM
Friday: 9:00 AM – 2:00 PM

WE ARE IN LONDON

Bear Design - WordPress Development

Bear Design provides website development and design, creating content uploaded websites and improving web page placements and web traffic. Bear Design websites are unique, easy to use and responsive. Site owners can easily edit the content, or can trust the Bear Design & Communications to keep them up to date and supply quality content regularly.


WE ARE IN LONDON

GET IN TOUCH
160 City Road, EC1V 2NX London, United Kingdom
Monday – Thursday: 9:00 AM – 5:00 PM
Friday: 9:00 AM – 2:00 PM

Bear Design - WordPress Development

Bear Design provides website development and design, creating content uploaded websites and improving web page placements and web traffic. Bear Design websites are unique, easy to use and responsive. Site owners can easily edit the content, or can trust the Bear Design & Communications to keep them up to date and supply quality content regularly.


GET IN TOUCH
160 City Road, EC1V 2NX London, United Kingdom
Monday – Thursday: 9:00 AM – 5:00 PM
Friday: 9:00 AM – 2:00 PM

WE ARE IN LONDON

© Made with by Bear Design

© Made with by Bear Design

    We are Bear Design

    WE DESIGN

    YOUR WORLD

    Bear Design & Communications Ltd.

    Address : 160 City Road, EC1V 2NX London, United Kingdom
    Phone : +36 702 448 100
    Email : [email protected]

    Opening hours :
    Monday – Thursday: 9:00 AM – 5:00 PM
    Friday: 9:00 AM – 2:00 PM

    Are you sure?
    You must approve our cookie policy to use our site. I you refuse it you will redirect to the Google.
    Refuse
    Approve Cookies
    Cookie Policy
    Cookie Policy
    This Bear Design Cookie Policy (“Policy”) outlines the general policy, practices, and types of cookies that Bear Design And Communications Ltd.. (“Bear Design”, “we”, “us” or “our”) may use to improve our services and your experience when visiting our websites.Cookies are small pieces of text used to store information on web browsers. They’re used by many websites to store and receive identifiers and other information on devices, such as a handheld phone or computer. Our site and services use cookies and other similar technologies (collectively in this Policy, “cookies”), in order to provide a better service to you and to generally improve our sites and services. For example, we may use cookies to help direct you to the appropriate part of our websites, by indicating that you are a repeat visitor. We may also use information to present you with services that are matched to your preferences.Some portions of our websites are functional without cookies, and you may generally choose whether to accept cookies. Most web browsers are set to accept cookies by default, however, you may be able to delete cookies yourself through your browser’s cookie manager. To do so, please follow the instructions provided by your web browser. Please note that disabling cookies will reset your session, disable auto-login, and may adversely the availability and functionality of our websites and the services we can provide to you.As part of our services, we may also place cookies on the computers of visitors to websites protected by Bear Design. We do this in order to identify malicious visitors, reduce the chance of blocking legitimate users, and to provide customized services.Our websites use first party cookies (i.e., cookies set directly by Bear Design) as well as third party cookies, as detailed in the table below.
    Type of CookieWhy we use these cookiesWho serves them and where can you find out more information?
    Analytics and research of usersThese are used to understand, improve, and research users visiting //beardesign.me and their needs for our product offerings. For example, we may use cookies to understand what pages a user browses before submitting a sales request form. We do not share information about this analysis with any third parties.Selected third parties listed and defined as follows:
    • Google Analytics – Web traffic tracking – //www.google.com/policies/privacy/
    • Bing – Conversion tracking from Bing ads – https://advertise.bingads.microsoft.com/en-us/resources/policies/microsoft-bing-adsprivacy-policy
    • Doubleclick – Google advertising platform that analyzes browsing activity across website to establish user profile – //www.google.com/policies/technologies/ads/
    • Twitter – Analyzes browsing activity across website to establish user profile – https://support.twitter.com/articles/20170514
    • Facebook – Analyzes browsing activity across website to establish user profile – https://www.facebook.com/policies/cookies/
    A user can delete these cookies through browser settings.
    Improving Website experienceThese provide functionality to help us deliver a better user experience for our website. For example, cookies help facilitate chats with our sales representatives, allow you to search the website, and deliver the user quickly to their intended website location.1st party and selected third parties as defined below:
    • __cfduid 3rd party cookie – This cookie is strictly necessary for Cloudflare’s security features
    • __hssc Cookie for keeping track of sessions. This is used to determine if we should increment the session number and timestamps in the __hstc cookie. It contains: the domain, viewCount (increments each pageView in a session), session start timestamp. (Expires: 30 min)
    • __hssrc Whenever HubSpot changes the session cookie, this cookie is also set. We set it simply to the value “1”, and use it to determine if the user has restarted their browser. If this cookie does not exist when we manage cookies, we assume it is a new session. (Expires: None. Session cookie)
    • __hstc The main cookie for tracking visitors. It contains: the domain, utk (see below), initial timestamp (first visit), last timestamp (last visit), current timestamp (this visit), and session number (increments for each subsequent session) (Expires: 2 years)
    • hsfirstvisit This cookie used to keep track of a user’s first visit. (Expires: 10 years)
    • hubspotutk This cookie is used for to keep track of a visitor’s identity. This cookie is passed to HubSpot on form submission and used when deduplicating contacts. (Expires: 10 years)
    • wordpress_ WordPress cookie for a logged in user.
    • wordpress_logged_in_ WordPress cookie for a logged in user.
    • wp-settings- WordPress also sets a few wp-settings-[UID] cookies. The number on the end is your individual user ID from the users database table. This is used to customize your view of admin interface, and possibly also the main site interface.
    • wp-settings-time- WordPress also sets a few wp-settings-{time}-[UID] cookies. The number on the end is your individual user ID from the users database table. This is used to customize your view of admin interface, and possibly also the main site interface.
    • __cfduid 3rd party cookie – This cookie is strictly necessary for Cloudflare’s security features
    A user can delete these cookies through browser settings.
    LAST UPDATE: 24.01.2018, LONDON
    Approve
    Refuse
    Cookie Policy
    This Bear Design Cookie Policy (“Policy”) outlines the general policy, practices, and types of cookies that Bear Design And Communications Ltd.. (“Bear Design”, “we”, “us” or “our”) may use to improve our services and your experience when visiting our websites.Cookies are small pieces of text used to store information on web browsers. They’re used by many websites to store and receive identifiers and other information on devices, such as a handheld phone or computer. Our site and services use cookies and other similar technologies (collectively in this Policy, “cookies”), in order to provide a better service to you and to generally improve our sites and services. For example, we may use cookies to help direct you to the appropriate part of our websites, by indicating that you are a repeat visitor. We may also use information to present you with services that are matched to your preferences.Some portions of our websites are functional without cookies, and you may generally choose whether to accept cookies. Most web browsers are set to accept cookies by default, however, you may be able to delete cookies yourself through your browser’s cookie manager. To do so, please follow the instructions provided by your web browser. Please note that disabling cookies will reset your session, disable auto-login, and may adversely the availability and functionality of our websites and the services we can provide to you.As part of our services, we may also place cookies on the computers of visitors to websites protected by Bear Design. We do this in order to identify malicious visitors, reduce the chance of blocking legitimate users, and to provide customized services.Our websites use first party cookies (i.e., cookies set directly by Bear Design) as well as third party cookies, as detailed in the table below.
    Type of CookieWhy we use these cookiesWho serves them and where can you find out more information?
    Analytics and research of usersThese are used to understand, improve, and research users visiting //beardesign.me and their needs for our product offerings. For example, we may use cookies to understand what pages a user browses before submitting a sales request form. We do not share information about this analysis with any third parties.Selected third parties listed and defined as follows:
    • Google Analytics – Web traffic tracking – //www.google.com/policies/privacy/
    • Bing – Conversion tracking from Bing ads – https://advertise.bingads.microsoft.com/en-us/resources/policies/microsoft-bing-adsprivacy-policy
    • Doubleclick – Google advertising platform that analyzes browsing activity across website to establish user profile – //www.google.com/policies/technologies/ads/
    • Twitter – Analyzes browsing activity across website to establish user profile – https://support.twitter.com/articles/20170514
    • Facebook – Analyzes browsing activity across website to establish user profile – https://www.facebook.com/policies/cookies/
    A user can delete these cookies through browser settings.
    Improving Website experienceThese provide functionality to help us deliver a better user experience for our website. For example, cookies help facilitate chats with our sales representatives, allow you to search the website, and deliver the user quickly to their intended website location.1st party and selected third parties as defined below:
    • __cfduid 3rd party cookie – This cookie is strictly necessary for Cloudflare’s security features
    • __hssc Cookie for keeping track of sessions. This is used to determine if we should increment the session number and timestamps in the __hstc cookie. It contains: the domain, viewCount (increments each pageView in a session), session start timestamp. (Expires: 30 min)
    • __hssrc Whenever HubSpot changes the session cookie, this cookie is also set. We set it simply to the value “1”, and use it to determine if the user has restarted their browser. If this cookie does not exist when we manage cookies, we assume it is a new session. (Expires: None. Session cookie)
    • __hstc The main cookie for tracking visitors. It contains: the domain, utk (see below), initial timestamp (first visit), last timestamp (last visit), current timestamp (this visit), and session number (increments for each subsequent session) (Expires: 2 years)
    • hsfirstvisit This cookie used to keep track of a user’s first visit. (Expires: 10 years)
    • hubspotutk This cookie is used for to keep track of a visitor’s identity. This cookie is passed to HubSpot on form submission and used when deduplicating contacts. (Expires: 10 years)
    • wordpress_ WordPress cookie for a logged in user.
    • wordpress_logged_in_ WordPress cookie for a logged in user.
    • wp-settings- WordPress also sets a few wp-settings-[UID] cookies. The number on the end is your individual user ID from the users database table. This is used to customize your view of admin interface, and possibly also the main site interface.
    • wp-settings-time- WordPress also sets a few wp-settings-{time}-[UID] cookies. The number on the end is your individual user ID from the users database table. This is used to customize your view of admin interface, and possibly also the main site interface.
    • __cfduid 3rd party cookie – This cookie is strictly necessary for Cloudflare’s security features
    A user can delete these cookies through browser settings.
    LAST UPDATE: 24.01.2018, LONDON
    Approve
    Refuse
    Welcome
    We use cookies to ensure that we give you the best experience on our website. Before you continue browsing you must approve or refuse our cookie policy.
    Approve
    Refuse
    Cookie Policy