Talk to anybody who has tried to clean up corporate hotel data, and you’ll know they hate doing it. It’s a pain in the butt to take a company’s hotel booking data from its TMC, and merge it with the company’s paid hotel data from its corporate card.
The first and arguably hardest step is to normalize the hotel identities. Somehow, you have to recognize that a credit card transaction at the “Marriott Courtyard in Salt Lake” should be tied to the reservation made at the “Courtyard by Marriott in Saltlake City”.
The variation in hotel names, as captured by the travel agencies, GDSs and credit card providers, is nothing short of maddening. And we’re not Continue reading