Analytics with Ottimo
Technical audit: how-to & template
Improve the accessibility & SEO potential of your website
A healthy website is absolutely essential for success in content marketing.
We assess that health with technical audits. Now you can too.
Click the button below to duplicate the template into your Google Drive
Why we created this template
We begin every client engagement with a technical audit.
Replicating that audit was one of the first big tasks we had to figure out when Ercule started out, oh so many years ago.
This is the template we use now, refined over many iterations.
What you need to get started
- Google analytics account
- Google search console account
- Screaming frog SEO Spider
How this template works
- Import data from various sources
- Fill out the checklist to determine site health
Step-by-step: using the technical audit template
To start, open up the template and make a copy.
Pick the domain you want to audit
On the Audit tab, fill in the domain and date for the site you want to audit.
The first thing we want to do is pull in page performance data, to help us understand where our priorities are when it comes to fixing various technical issues.
To do this, we use a plugin called SyncWith to call data from various tools. For this audit, you want to pull in page performance data from Google Analytics.
Pull in data from Google Analytics 4 if possible, since Universal Analytics (aka GA3) is going to be deprecated starting @July 1, 2023
After configuring the report, click Update to call the data.
Next, you’ll pull in the sitemap. in the sitemapData tab – fill in cell A2 with the url of the sitemap. A formula will auto-populate the results after a few seconds.
Next up, we pull in data for the coverageData tab. For this report, you need to go to Google Search Console for the website, and find the Page Indexing report. Export relevant list of pages and copy to the sheet.
Crawl the site with SEO Spider
Now that all of the external data has been imported, we have to crawl the site. To do this, you need to download Screaming Frog’s SEO Spider, a web crawling tool. After installation, load our custom configuration file and get started.
Now, choose the domain you want to crawl, and input it into SEO Spider’s url box.
Next, go to configuration>API>Pagespeed Insights, and connect it to the crawler using your API key. Once this is done you can start the crawl.
After the crawl is complete, you’ll export 4 reports:
- On the internal tab, filter the crawl to just show HTML pages, export, and paste the data into the internalData tab
- In the menu bar, go to Bulk Export > Links > External Links and export, and paste the data into the externalData tab
- In the menu bar, go to Bulk Export > Response codes > Internal > Internal Client Error (4xx) Inlinks, and paste the data into the 404data tab
- In the menu bar, go to Reports > Redirects > All Redirects, and paste the data into the redirectData tab
Run through the Audit checklist
Now that all of the data is in place, walk through the items in the Checklist tab one-by-one.
Some of the items will be answered automatically by data in the Analysis column, others will require you to follow the link in the Report column to determine the correct status.
If you get stuck, Use the guide column as a reference to figure out what the purpose of the audit item is and what you’re trying to answer.
Everything we have to say on SEO, content performance, and content analytics – in convenient email form.
(Having doubts? Here's a recent issue.)