Create a function, flag_completed that add new logicial columns that show if the applicant ever completed or completed within the session [2026-03-11]
Adjust the timestamp which is exported from the API in UTC to the correct timezone based on the state in read_mixpanel [2026-03-10]
Change applicant_only logic in read_mixpanel which originally was set to take distinct_id that started with “applicant” but with device_id as the driver, just filtered out Caseworker events [2026-03-09]
Change the pilot start for LA Feb 2026 when running add_pilot_week to account for actual tokenized link sharing start rather than planned start date [2026-03-03]
Change pilot week calculation in add_pilot_week to do it by day rather than floor week to account for pilot starting mid-week [2026-03-01]
Add function to calculate to lump timestamps into pilot weeks, add_pilot_week [2026-02-26]
Resolve issue where caseworkers were errantly dropped since they don’t have a cbv_flow_id [2026-02-26]
Add additional pilot periods to data [2026-02-25]
Fix object bug (typo) in read_mixpanel [2026-02-25]
