Welcome to Chadmin
Your administrative dashboard for data management and analysis
Current Version: 0.5.0
Version History
Version 0.5.0
- Changed Deals and Appointments to UPSERT (updates existing records)
- Created matched_records table for attribution analysis
- Added attribution analysis feature to find conflicts
- Run Analysis button appears after Deals import
- Progress bar for analysis execution
- Matches page displays all attribution conflicts
- Shows Lead ID, Appointment ID, Deal ID, phone, email, vendor, source
- Analysis finds external vendor deals matching internal/unbranded leads/appointments
Version 0.4.0
- Added Appointments table to database
- Enabled Appointments import from Monday.com exports
- Added Appointment ID (App ID) as unique constraint
- Updated column mappings for Appointments table
- Import system now supports Leads, Deals, and Appointments
- All cleaning rules apply to Appointments (phone, Monday formatting)
Version 0.3.0
- Added Deals table to database
- Enabled Deals import from Monday.com exports
- Added Deal ID as unique constraint for duplicate detection
- Extended data cleaner to support multiple table types
- Updated import logic to handle both Leads and Deals
- All cleaning rules apply to Deals (phone, Monday formatting, etc.)
Version 0.2.0
- Added file upload functionality for CSV/XLSX files
- Implemented data cleaning (remove Monday.com headers and groups)
- Created Leads database table with SQLite
- Added duplicate detection using Lead ID as unique constraint
- Implemented phone number cleaning (American format)
- Implemented creation log date extraction
Version 0.1.0
- Initial setup with Flask and Bootstrap 5
- Created header with menu system
- Added Attribution page placeholder
- Set up project structure and versioning