If youāve been following Benās amazing content for any time youāll know about the benefits of content at scale.
As much as I love scaled content production, this brings along its own issues.
One big one is...keyword prioritisation.
Iāve seen far too many great content strategies get lost in a spreadsheet of 10k keywords with no idea what to do next.
Iām Tim Hanson, owner of fivethreeoh. Iāve built content strategies for 50+ series A-E SaaS clients. At this point, Iāve organised and prioritised a few million keywords to help make my clients over Ā£23m in revenue from organic traffic in the last 3 years.
I used to do this manually. Over 5 days. Now it takes an hour.
In this newsletter, I'll show you how I do it for my clients.
Iāll take a list of 10k+ keywords and prioritize them so that:
- Easy wins come first
- They're aligned to business goals
- Whilst also giving the difficult content the time it needs to rank
We'll need a few things: A keyword list, some data against those keywords, and about an hour of time.
This one hour will save me months in flopping around, back and forth, making no headway.
Iāll then create a formula in Google Sheets to spit out a number based on the various inputs Iām gonna give it.
- Those inputs depend on what Iāve gotten from the tools weāve used, search vol, cpc, cps, a keyword difficulty score, an āSEOā score, trending data, how many keywords are being considered in the same search, SERP overlap, etc.
- Iāll need to know what my goals for this content are, too. Is it traffic? Is it conversion? Topical Authority? Iāll need to chat with my client to get straight on this.
With this data, Iāll create a series of prompts to help me work through this problem and give me a formula that works best for me, the data I have, and the goals I have.
Now, letās have a chat with our favourite AI chatbot.
Iām gonna use ChatGPT.