How can I measure the time between when my user first registered to when they first made a deposit when both events happen within a particular time frame?

You want to know what is the time, in days, that has past from a certain user's signup to their first deposit in a certain period of time, when both signup and FTD are in the same time period.

 

SELECT Avg(time_between_in_days) time_between_in_days 
FROM   (SELECT e1.uid, 
               e1_ts, 
               e2_ts, 
               ( e2_ts - e1_ts ) / 1000000 / 60 / 60 / 24 AS 
               time_between_in_days 
        FROM   (SELECT uid, 
                       Min(event_time_ts) AS e1_ts 
                FROM   cooladata 
                WHERE  Date_range(doc.date_range) 
                       AND doc.slicers 
                       AND event_name = "newplayer" 
                GROUP  BY 1) e1 
               JOIN (SELECT uid, 
                            Min(event_time_ts) AS e2_ts 
                     FROM   cooladata 
                     WHERE  Date_range(doc.date_range) 
                            AND doc.slicers 
                            AND event_name = "transaction" 
                     GROUP  BY 1) e2 
                 --/1000/60 as time_between_in_minutes  
                 ON e1.uid = e2.uid 
        WHERE  e1_ts < e2_ts) 
Segentation
Acquisition