09. Standard Definitions
Single Source of Truth: These definitions MUST be standardized across all reporting.
Glossary of Terms
| Term | Definition | Formula / Logic |
|---|---|---|
| Earners | Players with coins_minted > 0 OR xp_earned > 0 in period | COUNT(DISTINCT player WHERE coins > 0) |
| Redeemers | Players with coins_redeemed > 0 in period | COUNT(DISTINCT player WHERE redeemed > 0) |
| Redemption Rate (Players) | Redeemers / Earners | Redeemers / Earners × 100 (Green if >50%) |
| Redemption Rate (Coins) | LP Redeemed / LP Minted | SUM(redeemed) / SUM(minted) × 100 (Green if >60%) |
| Awarded Bonus | Face value of bonus issued at redemption (RON) | From redeem_events.awarded_bonus_value |
| Transformed Bonus | Portion converted to withdrawable cash | From redeem_events.transformed_bonus_value (TRUE cost to P&L) |
| Eligible Stakes | Stakes counting toward earning/maintenance | Excludes: crash, instant win, roulette, baccarat, keno, blackjack, videopoker, live |
| Active Day | Any day with ≥1 real-money wager on eligible product | COUNTIF(stakes > 0) |
| At-Risk Player | Below maintenance threshold with <7 days until evaluation | eligible_stakes < threshold AND days_remaining < 7 |
| Coin Velocity | LP Redeemed / AVG(LP Outstanding) per month | Monthly rolling calc (Higher = healthier) |
| GGR | Gross Gaming Revenue = Stakes - Winnings | Sum of player GGR |
| NGR | Net Gaming Revenue = GGR - Bonus - Tax | ~30.5% GGR tax in Romania |
| NRC | Net Revenue Contribution (player-level contribution) | NRC = GGR - Tax - Provider Fees - Bonus - Payment Fees |
| Liability | Outstanding coins × Cost per coin × Redemption probability | LP_Outstanding × 0.008-0.01 × 0.6 |