VK Ads Source

Renta supports data export from VK Ads to following destinations:

  • Google BigQuery
  • Clickhouse
  • SQL Server
  • Google Spreadsheets
  • Google Analytics

Integration creating in data warehouse (DWH)

  1. Go to integrations catalog;
  2. Select VK Ads;
  3. Add a VK Ads account that has the necessary data;
  4. Choose the added VK Ads account;
  5. Specify the destination you want to import the data into;
  6. Go to the settings screen and set necessary configuration:

Account

Available ad accounts for VK Ads.

Source type

Source type consists of the unique set of parameters and metrics available for uploading to DWH. Each Source Type has its own parameters and metrics collection.

Name Description
ad Reutrns all ads data.
campaign Reutrns all campaigns data.
client Reutrns all clients data.
office Reutrns all offices data.

Parameters

Parameters contains the list of parameters and metrics available for export. Specify the parameters required for uploading.

As a result, Renta will create the table that will contain the selected parameters data. The order of the selected parameters in the Rentas interface will match to the order of the table columns.

Date range type

Choose the inserting period. You can specify any historical time interval.

To select the necessary time, enter the date from which you want to start uploading data in the “From” field, then enter the end date in the “To” field.

If you want the data in the table to be updated daily and supplemented with new days, then enter “Yesterday” in the “To” field.

Detailed instructions for working with a date range.

Integration name

There is an auto generated name for your integration and here you can edit it as much as you like.

Both Cyrillic and Latin are permitted, but not more than 100 symbols.

The integration name is displayed on the Integration List page.

Table name

There is an auto generated name for your table and here you can edit it as much as you like.

Only Latin is permitted, numbers and “_” symbol.

Update time

You can specify any update time that you need. Users choose early morning integration updates most often, for example 5 AM.

In that case your integration will update in period from 5 AM to 6 AM.

Integrations are updating according to the time zone selected in your profile settings.

Overwrite period

Data overwrite period is a retrospective update of data for the selected period.

For instance you choose the overwrite period “Last 7 days” – it means that all data for the last 7 days will be deleted and inserted once again with updated data.

Note: this tab appears only if parameters like Day/Date/Time Period etc have been chosen.

Integration creating in Google Spreadsheets

Take advantage of the free extension available in the Google Workspace Marketplace. In order to do it:

  1. Install the extension Renta Spreadsheets Add-on.
  2. Then go to Google Sheets and in the Tools tab select Renta
  3. Press the Run button.

After that a workspace with integration settings will open in the right sidebar. Detailed instructions for creating an integration are available at this link. Please note that all integrations created in Google Spreadsheets are also available for management in the web version of Renta.

Data Structure

