Agency of Internet Rights (AIR) — YouTube partner that helps with video monetization. AIR makes agreements with content creators and takes a fee for management, but in return AIR tracks payouts from YouTube to be on schedule, copyright compliance, et cetera.
We created a management system to interact with clients and automated the payout system.
we had significant and extensive objectives that had to be implemented in the system.
Calculating the profit of the company and its clients
Tracking the tendencies of client channels
The ability to confirm client payments
Monitoring the client base and detailed financial statistics
The system we created works with millions of rows of data, since it stores the statistics on video profit for each day and country. There are hundreds of thousands of videos, which means that the database processes over 100,000,000 of different records monthly. Based on this info, personal payouts are formed, taking into consideration user settings.
The automation system fulfilled its main objective. The time required for payout processing was reduced 5760 times (not joking or boasting) when calculating it for 500 clients. In the past, all data was linked manually by three employees over a period of four working days, a lot of errors occurred due to the human factor, everything was bugged. Now, payout processing only requires one employee and one minute of her time to launch calculations for an unlimited number of clients, be it 500 or 50,000.