Twill Brain

KPI Sync

2 min read

KPI Sync

Date: 2025-05-06 · Duration: 66.7300033569336 min Organizer: Nader Attendees: Ahmad, Mike, Nader, Martin

Summary

  • Dashboard & KPI Framework Progress: Ahmadreza merged charts for card decline rate, transaction volume, and average transaction value using SQL/Python/HTML. Current dashboard supports required KPIs; plans for future complexity and interactivity discussed.

  • Technical Structure & Integration Planning: Focus on enhancing ‘experiment’ folder structure to integrate with backend/frontend. Martin & Ahmadreza to use Jinja templates for SQL queries, supporting dynamic filtering. SQL queries & JSON config for KPIs will be uploaded to main database for platform integration.

  • Next Steps & Action Items: Martin to finalize folder structure & document integration tickets. Ahmadreza to complete remaining KPIs, add Jinja templating for SQL, and research external benchmarks for actionable insights. Follow-up meeting scheduled for Thursday at 11:30 PST.

Action Items

  • Martin Elias Costa Finalize the folder structure outside of the ‘experiment’ folder to ensure compatibility with flexible widgets, APIs, and platform integration. Create a skeleton for this structure and coordinate with Ahmadreza to implement it (49:54) Break down and document step-by-step tickets required to move from the current state to full platform integration of the KPI dashboards, including backend and frontend requirements (50:28)

Ahmadreza Abdoli Add Jinja templating to the SQL queries for KPI dashboards to support dynamic filtering and compatibility with the platform’s flexible widget framework (54:46) Complete the remaining two KPIs (process fee and chargeback fee) with appropriate charts and structure for integration into the platform (53:30) Move ticket 13 (core decline rate) to review status for Martin to review and update with Jinja template as needed (01:06:03) Research and brainstorm potential external benchmark and industry data sources to enhance KPI insights, focusing on actionable and relevant metrics for each KPI (01:01:45)

Nader Atrchin Schedule a follow-up meeting for Thursday at 11:30 PST to review ticket structure, next steps, and clarify the integration plan (56:29)

Graph View