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.

NameDescription
adReutrns all ads data.
campaignReutrns all campaigns data.
clientReutrns all clients data.
officeReutrns 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

NameDescriptionType
spentSpent fundsFLOAT
impressionsImpressionsFLOAT
clicksClicksINTEGER
video_viewsVideo views (for video ads)INTEGER
video_views_halfHalf-video views (for video ads)FLOAT
video_views_fullFull-video views (for video ads)FLOAT
video_clicks_sitevisits of advertiser's website from the video ad (for video ads)INTEGER
reachReachSTRING
join_ratenumber 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
idAd IDSTRING
campaign_idCampaign IDSTRING
campaign_nameCampaign nameSTRING
ad_formatAd formatSTRING
cost_typeCost typeSTRING
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_platformAd platforms.STRING
ad_platform_no_wall1 — «Don't show on communities walls» restriction switched on.INTEGER
all_limitTotal ad limit in roubles. 0 — not specified.INTEGER
category1_idCategory ID.INTEGER
category2_idAdditional category IDINTEGER
statusAd statusSTRING
ad_nameAd nameSTRING
approvedAd moderation statusSTRING
video1 — Video ad.BIT
disclaimer_medical1 — 'Attention: Be sure to read contra indications before use' warning is shown.INTEGER
disclaimer_specialist1 — 'Attention: Consult a specialist before using' warning is shown.INTEGER
disclaimer_supplements1 — 'Attention: A bioactive nutrient, is not a medicine' warning is shown.INTEGER
goal_typeType of goal.STRING
repeat_videoLooping video.BIT
titleHeadline announcements.STRING
descriptionDescription announcements.STRING
link_urlLink to advertised object.STRING
link_domainDomain of advertised site.STRING
link_titleTitle next to button/link.STRING
link_buttonAd button id.STRING
preview_linkA link by clicking on which you can view the advertisement as it looks on the site.STRING
image_srcUrl image ads.STRING
image_src_2xUrl of double resolution image ads.STRING
icon_srcUrl of the ad logo.STRING
icon_src_2xUrl of double resolution of the ad logo.STRING
wallIdId of wall.STRING
postIdId of post.STRING
linkUrl of add.STRING
utm_sourceIt's the value of utm parameter that contains the ad URL.STRING
utm_mediumIt's the value of utm parameter that contains the ad URL.STRING
utm_campaignIt's the value of utm parameter that contains the ad URL.STRING
utm_contentIt's the value of utm parameter that contains the ad URL.STRING
utm_termIt's the value of utm parameter that contains the ad URL.STRING
dateDateDATE
spentSpent fundsFLOAT
impressionsImpressionsFLOAT
clicksClicksINTEGER
video_viewsVideo views (for video ads)INTEGER
video_views_halfHalf-video views (for video ads)FLOAT
video_views_fullFull-video views (for video ads)FLOAT
video_clicks_sitevisits of advertiser's website from the video ad (for video ads)INTEGER
reachReachSTRING
join_ratenumber 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
idAd IDSTRING
campaign_idCampaign IDSTRING
campaign_nameCampaign nameSTRING
ad_formatAd formatSTRING
cost_typeCost typeSTRING
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_platformAd platforms.STRING
ad_platform_no_wall1 — «Don't show on communities walls» restriction switched on.INTEGER
all_limitTotal ad limit in roubles. 0 — not specified.INTEGER
category1_idCategory ID.INTEGER
category2_idAdditional category IDINTEGER
statusAd statusSTRING
ad_nameAd nameSTRING
approvedAd moderation statusSTRING
video1 — Video ad.BIT
disclaimer_medical1 — 'Attention: Be sure to read contra indications before use' warning is shown.INTEGER
disclaimer_specialist1 — 'Attention: Consult a specialist before using' warning is shown.INTEGER
disclaimer_supplements1 — 'Attention: A bioactive nutrient, is not a medicine' warning is shown.INTEGER
goal_typeType of goal.STRING
repeat_videoLooping video.BIT
titleHeadline announcements.STRING
descriptionDescription announcements.STRING
link_urlLink to advertised object.STRING
link_domainDomain of advertised site.STRING
link_titleTitle next to button/link.STRING
link_buttonAd button id.STRING
preview_linkA link by clicking on which you can view the advertisement as it looks on the site.STRING
image_srcUrl image ads.STRING
image_src_2xUrl of double resolution image ads.STRING
icon_srcUrl of the ad logo.STRING
icon_src_2xUrl of double resolution of the ad logo.STRING
wallIdId of wall.STRING
postIdId of post.STRING
linkUrl of add.STRING
utm_sourceIt's the value of utm parameter that contains the ad URL.STRING
utm_mediumIt's the value of utm parameter that contains the ad URL.STRING
utm_campaignIt's the value of utm parameter that contains the ad URL.STRING
utm_contentIt's the value of utm parameter that contains the ad URL.STRING
utm_termIt's the value of utm parameter that contains the ad URL.STRING
monthMonthSTRING
spentSpent fundsFLOAT
impressionsImpressionsFLOAT
clicksClicksINTEGER
video_viewsVideo views (for video ads)INTEGER
video_views_halfHalf-video views (for video ads)FLOAT
video_views_fullFull-video views (for video ads)FLOAT
video_clicks_sitevisits of advertiser's website from the video ad (for video ads)INTEGER
join_ratenumber 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_fromStart of the period of time.STRING
day_toEnd of the period of time.STRING
idAd IDSTRING
campaign_idCampaign IDSTRING
campaign_nameCampaign nameSTRING
ad_formatAd formatSTRING
cost_typeCost typeSTRING
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_platformAd platforms.STRING
ad_platform_no_wall1 — «Don't show on communities walls» restriction switched on.INTEGER
all_limitTotal ad limit in roubles. 0 — not specified.INTEGER
category1_idCategory ID.INTEGER
category2_idAdditional category IDINTEGER
statusAd statusSTRING
ad_nameAd nameSTRING
approvedAd moderation statusSTRING
video1 — Video ad.BIT
disclaimer_medical1 — 'Attention: Be sure to read contra indications before use' warning is shown.INTEGER
disclaimer_specialist1 — 'Attention: Consult a specialist before using' warning is shown.INTEGER
disclaimer_supplements1 — 'Attention: A bioactive nutrient, is not a medicine' warning is shown.INTEGER
goal_typeType of goal.STRING
repeat_videoLooping video.BIT
titleHeadline announcements.STRING
descriptionDescription announcements.STRING
link_urlLink to advertised object.STRING
link_domainDomain of advertised site.STRING
link_titleTitle next to button/link.STRING
link_buttonAd button id.STRING
preview_linkA link by clicking on which you can view the advertisement as it looks on the site.STRING
image_srcUrl image ads.STRING
image_src_2xUrl of double resolution image ads.STRING
icon_srcUrl of the ad logo.STRING
icon_src_2xUrl of double resolution of the ad logo.STRING
wallIdId of wall.STRING
postIdId of post.STRING
linkUrl of add.STRING
utm_sourceIt's the value of utm parameter that contains the ad URL.STRING
utm_mediumIt's the value of utm parameter that contains the ad URL.STRING
utm_campaignIt's the value of utm parameter that contains the ad URL.STRING
utm_contentIt's the value of utm parameter that contains the ad URL.STRING
utm_termIt's the value of utm parameter that contains the ad URL.STRING
spentSpent fundsFLOAT
impressionsImpressionsFLOAT
clicksClicksINTEGER
reachReachSTRING
join_ratenumber 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
idCampaign IDINTEGER
nameCampaign nameSTRING
statusCampaign status (0 — campaign stopped, 1 — campaign started, 2 — campaign deleted)STRING
day_limitCampaign day limit, rubles (0 — no limit set)STRING
all_limitCampaign total limit, rubles (0 — no limit set)STRING
start_timeCampaign start time, as unixtime (0 — time not set)STRING
stop_timecampaign stop time, as unixtime (0 — time not set)STRING
dateDateDATE
spentSpent fundsFLOAT
impressionsImpressionsFLOAT
clicksClicksINTEGER
reachReachSTRING
join_ratenumber 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
idCampaign IDINTEGER
nameCampaign nameSTRING
statusCampaign status (0 — campaign stopped, 1 — campaign started, 2 — campaign deleted)STRING
day_limitCampaign day limit, rubles (0 — no limit set)STRING
all_limitCampaign total limit, rubles (0 — no limit set)STRING
start_timeCampaign start time, as unixtime (0 — time not set)STRING
stop_timecampaign stop time, as unixtime (0 — time not set)STRING
monthMonthSTRING
spentSpent fundsFLOAT
impressionsImpressionsFLOAT
clicksClicksINTEGER
join_ratenumber 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_fromStart of the period of time.STRING
day_toEnd of the period of time.STRING
idCampaign IDINTEGER
nameCampaign nameSTRING
statusCampaign status (0 — campaign stopped, 1 — campaign started, 2 — campaign deleted)STRING
day_limitCampaign day limit, rubles (0 — no limit set)STRING
all_limitCampaign total limit, rubles (0 — no limit set)STRING
start_timeCampaign start time, as unixtime (0 — time not set)STRING
stop_timecampaign stop time, as unixtime (0 — time not set)STRING
spentSpent fundsFLOAT
impressionsImpressionsFLOAT
clicksClicksINTEGER
idClient IDSTRING
nameClient's nameSTRING
day_limitClient's day limit, rubles.STRING
all_limitClient's total limit, rubles.STRING
dateDateDATE
spentSpent fundsFLOAT
impressionsImpressionsFLOAT
clicksClicksINTEGER
idClient IDSTRING
nameClient's nameSTRING
day_limitClient's day limit, rubles.STRING
all_limitClient's total limit, rubles.STRING
monthMonthSTRING
spentSpent fundsFLOAT
impressionsImpressionsFLOAT
clicksClicksINTEGER
day_fromStart of the period of time.STRING
day_toEnd of the period of time.STRING
idClient IDSTRING
nameClient's nameSTRING
day_limitClient's day limit, rubles.STRING
all_limitClient's total limit, rubles.STRING
spentSpent fundsFLOAT
impressionsImpressionsFLOAT
clicksClicksINTEGER
account_idAccount IDINTEGER
account_typeAccount typeSTRING
account_statusAccount statusSTRING
account_nameAccount nameSTRING
access_roleAccess roleSTRING
dateDateDATE
spentSpent fundsFLOAT
impressionsImpressionsFLOAT
clicksClicksINTEGER
account_idAccount IDINTEGER
account_typeAccount typeSTRING
account_statusAccount statusSTRING
account_nameAccount nameSTRING
access_roleAccess roleSTRING
monthMonthSTRING
spentSpent fundsFLOAT
impressionsImpressionsFLOAT
clicksClicksINTEGER
day_fromEnd of the period of time.STRING
day_toEnd of the period of time.STRING
account_idAccount IDINTEGER
account_typeAccount typeSTRING
account_statusAccount statusSTRING
account_nameAccount nameSTRING
access_roleAccess roleSTRING

_______________________________________________
If you have any questions – please contact us!