#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

Add wikilinks to related people, meetings, or other tickets