Hi,
Here is my current flow using a series of python scripts its all fully automated right now, but kind of dirty the way I am doing it.
1. Have 2 excel files
- Giant ass "TODO" keyword list
- All my links in sitemap.xml (Automatically downloaded and pulled after each post)
2. Using a content-based AI to do paragraph based generation on the "TODO" keyword list
- Best SEO practices
- Q&A's after every X amount generated articles (Roughly 33% of the time)
- Always using Tables on any short keywords /w high volume (Which usually means it will be a pillar based on my sheet my excel sheet could be better for this)
- Interlinking based off always updating sitemap.xml
- Is ran through various data cleaning, human checks, and copy checks.
3. Posting (this is the hardest part for me but it's still automated)
- AI chooses categories, if a new category must be made its ignored.
- Always tries to nest itself under pillar if possible (Finds internal links with tables)
- Will fill out the data in SEO plugin and will regenerate if % is not hit for the main keyword. Goes back to step 2 with the SEO plugin's instructions
- Finally, post is made
This is my current content solution, I feel as if there is an easier way to do things, there are a lot of spinning plates here, but currently its 99.5% automated. My work involves feeding thousands of keywords at a time and running through ahrefs shitty estimations.
Am I missing something, a better plugin, a better way? Maybe some ideas on how to improve the content?
Here is my current flow using a series of python scripts its all fully automated right now, but kind of dirty the way I am doing it.
1. Have 2 excel files
- Giant ass "TODO" keyword list
- All my links in sitemap.xml (Automatically downloaded and pulled after each post)
2. Using a content-based AI to do paragraph based generation on the "TODO" keyword list
- Best SEO practices
- Q&A's after every X amount generated articles (Roughly 33% of the time)
- Always using Tables on any short keywords /w high volume (Which usually means it will be a pillar based on my sheet my excel sheet could be better for this)
- Interlinking based off always updating sitemap.xml
- Is ran through various data cleaning, human checks, and copy checks.
3. Posting (this is the hardest part for me but it's still automated)
- AI chooses categories, if a new category must be made its ignored.
- Always tries to nest itself under pillar if possible (Finds internal links with tables)
- Will fill out the data in SEO plugin and will regenerate if % is not hit for the main keyword. Goes back to step 2 with the SEO plugin's instructions
- Finally, post is made
This is my current content solution, I feel as if there is an easier way to do things, there are a lot of spinning plates here, but currently its 99.5% automated. My work involves feeding thousands of keywords at a time and running through ahrefs shitty estimations.
Am I missing something, a better plugin, a better way? Maybe some ideas on how to improve the content?