Guest User

Untitled

a guest
Oct 20th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.36 KB | None | 0 0
  1. with control as (
  2. select *
  3. from marketing.user_campaign_performance
  4. where treatment = 'control'
  5. )
  6. select
  7. c.campaign_test,
  8. c.treatment,
  9. c.segment_1,
  10. c.population,
  11. c.orders_1d,
  12. c.orders_2d,
  13. c.orders_3d,
  14. c.orders_7d,
  15. c.orders_14d,
  16. c.orders_30d,
  17. c.bookings_1d,
  18. c.bookings_2d,
  19. c.bookings_3d,
  20. c.bookings_7d,
  21. c.bookings_14d,
  22. c.bookings_30d,
  23. c.pro_signups_1d,
  24. c.pro_signups_2d,
  25. c.pro_signups_3d,
  26. c.pro_signups_7d,
  27. c.pro_signups_14d,
  28. c.pro_signups_30d,
  29. c.unlimited_signups_1d,
  30. c.unlimited_signups_2d,
  31. c.unlimited_signups_3d,
  32. c.unlimited_signups_7d,
  33. c.unlimited_signups_14d,
  34. c.unlimited_signups_30d,
  35. c.pro_cancels_1d,
  36. c.pro_cancels_2d,
  37. c.pro_cancels_3d,
  38. c.pro_cancels_7d,
  39. c.pro_cancels_14d,
  40. c.pro_cancels_30d,
  41. c.return_visits_1d,
  42. c.return_visits_2d,
  43. c.return_visits_3d,
  44. c.return_visits_7d,
  45. c.return_visits_14d,
  46. c.return_visits_30d,
  47. c.rezo_searches_1d,
  48. c.rezo_searches_2d,
  49. c.rezo_searches_3d,
  50. c.rezo_searches_7d,
  51. c.rezo_searches_14d,
  52. c.rezo_searches_30d,
  53. c.rezo_selects_1d,
  54. c.rezo_selects_2d,
  55. c.rezo_selects_3d,
  56. c.rezo_selects_7d,
  57. c.rezo_selects_14d,
  58. c.rezo_selects_30d,
  59. c.shortlists_created_1d,
  60. c.shortlists_created_2d,
  61. c.shortlists_created_3d,
  62. c.shortlists_created_7d,
  63. c.shortlists_created_14d,
  64. c.shortlists_created_30d,
  65. c1.population as population_control,
  66. c1.orders_1d as orders_1d_control,
  67. c1.orders_2d as orders_2d_control,
  68. c1.orders_3d as orders_3d_control,
  69. c1.orders_7d as orders_7d_control,
  70. c1.orders_14d as orders_14d_control,
  71. c1.orders_30d as orders_30d_control,
  72. c1.bookings_1d as bookings_1d_control,
  73. c1.bookings_2d as bookings_2d_control,
  74. c1.bookings_3d as bookings_3d_control,
  75. c1.bookings_7d as bookings_7d_control,
  76. c1.bookings_14d as bookings_14d_control,
  77. c1.bookings_30d as bookings_30d_control,
  78. c1.pro_signups_1d as pro_signups_1d_control,
  79. c1.pro_signups_2d as pro_signups_2d_control,
  80. c1.pro_signups_3d as pro_signups_3d_control,
  81. c1.pro_signups_7d as pro_signups_7d_control,
  82. c1.pro_signups_14d as pro_signups_14d_control,
  83. c1.pro_signups_30d as pro_signups_30d_control,
  84. c1.unlimited_signups_1d as unlimited_signups_1d_control,
  85. c1.unlimited_signups_2d as unlimited_signups_2d_control,
  86. c1.unlimited_signups_3d as unlimited_signups_3d_control,
  87. c1.unlimited_signups_7d as unlimited_signups_7d_control,
  88. c1.unlimited_signups_14d as unlimited_signups_14d_control,
  89. c1.unlimited_signups_30d as unlimited_signups_30d_control,
  90. c1.pro_cancels_1d as pro_cancels_1d_control,
  91. c1.pro_cancels_2d as pro_cancels_2d_control,
  92. c1.pro_cancels_3d as pro_cancels_3d_control,
  93. c1.pro_cancels_7d as pro_cancels_7d_control,
  94. c1.pro_cancels_14d as pro_cancels_14d_control,
  95. c1.pro_cancels_30d as pro_cancels_30d_control,
  96. c1.return_visits_1d as return_visits_1d_control,
  97. c1.return_visits_2d as return_visits_2d_control,
  98. c1.return_visits_3d as return_visits_3d_control,
  99. c1.return_visits_7d as return_visits_7d_control,
  100. c1.return_visits_14d as return_visits_14d_control,
  101. c1.return_visits_30d as return_visits_30d_control,
  102. c1.rezo_searches_1d as rezo_searches_1d_control,
  103. c1.rezo_searches_2d as rezo_searches_2d_control,
  104. c1.rezo_searches_3d as rezo_searches_3d_control,
  105. c1.rezo_searches_7d as rezo_searches_7d_control,
  106. c1.rezo_searches_14d as rezo_searches_14d_control,
  107. c1.rezo_searches_30d as rezo_searches_30d_control,
  108. c1.rezo_selects_1d as rezo_selects_1d_control,
  109. c1.rezo_selects_2d as rezo_selects_2d_control,
  110. c1.rezo_selects_3d as rezo_selects_3d_control,
  111. c1.rezo_selects_7d as rezo_selects_7d_control,
  112. c1.rezo_selects_14d as rezo_selects_14d_control,
  113. c1.rezo_selects_30d as rezo_selects_30d_control,
  114. c1.shortlists_created_1d as shortlists_created_1d_control,
  115. c1.shortlists_created_2d as shortlists_created_2d_control,
  116. c1.shortlists_created_3d as shortlists_created_3d_control,
  117. c1.shortlists_created_7d as shortlists_created_7d_control,
  118. c1.shortlists_created_14d as shortlists_created_14d_control,
  119. c1.shortlists_created_30d as shortlists_created_30d_control
  120. from marketing.user_campaign_performance c
  121. left join control c1
  122. on c.campaign_test = c1.campaign_test
  123. and coalesce(c.segment_1, '') = coalesce(c1.segment_1, '')
Add Comment
Please, Sign In to add comment