Telegram Bot + Admin Dashboard for UTM Tracking & Attribution
An attribution system for affiliate traffic with deep-link UTM tracking, a Telegram bot, a FastAPI admin panel, FTD tracking, and automated data synchronization.
An attribution system for affiliate traffic with deep-link UTM tracking, a Telegram bot, a FastAPI admin panel, FTD tracking, and automated data synchronization.
This is a complete attribution system for affiliate and media buying traffic, built to provide more accurate user flow tracking, campaign transparency, and convenient analytics. The solution included a Telegram bot with deep-link UTM tracking, a PostgreSQL database for storing user data and campaign parameters, a FastAPI admin panel with filters, analytics, and export features, as well as FTD tracking and a finance dashboard. Additional automated integrations with Google Sheets and Airtable were implemented for reporting and data synchronization. As a result, the system simplified traffic tracking, improved attribution transparency, and created a foundation for data-driven scaling of advertising campaigns.
Problem
The goal was not just to collect leads from Telegram, but to build a full attribution system that shows where the user came from, how they moved through the funnel, and which campaigns actually drive results.
The main challenges included:
- tracking UTM parameters through deep links inside Telegram
- storing user and campaign data in a unified database
- providing the team with a convenient admin panel featuring filters and analytics
- integrating FTD tracking and financial reporting
- automating reporting and synchronization through Google Sheets and Airtable
- improving campaign performance transparency for media buying teams
Process
The project was built around attribution logic, analytical usability, and a stable backend infrastructure.
- developed a Telegram bot with deep-link UTM tracking
- structured PostgreSQL storage for users and campaign parameters
- built a FastAPI admin dashboard with filters, analytics, and export features
- added FTD tracking and a finance dashboard
- connected automated integrations with Google Sheets and Airtable
- organized the system so the team could analyze traffic more effectively and make data-driven decisions
Solution
The final result was a complete attribution and analytics system for affiliate traffic, combining Telegram, backend infrastructure, analytics, and reporting automation in one product.
Key solutions delivered:
- Telegram bot with deep-link UTM tracking
- PostgreSQL data storage
- FastAPI admin dashboard
- filters, analytics, and export
- FTD tracking
- finance dashboard
- integrations with Google Sheets and Airtable
- infrastructure for campaign transparency and scaling
Result
The result was a data-driven attribution system that improved campaign transparency, automated user flow tracking, and gave media buying teams a more effective tool for analytics and scaling.The project combined tracking, attribution, finance metrics, and reporting automation into one system that helps teams identify working traffic sources faster and manage campaigns more effectively.
