NightCoders
Portfolio

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

Capy Food Journal: How We Built a Programmatic SEO Engine That Generates Thousands of Pages from One Dataset

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.

Need an MVP like this?

NightCoders helps founders ship real MVPs in 4 weeks. Book a free 15-minute fit call and we will map your sprint.

Related posts