How can I determine the total revenue per player or user on my site?

This query will help you calculate the revenue or purchase sum per user in the selected date range.

Select avg(revenue) as avg_revenue_per_player, avg_purchases_per_player
from
(Select user_id, sum(purchase_amount) as revenue, count(*) as purchases
From cooladata 
Where date_range (context)  and filters (context) and event_name = ‘purchase’ and purchase_status = ‘successGroup by user_id)
Segentation
kpi