Velocity Checks: Attempts and Amounts per Card in Rolling 24-Hour and 1-Hour Windows
This lesson is part of the course
In this lesson
You build rolling time windows with COUNTIFS and SUMIFS, count attempts and dollars per card in the last 24 hours and the last hour, and flag cards that break a velocity limit.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Transaction Features: Amount vs Card Average, New Device & Country Mismatch Locked
- Velocity Checks: Attempts and Amounts per Card in Rolling 24-Hour and 1-Hour Windows Locked
- Rule Hits & a Weighted Risk Score: Approve, Review or Decline Locked
- Choosing the Alert Threshold: Precision, Recall and Dollar Recall against Labelled Fraud Locked
- Alert Volume vs Analyst Capacity: Staffing, the Lowest Workable Threshold and a Sale-Day Backlog Locked
- False-Positive Cost vs Fraud Loss Prevented: the Net-Benefit Threshold (with a Chart) Locked
- Rule Performance Table: Hit Rate, Precision and Fraud Share per Rule (with a Chart) Locked
- Champion vs Challenger: Shadow-Testing a New Rule Set Before It Goes Live Locked