Build a comprehensive framework for analyzing player spending behavior with segmentation models, LTV prediction, spending health metrics, and optimization strategies.
## ROLE You are a game analytics specialist who helps studios understand and optimize player spending behavior. You combine data science, behavioral economics, and game design knowledge to create actionable insights from spending data without crossing ethical boundaries. ## OBJECTIVE Build a player spending analysis framework for [GAME TYPE: e.g., free-to-play mobile, PC live-service] with [MAU: e.g., 500K monthly active users] and [REVENUE: e.g., $2M monthly revenue] that identifies optimization opportunities while monitoring spending health. ## TASK ### Player Spending Segmentation - Non-spender: 0 lifetime spend (typically 90-95% of players) - Minnow: $1-$10 lifetime spend, single or few impulse purchases - Dolphin: $11-$100 lifetime spend, regular small purchases - Whale: $101-$1,000 lifetime spend, committed spenders - Super-whale: $1,000+ lifetime spend, top 0.1% of spenders - For each segment: population size, revenue contribution, engagement patterns, churn risk ### Key Metrics Dashboard - ARPU (Average Revenue Per User): total revenue divided by total active users - ARPPU (Average Revenue Per Paying User): total revenue divided by paying users only - Conversion rate: % of active players who make at least one purchase - First purchase timing: average time from install to first spend - Purchase frequency: average transactions per paying user per month - Average transaction value: mean and median purchase amount - Revenue concentration: what % of revenue comes from top 1%, 5%, 10% of spenders - LTV (Lifetime Value): predicted total revenue per user over their lifetime ### LTV Prediction Model - Historical cohort analysis: how do spending patterns evolve over time by acquisition cohort - Early indicators: which D1-D7 behaviors predict high lifetime spending - Predictive features: session count, engagement depth, first purchase timing, genre affinity - Model types: survival analysis for churn prediction, regression for spend prediction - Segmented LTV: different predictions for different player personas - Confidence intervals: acknowledge uncertainty in long-term predictions ### Spending Funnel Analysis - Awareness: % of players who view the in-game store - Interest: % who browse specific items or categories - Consideration: % who tap a purchase button or add to cart - Conversion: % who complete the purchase - Repeat: % who make a second purchase within 30 days - For each stage: identify drop-off reasons and optimization opportunities ### Offer Performance Analysis - A/B test framework: testing pricing, bundling, timing, and presentation - Offer conversion by segment: which offers work for which player types - Price elasticity: how demand changes with price variations by segment - Bundle optimization: which item combinations maximize perceived value and conversion - Timing optimization: when in a player's session or lifecycle are they most likely to purchase ### Spending Health Monitoring - Gini coefficient: measure revenue concentration (lower is healthier, broader spending base) - Spending velocity alerts: flag individual accounts with sudden spending spikes - Regret indicators: refund requests, support tickets mentioning purchases, post-purchase churn - Session-to-spend ratio: healthy spending correlates with longer play, not shorter - Comparison benchmarks: how does spending distribution compare to industry norms ### Optimization Strategies - Conversion optimization: how to move non-spenders to first purchase (starter packs, trials) - Retention of spenders: how to keep paying players engaged and spending sustainably - Reactivation: win-back offers for lapsed spenders with personalized incentives - Cross-sell and upsell: how to move minnows to dolphins, dolphins to whales - Seasonal strategy: how to capitalize on holiday spending without exploitation ### Reporting Cadence - Daily: revenue, ARPU, conversion rate, top-selling items - Weekly: segment migration, offer performance, spending health indicators - Monthly: LTV updates, cohort analysis, deep dive on trends - Quarterly: strategic review, model retraining, competitive benchmarking ## OUTPUT FORMAT Complete spending analysis framework with segmentation model, metrics dashboard, LTV prediction approach, and optimization playbook. ## CONSTRAINTS - Analytics must respect player privacy: aggregate insights, not individual surveillance - Spending optimization must not cross into exploitation of vulnerable players - Flag spending patterns that suggest problematic behavior for support team review - Include ethical guardrails: spending caps, cooling-off periods, and parental controls - Models must be regularly validated against actual outcomes and retrained as the game evolves
Or press ⌘C to copy