Transfer of advertising expenses to SQL databases/Clickhouse

Updated November 16, 2022

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:

— Yandex.Direct
— VK
— Google Ads
— MyTarget
— Facebook Ads
— Yandex.Market

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.

Deployment instructions
  1. Register in zoomkit.ru
  2. Save the Zoomkit API Key
  3. Launch the application “‘Unloading advertising expenses""
  4. Generate or specify an ssh key from the instructions
  5. Visit the application server by its public IP
  6. Follow the instructions

Detailed description

Billing type
Hourly (Pay as you go)
Type
Virtual Machine
Category
Analytics
Connectors
Publisher
Artwist
Use cases
  1. Preparation of automatic PnL reporting
  2. Operational control of advertising expenses on a variety of channels
  3. Development of an automatic marketing reporting system
Technical support
Product IDs
image_id:
fd8ho46o3j50e4lasvvg
family_id:
artwist-expenses
Product composition
SoftwareVersion
Nginx1.18.0
MariaDb10.5.15
Php8.1.10
Python3.9.2
Terms
By using this product you agree to the Yandex Cloud Marketplace Terms of Service and the terms and conditions of the following software: Zoomkit end user license agreement
Billing type
Hourly (Pay as you go)
Type
Virtual Machine
Category
Analytics
Connectors
Publisher
Artwist