I won’t lie, a little bit of a taboo headline in the industry intended to generate a lot of traffic and discuss topics and ideas already well versed all over the Internet.


That’s exactly why I chose it.

We all know that fresh, relevant and well-written content gets recognised by those in the industry as well as those seeking more information which in turn crafts you, or your business as an authority figure in the industry. Google recognises this and rewards you by ranking your pages higher up on search engine ranking pages (SERPs).

What I hear a lot from my clients is the fact that keeping an updated blog, or social presence with new content is a very time consuming task and they would much rather spend it elsewhere because, to be frank, they don’t see the value in writing content when they see no one coming through the pipeline.

Let’s say you’ve got a new website, and some relevant content uploaded – lets maximise the impact of each page by performing an SEO audit to identify whether or not your pages are working as hard as they could be to draw in some traffic – and if not – let’s fix it!

So, an SEO audit, where the f*#k do I start – you might hear yourself say in your head.

Lucky for you, we’ve prepared an Excel spreadsheet to tell you exactly where to start – and be on your way to ranking higher on Google search results.

Download the SEO Audit Worksheet

The spreadsheet outlines the important key ranking factors that you can change right now to maximise each page’s impact to your overall website’s SEO.

  • Page Title (Meta Title) – The page title helps define the content of the page in the most clear and concise manner. This is written for both the search engine to index, and for your audience to understand the content and entice them to click. The page title should be between 50-60 characters in length.
  • Page Description (Meta Description) – The page description is a short ‘blurb’ of sorts that helps summarise the content on the page. This is written for both the search engine, and the audience. The search engine will take the meta description and display it underneath your meta description in search results pages (it is worthwhile to note that the meta description is in fact not a ranking factor in Google’s search results ranking algorithm). However, your meta description shouldn’t just be a random string of your keywords that you want to rank for, as it is important to write a captivating description to capture and engage your audience to entice them to click. This works in your favour as it’ll help prove to Google that your site is relevant to the search term used to find your site – and in turn boost your rankings.
  • Heading 1 Tag (H1) – There should only be one H1 tag on your page which should align with your focus keyword, and the meta title of your page. You’ll want to make sure that the H1 tag starts with the keyword as this’ll reinforce the notion of the content for Google.

Here are some useful resources to help you write some eye-catching and captivating meta titles, descriptions:

How to create the right meta description • Yoast


Meta Titles and Common Mistakes to Avoid

How to use our SEO Audit Spreadsheet

  1. Download the spreadsheet
  2. There are a couple of columns you’ll need to populate before you can begin writing:
      • Populating the URL column You’ll need to access your website’s sitemap to view all the different URLs for all the pages on your website. Once you have these, you can paste them into the URL column of the spreadsheet
      • Populating the Meta Title column BuzzStream has a fantastic tool for extracting meta titles and meta descriptions from a list of URLs. Just copy and paste all your URLs into their tool here: Extract Title Tag and Meta Description from URLs – Free SEO Tool
      • Populating the Meta Description column From above, just copy the meta description into the meta description column.
      • Populating the H1 column You can populate this column beforehand, or when you get to the H1 improvement column. Just visit the corresponding page with the URL and type in the H1 tag on that page.
  3. The next step is to work row by row, starting with the ‘focus keyword’ and then using that to align your title, description and H1. You can use the prompts in the column heading to help you out.
  4. Finally, once you’re happy with each – load em up onto your site – and track your Google search ranking periodically to see if the changes you’ve made have had an impact.

This exercise usually works best when you are tracking the before and after. Google has a suite of tools that help with this, in particular, Google Analytics and the Google Search Console.

That’s all from me – but as always – if you have a question please feel free to let us know by dropping us a line at hello@digitalhut.com.au, or reaching out to us on one of our social platforms!