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)
- Go to integrations catalog;
- Select VK Ads;
- Add a VK Ads account that has the necessary data;
- Choose the added VK Ads account;
- Specify the destination you want to import the data into;
- 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:
- Install the extension Renta Spreadsheets Add-on.
- Then go to Google Sheets and in the Tools tab select Renta
- 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!