No need to waste money on buying PAA sites. You can make your own PAA site with hundreds of posts in a few hours.
Here's an easy tutorial and python script to make your own PAA site.
I don't like combining multiple PAA questions in one post so tutorial will show you how to create an article for each PAA question.
The only thing you'll need to refine is the prompt you use to create the content with OpenAI. I've included a very basic prompt. The output with this prompt is not going to be great. The output may even be too short to be usable.
You'll need to come up with your own prompts that are tailored for your niche.
DO NOT skip this step.
Prompts are the most important part of the entire process. Take some time and come up with a great prompt that'll produce high quality content.
Step 1: Select a niche
I recommend selecting a sub-niche within a broader niche. Working with smaller niches is much easier and you can build topical authority and rank quickly. For this tutorial, I'm going to use "Yerba Mate" as an example.
If this is your first time, I recommend selecting a super small niche like the one in the example.
Step 2: SEO Minion
Step 2 is straight forward. Use a VPN server in your target country, Google the main head term and scrape the PAA using the SEO Minion Chrome extension. You can use as many levels as you like. I'm using 8 levels for this example.
Step 3: Remove Duplicates
Use Excel/Numbers/Google Sheets to remove the duplicate PAAs. SEO Minion doesn't remove the duplicates so it has to be done manually. Also, make sure that all the PAA's are related to the topic. Sometimes, the PAA's have no relation to the topic. I suggest taking the time and manually going through the questions. Remove anything that isn't relevant.
Step 4: Prepare The CSV
We need to prepare the CSV for the script. It's pretty easy to do.
This is the output from SEO Minion:
View attachment 239045
Delete all the columns except PAA Title and Text. Rename PAA title to topic. Rename Text to context.
This is how the final CSV should look:
View attachment 239046
Rename the file as "input.csv".
Step 5: Use OpenAI to Generate Content
You're now ready to generate content using the OpenAI API. You'll need to use your OpenAI API key.
Here's the Python code you need to use:
Code:
import openai
import pandas as pd
df = pd.read_csv("input.csv")
# Set OpenAI API key
openai.api_key = "YOUR_API_KEY"
results = []
for index, row in df.iterrows():
prompt = f"Please write a detailed article about {row['topic']}. Use this information to write the article: {row['context']}"
response = openai.Completion.create(engine="text-davinci-003", prompt=prompt, temperature=0.7,max_tokens=2048,top_p=0.5)
results.append([row['topic'], response.choices[0].text])
output_df = pd.DataFrame(results, columns = ['Topic', 'Generated Text'])
output_df.to_csv('output.csv', index=False)
In its basic form, the prompt will use the PAA answer as context to write the article. Assuming that the PAA answer that Google shows is accurate, the output generated using that as context should generate more accurate content.
Once again, YOU NEED TO CHANGE THE PROMPT. Please don't use this prompt because the output will be pathetic and short. The variable for the topic is {row['topic']} and the context is {row['context']}. Use these in your own prompt any way you see fit.
You need to customize your prompts for your specific niche. Ideally, you'd want custom prompts for each article but that takes too long when you're creating bulk content.
The output will be saved as a CSV.
Step 6: Use WP All Import
Use the WP All Import plugin to upload the content to your site. There are several tutorials that go over how you can do that. You can use some plugins for images etc.
That's pretty much it. It's super easy to get started. There are several ways to improve the output you get from OpenAI but I'm not going to get into that here.
You can also use this script for other types of content or for inserting researched data into a prompt.
