Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --waitlist
- select
- distinct
- us.name,
- us.email,
- c.code as pricing_plan,
- c.amount,
- u.created_at::date as entered_credit_card_at
- from user_events u
- join coupons c
- on c.id = json_extract_path_text(properties, 'coupon_id')
- join analytics.acquisition_credit_card_source_tracking a
- on a.user_id = u.user_id
- and a.subscription_id is null
- join users us
- on us.id = u.user_id
- where
- event_name in ('Payment Form Completed', 'Requested Access')
- and u.created_at >= getdate() - '30 days'::interval
- order by 5 desc
Add Comment
Please, Sign In to add comment