Effective keyword research with ChatGPT guides your entire content strategy, helping you produce content your audience genuinely values.
Combining free keyword research tools like Ahrefs Keyword Generator, AnswerThePublic, and AnswerSocrates with ChatGPT simplifies this process dramatically.
Here’s a simple and short guide on exactly how to do it 😊
Step-by-Step Guide
1. Gather Keyword Data Using Free Tools
Start by collecting keyword data:
- Ahrefs Keyword Generator (ahrefs.com/keyword-generator): Enter your topic and export the keyword list (CSV).
- AnswerThePublic (answerthepublic.com): Type your topic, gather common questions, and download CSV.
- AnswerSocrates (answersocrates.com): Similar to AnswerThePublic, export questions related to your topic.
These tools provide:
- Keywords
- Monthly search volumes
- Keyword difficulty (Ahrefs)
- User questions (AnswerThePublic, AnswerSocrates)
Export this data to CSV format.
2. Craft Your ChatGPT Prompt
Copy and customise this prompt exactly:
You’re a skilled content marketer tasked with generating a strategic content plan based solely on keyword research data provided in a CSV file (from Ahrefs, AnswerThePublic, or similar tools). The CSV includes keywords, search volumes, keyword difficulty, and categories or related questions.
Before generating ideas, briefly summarise the key trends and strategic opportunities evident in the keyword data. Identify particularly valuable keywords based on search volume, keyword difficulty, intent, or relevance.
Then, create up to 50 strong, actionable content ideas presented clearly in a table with these columns:
| Keyword | Intelligent Headline or Hook | Suggested Formats (e.g., Blog, LinkedIn, TikTok, Instagram, YouTube, Newsletter) | Strategic Rationale (Why this will resonate or perform well) |
Each content idea must clearly align with audience interest, keyword intent, and SEO opportunity, providing thoughtful rationale to explain your choices.
Now, analyse the CSV data and generate the content ideas.
3. Use ChatGPT with Your CSV Data
- Open ChatGPT.
- Provide the above prompt.
- Upload or paste your CSV data when prompted.
4. Review and Refine Content Ideas
ChatGPT will generate:
- A summary of trends and strategic insights from your keyword data.
- A clear, structured table of content ideas.
- Suggested formats and rationales for each idea.
Evaluate these suggestions based on your own knowledge of your audience, then select the best ideas.
5. Execute Across Multiple Channels
Using the suggested formats:
- Create blog posts, LinkedIn articles, short-form videos, newsletters, etc.
- Tailor content to each platform’s audience and format requirements.
Why This Works
- Data-driven: Based on real audience queries.
- Efficient: Quickly turn keyword data into actionable content plans.
- Strategic: Clearly explained rationales help prioritise effectively.
Start implementing this simple method today and boost the effectiveness of your content strategy.
Want to learn new creative and marketing skills with me? Check out upcoming courses on topics like SEO, content marketing, copywriting and podcasting.
What's trending in digital marketing?
Stay on top of the latest news, tips, tools and updates in digital. Just for people in marketing and business. No fluff, no ads, no spam.
Join thousands of readers keeping abreast with it all, every Thursday.
