📜 ⬆️ ⬇️

How much does Habr + earn how to find out how much other companies earn

Background: after last year we had closed the company with the team and had not yet begun work on a new one, we decided to update our old, but rather large, site with recipes. To understand how seriously it is to go into the work on it, I analyzed the data on the revenue of sites that also earn from advertising.

This year has already released new data, which also decided to share. Revenues, expenses and profits are given in millions of rubles.

image

Full version of the table in Google Docs
')
image

Why count other people's money


Benchmarking (from the English. Benchmarking), - benchmarking. Comparative analysis based on benchmarks is the process of identifying, understanding and adapting existing examples of the effective functioning of a company in order to improve its own work.

https://ru.wikipedia.org/wiki/Benchmarking

Benchmarking helps to highlight those who grow best on the chosen KPI, to understand why they grow faster and to adopt their methods. Thanks to benchmarking in terms of revenue and traffic, we were able to quite successfully select priority tasks and, with limited resources, grow on traffic like this:

image
That's the income:

image

Where to get data for your research


All data are public, obtained from official sources. Last year I used gks.ru/accounting_report . But this year they have not yet posted new data (perhaps available in the API or on request). Therefore, I used open data sets from the Federal Tax Service Inspectorate, which were published quite recently:

www.nalog.ru/opendata/7707329152-revexp
www.nalog.ru/opendata/7707329152-sshr

After merging xml files and converting to SQL, it was enough to write one SQL query with last year's INN list in order to quickly get the latest data.

Thanks to the use of IFTS data, information on the average number of employees of each company for the year has become available. But the Federal Tax Service gives only dry figures of income and expenditure, without detailed data on financial statements, like the State Statistics Committee. I noticed that the data often differ from the data in counterparty check services. If you need more accurate data, it is better to wait for the release from the State Statistics Committee.

The IFSN has a set of www.nalog.ru/opendata/7707329152-paytax , with the help of which you can indirectly estimate the size of the payroll fund and the average salary per organization.

This year I did not parse the data on their attendance for all sites and count ecpm, since it takes a lot of time, and the indicator is very specific, depends on many factors. I counted it only for a few sites that interested me.

How to determine the TIN of the site


To find information on a company, you first need to know its TIN or the exact name of the legal entity. I found almost all the correspondences of legal entities and websites last year (see the previous publication , plus there I described possible options for which the data may be inaccurate / incorrect).

The most effective options for finding a legal entity on the site:


I welcome the initiative of the Federal Tax Service to open data, transparency reduces corruption and increases competition, from which the economy grows faster. I urge habrovchan too to use open data. I'm not sure that you can publicly fumble the SQL file resulting from the merge and converting the xml files, write to the PM, I’ll give you an individual link on Yandex Disk.

If someone knows how to get similar data from private companies in other countries - write in the comments! I heard that in Cyprus the financial statements are also public, but I found only the opportunity to make a request through an intermediary for 20 euros.

Source: https://habr.com/ru/post/427495/


All Articles