Rotate advertisements periodically

Any thoughts on the possibility of rotating a given advertisement ‘location’ periodically. Here’s what I mean. I have a single advertiser per day on my community. I would like to make that ad into the ‘Sponsor of the Day Advertiser’. So every day, I would like my sitewide ads (or ideally do so each different location) to rotate to a different ad. based on a time It could be hourly, daily, weekly, only on Sundays, etc. Currently, I have to go in manually and enable or disable the source advertisement.

Not sure this will be a priority for most… 🤐