Zip Code Booking Conversion

What this measures. Of the leads bought into a zip, how many turned into a booking. The denominator is every fresh lead in the window whose address carried a readable zip — not the /lead-funnel "usable" figure, because the question here is what the money bought. Recycled codes and codes with no city are excluded.
How the join works. The CRM bookings feed carries no phone, email or lead id, so a lead → booking join is a name match, keyed on name + marketing code — never name + date, because Date Distributed is not the lead's date. 79.1% of the 6,941 bookings in the window joined to a lead here; the rest belong to leads outside the window, to recycled codes, or to a name spelt differently on the two feeds. So read these rates zip against zip, not as absolute truth.
Coverage. 783 in-range leads had no readable zip and are excluded from every zip table — they stay in the join, so they cannot donate a booking to a namesake. 41,725 recycled and 403 unknown-city leads were dropped before that.
Late bookings. Bookings are pulled to today, not to the end of the window, so a lead that books after the window closes still counts. A window ending in the last fortnight will keep creeping upward.