Finish CRM module

Bayer - statistics on invite links

Handler - statistics by channels

1. Add 3 types of users (team leader for handlers, team leader for bayers, financial analyst)

2. Statistics page for the handler (layout, functionality, filter).

Data: deposit, joined, written, cash, username, Telegram ID (chat ID when chat is implemented), type (deposit, commissions 1-2)

3. Statistics page for team leaders of bayers, financial analysts, and team leaders of handlers by channels

The Bayer team leader sees this table on a new page. This is general statistics by channels (as one channel can have several bayers and the report indicates information specifically by bayer separately, here statistics are indicated for each project as a whole).

Not only the Bayer team leader sees this table, but also the handler team leader

Filters: project selection (channel name), you can also view the total, the total is information for all projects, on the right you can select a date, at the bottom you can make a selection of different commissions and deposits to see detailed results for individual indicators, also forgot to add a button with a dropdown menu in the mockup, where you can select cash

Information from this table will be pulled into the table for financial analysts

4. Statistics page for the Bayer team leader (statistics of all bayers through a filter)

Results are automatically pulled at 12, 15, 18, 21, and 24 hours

the "spend" cell is filled in manually by the bayer

for understanding, spend is the amount spent on advertising from 00:00 of the current day

the avg. pdp cell records the result of dividing the number of subscribers by the spend amount specified by the bayer

similarly with dialogues and deposits

For example, we have 30 subscribers, 15 dialogues, and 5 deposits for a $50 spend

the bayer records $50 in the spend column, automatically records 1.7 (rounding to 1.666) in the avg. pdp cell, records 3.3 in the avg. dialogue cell, and records 10 in the avg. deposit cell

you can also choose the number of days to view statistics

for reference - at 15:00, information about subscribers is recorded not from 12:00 but from 00:00 of the current day, and naturally at 18, 21, and 24 also from 00:00, not for separate time intervals

In addition to all the above, where the bayer selection is, a "total" button needs to be added on the page to record the spend of all bayers, collect the total number of subscribers, dialogues, and deposits, and calculate the average price for all bayers' spend

5. Statistics page for financial analysts

from the income amount from the tables of team leaders and financial analysts for the selected period on the calendar, the amount of expenses added by the financial analyst for the same selected period is subtracted on the right, and the result is obtained, naturally, for the same period

6. Statistics page for bayers (same as for the Bayer team leader, only without the average deposit column and they cannot select which bayer's report they will view at the top, they only have information available for their accessible links)