Bazaarvoice interview question

How would you solve this technical problem?