How do I calculate the amount of money each of my players or users spend per day?

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

Select day, avg(revenue) as avg_revenue_per_player, avg_purchases_per_player
from
(Select date(event_time_ts) as day, 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 day, user_id)
Group by day
Segentation
kpi
Behavioral