Design a payment offers system

Design a payment offers system that allows running targeted offers for specific users and payment methods (like VISA cards or GPay UPI), with configurable redemption limits at both user level (x times per period/week/month) and global level (total redemption cap), where offers automatically become invisible once limits are reached.