daily results.sql

      results AS (
        SELECT
          event,
          experiment_test,
          experiment_result,
          day,
          count(DISTINCT first_exposures.tracking_id)            exposures,
          count(DISTINCT conversions_order_placed_1.tracking_id) order_placed_1,
          count(DISTINCT conversions_order_placed_1.tracking_id) /
          count(DISTINCT first_exposures.tracking_id) :: FLOAT   conversion_rate

        FROM first_exposures
          LEFT JOIN conversions_order_placed_1
            ON first_exposures.tracking_id = conversions_order_placed_1.tracking_id AND
               conversions_order_placed_1.created_at > first_exposures.created_at

        GROUP BY 1, 2, 3, 4
        ORDER BY 1, 2, 3, 4
    ),