Free SEO Reporting Template for Digital Marketers

Tim Hopma 8 years ago

Everything we do in marketing MUST ALWAYS be measurable and we must understand the effects of our work and prove value in what we’re doing. Reporting is the tangible manifestation of this. We have recently launched a new tool which goes into detail as to how, why and when to report, using this free SEO report format Excel - here is the FREE template that you can download and use for your own reporting, and we'll cover below how to use it.

"I’ve always said that I learnt SEO via reporting. Finding the right data, understanding it and commentating on it - and overlaying this on top of the work/tasks undertaken – can only breed knowledge. Reporting has value beyond simply communicating numbers." Mark Leech

Reporting on the right data is imperative and this is usually defined by two things:

  1. What the business/client wants to see (i.e. the KPIs)
  2. What shows digital value outside of KPIs (this is the bit that adds value and context)

'Client X' (or senior management in-house) may be measuring SEO on traffic, revenue and some key rankings and, ultimately, this then has to form the basis of reporting. On top of this, we can explain how those KPI numbers have been achieved.

Equally, however, additional 'over-and-above' metrics can become a hindrance, so ensuring they truly add value and are insightful is key. Trying to achieve the right balance here can be difficult, which is why we’ve produced a downloadable Excel template so you can cover the basics well.

What does the free SEO report include?

Here's a list of the metrics which the Excel template covers:

  • Organic traffic

    • The visits arriving from search engines
  • Organic conversion

    • The commercial benefit those visits drive
      • Transaction/conversion volumes
      • Revenue
      • Average order value
      • Conversion rate
  • Engagement metrics

    • How visitors are behaving on site
    • Bounce rate
    • Time on site
    • Pages per visit
  • Key landing pages

    • How key pages are performing
      • Traffic
      • Bounce rate
      • (Conversion data by page is not in the template, however this may be a worthwhile addition for your business)
  • Search visibility

    • A tangible way of showing overall search presence improvements
    • Number of terms ranking
    • Position spread
    • Volume of organic landing pages
    • Number of terms sending worthwhile clicks
    • Overall trend
  • Key rankings

    • Ranking movements for commercially valuable terms
      • Use a consistent source as there are so many variables in today’s SERPs
  • Top performing keywords

    • Which keywords are sending commercially valuable traffic?
      • Clicks by keyword
  • Link acquisition/velocity

    • How the domain’s link profile is changing over time
      • Referring domains lost
      • Referring domains gained
      • Ratio
  • Authority metrics

    • How the domain’s authority is changing over time
    • Citation Flow
    • Trust Flow
  • Commentary

    • You can include all the metrics in the world, but what do they mean and how have they been achieved?
  • Key time comparisons to consider

    • Included in the template
      • Week on week
      • Month on month
      • Year on year
    • Not included in the template
      • Since start
      • Month to date
      • Year to date
      • Quarter to date
      • Custom comparisons such post-site launch versus pre-site launch

We believe this setup should cover the most common SEO KPIs, plus some over-and-above metrics that can prove further value and add context to KPI performance, whilst keeping the report simple and clear.

The template includes manually-entered week-on-week, month-on-month and year-on-year percentage comparisons. However, you may wish to replace these with your own formulas, if needed. Conditional formatting has been added to highlight positive and negative movements. The trends featured (fuelled by the data in the second tab) can also be changed to other metrics if you need, you’ll just need to change the data that populates them.

And finally, the report has been populated with sample data so don’t forget to make sure you change it for your own information.

Feel free to edit and tweak the template to suit, and if you think there’s anything we’ve missed in the template then please let us know in the comments below. We have kept the report to a single A3 page but this can, of course, be expanded or condensed if needs be.

If you have any questions about where to get any of the metrics from, or if you need further insight into why any of them are important, please take a look at our SEO service page or get in touch and we will be happy to help you.

To download your FREE SEO Reporting Template, click on the button below!

 

Stay in touch with the Zazzle Media family

Sign up for our monthly newsletter and follow us on social media for the latest news.

Our website uses cookies for various purposes and to enhance the site’s functionality. This helps us understand how you use and interact with the website.

Settings Accept Cookies