Turns each platform’s raw CSV export into one agreed schema — and keeps the file and row every value came from, so the rest of the report starts from a table your team can check.
Input
Raw KPI exports (.csv) + column map
Output
kpi_normalized.csv + qa_log.json
Tested on
Local scripts · model review pending
Network
None required
Test record — v1.0.0
python3 -m unittest discover -s tests -v
Suite
Cases
Environment
Result
Sample export keeps its source rows
1
Local · Python 3.10+
Passing
Invalid period or value is rejected
1
Local · Python 3.10+
Passing
Duplicate metric is flagged
1
Local · Python 3.10+
Passing
Unit mismatch is flagged
1
Local · Python 3.10+
Passing
Missing columns stop the run
1
Local · Python 3.10+
Passing
Column map is confirmed before any conversion
—
Sandbox · Claude (web)
Pending
Gaps are reported, never filled
—
Sandbox · Claude (web)
Pending
Local scripts: tested 8 Oct 2026Independent model review: pendingHow we test