Join datasets and compute conversion by assignment

You are given two event-level tables from a booking funnel. The visit table has one row for each site visit, and the booking table has one row for each completed checkout. All timestamp values are in UTC. Use the following schema: Part 1: Visit-level conversion dataset Create one row for every visit record. The output columns are: id_visitor visit_ts country assign booked_flag For each visit, define the following attribution window: It starts at the visit's own timestamp,…