How many paying users do I have compared to non-paying users?
Understanding how many of your app’s players or users are actually generating income is an important KPI to monitor in the gaming monetization field. Keep in mind that this query actually counts the number of users who made a successful purchase in the selected time frame. If you want to count the number of users who made a purchase during a particular date range see segmentation of paying players. We suggest visualizing with line chart (2 Y axis).
select date(event_time_ts) as day, count(distinct user_id) as DAU, count( distinct case when event_name = "purchase" and purchase_status = ‘success’ then user_id end ) as pDAU, (count( distinct case when event_name = ‘purchase’ and purchase_status = ‘success’ then user_id end )/count(distinct user_id))*100 as payers_percentage from cooladata where slicers(context) and date_range(context) group by day order by day