Luke Davis

Morsel #25: templates are meant to be flexible

Filed under: data viz | SEO | tech | Web performance

When I started in tech SEO, my audits were in the classic Google Docs checklist format. I remember getting feedback on one of my first ones and I felt awful because I had no idea how I was supposed to do it any differently; reports were written as documents and that was that.

But over time, I learnt that data representation can take on so many different forms and perhaps a Google Doc isn’t the right way all the time. I now present my audit findings in a spreadsheet with a prioritisation framework adapted from CXL’s PXL framework. I list the following things:

I made this to remove a lot of the guesswork out of auditing as our priorities may not be the same as other peoples’ priorities. This idea came after years of doing things in different ways and I may end up changing this or adapting it further (the current format has only recently been changed to include more things).

For web performance audits, I ditched documents for slide decks. I present a basic agenda, what all the metrics mean and what data I’ve looked at, and outline each Core Web Vitals metric and the issues with recommendations. This is a way to meet stakeholders wherever they are in terms of web performance knowledge and ensure developers know what they need to do to investigate and fix issues. It also helps if you can show how these issues affect revenue and conversions!

My point is with anything we present, templates need to be flexible to get everyone on board and to understand what the problem is and how to fix it. A document may do this but maybe a slide deck can, or an organised spreadsheet, or even some cool interactive data visualisations. That fluidity is what will get people engaged and interested in making the Web a better place.

Semi-related:

Morsel #24: Python Morsels Morsel #26: vibe recursion