We have developed a solution that allows you to collect expenses from multiple advertising cabinets in one database: MySQL, Clickhouse, PostgreSQL. You can upload data to your database, or create a local one directly from under our solution.
The solution allows (1) to make a one-time import for the date range selected by the user, and (2) automatically starts automatic import of fresh data (for the last 2 days)
Currently, the system supports the following advertising systems:
— Yandex.Direct (without support for trading campaigns, — now 01.09.2022 the Yandex.Direct API is not supported)
— Yandex.Market
— Vkontakte
— My.Target
— Google Ads
Since a flexible solution requires obtaining application keys, we use a proxy application zoomkit.ru to import expenses. The operability of the entire system is possible only through authorization in zoomkit.ru and receiving tokens in the relevant advertising channels.
<aside> 💡 Using Zoomkit to solve this problem is completely free, despite other interface instructions. If you are only going to import expenses using a virtual machine in Yandex.Cloud — DO NOT top up the service account, no matter what notifications are received.
</aside>
<aside> 👉 To use the Zoomkit for free, you must create a service account in Yandex.Cloud. The service account must be granted compute.viewer rights.
</aside>
We have developed this integration in order to exclude mutual settlements between customers of the service and Zoomkit and work entirely through Yandex.
<aside> ❗ Be sure to confirm the email address in the Zoomkit, since tokens are not issued forever and you should receive notifications that the token needs to be renewed.
</aside>
The entire connection according to this instruction takes about 30 minutes. This is a one-time investment of time, then everything will happen automatically.
After registering in the system zoomikit.ru and to confirm the email address, you need to connect advertising systems to the service.
The principle of connecting advertising systems is identical for each of them.