ProductReadyProductReady

ProductReady v0.9.0 - Growth Analytics & Marketing Infrastructure

Comprehensive growth analytics dashboard, marketing message centralization, and production enhancements

ProductReady v0.9.0

Release Date: February 2, 2026

Overview

ProductReady v0.9.0 delivers a comprehensive Growth Analytics system with real database queries, centralizes marketing messages for i18n readiness, and includes critical production improvements including build metadata tracking and redemption code enhancements.

This release transforms ProductReady from a development boilerplate into a data-driven product platform with actionable insights for product growth.


🌟 Key Features

1. Growth Analytics Dashboard (80% Real Data)

A complete analytics system for tracking product growth across 5 key dimensions:

📊 Overview/Scoreboard

  • Total users, DAU (Daily Active Users), MAU (Monthly Active Users)
  • New user growth trends
  • Activation rate from real onboarding data
  • D7 retention from session tracking
  • Real-time metrics with time range filters (7d/30d/90d)

🎯 Activation Metrics

  • 4-step onboarding funnel: Signup → Create Post → Manage Posts → Share Referral
  • Time to first success (average hours from signup to first post)
  • Task completion rate and average task time
  • Content creation stats: total posts, publish rate, avg posts per user
  • All metrics derived from user_profiles.onboarding JSON field

🔄 Retention Analysis

  • Cohort retention matrix (8 weeks of cohorts × 12 weeks tracking)
  • Color-coded retention rates with visual heatmap
  • DAU/MAU ratio tracking
  • Activity trends with task and content stats
  • Session-based retention calculation

🔗 Referral Tracking

  • Top 10 referrers leaderboard with rank, name, referral count
  • Referral quality score (% of referred users who activated)
  • Individual referrer stats: activated count, rewarded count
  • Viral loop metrics from user_profiles.referredBy field

📈 Acquisition Insights

  • User growth trends over time
  • Language distribution (geographic proxy)
  • Resource usage platform-wide: AI credits, storage, posts
  • Active organizations count

Technical Implementation:

  • 11 new database query functions in growth-logic.ts
  • 5 tRPC endpoints with real data integration
  • PostgreSQL JSON field querying for onboarding data
  • Cohort analysis with window functions
  • Type-safe VO/DTO patterns throughout

Current Status:

  • ✅ 28/35 metrics implemented with real data (80%)
  • ⏳ 7 metrics pending (mostly billing-related)
  • ✅ All UI components fully functional
  • ✅ Time range filtering working across all pages

2. Marketing Message Centralization

Eliminated hardcoded marketing copy across 10+ files with a centralized i18n system:

New Marketing Config Structure:

marketing: {
  slogan: "Turn Vibe Coding Demos Into a Product You Can Sell",
  definition: {
    short: "Brief description for Twitter cards",
    medium: "Medium description for OpenGraph",
    full: "Full description with all features"
  },
  positioning: {
    whatItIs: "Production-Ready Next.js Boilerplate",
    forWhom: "AI demo builders, indie hackers",
    coreProblem: "Demos to products takes weeks",
    coreSolution: "Ship SaaS apps in under an hour"
  }
}

Benefits:

  • Single source of truth for all marketing copy
  • Automatic i18n support for all languages (en, ja, zh-CN)
  • Type-safe access via helper functions
  • Consistent messaging across all touchpoints
  • Easy to replicate across other apps in monorepo

Updated Components:

  • Root metadata and layout
  • SEO structured data (Schema.org)
  • PWA manifest (now dynamic route handler)
  • About page product information
  • All OpenGraph and Twitter card tags

3. Build Metadata & Health Monitoring

Added build-time information tracking for better production monitoring:

Build Info API:

  • Build timestamp
  • Git commit hash
  • Git branch name
  • Environment (production/development)
  • Accessible via /api/health endpoint

Health Check Enhancements:

  • Combined health status with build info
  • Database connectivity check
  • Service status reporting
  • Useful for deployment verification and debugging

Configuration:

  • Build info injected at build time via environment variables
  • Stored in src/config/build-info.ts
  • Exposed through tRPC and REST endpoints

4. Redemption Codes System Improvements

Major enhancements to the redemption code system:

