What’s better than a win?
A quick win.
Combine this with SEO and you’ve got yourself some quick win keywords.
🔥How to find quick win keywords
In this article I’ll walk you through how to use APIs + spreadsheets to find keywords you can results from FAST.
WTF are quick win keywords?
Sometimes they are referred to as low hanging fruit keywords or even striking distance keywords.
But the point remains the same:
Keywords you can make a few tweaks to and see noticeable improvements quickly. Hence the name.
I’ve classed quick win keywords as terms you rank on the first/second page for (average position of 5-20) but not within the top positions.
So how do I find them?
By analysing the keywords you are ranking for.
You want to look for keywords hovering between the bottom of the first page and top of second page of the SERPs. Like I’ve said, keywords with an average position of between 5 – 20.
Basically any rankings not within the top positions.
Now there’s a couple of ways you could get this info:
- You could filter by position in Ahrefs, SEMRush, Serpstat etc.
- You could export your rankings from a rank tracker and analyse your positions.
- You could comb through Search Console data.
Or, you can just make a copy of my spreadsheet and let it do the work for you:
Yeah yeah, but what about the results?
Okay, I can hear you:
This tool/google sheets thingy sounds great, but does it actually get results?
Yes. Yes it does.
Working as a digital marketing consultant, when starting to work on new sites for the first time, I always like to check for quick wins.
Here’s some results:
Client Results #1
B2C & B2B client targeting competitive London keywords:
Client Results #2
B2C Client targeting buyer-intent keywords:
Client Results #3
B2B client targeting really niche keywords:
How it works & setup instructions
First things first:
Go grab yourself a copy here.
To get it working, you only need 3 things to get the tool setup:
- Google Sheets
- Search Console Add-on
- And a website (with GCS setup obviously*)
*If you haven’t setup Google Search Console for your site, why not? Go and watch this GSC Setup guide then come back.
There’s two ways to use this tool:
- Automated via Search Console – This method uses an API to pull in GSC data and then wrangles it in an easy to understand sheet
- Manually via a rank tracker – This method allows you to copy and paste existing rankings in and find your quick wins. Particularly useful for projects where you perhaps don’t have access to a client’s Search Console.*
Pick which method you’d like use, and follow along below:
Automated via Search Console
1) Install this add-on to pull in Search Console data: searchanalyticsforsheets.com
2) Authorize your sheet by going to Add-ons >>> Search Analytics for Sheets >>> Open Sidebar
⚠️Make sure your Google account is authorized to use the Search Console property you want to back up!⚠️
3) Choose your site. Make sure to add Query & Page to the Group By box:
4) In Results Sheet, select ‘RAW DATA’ (If you don’t select the RAW DATA tab, it won’t work. 👎)
5) Now request data. This will get the spreadsheet goblins working and you should see your quick win keywords! 👍
Manual via Rank Tracker of your choosing
1) Export your rankings from your tool of choice.
2) Tidy up your export: you only want 3 columns of data: Keyword, URL and Rank.
3) Paste these 3 columns into the MANUAL tab.
4) Once you’ve pasted your keywords, your data will populate in Quick Wins [Manual] 👍
Go forth and tweak…
But what kind of tweaks?
So you’ve got your list of quick win keywords. But now what?
Often, getting results from quick win keywords is just a matter of either improving a page or updating a page.
Here’s a few things you can try:
Do more (or better) keyword research
Going after the right keywords can make or break an SEO campaign.
So sometimes it’s worth a refresh.
It’s far beyond the scope of this article to tell you how to improve your keyword research, so here’s some useful guides you should read to up your keyword research game.
- How To Do Keyword Research for SEO – A great article put together by Ahrefs which serves as the perfect introduction to keyword research. Ahrefs, need I say more.
- How To Do Keyword Research in 2018 – Want to go a bit deeper with your research, go read this. Everything the team From The Future puts out on their blog is worth a read.
- A better approach to keyword research for content marketing – If you want to get more results with content marketing, go read this. It only takes 11 minutes to read but you’ll be thinking about it for a lot longer!
- 75 Keyword Research Ideas – If you are stuck for ideas, go read this.
Make sure your pages are optimised. If you know what keywords you are going after (see previous section) this is easy.
You’ll want to make sure your keyword are in:
- Your title tag
- Your URL
- In Your H1 tag
- And variations of keyword used throughout your page.
Sometimes a page won’t be ranking as well as it could be simply because it is not targeting a specific keyword effectively.
Just make sure to get the balance right between optimized for a search engine vs optimized for a user.
- On-Page SEO: Anatomy of a Perfectly Optimized Page – When it comes to getting a goo grounding in on-page SEO, you can’t really go wrong with this guide by Brian @ Backlinko.
- 19-Step On-Page SEO Checklist – This is an awesome article that walks you step by step through optimising your site. And it comes with a free automation template. What more do you want?
- The Complete Guide to Blog SEO – A great primer on optimising your Blog by Ryan Stewart @ Webris. Seriously, anything they put out is golden. 👌
With quick win keywords, you don’t necessarily have to create brand new content.
It can be a case of reworking what is there, rewriting sections or adding in additional sections. Relevancy is key here.
As the the 21st century philosopher Missy of Elliot proposed:
“Is it worth it? Let me work it. I put my thing down, flip it and reverse it”
Either write it yourself or hire a content marketer. It doesn’t really matter which, just produce useful and topically relevant content.
If you want a heads start in content marketing, go read anything by Jimmy Daly @ Animalz, but start here with his awesome post about core content marketing concepts.
Grab a list of the most linked pages of your site (HINT: in Search Console).
Add links on those pages back to the pages you want to rank higher. Make sure to take care with your anchor texts.
To find internal link targets, use this search operator:
Keep anchor text, amount of links and the actual pages you link to in check. Don’t over do it. Oh, and go read this internal linking guide.
Link links links.
Some people have pretty strong feelings about linkbuilding. Instead of overthinking it, I like to just go build them.
Point them at the URLs you want to rank higher. Don’t overdo it with exact match anchors and try to be natural with it.
There’s loads of ways to build links. Some are scaleable, some aren’t. Some will work for a long time, some will be out of date next week.
Use your noggin and build links that make sense for your website.
- Link Building Strategies: The Complete List – A great collection of linkbuilding tactics, 184 at my last count. Go pick and test drive a few for yourself.
- 13 Advanced Link Building Strategies You (Probably) Haven’t Used – Glen Allsopp (aka Viperchill) is the Godfather of linkbuilding. His strategies are the kind of things you wish you thought of first.
- Audience First Link Building – A really great list of actionable tips to make sure you keep focussed on your audience when link building.
- Local Link Building Tactics – 50 local link building tactics by Loganix to help build high quality links as part of a local SEO campaign.
- Loads of Google Sheets templates to use for SEO & marketing.
SEO is all about ROI.
If you are spending too much time and money on getting the right traffic to your site, you’re not going to have a good time.
I’ve always subscribed to the ‘do more of what is working’ school of thought.
I call it lazy efficiency.
That’s why I built this tool. To speed up SEO & keyword prioritization for me.
Less time spent analyzing and prioritising keywords means more time spent creating content, building links and getting away from a screen. All important parts of an SEO campaign IMHO.
That’s it. Get yourself a copy of the Quick Win Keyword Finder and optimize away.