Name Description Type
spent Spent funds FLOAT
impressions Impressions FLOAT
clicks Clicks INTEGER
video_views Video views (for video ads) INTEGER
video_views_half Half-video views (for video ads) FLOAT
video_views_full Full-video views (for video ads) FLOAT
video_clicks_site visits of advertiser's website from the video ad (for video ads) INTEGER
reach Reach STRING
join_rate number of joins to a group, event, subscriptions for a public page or application installation (only if the ad includes a direct link to the respective VK page) STRING
id Ad ID STRING
campaign_id Campaign ID STRING
campaign_name Campaign name STRING
ad_format Ad format STRING
cost_type Cost type STRING
cpc (if cost_type = per clicks) cost of a click, kopecks. FLOAT
cpm (if cost_type = per impressions) cost of 1000 impressions, kopecks. FLOAT
impressions_limit (if any) impressions limit per user. INTEGER
impressions_limited (if any) 1 — not more than 100 impressions per user. INTEGER
ad_platform Ad platforms. STRING
ad_platform_no_wall 1 — «Don't show on communities walls» restriction switched on. INTEGER
all_limit Total ad limit in roubles. 0 — not specified. INTEGER
category1_id Category ID. INTEGER
category2_id Additional category ID INTEGER
status Ad status STRING
ad_name Ad name STRING
approved Ad moderation status STRING
video 1 — Video ad. BIT
disclaimer_medical 1 — 'Attention: Be sure to read contra indications before use' warning is shown. INTEGER
disclaimer_specialist 1 — 'Attention: Consult a specialist before using' warning is shown. INTEGER
disclaimer_supplements 1 — 'Attention: A bioactive nutrient, is not a medicine' warning is shown. INTEGER
goal_type Type of goal. STRING
repeat_video Looping video. BIT
title Headline announcements. STRING
description Description announcements. STRING
link_url Link to advertised object. STRING
link_domain Domain of advertised site. STRING
link_title Title next to button/link. STRING
link_button Ad button id. STRING
preview_link A link by clicking on which you can view the advertisement as it looks on the site. STRING
image_src Url image ads. STRING
image_src_2x Url of double resolution image ads. STRING
icon_src Url of the ad logo. STRING
icon_src_2x Url of double resolution of the ad logo. STRING
wallId Id of wall. STRING
postId Id of post. STRING
link Url of add. STRING
utm_source It's the value of utm parameter that contains the ad URL. STRING
utm_medium It's the value of utm parameter that contains the ad URL. STRING
utm_campaign It's the value of utm parameter that contains the ad URL. STRING
utm_content It's the value of utm parameter that contains the ad URL. STRING
utm_term It's the value of utm parameter that contains the ad URL. STRING
date Date DATE
spent Spent funds FLOAT
impressions Impressions FLOAT
clicks Clicks INTEGER
video_views Video views (for video ads) INTEGER
video_views_half Half-video views (for video ads) FLOAT
video_views_full Full-video views (for video ads) FLOAT
video_clicks_site visits of advertiser's website from the video ad (for video ads) INTEGER
reach Reach STRING
join_rate number of joins to a group, event, subscriptions for a public page or application installation (only if the ad includes a direct link to the respective VK page) STRING
id Ad ID STRING
campaign_id Campaign ID STRING
campaign_name Campaign name STRING
ad_format Ad format STRING
cost_type Cost type STRING
cpc (if cost_type = per clicks) cost of a click, kopecks. FLOAT
cpm (if cost_type = per impressions) cost of 1000 impressions, kopecks. FLOAT
impressions_limit (if any) impressions limit per user. INTEGER
impressions_limited (if any) 1 — not more than 100 impressions per user. INTEGER
ad_platform Ad platforms. STRING
ad_platform_no_wall 1 — «Don't show on communities walls» restriction switched on. INTEGER
all_limit Total ad limit in roubles. 0 — not specified. INTEGER
category1_id Category ID. INTEGER
category2_id Additional category ID INTEGER
status Ad status STRING
ad_name Ad name STRING
approved Ad moderation status STRING
video 1 — Video ad. BIT
disclaimer_medical 1 — 'Attention: Be sure to read contra indications before use' warning is shown. INTEGER
disclaimer_specialist 1 — 'Attention: Consult a specialist before using' warning is shown. INTEGER
disclaimer_supplements 1 — 'Attention: A bioactive nutrient, is not a medicine' warning is shown. INTEGER
goal_type Type of goal. STRING
repeat_video Looping video. BIT
title Headline announcements. STRING
description Description announcements. STRING
link_url Link to advertised object. STRING
link_domain Domain of advertised site. STRING
link_title Title next to button/link. STRING
link_button Ad button id. STRING
preview_link A link by clicking on which you can view the advertisement as it looks on the site. STRING
image_src Url image ads. STRING
image_src_2x Url of double resolution image ads. STRING
icon_src Url of the ad logo. STRING
icon_src_2x Url of double resolution of the ad logo. STRING
wallId Id of wall. STRING
postId Id of post. STRING
link Url of add. STRING
utm_source It's the value of utm parameter that contains the ad URL. STRING
utm_medium It's the value of utm parameter that contains the ad URL. STRING
utm_campaign It's the value of utm parameter that contains the ad URL. STRING
utm_content It's the value of utm parameter that contains the ad URL. STRING
utm_term It's the value of utm parameter that contains the ad URL. STRING
month Month STRING
spent Spent funds FLOAT
impressions Impressions FLOAT
clicks Clicks INTEGER
video_views Video views (for video ads) INTEGER
video_views_half Half-video views (for video ads) FLOAT
video_views_full Full-video views (for video ads) FLOAT
video_clicks_site visits of advertiser's website from the video ad (for video ads) INTEGER
join_rate number of joins to a group, event, subscriptions for a public page or application installation (only if the ad includes a direct link to the respective VK page) STRING
day_from Start of the period of time. STRING
day_to End of the period of time. STRING
id Ad ID STRING
campaign_id Campaign ID STRING
campaign_name Campaign name STRING
ad_format Ad format STRING
cost_type Cost type STRING
cpc (if cost_type = per clicks) cost of a click, kopecks. FLOAT
cpm (if cost_type = per impressions) cost of 1000 impressions, kopecks. FLOAT
impressions_limit (if any) impressions limit per user. INTEGER
impressions_limited (if any) 1 — not more than 100 impressions per user. INTEGER
ad_platform Ad platforms. STRING
ad_platform_no_wall 1 — «Don't show on communities walls» restriction switched on. INTEGER
all_limit Total ad limit in roubles. 0 — not specified. INTEGER
category1_id Category ID. INTEGER
category2_id Additional category ID INTEGER
status Ad status STRING
ad_name Ad name STRING
approved Ad moderation status STRING
video 1 — Video ad. BIT
disclaimer_medical 1 — 'Attention: Be sure to read contra indications before use' warning is shown. INTEGER
disclaimer_specialist 1 — 'Attention: Consult a specialist before using' warning is shown. INTEGER
disclaimer_supplements 1 — 'Attention: A bioactive nutrient, is not a medicine' warning is shown. INTEGER
goal_type Type of goal. STRING
repeat_video Looping video. BIT
title Headline announcements. STRING
description Description announcements. STRING
link_url Link to advertised object. STRING
link_domain Domain of advertised site. STRING
link_title Title next to button/link. STRING
link_button Ad button id. STRING
preview_link A link by clicking on which you can view the advertisement as it looks on the site. STRING
image_src Url image ads. STRING
image_src_2x Url of double resolution image ads. STRING
icon_src Url of the ad logo. STRING
icon_src_2x Url of double resolution of the ad logo. STRING
wallId Id of wall. STRING
postId Id of post. STRING
link Url of add. STRING
utm_source It's the value of utm parameter that contains the ad URL. STRING
utm_medium It's the value of utm parameter that contains the ad URL. STRING
utm_campaign It's the value of utm parameter that contains the ad URL. STRING
utm_content It's the value of utm parameter that contains the ad URL. STRING
utm_term It's the value of utm parameter that contains the ad URL. STRING
spent Spent funds FLOAT
impressions Impressions FLOAT
clicks Clicks INTEGER
reach Reach STRING
join_rate number of joins to a group, event, subscriptions for a public page or application installation (only if the ad includes a direct link to the respective VK page) STRING
id Campaign ID INTEGER
name Campaign name STRING
status Campaign status (0 — campaign stopped, 1 — campaign started, 2 — campaign deleted) STRING
day_limit Campaign day limit, rubles (0 — no limit set) STRING
all_limit Campaign total limit, rubles (0 — no limit set) STRING
start_time Campaign start time, as unixtime (0 — time not set) STRING
stop_time campaign stop time, as unixtime (0 — time not set) STRING
date Date DATE
spent Spent funds FLOAT
impressions Impressions FLOAT
clicks Clicks INTEGER
reach Reach STRING
join_rate number of joins to a group, event, subscriptions for a public page or application installation (only if the ad includes a direct link to the respective VK page) STRING
id Campaign ID INTEGER
name Campaign name STRING
status Campaign status (0 — campaign stopped, 1 — campaign started, 2 — campaign deleted) STRING
day_limit Campaign day limit, rubles (0 — no limit set) STRING
all_limit Campaign total limit, rubles (0 — no limit set) STRING
start_time Campaign start time, as unixtime (0 — time not set) STRING
stop_time campaign stop time, as unixtime (0 — time not set) STRING
month Month STRING
spent Spent funds FLOAT
impressions Impressions FLOAT
clicks Clicks INTEGER
join_rate number of joins to a group, event, subscriptions for a public page or application installation (only if the ad includes a direct link to the respective VK page) STRING
day_from Start of the period of time. STRING
day_to End of the period of time. STRING
id Campaign ID INTEGER
name Campaign name STRING
status Campaign status (0 — campaign stopped, 1 — campaign started, 2 — campaign deleted) STRING
day_limit Campaign day limit, rubles (0 — no limit set) STRING
all_limit Campaign total limit, rubles (0 — no limit set) STRING
start_time Campaign start time, as unixtime (0 — time not set) STRING
stop_time campaign stop time, as unixtime (0 — time not set) STRING
spent Spent funds FLOAT
impressions Impressions FLOAT
clicks Clicks INTEGER
id Client ID STRING
name Client's name STRING
day_limit Client's day limit, rubles. STRING
all_limit Client's total limit, rubles. STRING
date Date DATE
spent Spent funds FLOAT
impressions Impressions FLOAT
clicks Clicks INTEGER
id Client ID STRING
name Client's name STRING
day_limit Client's day limit, rubles. STRING
all_limit Client's total limit, rubles. STRING
month Month STRING
spent Spent funds FLOAT
impressions Impressions FLOAT
clicks Clicks INTEGER
day_from Start of the period of time. STRING
day_to End of the period of time. STRING
id Client ID STRING
name Client's name STRING
day_limit Client's day limit, rubles. STRING
all_limit Client's total limit, rubles. STRING
spent Spent funds FLOAT
impressions Impressions FLOAT
clicks Clicks INTEGER
account_id Account ID INTEGER
account_type Account type STRING
account_status Account status STRING
account_name Account name STRING
access_role Access role STRING
date Date DATE
spent Spent funds FLOAT
impressions Impressions FLOAT
clicks Clicks INTEGER
account_id Account ID INTEGER
account_type Account type STRING
account_status Account status STRING
account_name Account name STRING
access_role Access role STRING
month Month STRING
spent Spent funds FLOAT
impressions Impressions FLOAT
clicks Clicks INTEGER
day_from End of the period of time. STRING
day_to End of the period of time. STRING
account_id Account ID INTEGER
account_type Account type STRING
account_status Account status STRING
account_name Account name STRING
access_role Access role STRING

_______________________________________________
If you have any questions – please contact us!