Overview
Weekly, search seed keywords, extract People Also Ask questions and Reddit thread titles, deduplicate, and produce a ranked content calendar based on engagement signals.
Trigger
Weekly Monday at 9 AM UTC
Schedule
Weekly Monday at 9 AM UTC
Workflow Steps
1
Search seed keywords on Google
Get PAA questions from SERP data for each seed keyword.
2
Search seed keywords on Reddit
Find recent Reddit discussions about each topic.
3
Extract content angles
Combine PAA questions and Reddit thread titles into unique angles.
4
Rank by engagement
Sort Reddit results by upvotes + comments as demand signal.
5
Output content calendar
Format as a prioritized list of content ideas with sources.
Python Implementation
Python
import requests, os
H = {"x-api-key": os.environ["SCAVIO_API_KEY"]}
SEEDS = ["ai agents for business", "search api integration"]
ideas = []
for seed in SEEDS:
# Google PAA
g = requests.post("https://api.scavio.dev/api/v1/search",
headers=H, json={"platform": "google", "query": seed}).json()
for paa in g.get("people_also_ask", []):
ideas.append({"source": "paa", "topic": paa.get("question", ""), "engagement": 0})
# Reddit
r = requests.post("https://api.scavio.dev/api/v1/search",
headers=H, json={"platform": "reddit", "query": seed}).json()
for post in r.get("results", []):
ideas.append({
"source": "reddit",
"topic": post.get("title", ""),
"engagement": post.get("upvotes", 0) + post.get("comments", 0) * 2
})
ideas.sort(key=lambda x: x["engagement"], reverse=True)
for i, idea in enumerate(ideas[:15]):
print(f"{i+1}. [{idea['source']}] {idea['topic']} (engagement: {idea['engagement']})")JavaScript Implementation
JavaScript
const H = {"x-api-key": process.env.SCAVIO_API_KEY, "Content-Type": "application/json"};
const seeds = ["ai agents for business"];
const ideas = [];
for (const seed of seeds) {
const g = await fetch("https://api.scavio.dev/api/v1/search", {
method: "POST", headers: H, body: JSON.stringify({platform: "google", query: seed})
}).then(r => r.json());
(g.people_also_ask || []).forEach(p => ideas.push({source: "paa", topic: p.question, engagement: 0}));
const rd = await fetch("https://api.scavio.dev/api/v1/search", {
method: "POST", headers: H, body: JSON.stringify({platform: "reddit", query: seed})
}).then(r => r.json());
(rd.results || []).forEach(p => ideas.push({source: "reddit", topic: p.title, engagement: (p.upvotes||0) + (p.comments||0)*2}));
}
ideas.sort((a,b) => b.engagement - a.engagement).slice(0,15).forEach((idea, i) =>
console.log(`${i+1}. [${idea.source}] ${idea.topic}`));Platforms Used
Web search with knowledge graph, PAA, and AI overviews
Community, posts & threaded comments from any subreddit