Offering a Discount

When offering a discount downsell to save the order, do you do a data dip into the customer record BEFORE you offer a discount so we know if there is already an existing discount in the customer record? This is very important to know because we cannot randomly offer discounts without understanding first how much of a discount they may already have. To illustrate, suppose the customer initially purchased with a 10% coupon code. Now they’re cancelling. I need to know the current discount so I can offer them the “right” discount, say, another 10% discount for a total of 20% total discount for this case. This will protect me from over discount when downselling. Moreover, using the same scenario above, suppose the customer accepts the additional 10% offer for a total of 20% off. Three months later he comes back to cancel again. Same problem, e.g., what is the current total discount the customer is enjoying so I can either offer another discount, or, none at all, depending on this particular customer’s total discount. So, I may NOT want the customer to even see another discount offer at all in some cases depending on his total discount at the time of cancellation. I may want to only offer a Skip payment screen for “n” months, effectively a temporary pause until “n” months is up. 

How are you handling these scenarios?

I’m looking forward to your response.