Project Overview
This project was born from the Actionable AI for Marketers cohort by Britney Muller, where I turned Reddit discussions into a live market intelligence system for SEO and demand generation.
The goal was simple yet Actionable!
To mine real-world conversations from Reddit, connect them with GA4 + GSC data, and generate actionable insights that lead to better content, stronger engagement, and higher conversions.
Categories
App Design
Client
Workflow Architecture
Phase 1 – Data Collection:
Scraped 12+ Reddit threads (r/CleaningTips, r/HomeImprovement, r/CarpetCleaning) via Python + PRAW.
Analyzed 500+ comments for pain points, sentiment, and customer intent.
Integrated GA4 and GSC data for engagement and CTR patterns.
Phase 2 – Data Processing:
Cleaned and aligned data into unified themes: “Topic,” “Sentiment,” “Keyword,” “Intent.”
Connected Screaming Frog embeddings to identify internal linking and topical depth gaps.
Phase 3 – AI Analysis:
Used Claude and TextBlob for sentiment classification.
Clustered content via UMAP + HDBSCAN to find semantic themes.
Identified key customer concerns (“slow drying time,” “eco-friendly solutions,” “pet odor issues”).
Phase 4 – Actionable Insights:
Generated client-ready dashboards and CSVs.
Auto-created FAQ and content briefs linked to engagement metrics.
Pushed all data into Google Sheets → visualized in Looker Studio (Phase 2).
Real-World SEO Impact
From Reddit to Rankings:
Identified “faster carpet drying” as an unaddressed topic → new FAQ + blog drove direct organic visits.
Detected “eco-friendly carpet cleaning” keyword gap → rewrote meta titles using Reddit language → improved CTR by 21%.
Used embeddings analysis to strengthen internal linking for underperforming pages.
AI Components Used
PRAW API: Reddit scraping
Claude / TextBlob: Sentiment & intent tagging
Screaming Frog + OpenAI: Internal linking embeddings
GA4 + GSC API: Automated data pulling
Looker Studio: Visualization dashboard
Future Enhancements
Integrate Google Business Profile (GBP) review sentiment.
Add automated trend alerts via Slack.
Enable live dashboard syncs with GA4 & GSC APIs.
Launch an AI-driven Meta + FAQ generator based on Reddit sentiment clusters.
Branding Nice Studio
I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because those who do not know how to pursue pleasure rationally
Categories
Client
Let’s Build What’s Next
From automating insights to building AI-ready SEO frameworks, I specialize in helping brands turn data into real business outcomes. If that sounds like your next move, let’s make it happen.
