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.onboardingJSON 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.referredByfield
📈 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/healthendpoint
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
planExpiresAtfield added to spaces table
Database Schema:
- New migration:
0006_20260128040217.sql - Added
plan_expires_atto spaces table - Unique constraint on codeId + spaceId
API Improvements:
spaceIdnow 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 () * 100New Logic Functions:
getActivationFunnel()- Onboarding funnel from user_profilesgetTimeToFirstSuccess()- Hours from signup to first postgetTopReferrers()- Leaderboard with quality scoresgetReferralQuality()- % of referred users activatedgetCohortRetention()- Weekly cohort retention matrixgetLanguageDistribution()- Geographic breakdowngetTaskStats()- AI task metricsgetContentStats()- Post creation metricsgetResourceUsage()- Platform-wide usage
tRPC Endpoints:
systemAdmin.growth.scoreboard- Overview metricssystemAdmin.growth.activation- Activation funnel & metricssystemAdmin.growth.retention- Cohort analysis & trendssystemAdmin.growth.referral- Referral leaderboard & qualitysystemAdmin.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-configBuild Info Configuration
Environment Variables:
NEXT_PUBLIC_BUILD_TIME=2026-02-02T09:00:00Z
NEXT_PUBLIC_GIT_COMMIT=e140bbe07
NEXT_PUBLIC_GIT_BRANCH=mainAccess 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:migrateMigration File:
apps/productready/src/db/migrations/0006_20260128040217.sql
API Changes
Redemption Codes:
systemRedemptionCodes.redeem-spaceIdnow required (was optional)systemRedemptionCodes.create- Code minimum length increased to 8 characterssystemRedemptionCodes.create- Spaces not allowed in codes
Return Value Changes:
redeemmutation returnsrewardType,planType,expiresAt,bonusGranted
🐛 Bug Fixes
- Redemption Code Pagination - Fixed page jumping back to 1 on navigation
- Bonus Template Error - Fixed "Bonus template not found" for plan-type codes
- Duplicate Redemption - Added unique constraint on codeId + spaceId
- Code Validation - Enforced minimum length and no-spaces rules
- 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:migrate2. 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