ZiviTV: Architecture & Technical SEO Rebuild
Entertainment discovery engine rebuilt on Next.js 15. Restructured an 800+ URL bloated sitemap into a lean 16-page application with optimized PostgreSQL queries and cached external API data.
Objective & Problem
ZiviTV inherited crippling technical debt: an uncurated 800+ URL sitemap generated from raw TMDB datasets, riddled with JavaScript Invalid Date serialization errors corrupting XML feeds. The objective was to rebuild the application on Next.js 15, consolidate thin URL structures into a clean 16-page static architecture, eliminate indexing blockers in Google Search Console, and implement a data-backed 100-day content roadmap.
Stack & Pipeline
Key Contributions
- •Sitemap Consolidation: Rebuilt bloated 800+ URL sitemap into 16 indexable high-intent landing pages.
- •XML Serialization Fix: Fixed date serialization bugs that were breaking Google bot sitemap parsing.
- •Technical SEO Audit: Eradicated soft-404s on dynamic route boundaries, restored OpenGraph metadata across all views.
- •Anti-Cannibalization Pipeline: Built a structured keyword research index to prevent duplicate internal competition.
Technical Details & Solutions
Migrated the backend layer to Next.js 15 with Drizzle ORM and Supabase. Cached external TMDB API responses to avoid rate limits and standardize catalog queries.
Replaced 13 fragmented sitemaps with a single clean, validated sitemap module. Pruned zero-value crawl targets to focus Google crawl budget on high-intent pages.