Everyone in the company adds new rows straight to the shared "All Sales" Google Sheet — nothing is ever
removed, so cancelled and resold leads stay visible in the history. This page re-syncs from that sheet
into staging_sales automatically every 5 minutes, matching
rows on Lead Id + Fuel Type — an edited row (e.g. a status
change to Cancelled) updates the existing record instead of creating a duplicate. Promotion into
fact_sales (dedup, quarantine, generated fields) still
happens separately via 01_fact_sales_load_fixed.sql.
Cancelled sales stay in the table but are excluded from billable revenue in reporting, same convention
as the rest of the pipeline.