Compute C/T metrics from bookings and visits

Given two related tables from an experiment, write a query or script that computes daily control/treatment metrics for a fixed seven-day period. Tables visits Column Type Description visit_id string Unique identifier for the visit user_id string Identifier for the user visit_ts timestamp UTC Time when the visit occurred market_id string Market or city code channel string Acquisition channel variant char(1) Either 'C' (control) or 'T' (treatment) bookings Column Type…