Ran the CSV through our deduper first. Lat/long landed every pin on the right storefront in Mapbox. Sales team is happy.
Really appreciate you taking the time to write this, we'll keep tightening the column coverage in the next refresh. Happy to fast-track a custom segment if you ever need one.