Budget: 27000 UAH Deadline: 14 days
Good day.
I propose to build the architecture on the combination of PostgreSQL as a single storage and Apache Superset or Metabase as the BI interface. Writing a custom frontend with charts and a role model for this task is not cost-effective; it will inflate the budget and timelines. Ready-made BI systems already have RLS (Row-Level Security) settings, which will allow limiting data visibility: a manager will see only their metrics, while the head of sales will see the entire team.
I will implement data collection (ETL) through a microservice in Python with FastAPI. It will listen to webhooks from Kommo CRM for instant recording of transitions through the funnel stages, as well as periodically retrieve expenses from Meta Ads and payment statuses from Stripe.
The logic for early warning of dips, calculation of moving averages, and identification of stalled deals will be laid out at the database level through SQL views. They will automatically recalculate the median deal cycle and historical conversion.
For working with AI and alerts, I will write a separate Telegram bot based on LangChain and OpenAI API. The bot will use Text-to-SQL: translating managers' questions in natural language into SQL queries to the database and returning ready figures. It will also push notifications about overdue payments and performance drops below plan.
Regarding the budget and resources. The stated 26,999 UAH covers only the first and second stages (database setup, ETL scripts from three sources, and a basic dashboard). The full implementation of all 5 stages with predictive analytics and neural networks will cost several times more. Monthly infrastructure expenses will be around 20 euros for a VPS on Hetzner and approximately 10-15 dollars for OpenAI tokens.
How do you plan to pass UTM tags and ClientID from organic traffic into the Kommo card so that we can link sessions from Google Analytics to specific payments in Stripe?