In the example below, we have an expression to find the minimum distance between each customer postcode and Heathrow, Birmingham and Manchester airports. This kind of expression can be used to find customers who are near to particular relevant locations.
ge-ap-1.jpg
A slight modification of the expression cyprus mobile numbers can give the textual value of the particular airport that the customer is closest to. This expression below could also be turned into a Selector virtual variable using the Expression wizard.
ap-2_2.jpg
These two examples can be utilised together in a marketing context. In the screenshot below, I’ve selected customers who live within 20 miles of one of the three airports. and the name of the airport that they’re closest to.
ge-ap-3.jpg
How far between?
In this next example, we’re using a FastStats system built out of UK flight delay data. The data provided by the CAA includes origin and destination airports, but does not provide location information. We’ve found and added the latitude and longitude values for over 1,200 airports that are flown to from the UK. The rationale behind doing this was so that we could investigate whether flight distance had an impact on how much flights were delayed.