For those looking to DIY their SEO report cards, but don’t necessarily live in the “SEO world,” making sense of all the analytics, keyword and technical data about a website can be overwhelming. What’s the most important thing you should look at?

Keyword rankings?

Website traffic?

Landing page traffic?

Local citations?

Duplicate content?

So for those out there who want to take SEO auditing and SEO report cards into their own hands, we’ve got a nifty guide that will help you put together the best DIY SEO report card for your website.

Get Your SEO Report Card Template

Don’t feel like doing it yourself? Start your 14-day free trial and get your own SEO report templates! Sign up now!

What to Include in Your SEO Report Card

This is probably question number one for most people putting together their first SEO report card. And it’s a good one. After all, even when your data is completely accurate it won’t help your marketing if it’s not relevant.

So what type data should you include in your SEO report card?

  • Crawl errors – what’s stopping Google from finding your content?
  • Technical SEO – do you have issues with canonical URLs, hreflang and site structure?
  • Backlinks – are you building link juice for your site?
  • Mobile friendliness – does your website work well on mobile devices?
  • User behavior – how are users interacting and engaging with your website?

However, an effective SEO report card doesn’t just list the data. Report cards have grades, right? The best method is to use the stop light color code so you can quickly and easily see your website’s overall SEO health.

How to DIY It

You can use a tool WooRank, for example. We’ll even do it for free!) to create an SEO report card for you. But you’re looking to DIY it.

So how should you build your report card?

I like to use spreadsheets to build templates. Spreadsheets are easy to keep organized and use to format based on data.

Start by creating columns for:

  • Criteria – This will be each individual item you are scoring in your report, such as title tag or robots.txt.
  • Content – This column contains any text that accompanies a criteria, like meta description or link anchor text
  • Count – Put the total number of backlinks and linking domains in this column, as well as the character count for text-based criteria.

You can put all of your criteria in one tab, or you can create a tab for each section such as technical SEO, backlinks, engagement, etc. This is a little helpful in keeping things organized and making sure you don’t miss something. You also have the option to create a column for every criteria that is evaluated as a number. Doing this will make your spreadsheet a bit unwieldy, but will make your next step a bit easier.

Now, conditionally format your cells so you can score your website’s SEO.

Format your cells so that aren’t within an ideal range, such as title tag or meta description character counts, will display as red, while the rest will show as green. The same goes for the number of links and linking domains and user behavior statistics.

Use text-based rules to score yes/no criteria such as robots.txt files and XML sitemaps.

Don’t get lazy and neglect to highlight passing criteria in green. Knowing what’s been done correctly is just as important in knowing what still needs to be fixed.


You’ve just created a simple, do-it-yourself SEO report card.

Make It Look Good

Since we’re making an SEO report card template, we should set this up to make it easily usable in the future.

So make it look nice, especially if you’re creating this report card for bosses, teammates, (potential) clients or other stakeholders.

If you’re doing an all-inclusive SEO report card, it might be useful to create a branded cover page that include prioritized recommendations, improvements made since the last report and how traffic and/or scores have changed over time.

People will absorb the data better if it’s easier on the eyes.

Don’t Want to DIY? We’ll Do It For You

If you’re reading this, there’s a good chance you do want to make your own SEO report card. But if you don’t want to, don’t worry about it. You can use WooRank to do it for you.

Just type your URL in the generation bar at the top of this page and hit “Review” to get a nice detailed, formatted and actionable SEO report card for site. Instantly!