Skip to main content

Live Ops & In-Game Economies

A/B Test revene per user​

DECLARE target_ab_test_id STRING DEFAULT '';  -- Replace with your A/B test ID


SELECT
  user_id,
  SUM(revenue_usd) AS total_revenue_usd
FROM `live_publicdemo_35f6889f_checkpoints.player_checkpoint`
WHERE ab_test_id = target_ab_test_id
  AND game_id = 237761
GROUP BY user_id
ORDER BY total_revenue_usd DESC;
SELECT
  DATE(checkpoint) AS day,
  resource_currency,
  SUM(resource_amount_sum) AS total_sourced
FROM `live_publicdemo_35f6889f_checkpoints.resource_checkpoint`
WHERE flow_type = 'Source'
  AND game_id = 237761  -- assuming game_id is needed here too
  AND checkpoint = DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)
GROUP BY day, resource_currency
ORDER BY day DESC, total_sourced DESC;