Field-tested by my team. Lat/long landed every pin on the right storefront in Mapbox. Connect rate could have been higher with cleaner mobile numbers.
Thanks for the detailed review, we hear you on the gaps — the next monthly refresh tightens those exact columns. Drop a note via Help → Contact Support and we'll line up a fresh export for you.