Complex~33min

The Chargeback Rate That Hides in Aggregation

BIN 411111 has a 25% chargeback rate — 125 of 500 transactions — completely diluted into the merchant's overall 3.09% chargeback rate by volume from 19 other BINs. BIN 533221 also runs elevated at 8%, but that's a documented high-risk international BIN category that has always disputed more, not new fraud. Grouping by BIN instead of the merchant total is what surfaces the real breach.

Tables you'll query

bin_profilestransactions

What you'll learn

CTEs (WITH clause)Window FunctionsCohort Analysis
Investigate this case →