I have a table of advertisement with expiry date and location. Currently, I display ad at random base on userís location.

In the near future, I want to add tier system in to my ad sale. It means the first tier ad should be displayed more often than the second tier, but I donít know how to control that.

Is there any existing solution for my problem?

Thank you,