Renta supports data export from MyTarget to following destinations:
- Google BigQuery
- Clickhouse
- SQL Server
- Google Spreadsheets
- Google Analytics
Integration creating in data warehouse (DWH)
- Go to integrations catalog;
- Select MyTarget;
- Add a MyTarget account that has the necessary data;
- Choose the added MyTarget account;
- Specify the destination you want to import the data into;
- Go to the settings screen and set necessary configuration:
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 |
---|---|
banners | Ads that were created and filled in one or more format variants in your ad account. |
campaigns | The highest level organizational structure within an ad account and contains different banners from your personal cabinet. |
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 |
---|---|---|
base-shows | the number of impressions | STRING |
base-clicks | the number of clicks | STRING |
base-goals | the number of achievement goals (Top@Mail.ru goals for sites and installations for mobile applications) | STRING |
base-spent | write-offs | STRING |
base-cpm | average write-off for 1000 views | STRING |
base-cpc | average write-off for 1 click | STRING |
base-cpa | average write-off for achieving 1 goal | STRING |
base-ctr | the percentage of clicks to the number of views | STRING |
base-cr | the percentage of the number of goal achievements to the number of clicks | STRING |
events-opening_app | the number of openings of the advertised social networks application | STRING |
events-opening_post | the number of openings of the advertised message in the social network | STRING |
events-moving_into_group | the number of transitions to the group page from the advertised message | STRING |
events-clicks_on_external_url | the number of clicks on the external link in the advertised message | STRING |
events-launching_video | the number of video starts in the advertised message | STRING |
events-comments | the number of comments left in the advertised message | STRING |
events-joinings | the number of connections to the group through the advertised message | STRING |
events-likes | the number of likes of the advertised message | STRING |
events-shares | the number of actions 'Share' for the advertised message | STRING |
events-votings | the number of voting actions in the advertised message | STRING |
uniques-reach | the number of unique users who saw the ad for the specified period | STRING |
uniques-total | the total number of unique users who saw the ad all the time | STRING |
uniques-increment | the number of new unique users who saw the ad for the specified period | STRING |
uniques-frequency | the average frequency of showing ads to one unique user | STRING |
video-started | the number of starts of video playback | STRING |
video-paused | the number of pauses of video playback | STRING |
video-resumed_after_pause | the amount of video playback after a pause | STRING |
video-fullscreen_on | the number of full-screen video playback | STRING |
video-fullscreen_off | the number of off-screen full-screen video playback | STRING |
video-sound_turned_off | the number of video sound mutes | STRING |
video-sound_turned_on | the number of video sound clips | STRING |
video-viewed_10_seconds | the number of views of the first 10 seconds of the video | STRING |
video-viewed_25_percent | the number of views of the first 25% of the duration of the video | STRING |
video-viewed_50_percent | the number of views of the first 50% of the duration of the video | STRING |
video-viewed_75_percent | the number of views of the first 75% of the duration of the video | STRING |
video-viewed_100_percent | the number of views 100% of the duration of the video | STRING |
video-viewed_10_seconds_rate | the percentage of views with the first 10 seconds of video reached | STRING |
video-viewed_25_percent_rate | the percentage of views with the first 25% of the duration of the video | STRING |
video-viewed_50_percent_rate | the percentage of views with the achievement of the first 50% of the duration of the video | STRING |
video-viewed_75_percent_rate | the percentage of views with the achievement of the first 75% of the duration of the video | STRING |
video-viewed_100_percent_rate | the percentage of views with the achievement of 100% of the duration of the video | STRING |
video-depth_of_view | average depth of video viewing (in percent) | STRING |
video-view_10_seconds_cost | the average cost of viewing the first 10 seconds of the video | STRING |
video-viewed_25_percent_cost | the average cost of viewing the first 25% of the duration of the video | STRING |
video-viewed_50_percent_cost | the average cost of viewing the first 50% of the duration of the video | STRING |
video-viewed_75_percent_cost | the average cost of viewing the first 75% of the duration of the video | STRING |
video-viewed_100_percent_cost | the average cost of viewing 100% of the duration of the video | STRING |
viral-impressions | the number of impressions of a shared advertisement in social networks | STRING |
viral-reach | the number of unique users who saw a shared advertising message for the specified period | STRING |
viral-total | the total number of unique users who saw a shared advertising message for all time | STRING |
viral-increment | the number of new unique users who saw a shared advertising message for the specified period | STRING |
viral-frequency | the average frequency of displaying a shared advertisement to one unique user | STRING |
viral-opening_app | the number of openings of the advertised application from the shared advertising message | STRING |
viral-opening_post | the number of open advertisements in the social network | STRING |
viral-moving_into_group | the number of transitions to the group page from the shared advertisement | STRING |
viral-clicks_on_external_url | the number of clicks on an external link in a publicized advertised message | STRING |
viral-comments | the number of comments left in the public message advertised | STRING |
viral-joinings | the number of connections to a group through a publicized advertised message | STRING |
viral-likes | the number of likes of the advertised message | STRING |
viral-shares | the number of actions to 'Share' for the advertised message | STRING |
viral-votings | the number of voting actions in a publicized advertised message | STRING |
tps-tps | additional charges for using the moat service | STRING |
tps-tpd | additional write-offs for the use of third-party data (from dmp) | STRING |
moat-impressions | the number of impressions | STRING |
moat-in_view | the number of visible impressions | STRING |
moat-never_focused | the number of impressions in the inactive tab | STRING |
moat-never_visible | the number of impressions out of scope | STRING |
moat-never_50_perc_visible | the number of impressions with an ad zone less than 50% | STRING |
moat-never_1_sec_visible | the number of impressions with visibility less than 1 second | STRING |
moat-human_impressions | the number of verified impressions | STRING |
moat-impressions_analyzed | the number of impressions analyzed | STRING |
moat-in_view_percent | the percentage of visible impressions | STRING |
moat-human_and_viewable_perc | percentage of verified impressions | STRING |
moat-never_focused_percent | the percentage of impressions in the inactive tab | STRING |
moat-never_visible_percent | the percentage of impressions out of scope | STRING |
moat-never_50_perc_visible_percent | the percentage of cases with an ad visibility area of less than 50% | STRING |
moat-never_1_sec_visible_percent | percentage of impressions with visibility less than 1 second | STRING |
moat-in_view_diff_percent | the difference in the number of visible impressions | STRING |
moat-active_in_view_time | the average time that the ad is visible in the visibility zone | STRING |
moat-attention_quality | the level of waxing | STRING |
Href | Identifies sections within a document | 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 |
id | id | INTEGER |
campaign_id | campaign_id | INTEGER |
call_to_action | call_to_action | STRING |
created | created | DATE |
delivery | delivery | STRING |
moderation_status | moderation_status | STRING |
status | status | STRING |
updated | updated | DATE |
user_can_request_remoderation | user_can_request_remoderation | BIT |
date | Date | DATE |
base-shows | the number of impressions | STRING |
base-clicks | the number of clicks | STRING |
base-goals | the number of achievement goals (Top@Mail.ru goals for sites and installations for mobile applications) | STRING |
base-spent | write-offs | STRING |
base-cpm | average write-off for 1000 views | STRING |
base-cpc | average write-off for 1 click | STRING |
base-cpa | average write-off for achieving 1 goal | STRING |
base-ctr | the percentage of clicks to the number of views | STRING |
base-cr | the percentage of the number of goal achievements to the number of clicks | STRING |
events-opening_app | the number of openings of the advertised social networks application | STRING |
events-opening_post | the number of openings of the advertised message in the social network | STRING |
events-moving_into_group | the number of transitions to the group page from the advertised message | STRING |
events-clicks_on_external_url | the number of clicks on the external link in the advertised message | STRING |
events-launching_video | the number of video starts in the advertised message | STRING |
events-comments | the number of comments left in the advertised message | STRING |
events-joinings | the number of connections to the group through the advertised message | STRING |
events-likes | the number of likes of the advertised message | STRING |
events-shares | the number of actions 'Share' for the advertised message | STRING |
events-votings | the number of voting actions in the advertised message | STRING |
uniques-reach | the number of unique users who saw the ad for the specified period | STRING |
uniques-total | the total number of unique users who saw the ad all the time | STRING |
uniques-increment | the number of new unique users who saw the ad for the specified period | STRING |
uniques-frequency | the average frequency of showing ads to one unique user | STRING |
video-started | the number of starts of video playback | STRING |
video-paused | the number of pauses of video playback | STRING |
video-resumed_after_pause | the amount of video playback after a pause | STRING |
video-fullscreen_on | the number of full-screen video playback | STRING |
video-fullscreen_off | the number of off-screen full-screen video playback | STRING |
video-sound_turned_off | the number of video sound mutes | STRING |
video-sound_turned_on | the number of video sound clips | STRING |
video-viewed_10_seconds | the number of views of the first 10 seconds of the video | STRING |
video-viewed_25_percent | the number of views of the first 25% of the duration of the video | STRING |
video-viewed_50_percent | the number of views of the first 50% of the duration of the video | STRING |
video-viewed_75_percent | the number of views of the first 75% of the duration of the video | STRING |
video-viewed_100_percent | the number of views 100% of the duration of the video | STRING |
video-viewed_10_seconds_rate | the percentage of views with the first 10 seconds of video reached | STRING |
video-viewed_25_percent_rate | the percentage of views with the first 25% of the duration of the video | STRING |
video-viewed_50_percent_rate | the percentage of views with the achievement of the first 50% of the duration of the video | STRING |
video-viewed_75_percent_rate | the percentage of views with the achievement of the first 75% of the duration of the video | STRING |
video-viewed_100_percent_rate | the percentage of views with the achievement of 100% of the duration of the video | STRING |
video-depth_of_view | average depth of video viewing (in percent) | STRING |
video-view_10_seconds_cost | the average cost of viewing the first 10 seconds of the video | STRING |
video-viewed_25_percent_cost | the average cost of viewing the first 25% of the duration of the video | STRING |
video-viewed_50_percent_cost | the average cost of viewing the first 50% of the duration of the video | STRING |
video-viewed_75_percent_cost | the average cost of viewing the first 75% of the duration of the video | STRING |
video-viewed_100_percent_cost | the average cost of viewing 100% of the duration of the video | STRING |
viral-impressions | the number of impressions of a shared advertisement in social networks | STRING |
viral-reach | the number of unique users who saw a shared advertising message for the specified period | STRING |
viral-total | the total number of unique users who saw a shared advertising message for all time | STRING |
viral-increment | the number of new unique users who saw a shared advertising message for the specified period | STRING |
viral-frequency | the average frequency of displaying a shared advertisement to one unique user | STRING |
viral-opening_app | the number of openings of the advertised application from the shared advertising message | STRING |
viral-opening_post | the number of open advertisements in the social network | STRING |
viral-moving_into_group | the number of transitions to the group page from the shared advertisement | STRING |
viral-clicks_on_external_url | the number of clicks on an external link in a publicized advertised message | STRING |
viral-comments | the number of comments left in the public message advertised | STRING |
viral-joinings | the number of connections to a group through a publicized advertised message | STRING |
viral-likes | the number of likes of the advertised message | STRING |
viral-shares | the number of actions to 'Share' for the advertised message | STRING |
viral-votings | the number of voting actions in a publicized advertised message | STRING |
tps-tps | additional charges for using the moat service | STRING |
tps-tpd | additional write-offs for the use of third-party data (from dmp) | STRING |
moat-impressions | the number of impressions | STRING |
moat-in_view | the number of visible impressions | STRING |
moat-never_focused | the number of impressions in the inactive tab | STRING |
moat-never_visible | the number of impressions out of scope | STRING |
moat-never_50_perc_visible | the number of impressions with an ad zone less than 50% | STRING |
moat-never_1_sec_visible | the number of impressions with visibility less than 1 second | STRING |
moat-human_impressions | the number of verified impressions | STRING |
moat-impressions_analyzed | the number of impressions analyzed | STRING |
moat-in_view_percent | the percentage of visible impressions | STRING |
moat-human_and_viewable_perc | percentage of verified impressions | STRING |
moat-never_focused_percent | the percentage of impressions in the inactive tab | STRING |
moat-never_visible_percent | the percentage of impressions out of scope | STRING |
moat-never_50_perc_visible_percent | the percentage of cases with an ad visibility area of less than 50% | STRING |
moat-never_1_sec_visible_percent | percentage of impressions with visibility less than 1 second | STRING |
moat-in_view_diff_percent | the difference in the number of visible impressions | STRING |
moat-active_in_view_time | the average time that the ad is visible in the visibility zone | STRING |
moat-attention_quality | the level of waxing | STRING |
package_id | package_id | INTEGER |
id | id | INTEGER |
name | name | STRING |
age_restrictions | age_restrictions | STRING |
autobidding_mode | autobidding_mode | STRING |
banner_uniq_shows_limit | banner_uniq_shows_limit | STRING |
budget_limit | budget_limit | FLOAT |
budget_limit_day | budget_limit_day | FLOAT |
created | created | DATE |
date_end | date_end | STRING |
date_start | date_start | STRING |
delivery | delivery | STRING |
enable_utm | enable_utm | STRING |
mixing | mixing | STRING |
price | price | FLOAT |
pricelist_id | pricelist_id | INTEGER |
shows_limit | shows_limit | STRING |
status | status | STRING |
uniq_shows_limit | uniq_shows_limit | STRING |
uniq_shows_period | uniq_shows_period | STRING |
updated | updated | DATE |
utm | utm | STRING |
date | Date | DATE |
_______________________________________________
If you have any questions – please contact us!