Tools
Exporting sources and counting subscribers in a spreadsheet.
Two tools for working with spreadsheets: export all project sources with their statistics, and fill in subscriber counts in someone else's spreadsheet of links. Both work with XLSX files, which open in Excel, Google Sheets and MyOffice.
Open Tools («Инструменты»).
#Exporting sources
Saves all channels and communities of the current project (Telegram, VK and MAX) with their statistics to a spreadsheet. Click "Generate file" («Сгенерировать файл»), and the download starts in a few seconds.
| Column | What it contains |
|---|---|
| Link | Address of the channel or community |
| Name | The channel's current name |
| Type | Platform |
| Active | Whether the source is being read |
| Subscribers | The latest measured value |
| Views 24h | Total post views over the last day |
| Views 30d | The same over 30 days |
| Last post | When the channel last posted |
| Added | When the source was added to the project |
| Region | The source's region, if known |
Column headers in the file are in Russian; the table above gives their meaning in the same order.
The export is the fastest way to find dead sources: sort by "Last post", and the channels that went quiet long ago come to the top. Their share of the limit is better given to active ones.
#Enriching a spreadsheet
Sometimes a list of channels or posts comes from colleagues or a client as a spreadsheet of links with no figures. This tool fills in the figures for you.
- Drag an XLSX file into the upload area or choose a file.
- The system finds links to Telegram, VK, MAX, OK and Rutube channels and posts in the cells.
- For a channel link it adds the subscriber count from the TeleMax Catalog; for a post link, the number of views.
- It returns the file with the prefix «Обогащенный_» ("Enriched_") in its name.
What it can do:
- New columns. Figures are written at the end of the sheet, in columns "…: subscribers" and "…: views". The tool does not touch your cells.
- Several links in one cell. All of them are found, and the figure is their sum.
- Breakdown. A note is added to the cell with the figure: how much each link gave, or, if there is no figure, why.
- New channels. Channels that are not yet in the Catalog are queued for connection. Figures for them appear later: upload the file again in a day or two.
What it does not cover: views of OK posts (the platform does not show them), VK stories, YouTube, Dzen and Instagram. Telegram views above a thousand are rounded the same way as in Telegram itself.
The tool card shows how many posts and channels you can check: post views are counted per day, and channels outside your sources come from your plan's quota. Channels from the project's sources and repeat checks of the same post do not use the limit. A file can be up to 5 MB, one at a time.