Was wondering what a good approach would be to route leads in a round robin fashion.
I have products for sale in particular cities and each city can have multiple salespeople. How would I go about routing leads between them in an organized fashion?
The approach I can think of, not sure how efficient it is, however:
One method I can think of would be storing the salesperson id in a field in MySQL in the 'cities' table of the salesperson who last got a lead in that city. Then I could randomly assign the next lead to an agent other than the one stored in the DB (if multiple salespeople are in the particular city).
Would that be a good way to do it or is there a better way I could go about it rather than random assignment and more toward a 'round robin' approach?
Thank I'm mainly stuck on the logic behind it.
Thanks for the help!