Ran the CSV through our deduper first. Website URLs were populated for ~80% of rows, far better than the competition. Couple of small gaps but workable.
Appreciate the write-up, noted on the minor gaps — they're tracked for the next refresh. Open a ticket via the Support tab and we'll prioritise the columns you flagged for the next refresh.