System Design: Banner Frequency Capping at 100M DAU — How Swiggy/Flipkart Show You Ads Exactly Twice a Day

I designed this system after coming across a common product problem — how does Swiggy show you a promotional banner exactly twice a day without hammering their database 100 million times? Here's the f