5/3/2026
Capy Food Journal: How We Built a Programmatic SEO Engine That Generates Thousands of Pages from One Dataset
See how NightCoders built a programmatic SEO engine that generates thousands of optimized pages from a single food database.
By fathin@nightcoders.id

The Problem
Capy Food Journal is a nutrition platform with an ambitious goal: dominate organic search for food and calorie queries without hiring a content team.
The nutrition niche is crowded with established players:
Noom with millions in marketing
MyFitnessPal with millions of users
Chronometer with dedicated health communities
Competing manually was impossible. The math doesn't work - writing articles one at a time against players with 10-year head starts.
The Challenge
SEO is Competitive
Nutrition content is one of the most competitive SEO niches. The established players have:
Millions of pages indexed by Google
Large editorial teams producing content daily
Years of domain authority and backlink profiles
Brand recognition when users search
A new entrant cannot compete by writing articles one at a time.
Content is Data
Here's what we realized: nutrition content is fundamentally different from blog content.
A banana page doesn't need your opinion. It needs:
Calorie count
Macronutrient breakdown
Serving size information
Related foods
This is structured data, not prose. Data can be generated. Opinions cannot.
Our Approach
Programmatic SEO
Instead of writing articles, we built a data-driven page generator.
One structured food database feeds thousands of unique landing pages - each targeting a specific search query with personalized content, meta tags, and internal linking.
Write the template once. Generate 10,000 pages.
Data as Content
We structured the food dataset with rich attributes:
Calories and macros (protein, carbs, fat)
Categories (fruits, vegetables, proteins)
Serving sizes (grams, ounces, cups)
Related foods (based on nutritional similarity)
Each attribute becomes a content variable. Each row becomes a page.
Web for Acquisition, Mobile for Retention
The strategy is clear:
Web dominates search and brings visitors in
Mobile app converts visitors into daily active users
Data flows from database to both surfaces
What We Built
The Web: SEO Engine
Dynamic Landing Pages
Every food item generates its own page at a structured URL:
/foods/banana - banana nutrition
/foods/chicken-breast - chicken nutrition
/foods/brown-rice - rice nutrition
Each page includes:
Search-volume-targeted meta tags and descriptions
Personalized content based on food attributes
Calorie and macronutrient breakdowns
Related food recommendations
FAQ schema for rich results
Smart Internal Linking
The system builds internal links automatically:
"Related Foods" based on category
"High Protein" foods when protein is high
"Low Carb" foods when carbs are low
This strengthens page authority and prevents orphan pages.
Premium UI
GSAP-powered animations and smooth scrolling create an experience that feels like a lifestyle brand, not a database.
The Mobile: Retention App
Meal Logging Quick-capture food entries with photo support, portion sizing, and automatic macro calculation.
Health Integrations Syncs with Apple Health and Health Connect for automatic activity and biometric imports.
Offline Storage Local SQLite database ensures the app works without connectivity.
Home Screen Widgets Quick logging and daily summary at a glance.
Camera Integration Scan barcodes or photograph meals for instant nutritional lookup.
Technical Stack
Layer | Technology |
|---|---|
Web | Next.js 16, React 19, Tailwind CSS |
Animation | GSAP |
Mobile | Expo, React Native, Uniwind |
Backend | Convex |
Health | react-native-health |
Storage | expo-sqlite, react-native-mmkv |
Payments | RevenueCat |
Monorepo | Turbo + Bun workspaces |
The Results
SEO Performance
Unlimited SEO pages generated from structured data
No manual writing required
Internal linking strengthens domain authority automatically
Mobile Metrics
Native health integrations for user retention
Offline-first design ensures usability in any condition
Shared backend reduces infrastructure costs
Business Impact
Organic traffic from thousands of long-tail queries
Daily active users converting from search
Recurring revenue through the mobile app
Capy vs Traditional SEO
Approach | Traditional | Programmatic |
|---|---|---|
Pages | 10-100 | 10,000+ |
Writing | Manual | Automated |
Update | Weekly | Real-time |
Scale | Limited | Unlimited |
What This Proves About NightCoders
We understand modern growth architecture.
SEO is not just about writing blog posts anymore. It is about:
Building systems that generate content at scale
Structuring data for search engines
Converting organic traffic into engaged users
We combine technical SEO expertise with product development to build acquisition engines, not just websites.
