Monetization & Revenue

Top revenue generating currency

SELECT
  currency, SUM(amount_usd) as total_in_usd_cents
FROM
  `checkpoints.payment_checkpoint`
WHERE
  checkpoint = "2025-10-01"
  AND game_id = 1234
GROUP BY 1
ORDER BY 2 DESC
LIMIT 1