If you haven’t been following along, I’ve been documenting my journey to a 1,000+ page programmatic site in WordPress using Google sheets. The build is heavily reliant on Google Sheets to generate dynamic content based on templates. The content there is a little more advanced, as it is leveraging rules to determine which content template …
When doing keyword research for programmatic sites, you shouldn’t be analysing each page individually. You especially can’t be optimising an entire programmatic build page by page. You should really be looking at the overall group, that each page falls into, and looking it as a whole. How do we do this though? How can we …
Extracting Keyword Templates/Patterns from a Keyword Set Read More »
Rather than performing analysis using just the bare average rank, you can bring in a keyword’s search volume and add some weighting to the rank. To do this, you estimate SEO traffic for a keyword by multiplying its current rank, by the estimated click-through rate at that position. It’s not meant to be extremely accurate, …
Building Your Own CTR Model from Search Console Data Read More »
Batch downloading images, and renaming them, isn’t something you’ll use often, but when you do, doing it in bulk can really save you quite a bit of time. Why would you want to do it? Well, plenty of reasons. From migrating images, wanting to bulk optimise their file names, or downloading imagery from brands for …
Bulk Download Images from URLs – Convert & Rename Read More »
When you start doing SEO data analysis, one of the first things you’ll find out is that GSC only gives you 1,000 rows of data. So how do you extract the rest of the data? How do you get more keywords, and more landing pages downloaded from GSC? Search Analytics for Sheets Whilst there are …
Data preparation is the base of any good analysis. Getting it right from the start will just ensure that any analysis you do in the future, will be nice and easy for you. It’s back to basics time! I run through a number of different basics, from file naming and why you should follow a …
Categorising a large keyword list in bulk takes hours to do, unless you do it a special way. Learn how to categorise thousands of keywords in seconds through the use of a magical Excel formula. You can categorise data in Excel with this formula, it doesn’t only work on keywords. Another popular use of mine …
When downloading a pre-built Excel dashboard, or moving one around on your computer, you might experience an error and you won’t be able to open your PivotTable. The error will come up and say ‘Cannot open PivotTable source file’ and then include the file name. The simple fix is to disconnect all slicers, remove the …
Turn your file-based dashboards into a link, and let your clients / stakeholders view them online! No more sharing files, just send the link.
An overview of how graphs in Excel work, and the basic behind customising the look. This is a great starting point if you’re just getting into SEO, and want to play around with a data set in Excel. Yes, Google Data Studio and Google Sheets are replacing a lot of this now, but this is …
