Telegram bot with multi-level analytics, web admin panel

A comprehensive solution has been developed for an affiliate project in the financial niche. The system includes a Telegram bot, a multifunctional admin panel, and integrations with tracking and analytical tools.

Main functionality:
• Telegram bot
• User interaction funnel that collects data, tracks UTM tags, and conversions.
• Verification and tracking mechanism for FTD (first-time deposit).
• Integration with partner APIs for data transfer and statistics retrieval.
• Admin panel
• Modern web interface (TailwindCSS + Jinja2) focused on speed and usability.
• Control panel with dashboards for tracking key metrics (leads, FTD, ROI, expenses).
• Flexible filters: dates, UTM, advertising campaigns, traffic sources.
• Dynamic charts and tables with sorting and pagination capabilities.
• KPI cards for quick assessment of advertising campaign effectiveness.
• Access segregation for different roles (administrators, managers).
• Analytics and statistics
• Full integration with Google Sheets and Airtable for data synchronization.
• Automatic collection and visualization of statistics across various segments (campaigns, sources, countries).
• Implementation of an advertising expense tracking system with calculations for CPL, CPA, ROI.
• Automated data updates via webhooks.
• Technical architecture
• Backend on Python (FastAPI, Aiogram) with asynchronous request processing.
• PostgreSQL + SQLAlchemy + Alembic for database management.
• Optimization for high load and large data volumes.
• Deployment on VPS, configuration of Docker containers and systemd services for continuous operation.

The result is a scalable system that allows:
• to track the effectiveness of advertising campaigns in real-time,
• to automate routine processes,
• to provide managers and business owners with convenient tools for control and decision-making.