#832 — Add authorization kpis
Repo: Twill-AI/facade State: open | Status: open Assignee: nadddder, Ahmad1809
Created: 2025-12-16 · Updated: 2026-03-20
Description
Request
Extend DbMerchantKPI table to support authorization metrics with flexible time periods.
- Each of the following should have values for
all-time,last-30-days,last-90-days,month-to-date,last-year: - Total Authorizations Count
- Total Authorization Amount
- Total Approved Authorizations Count
- Total Approved Amount
- Total Declined Authorizations Count
- Approved Ratio by Count
- Approved Ratio by Amount
- Job updates incrementally using only necessary data.
- Include newly created KPIs in the get merchant detail endpoints kpis (master + partner)
Existing KPI patterns for reference: calculate metrics → bulk upload → query endpoint → background sync
Notes
Add implementation notes, blockers, and context here
Related
Add wikilinks to related people, meetings, or other tickets