
How I Got 33K Google Impressions in 2 Weeks with Programmatic SEO
Two weeks ago I shared how I built a 10,000+ page SEO site with Next.js and PostgreSQL . Today I'm back with the results. TL;DR: 33,467 impressions, 70 clicks, pages ranking on page 1 of Google — all within 14 days of deploying to Vercel. No paid ads. No backlinks. Just programmatic SEO done right. Here's exactly what worked, what didn't, and what I'd do differently. The Numbers (first 14 days) Metric Value Total impressions 33,467 Total clicks 70 Average CTR 0.21% Average position 23.5 Indexed pages 10,000+ Countries reached 50+ Peak daily clicks 22 (day 12) The growth curve looked like this: Day 1: 0 impressions Day 2: 2 impressions Day 3: 132 impressions Day 5: 705 impressions Day 10: 4,507 impressions Day 11: 12,129 impressions (something clicked) That jump from 700 to 12K impressions in one day? That's when Google finished crawling the bulk of my sitemap. More on that below. The Stack (Quick Recap) Next.js 16 (App Router) on Vercel PostgreSQL (Neon) + Prisma ORM ISR with 24-hour r
Continue reading on Dev.to
Opens in a new tab



_.png&w=1200&q=75)