9. BI & reporting

9.1 What dashboards and pre‑built reports are available?

Metabase dashboards provide key analytics for refunds and transactions.

9.2 Can I pull aggregated transaction data via the API or export to CSV/JSON?

Yes via the API. Apply filters (e.g., createdAt, id, pnr, status, ticketNum, userId) with operators like gt, gte, lt, lte, in, not, contains, startsWith, endsWith. Export to CSV/JSON must be done client‑side from the API response.

9.3 How can I monitor API health and uptime?

API health and uptime on our status page: status.deal-engine.com.

9.4 Can I schedule recurring reports or subscribe to analytics updates?

Not currently. Generate on demand via dashboards or API.

9.5 Can you share some filtering examples?

Yes, Date range:

{ "filter": { "createdAt_gte": "2025-01-01T00:00:00Z", "createdAt_lte": "2025-01-31T23:59:59Z" } }

ID list:

{ "filter": { "id_in": ["QTE-1001", "QTE-1002", "QTE-1003"] } }

PNR contains:

{ "filter": { "pnr_contains": "ABC" } }

Status in:

{ "filter": { "status_in": ["PENDING", "APPROVED"] } }

Ticket number exact:

{ "filter": { "ticketNum": "1282132019309" } }