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.

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.