Fixed Critical Bugs:

  • Pagination bug (page jumping back to 1)
  • "Bonus template not found" error for plan-type codes
  • Duplicate redemption prevention

Enhanced Validation:

  • Code minimum length: 8 characters (up from 4)
  • No spaces allowed in codes
  • Reward type validation (plan vs bonus)
  • Duration and expiry date consistency checks
  • Duplicate code checking

New Features:

  • Support for both "plan" and "bonus" reward types
  • Automatic expiry date calculation
  • Complete redemption history recording
  • System log entries for all redemption actions
  • planExpiresAt field added to spaces table

Database Schema:

  • New migration: 0006_20260128040217.sql
  • Added plan_expires_at to spaces table
  • Unique constraint on codeId + spaceId

API Improvements:

  • spaceId now required (was optional)
  • Better error messages with i18n support
  • Type-safe return values with proper VO/DTO

5. About Page Markdown Support

Enhanced the About page with full Markdown rendering:

Features:

  • Markdown content support in gallery slides
  • Proper typography and formatting
  • Code syntax highlighting
  • Link handling
  • Responsive design

Use Cases:

  • Product feature descriptions
  • Technical documentation
  • Marketing content
  • Release notes preview

📊 By the Numbers

  • 35+ metrics implemented in Growth Analytics
  • 28 metrics (80%) using real database queries
  • 11 new database query functions for analytics
  • 5 tRPC endpoints for growth data
  • 10+ files updated for marketing centralization
  • 3 languages supported for marketing messages
  • 8 character minimum for redemption codes
  • 4 critical bugs fixed in redemption system

🔧 For Developers

Growth Analytics Implementation

Database Query Techniques:

// JSON field querying (PostgreSQL)
(onboarding->'gettingStarted'->'steps'->'createPost'->>'done')::boolean = true

// Cohort analysis
DATE_TRUNC('week', created_at) as cohort_week
EXTRACT(WEEK FROM AGE(s.created_at, c.signup_date))::int as weeks_since_signup

// Window functions
COUNT(*) OVER (PARTITION BY language) / SUM(COUNT(*)) OVER () * 100

New Logic Functions:

  • getActivationFunnel() - Onboarding funnel from user_profiles
  • getTimeToFirstSuccess() - Hours from signup to first post
  • getTopReferrers() - Leaderboard with quality scores
  • getReferralQuality() - % of referred users activated
  • getCohortRetention() - Weekly cohort retention matrix
  • getLanguageDistribution() - Geographic breakdown
  • getTaskStats() - AI task metrics
  • getContentStats() - Post creation metrics
  • getResourceUsage() - Platform-wide usage

tRPC Endpoints:

  • systemAdmin.growth.scoreboard - Overview metrics
  • systemAdmin.growth.activation - Activation funnel & metrics
  • systemAdmin.growth.retention - Cohort analysis & trends
  • systemAdmin.growth.referral - Referral leaderboard & quality
  • systemAdmin.growth.acquisition - User growth & distribution

Marketing Config Usage

Before:

const title = "ProductReady - Turn Vibe Coding Demos...";
const description = "The production-ready Next.js boilerplate...";

After:

import { common, marketing } from "~/i18n/marketing-config";

const title = `${common.appName} - ${marketing.slogan}`;
const description = marketing.definition.full;

Reusability Pattern:

# Copy to other apps
cp apps/productready/src/i18n/marketing-config.ts apps/YOUR_APP/src/i18n/

# Add marketing section to i18n files
# Update metadata files to import from marketing-config

Build Info Configuration

Environment Variables:

NEXT_PUBLIC_BUILD_TIME=2026-02-02T09:00:00Z
NEXT_PUBLIC_GIT_COMMIT=e140bbe07
NEXT_PUBLIC_GIT_BRANCH=main

Access Build Info:

import { buildInfo } from "~/config/build-info";

console.log(buildInfo.buildTime);  // "2026-02-02T09:00:00Z"
console.log(buildInfo.gitCommit);  // "e140bbe07"
console.log(buildInfo.gitBranch);  // "main"

Health Check:

curl https://your-app.com/api/health
# Returns: { status: "ok", buildInfo: {...}, database: "connected" }

