Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- with control as (
- select *
- from marketing.user_campaign_performance
- where treatment = 'control'
- )
- select
- c.campaign_test,
- c.treatment,
- c.segment_1,
- c.population,
- c.orders_1d,
- c.orders_2d,
- c.orders_3d,
- c.orders_7d,
- c.orders_14d,
- c.orders_30d,
- c.bookings_1d,
- c.bookings_2d,
- c.bookings_3d,
- c.bookings_7d,
- c.bookings_14d,
- c.bookings_30d,
- c.pro_signups_1d,
- c.pro_signups_2d,
- c.pro_signups_3d,
- c.pro_signups_7d,
- c.pro_signups_14d,
- c.pro_signups_30d,
- c.unlimited_signups_1d,
- c.unlimited_signups_2d,
- c.unlimited_signups_3d,
- c.unlimited_signups_7d,
- c.unlimited_signups_14d,
- c.unlimited_signups_30d,
- c.pro_cancels_1d,
- c.pro_cancels_2d,
- c.pro_cancels_3d,
- c.pro_cancels_7d,
- c.pro_cancels_14d,
- c.pro_cancels_30d,
- c.return_visits_1d,
- c.return_visits_2d,
- c.return_visits_3d,
- c.return_visits_7d,
- c.return_visits_14d,
- c.return_visits_30d,
- c.rezo_searches_1d,
- c.rezo_searches_2d,
- c.rezo_searches_3d,
- c.rezo_searches_7d,
- c.rezo_searches_14d,
- c.rezo_searches_30d,
- c.rezo_selects_1d,
- c.rezo_selects_2d,
- c.rezo_selects_3d,
- c.rezo_selects_7d,
- c.rezo_selects_14d,
- c.rezo_selects_30d,
- c.shortlists_created_1d,
- c.shortlists_created_2d,
- c.shortlists_created_3d,
- c.shortlists_created_7d,
- c.shortlists_created_14d,
- c.shortlists_created_30d,
- c1.population as population_control,
- c1.orders_1d as orders_1d_control,
- c1.orders_2d as orders_2d_control,
- c1.orders_3d as orders_3d_control,
- c1.orders_7d as orders_7d_control,
- c1.orders_14d as orders_14d_control,
- c1.orders_30d as orders_30d_control,
- c1.bookings_1d as bookings_1d_control,
- c1.bookings_2d as bookings_2d_control,
- c1.bookings_3d as bookings_3d_control,
- c1.bookings_7d as bookings_7d_control,
- c1.bookings_14d as bookings_14d_control,
- c1.bookings_30d as bookings_30d_control,
- c1.pro_signups_1d as pro_signups_1d_control,
- c1.pro_signups_2d as pro_signups_2d_control,
- c1.pro_signups_3d as pro_signups_3d_control,
- c1.pro_signups_7d as pro_signups_7d_control,
- c1.pro_signups_14d as pro_signups_14d_control,
- c1.pro_signups_30d as pro_signups_30d_control,
- c1.unlimited_signups_1d as unlimited_signups_1d_control,
- c1.unlimited_signups_2d as unlimited_signups_2d_control,
- c1.unlimited_signups_3d as unlimited_signups_3d_control,
- c1.unlimited_signups_7d as unlimited_signups_7d_control,
- c1.unlimited_signups_14d as unlimited_signups_14d_control,
- c1.unlimited_signups_30d as unlimited_signups_30d_control,
- c1.pro_cancels_1d as pro_cancels_1d_control,
- c1.pro_cancels_2d as pro_cancels_2d_control,
- c1.pro_cancels_3d as pro_cancels_3d_control,
- c1.pro_cancels_7d as pro_cancels_7d_control,
- c1.pro_cancels_14d as pro_cancels_14d_control,
- c1.pro_cancels_30d as pro_cancels_30d_control,
- c1.return_visits_1d as return_visits_1d_control,
- c1.return_visits_2d as return_visits_2d_control,
- c1.return_visits_3d as return_visits_3d_control,
- c1.return_visits_7d as return_visits_7d_control,
- c1.return_visits_14d as return_visits_14d_control,
- c1.return_visits_30d as return_visits_30d_control,
- c1.rezo_searches_1d as rezo_searches_1d_control,
- c1.rezo_searches_2d as rezo_searches_2d_control,
- c1.rezo_searches_3d as rezo_searches_3d_control,
- c1.rezo_searches_7d as rezo_searches_7d_control,
- c1.rezo_searches_14d as rezo_searches_14d_control,
- c1.rezo_searches_30d as rezo_searches_30d_control,
- c1.rezo_selects_1d as rezo_selects_1d_control,
- c1.rezo_selects_2d as rezo_selects_2d_control,
- c1.rezo_selects_3d as rezo_selects_3d_control,
- c1.rezo_selects_7d as rezo_selects_7d_control,
- c1.rezo_selects_14d as rezo_selects_14d_control,
- c1.rezo_selects_30d as rezo_selects_30d_control,
- c1.shortlists_created_1d as shortlists_created_1d_control,
- c1.shortlists_created_2d as shortlists_created_2d_control,
- c1.shortlists_created_3d as shortlists_created_3d_control,
- c1.shortlists_created_7d as shortlists_created_7d_control,
- c1.shortlists_created_14d as shortlists_created_14d_control,
- c1.shortlists_created_30d as shortlists_created_30d_control
- from marketing.user_campaign_performance c
- left join control c1
- on c.campaign_test = c1.campaign_test
- and coalesce(c.segment_1, '') = coalesce(c1.segment_1, '')
Add Comment
Please, Sign In to add comment