Cooladata. Create the script and look for part of the email презентация

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

Make sure that the DB is fibiz_mobile_qa

Check the timeframe

Run it

Copy the user_id

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

Check the results