Redemption Codes API

Create Code:

await trpc.systemRedemptionCodes.create.mutate({
  code: "WELCOME2026",
  rewardType: "plan",
  planType: "pro",
  durationDays: 30,
  maxRedemptions: 100,
  isActive: true
});

Redeem Code:

const result = await trpc.systemRedemptionCodes.redeem.mutate({
  code: "WELCOME2026",
  spaceId: "space_123"
});

// Returns:
// {
//   rewardType: "plan",
//   planType: "pro",
//   expiresAt: "2026-03-04T09:00:00Z",
//   bonusGranted: false
// }

🔄 Breaking Changes

Database Migration Required

New Field:

  • spaces.plan_expires_at (timestamp, nullable)

Migration:

pnpm --filter productready db:migrate

Migration File:

  • apps/productready/src/db/migrations/0006_20260128040217.sql

API Changes

Redemption Codes:

  • systemRedemptionCodes.redeem - spaceId now required (was optional)
  • systemRedemptionCodes.create - Code minimum length increased to 8 characters
  • systemRedemptionCodes.create - Spaces not allowed in codes

Return Value Changes:

  • redeem mutation returns rewardType, planType, expiresAt, bonusGranted

🐛 Bug Fixes

  1. Redemption Code Pagination - Fixed page jumping back to 1 on navigation
  2. Bonus Template Error - Fixed "Bonus template not found" for plan-type codes
  3. Duplicate Redemption - Added unique constraint on codeId + spaceId
  4. Code Validation - Enforced minimum length and no-spaces rules
  5. Build Info Display - Fixed health endpoint to include build metadata

📚 Documentation

New Documentation

  • Growth Analytics implementation guide
  • Marketing config usage examples
  • Build info configuration guide
  • Redemption codes API reference

Updated Documentation

  • Health check endpoint documentation
  • Database schema documentation (spaces table)
  • i18n system documentation

🚀 Upgrade Guide

From v0.8.0 to v0.9.0

1. Run Database Migration:

pnpm --filter productready db:migrate

2. Update Environment Variables (Optional):

# Add to .env for build info tracking
NEXT_PUBLIC_BUILD_TIME=$(date -u +"%Y-%m-%dT%H:%M:%SZ")
NEXT_PUBLIC_GIT_COMMIT=$(git rev-parse --short HEAD)
NEXT_PUBLIC_GIT_BRANCH=$(git branch --show-current)

3. Update Redemption Code Validation:

  • Ensure all existing codes are at least 8 characters
  • Remove any codes with spaces
  • Update code generation logic if custom

4. Test Growth Analytics:

  • Navigate to System Admin → Growth Analytics
  • Verify all 5 tabs load correctly
  • Check time range filters work
  • Confirm data displays (may be empty if no usage yet)

5. Verify Marketing Messages:

  • Check all pages for consistent marketing copy
  • Test i18n switching (en, ja, zh-CN)
  • Verify PWA manifest loads correctly

🎯 What's Next

Planned for v0.10.0

Revenue Analytics (Priority 1):

  • Billing system integration
  • ARPU, LTV, MRR calculations
  • Cost tracking for AI usage
  • Gross margin analysis

Advanced Analytics (Priority 2):

  • Signup source tracking (add users.signupSource field)
  • Source quality analysis (source × activation × retention)
  • Predictive churn models
  • A/B testing framework

UX Enhancements (Priority 3):

  • Custom date range picker
  • Metric comparison (vs previous period)
  • Drill-down views (click cohort cell → see users)
  • Shareable dashboard links
  • Export functionality for charts

Background Jobs (Priority 4):

  • Automatic plan downgrade when expired
  • Email notifications for plan expiry
  • Scheduled analytics reports

🙏 Acknowledgments

This release represents a major milestone in ProductReady's evolution from a development boilerplate to a complete product platform with data-driven insights.

Special thanks to:

  • The ProductReady team for comprehensive changelog documentation
  • Contributors who reported redemption code bugs
  • Early adopters providing feedback on analytics needs

📦 Installation

# Install dependencies
pnpm install

# Run database migrations
pnpm --filter productready db:migrate

# Start development server
pnpm --filter productready dev

🔗 Resources

On this page