SitterSync Pro Operations

# SitterSync Pro Operations Post-launch operations for SitterSync Pro. ## Monitoring - Supabase dashboard: Check database size, API requests, auth users - Stripe dashboard: MRR, churn, failed payments - Lovable Cloud: Deployment status, error logs ## Customer Support - Common issues: agency onboarding, sitter background check flow, booking conflicts - Escalation: billing disputes → Stripe, data issues → Supabase SQL ## Billing Operations - Plans: Starter $29/mo (10 sitters), Growth $79/mo (50 sitters), Enterprise $199/mo (unlimited) - Stripe webhooks handle subscription lifecycle - Failed payment retry: Stripe handles automatically (3 attempts over 2 weeks) ## Compliance - Background check expiry: Alert agencies 30 days before sitter checks expire - Certification tracking: First Aid, CPR, and custom certs with document storage - Audit log: All booking status changes logged ## Growth - SEO: Town-level landing pages (Ontario focus initially) - Content: Blog posts on childcare business management - Referral: Agency referral program - Upsell: Starter → Growth → Enterprise based on sitter count ## Database Maintenance ```bash # Check agency count select count(*) from agencies; # Check active bookings select count(*), status from bookings group by status; # Find expiring background checks select first_name, last_name, background_check_date from sitters where background_check_status = 'cleared' and background_check_date < now() - interval '11 months'; ```