Excel/Google Sheets

Estimating SEO Traffic for a Keyword Set

Estimating your organic traffic will allow you better assess your current performance for a set of keywords, but also allows you to directly compare that performance with your competitors. In this video, I run through how to properly set up your data and run the formula across a set of categorised keywords. This will be …

Estimating SEO Traffic for a Keyword Set Read More »

Bulk Generating Keywords for SEO

Discover the easiest ways to generate keywords in bulk using Excel. These formulas are the basis of so much work, and keyword generation really will just give you a top-level understanding of the formula’s use.   Concatenate – Join as many cells together as needed =CONCATENATE(*First CELL to join*,*Second CELL to Join*) Concatenation is a …

Bulk Generating Keywords for SEO Read More »

Bulk Generating Page Titles in Google Sheets (and Excel!)

Yeap, chances are that if you’re working with a large enough client that you’re contemplating bulk-generating page titles for, you’d be working with a dynamic system. Ideally, you can just give the developers your rules and they’ll build them in and you don’t need to manually generate anything other than some examples. Ideally. So, in …

Bulk Generating Page Titles in Google Sheets (and Excel!) Read More »

Stripping and Rebuilding a URL Structure for Migration Testing

Some clients have recently required a migration mapped out for 10’s to 100’s of thousands of URLs. To do this, we needed to capture all the different URLs, build out the migration rules, and then test the redirects. Mapping out and building the rules is one thing, but then how do we bulk generate what …

Stripping and Rebuilding a URL Structure for Migration Testing Read More »

Scroll to Top