Transfer of advertising expenses to SQL databases/Clickhouse
The application allows you to get data on advertising expenses and upload them to your own MySQL, PostgreSQL, ClickHouse databases.
The application is able to work with the following advertising systems:
— Google Ads
— Facebook Ads
The application supports both manual unloading mode for an arbitrary period of time, and regular unloading of expenses every 2 hours.
Since for the application to work, it is required to receive keys separately for each advertising system, we invented Zoomkit — this is a service that has already received all access keys and in order to receive data on expenses, you need to get only one authorization key.
We write in detail about the setup in the instructions.
- Register in zoomkit.ru
- Save the Zoomkit API Key
- Launch the application “‘Unloading advertising expenses""
- Generate or specify an ssh key from the instructions
- Visit the application server by its public IP
- Follow the instructions
- Preparation of automatic PnL reporting
- Operational control of advertising expenses on a variety of channels
- Development of an automatic marketing reporting system