Internal use only - not indexed
creators_countTotal number of active creator profiles on the platform
SELECT COUNT(*) FROM users WHERE type = 'CREATOR' AND status = 'active'brands_countUnique companies that have made a payment >$1 (lifetime paying customers)
SELECT COUNT(DISTINCT company_id) FROM receipts WHERE CAST(REPLACE(amount, '$', '') AS DECIMAL(10,2)) > 1posts_analyzedTotal SocialPosts tracked in the PostMetrics system with engagement data
SELECT COUNT(*) FROM social_posts WHERE has_metrics = truecountriesNumber of unique countries where creators are located
SELECT COUNT(DISTINCT country) FROM users WHERE type = 'CREATOR'marketsNumber of active markets with meaningful creator coverage (10+ creators)
SELECT COUNT(*) FROM markets WHERE creator_count >= 10total_followersSum of all followers across all creator social accounts
SELECT SUM(followers) FROM social_accounts WHERE user.type = 'CREATOR'avg_engagement_rateAverage engagement rate across all tracked creator posts
SELECT AVG(engagement_rate) FROM post_metricscampaigns_countTotal number of campaigns/boosts created on the platform
SELECT COUNT(*) FROM boostsmonthly_growthAverage number of new creator signups per month
SELECT COUNT(*) FROM users WHERE type = 'CREATOR' AND created_at > NOW() - INTERVAL 30 DAYcollaborations_countCollaborations where product was shipped and content was submitted
SELECT COUNT(*) FROM campaign_channels WHERE status IN ('shipped', 'submitted')free_tierThe basic creator tier will always be free, no time limit
no_follower_minimumCreators can join regardless of their follower count
signup_timeAverage time to complete creator onboarding flow
case_brand_campaignEdit claims at: content/proof/claims.json
See governance rules: prompts/claims_governance.md