[METHOD] Make Your Own PAA Site With OpenAI - Complete Tutorial + FREE Python Script

Mattrhere said:

Yeah I don’t need it to be exact. It’s just far more academic than what I’m getting with ChatGPT using the same prompts. I’ve tried telling it to use a casual style, a conversational style, and even in the style of some comedians to try and get it to loosen up and just can’t get it there.

Click to expand...

warriorsam53 said:

Do you mind PMing me a keyword or topic? Let me give it a shot.

Click to expand...

Mattrhere said:

With no coding experience I was able to tweak this (thanks ChatGPT) to have it create an outline and then create all the content for the subheadings using a single script. Takes about 10 minutes to create 25 articles and costs 3-4 cents an article.

Click to expand...

xeroniot said:

can you do this and load the content to your money site directly?.
Also new to python like today, when you mention the variable, what are we supposed to change is it what is in the bracket and please can you help with an exemplary change.
thanks great content ive been looking to get this started in a while

Click to expand...

debakid said:

If the parent column has the keyword, but the PAA is totally different, do you remove it?

Click to expand...

warriorsam53 said:

You can publish the content directly but it might be better if you proof read and edit the content.

It’s hard to proofread content in bulk so you can always improve rewrite the articles that are getting traffic after a few months.

I’m not sure which variable you’re talking about. If you’re talking about the prompt, you can replace the current prompt with your own prompt but don’t remove any of the other code.

I’m sorry if I misunderstood your question. If I did, feel free to ask again.

Click to expand...

warriorsam53 said:

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.

Click to expand...

RhebaReaux said:

Thank you for this generous share. I intend to give it a go and will report back if I can get it going.

Click to expand...

xeroniot said:

thank you for your reply
yes i am talking about the prompt as i donot know what to edit if you can highlight it i will be glad

prompt = f"Please write a detailed article about {row['topic']}. Use this information to write the article: {row['context']}"

is this what we are supposed to edit?.
If yes are we editing just Please write a detailed article about & Use this information to write the article

one more question are we paying for the api?. and also how do we get the api key?. and i have a shopify store can i guess i cant use the all wp import

thanks

Click to expand...

Joseph Ghou said:

is the python code able to generate paragraphs based on sheets?
Sorry for the newbie question

Click to expand...

snapsafe said:

Great share, very informative. What other WP plugins do you recommend we use with this?

Click to expand...

MgicalaEarner said:

Can anyone tell me what is PAA and what are benefits.

Click to expand...

warriorsam53 said:

It stands for People Also Ask. Here’s a link: https://ahrefs.com/seo/glossary/people-also-ask

Click to expand...