Creatively using Marketview parameters to identify cruise cardholders for economic analysis
Published on 03 July 2024
The client wanted to know how much and what cruise passengers were spending in the regions. But how do we identify potential cruise cards?
The challenge
Our client wanted to find out how much cruise passengers were spending in New Zealand.
We collect country of origin data but have no way of knowing which cards belonged to cruise passengers.
The solution
Thankfully, New Zealand lends itself to a multi-port itinerary which allowed us to trace the use of cards. The assumption was, if a card was used i) in at least 2 of the same ports as a New Zealand cruise itinerary, ii) between the passenger disembarkation and embarkation times, and iii) in a location passengers could access within its time ashore, then it had a high probability of being a card that belonged to a cruise passenger.
Our client provided the required cruise information and we input those restrictions into our code. We also extracted the location where the transactions took place and the store type they had transacted.
The outcome
As it was a considerably tight qualification of cards, the sample returned was small but robust. Our client took the results and weighted it against the type of ship and the population the ship carried, to work out the total passenger spend.
Our client presented these results at a national cruise conference which was very well received by the industry who up until that point, had no objective measurement of cruise passenger spend in their region, much less knowing which storetypes the cruise passengers had spent in.