exposure and conversion.sql

 WITH first_exposures AS (
      SELECT
        tracking_id,
        created_at,
        event,
        experiment_test,
        experiment_result,
        date_trunc('day', created_at) AS day
      FROM warehouse.events
      WHERE category = 'experiment'
            AND created_at > '10-13-16'
  ),

      conversions_order_placed_1 AS (SELECT
                                       tracking_id,
                                       created_at
                                     FROM warehouse.events
                                     WHERE event_name = 'Order: order-placed-1'
                                     GROUP BY 1, 2
    ),