Overview
Track auth→capture funnel by PSP/BIN/region, decline taxonomy, invoice aging, and dispute win rate.
Problem
Payments span gateways, BINs, and regions; teams lack a unified view and miss systemic failures.
Solution
InsightLake models PayStream events into fact_payment and LTV cohorts, surfacing weak PSP routes and risky segments.
How it works
Enable the Payments pack. Compare auth rates across PSPs, monitor “do_not_honor” spikes, and trend dispute outcomes by SKU/cohort.
Who is this for
Expected outcomes
- Higher auth and capture rates
- Faster collections and fewer disputes
Key metrics
Auth success rate
Baseline
87 %
Target
92 %
Dispute win rate
Baseline
44 %
Target
54 %
Invoice aging >30d
Baseline
18 %
Target
10 %
Gallery
Downloads & templates
Case studies
SubHub optimizes EU auth rates
Routing changes raised auth +4.2 points.
Security impact
- Payment events (no PAN), invoices, dispute outcomes · PII: yes (customer/account references, masked)
Compliance
- GDPR
- SOC2
- PCI-N/A (no card numbers stored)