Cooladata. Create the script and look for part of the email

1. Cooladata

2.

3. Create the script and look for part of the email

select customer_user_id, event_name , user_id
from cooladata
where date_range(context)
and filters(context)
and customer_user_id contains "kimaia"
group by 1,2,3
limit 1000

4. Make sure that the DB is fibiz_mobile_qa

5. Check the timeframe

6. Run it

7. Copy the user_id

8. Create new query and add the user_id

select event_name, event_time_ts , user_id , customer_user_id ,
user_alternative_id
from cooladata
where date_range(context)
and user_id =6505988450215149113
order by event_time_ts
limit 800

9. Check the results