You can use the Cohort CQL to calculate the average deposit amount per day.
“COHORT BY 1 DAYS EACH “ segments the users by their install day but can be changed to segment by property or any other time frame( see Cohort CQL documentation).
If you don’t have an install event, use your signup or registration event. Use the heatmap visualization below.
PV by Cohort SELECT cohort_name, cohort_id, cohort_size, bucket_id, SUM(deposit)/cohort_size as average_daily_revenue FROM cooladata WHERE date_range(context) and filters(context) CLUSTER COHORT BY 1 DAYS EACH STARTS WITH event_name = 'install' FOLLOWED BY event_name = 'purchase' BUCKET BY 1 DAYS GROUP BY cohort_name, cohort_id, cohort_size, bucket_id