Free SEO Keyword Research Excel Spreadsheet Template (Download + Tutorial)
Download my free SEO keyword research Excel template with 4 tabs, 15 data sources, and a video tutorial. Works in Google Sheets too.
How AI is changing search engine optimization — Claude, Perplexity, SGE, and ranking in the age of AI-generated answers.
13 articles
Download my free SEO keyword research Excel template with 4 tabs, 15 data sources, and a video tutorial. Works in Google Sheets too.
Find long-tail keywords without paid tools. Mine forums, Reddit, Amazon, YouTube, Wikipedia, and 10+ more free sources before opening any keyword software.
Learn SEO keyword research from scratch. Free step-by-step course covering keyword types, validation factors, brainstorming methods, and keyword clustering. No paid tools needed.
Build a free AI SEO internal linking tool using Google AI Studio. No coding needed. Auto-discover internal link opportunities and inject them with one click.
283 overused ChatGPT words and 335 phrases that make AI content detectable. Complete list by category with copy-paste prompts to block them permanently.
I built a free ChatGPT GPT for local business SEO. It handles keyword research, Google Business Profile, backlinks, and social media. Here's exactly what it does.
Learn how to use Google Search Console for keyword research. Find low-hanging fruit, spot intent mismatches, cluster semantic keywords, and boost rankings, all free.
Build a Custom GPT that writes SEO outlines and meta titles on autopilot. Step-by-step guide with real instructions, screenshots, and no coding required.
The only Semrush tutorial you need. Covers every tool with step-by-step workflows, real screenshots, and dedicated video walkthroughs — keyword research, competitor analysis, site audit, backlinks, and PPC.
New to SEO? This beginner tutorial covers how Google works, keyword research, on-page SEO, backlinks, and what results to expect in 2026.
Copy-paste 40+ ChatGPT prompts for SEO keyword research. Organized by task: idea generation, intent filtering, clustering, competitor analysis, and more.
I lost 100% of my traffic overnight. This is my live SEO penalty recovery case study showing real GSC data, mistakes made, and every fix I'm implementing.
I tested Claude for SEO across 50+ projects. Here are the 7 mistakes most marketers make that tank rankings — and exactly how to fix each one with better prompts.