Jun '25 • General discussion
SEO keyword Research and on page Optimisation workflow
I am working on this flow and then I messed it up, oops anyone want to chime in?
Clients uses basecamp and basecamp sends email and basecamp in app message.
Subject = keyword research which is the task title.
That has
Website url
1
keyword
2
keyword
3
Keyword
4
Keyword
5
keyword
Locations or target markets
Cape town
Johannesburg
Pretoria
Needs to understand this and then find keyword on Google that people are actually typing.
Add to a google sheet and group them as per related keyword
Eg
Seo services
Seo cape town
Seo Johannesburg
Seo south Africa
Skip two rows Nest set of related keywords
Good ads
Google ads management
Google ads cape town
Google ads Johannesburg
Google ads south Africa
Skip 2 rows
Website design
Website design services
Website design cape town
Website design south africa
Website design Johannesburg
Once has the list or even at the same time gets search volume, cpc and competition data from google ads and need to be in the currency and Location of the country.
Then sends each keyword group set to chat gpt to create the meta title, meta description and h1 tags and optimized url
Chat gpt instructions are from a custom prompt.
Then these are sent to a sheet that are filled into specific rows and cells
1
2 comments
SEO keyword Research and on page Optimisation workflow
skool.com/systems-to-scale-9517
A community for mastering AI, Agents, and Automation.
Join today for immediate value!
Leaderboard (30-day)
1
🔥
+506
2
+397
3
+126
4
+100
5
+70
Powered by