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 Https://Example.com 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