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
An introduction to using pivot tables in Excel with slicers to be able to better visualise your data. This is perfect for anyone who is just starting out in SEO, and particularly in Excel, that wants to understand some foundations. Creating a pivot table in Excel You’ll need to get your data setup properly, and
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
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
Ever wanted to see the top-ranking domains / URLs for a particular keyword set? This analysis will let you do exactly that, and give you more refined performance data, allowing you to dig into the true top performers. There are a few tools out there that let you see the top competitors and their estimated
Doing keyword research, and have a million CSV files that you need to extract data from? Well, this is where a handy, and rather tiny, merge CSV files SEO hacks that has saved me plenty of time over the years comes in. The ability to merge as many CSVs as you want into a single
Merging Multiple CSV Files Together with CMD (Windows Command Prompt) Read More »
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 »
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 »
