Reduction groups — what the card was doing before each reduction, and what came in after

The groups, side by side

Days to reduction is simply agreement date → reduction date. It is not a measure of how long the account was "active" or paying. Charges tried counts every Square charge attempt on that customer before the reduction, landed or not; success rate is how many landed.

"Still owed after" is what the customer owed once the discount was applied, and "% of that collected" is how much of it actually came in. That is the number that says whether the deal was honoured — measuring against what they still had to pay, not against what we gave away. Where the credit cleared the balance outright there is nothing left to collect and no percentage exists; that count is its own column.

These groups describe what the CARD was doing — they are NOT the reason the reduction was given. The CRM records no reason beyond the free text somebody typed on the credit line, so the driver behind any of these decisions is not in this data. Read the groups as billing context, not as cause.

Deals only — discounts, package reductions, management credits

Write-offs, cancellations and Monterey settlements are stripped out here. Those are meant to recover nothing, so leaving them in flatters the groups that hold them.

Row-level detail is on each group's own tab, and the whole thing is in the CSV. There is no reduction reason beyond the typed reference — the CRM's note fields on the credit line, the payment and the no-sale reason are all empty on every reduced booking checked; the only free text on the booking is shoot admin written at sale time.