SEO Scorecard template
Crawl and summarization template
Communicating issues in your SEO audit to both marketing professionals, decision makers, copywriters, and developers is an important task. They all have different concerns and interests in SEO and your Audit.
Visualization is being remembered 650% better than text and our brain process visual information faster and easier than text.
Visualization is thus in our SEO Audits key if we want to communcate effectively and here Excel is an underestimated tool.
There are hundreds of tools in the market but they all visualize and set up data differently. This create a clutter of styles, tone of voices and data. Instead you can use Excel to put it all together in one sheet. This allows you to create branded visualizations for you SEO audit.
Collect and put together data in excel from tools like Screaming Frog SEO Spider, Ahrefs, Siteliner, Ranking tools and many others and use Excel to create powerful visualizations.
In the above you can see how I used Excel to create a radar diagram that give a top level scorecard of your website. The scorecard in the Excel SEO Template has been divided into the two main categories Tech and Content.
The overview is a great way to create an executive summary and visually point out the biggest potentials. This template is truly something I recommend when communicating SEO to the C level and it is easy to create in Excel.
This is an excellent way to visualize crawls and insert into your SEO audits. It give yourself and your stakeholders great knowledge into the sidewide performance of the website. And Excel lets you easily filter out data to narrow the graphs down to where you want.
My background is a Master of Science within IT E-business where i mainly focused my studies and thesis around SEO. For the past 5 years I have been an active blogger and speaker at Danish Marketing conferences.