Ran the CSV through our deduper first. Website URLs were populated for ~80% of rows, far better than the competition. Otherwise no complaints.
Thanks for the detailed review, the points you raised are on the refresh checklist for the next pull. Drop a note via Help → Contact Support and we'll line up a fresh export for you.