Who this is for
| Company type | Payment gateway, fintech, merchant services |
| Connector | PostgreSQL |
| Teams | Risk, treasury, merchant success, compliance |
Get started
Add PostgreSQL
Connect your payments ledger or warehouse. See Add connectors.
See it in Vizkraft
Your data
| Table | What it holds |
|---|---|
merchants | Merchant profile, category, tier, region |
accounts | Ledger balances by merchant |
transactions | All payment attempts — amount, method, status |
payments | Settled payments and fees |
chargebacks | Disputes — reason, amount, status |
fraud_scores | Risk score and flagged transactions |
settlement_batches | Payout batches and status |
Tables to mark during indexing
- Transactions and payments — volume and approval rate
- Fraud scores — flagged rate and model performance
- Chargebacks — dispute ratio by category
- Settlement batches — treasury operations
- Merchants — tier and segment analysis
Dashboards to build
Payment volume and success rate
Answers: Is payment volume growing and are authorizations healthy? Include volume, approval rate, and average transaction value KPIs; daily volume trend; and breakdown by payment method.Fraud and chargebacks
Answers: Where is risk concentrated? Include flagged rate and chargeback ratio KPIs; chargebacks by reason; and a table of flagged transactions.Merchant performance
Answers: Which merchants drive GMV and who needs support? Include active merchants and GMV KPIs; volume by merchant tier; and a top merchants table.Settlement operations
Answers: Are payouts on time? Include pending settlement and average lag KPIs; batch volume over time; and overdue batches table.Questions to ask by role
| Role | Questions to try |
|---|---|
| Risk analyst | What is the flagged transaction rate by payment method and merchant tier? |
| Treasury | What is settlement lag and total pending batch amount? |
| Merchant success | What is approval rate by payment method? |
| Compliance | What is chargeback ratio by merchant category? |
Example conversations
Approval rate
Ask: What is approval rate by payment method for the last 30 days? Compare methods by both rate and volume so low performers are not hidden behind small sample sizes.Metrics worth defining
Add to Connector memory as needed:- Approval rate — successful payments ÷ transaction attempts
- Chargeback ratio — chargeback amount ÷ settled volume
- GMV — gross merchandise value from settled payments
- Settlement lag — days between payment and batch settlement