7 projects
Ihsan's Project Directory
CRM & customers
- OpenCRM v3 OverviewLive read-only status dashboard from the CRM v3 Timeline & Brief sheet.See where every CRM v3 workstream stands today without opening the sheet.
- OpenKebunPRO Look-alike Target ListScored list of leads who look like existing KebunPRO customers, with owner, last engagement, purchases and leader (MBR/CBR) reviews.Decide which look-alike leads to approach next, and who owns them.
Incentives
- OpenIncentive Reconciliation HandoverHow the monthly incentive payout check works and how to run it: data flow, the four schemes, the monthly run, the Sep 2026 worked example, runbook and evidence.Hand the monthly reconciliation over to Dena so she can run it alone.
- OpenMay & June 2026 Incentive Reconciliation (V6)Margin and weekly-winner reconciliation of the May–Jul sheet vs V6 vs live Metabase, with the V6 cost-lookup fix blueprint.Explain why V6 disagreed on 4 weeks and how pulling live Odoo PO costs fixes it.
- OpenIncentive Automation Plan (GitHub Actions + Lark)Plan v2 (not implemented): run the daily CM123 rebuild on GitHub Actions after the V6 import, and mirror incentive rules and each PIC's potential incentive into Lark Base.Move the daily rebuild off a PC and give each salesperson a 'what can I earn' view.
Data platform & access
- OpenNeuron v3 Data Knowledge ExplorerOffline explorer of the data knowledge layer: ClickHouse tables, Airflow DAGs, CRM concepts and the metric tree, with lineage and path finding.Find where a metric comes from and which tables and DAGs feed it.
- OpenB16 Permission AuditRole approval workbench for the B16 base (has its own reviewer PIN).Review and approve who keeps which role and table permission on the B16 Customers Relations Master base.
Status is a live TCP check of each upstream. The lock means the page asks for a PIN; entries tagged Google sign-in need a @sawitpro.com Google account.