(Sorry for the delayed reply! the last two weeks have been too full with projects + part-time-teaching, so I overlooked this as the automatic forwarding did not work) I do not have particular experience with NPS in multiple locations as described here. But I think some other ideas can be generalized to solve this.
your approach with aggregating sounds feasilbe, some ideas that pop up in my mind
- do you want to end up with ONE value per customer (aggregated over days + cities) or should/could it be a value per city
- cities could be ordered by weight, e.g. the top 3 cities with the longest duration
- you can also calculate a variability measure/segement : A: customers who only have one city, customers with >= 2 cities with rather equal time there, customer with a dominant city
just some quick thoughts
happy to discuss further Gerhard
... View more