MyTarget Source

Renta supports data export from MyTarget 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 MyTarget;
  3. Add a MyTarget account that has the necessary data;
  4. Choose the added MyTarget account;
  5. Specify the destination you want to import the data into;
  6. 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.

Namedescription
bannersAds that were created and filled in one or more format variants in your ad account.
campaignsThe 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:

  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
base-showsthe number of impressionsSTRING
base-clicksthe number of clicksSTRING
base-goalsthe number of achievement goals (Top@Mail.ru goals for sites and installations for mobile applications)STRING
base-spentwrite-offsSTRING
base-cpmaverage write-off for 1000 viewsSTRING
base-cpcaverage write-off for 1 clickSTRING
base-cpaaverage write-off for achieving 1 goalSTRING
base-ctrthe percentage of clicks to the number of viewsSTRING
base-crthe percentage of the number of goal achievements to the number of clicksSTRING
events-opening_appthe number of openings of the advertised social networks applicationSTRING
events-opening_postthe number of openings of the advertised message in the social networkSTRING
events-moving_into_groupthe number of transitions to the group page from the advertised messageSTRING
events-clicks_on_external_urlthe number of clicks on the external link in the advertised messageSTRING
events-launching_videothe number of video starts in the advertised messageSTRING
events-commentsthe number of comments left in the advertised messageSTRING
events-joiningsthe number of connections to the group through the advertised messageSTRING
events-likesthe number of likes of the advertised messageSTRING
events-sharesthe number of actions 'Share' for the advertised messageSTRING
events-votingsthe number of voting actions in the advertised messageSTRING
uniques-reachthe number of unique users who saw the ad for the specified periodSTRING
uniques-totalthe total number of unique users who saw the ad all the timeSTRING
uniques-incrementthe number of new unique users who saw the ad for the specified periodSTRING
uniques-frequencythe average frequency of showing ads to one unique userSTRING
video-startedthe number of starts of video playbackSTRING
video-pausedthe number of pauses of video playbackSTRING
video-resumed_after_pausethe amount of video playback after a pauseSTRING
video-fullscreen_onthe number of full-screen video playbackSTRING
video-fullscreen_offthe number of off-screen full-screen video playbackSTRING
video-sound_turned_offthe number of video sound mutesSTRING
video-sound_turned_onthe number of video sound clipsSTRING
video-viewed_10_secondsthe number of views of the first 10 seconds of the videoSTRING
video-viewed_25_percentthe number of views of the first 25% of the duration of the videoSTRING
video-viewed_50_percentthe number of views of the first 50% of the duration of the videoSTRING
video-viewed_75_percentthe number of views of the first 75% of the duration of the videoSTRING
video-viewed_100_percentthe number of views 100% of the duration of the videoSTRING
video-viewed_10_seconds_ratethe percentage of views with the first 10 seconds of video reachedSTRING
video-viewed_25_percent_ratethe percentage of views with the first 25% of the duration of the videoSTRING
video-viewed_50_percent_ratethe percentage of views with the achievement of the first 50% of the duration of the videoSTRING
video-viewed_75_percent_ratethe percentage of views with the achievement of the first 75% of the duration of the videoSTRING
video-viewed_100_percent_ratethe percentage of views with the achievement of 100% of the duration of the videoSTRING
video-depth_of_viewaverage depth of video viewing (in percent)STRING
video-view_10_seconds_costthe average cost of viewing the first 10 seconds of the videoSTRING
video-viewed_25_percent_costthe average cost of viewing the first 25% of the duration of the videoSTRING
video-viewed_50_percent_costthe average cost of viewing the first 50% of the duration of the videoSTRING
video-viewed_75_percent_costthe average cost of viewing the first 75% of the duration of the videoSTRING
video-viewed_100_percent_costthe average cost of viewing 100% of the duration of the videoSTRING
viral-impressionsthe number of impressions of a shared advertisement in social networksSTRING
viral-reachthe number of unique users who saw a shared advertising message for the specified periodSTRING
viral-totalthe total number of unique users who saw a shared advertising message for all timeSTRING
viral-incrementthe number of new unique users who saw a shared advertising message for the specified periodSTRING
viral-frequencythe average frequency of displaying a shared advertisement to one unique userSTRING
viral-opening_appthe number of openings of the advertised application from the shared advertising messageSTRING
viral-opening_postthe number of open advertisements in the social networkSTRING
viral-moving_into_groupthe number of transitions to the group page from the shared advertisementSTRING
viral-clicks_on_external_urlthe number of clicks on an external link in a publicized advertised messageSTRING
viral-commentsthe number of comments left in the public message advertisedSTRING
viral-joiningsthe number of connections to a group through a publicized advertised messageSTRING
viral-likesthe number of likes of the advertised messageSTRING
viral-sharesthe number of actions to 'Share' for the advertised messageSTRING
viral-votingsthe number of voting actions in a publicized advertised messageSTRING
tps-tpsadditional charges for using the moat serviceSTRING
tps-tpdadditional write-offs for the use of third-party data (from dmp)STRING
moat-impressionsthe number of impressionsSTRING
moat-in_viewthe number of visible impressionsSTRING
moat-never_focusedthe number of impressions in the inactive tabSTRING
moat-never_visiblethe number of impressions out of scopeSTRING
moat-never_50_perc_visiblethe number of impressions with an ad zone less than 50%STRING
moat-never_1_sec_visiblethe number of impressions with visibility less than 1 secondSTRING
moat-human_impressionsthe number of verified impressionsSTRING
moat-impressions_analyzedthe number of impressions analyzedSTRING
moat-in_view_percentthe percentage of visible impressionsSTRING
moat-human_and_viewable_percpercentage of verified impressionsSTRING
moat-never_focused_percentthe percentage of impressions in the inactive tabSTRING
moat-never_visible_percentthe percentage of impressions out of scopeSTRING
moat-never_50_perc_visible_percentthe percentage of cases with an ad visibility area of ​​less than 50%STRING
moat-never_1_sec_visible_percentpercentage of impressions with visibility less than 1 secondSTRING
moat-in_view_diff_percentthe difference in the number of visible impressionsSTRING
moat-active_in_view_timethe average time that the ad is visible in the visibility zoneSTRING
moat-attention_qualitythe level of waxingSTRING
HrefIdentifies sections within a documentSTRING
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
ididINTEGER
campaign_idcampaign_idINTEGER
call_to_actioncall_to_actionSTRING
createdcreatedDATE
deliverydeliverySTRING
moderation_statusmoderation_statusSTRING
statusstatusSTRING
updatedupdatedDATE
user_can_request_remoderationuser_can_request_remoderationBIT
dateDateDATE
base-showsthe number of impressionsSTRING
base-clicksthe number of clicksSTRING
base-goalsthe number of achievement goals (Top@Mail.ru goals for sites and installations for mobile applications)STRING
base-spentwrite-offsSTRING
base-cpmaverage write-off for 1000 viewsSTRING
base-cpcaverage write-off for 1 clickSTRING
base-cpaaverage write-off for achieving 1 goalSTRING
base-ctrthe percentage of clicks to the number of viewsSTRING
base-crthe percentage of the number of goal achievements to the number of clicksSTRING
events-opening_appthe number of openings of the advertised social networks applicationSTRING
events-opening_postthe number of openings of the advertised message in the social networkSTRING
events-moving_into_groupthe number of transitions to the group page from the advertised messageSTRING
events-clicks_on_external_urlthe number of clicks on the external link in the advertised messageSTRING
events-launching_videothe number of video starts in the advertised messageSTRING
events-commentsthe number of comments left in the advertised messageSTRING
events-joiningsthe number of connections to the group through the advertised messageSTRING
events-likesthe number of likes of the advertised messageSTRING
events-sharesthe number of actions 'Share' for the advertised messageSTRING
events-votingsthe number of voting actions in the advertised messageSTRING
uniques-reachthe number of unique users who saw the ad for the specified periodSTRING
uniques-totalthe total number of unique users who saw the ad all the timeSTRING
uniques-incrementthe number of new unique users who saw the ad for the specified periodSTRING
uniques-frequencythe average frequency of showing ads to one unique userSTRING
video-startedthe number of starts of video playbackSTRING
video-pausedthe number of pauses of video playbackSTRING
video-resumed_after_pausethe amount of video playback after a pauseSTRING
video-fullscreen_onthe number of full-screen video playbackSTRING
video-fullscreen_offthe number of off-screen full-screen video playbackSTRING
video-sound_turned_offthe number of video sound mutesSTRING
video-sound_turned_onthe number of video sound clipsSTRING
video-viewed_10_secondsthe number of views of the first 10 seconds of the videoSTRING
video-viewed_25_percentthe number of views of the first 25% of the duration of the videoSTRING
video-viewed_50_percentthe number of views of the first 50% of the duration of the videoSTRING
video-viewed_75_percentthe number of views of the first 75% of the duration of the videoSTRING
video-viewed_100_percentthe number of views 100% of the duration of the videoSTRING
video-viewed_10_seconds_ratethe percentage of views with the first 10 seconds of video reachedSTRING
video-viewed_25_percent_ratethe percentage of views with the first 25% of the duration of the videoSTRING
video-viewed_50_percent_ratethe percentage of views with the achievement of the first 50% of the duration of the videoSTRING
video-viewed_75_percent_ratethe percentage of views with the achievement of the first 75% of the duration of the videoSTRING
video-viewed_100_percent_ratethe percentage of views with the achievement of 100% of the duration of the videoSTRING
video-depth_of_viewaverage depth of video viewing (in percent)STRING
video-view_10_seconds_costthe average cost of viewing the first 10 seconds of the videoSTRING
video-viewed_25_percent_costthe average cost of viewing the first 25% of the duration of the videoSTRING
video-viewed_50_percent_costthe average cost of viewing the first 50% of the duration of the videoSTRING
video-viewed_75_percent_costthe average cost of viewing the first 75% of the duration of the videoSTRING
video-viewed_100_percent_costthe average cost of viewing 100% of the duration of the videoSTRING
viral-impressionsthe number of impressions of a shared advertisement in social networksSTRING
viral-reachthe number of unique users who saw a shared advertising message for the specified periodSTRING
viral-totalthe total number of unique users who saw a shared advertising message for all timeSTRING
viral-incrementthe number of new unique users who saw a shared advertising message for the specified periodSTRING
viral-frequencythe average frequency of displaying a shared advertisement to one unique userSTRING
viral-opening_appthe number of openings of the advertised application from the shared advertising messageSTRING
viral-opening_postthe number of open advertisements in the social networkSTRING
viral-moving_into_groupthe number of transitions to the group page from the shared advertisementSTRING
viral-clicks_on_external_urlthe number of clicks on an external link in a publicized advertised messageSTRING
viral-commentsthe number of comments left in the public message advertisedSTRING
viral-joiningsthe number of connections to a group through a publicized advertised messageSTRING
viral-likesthe number of likes of the advertised messageSTRING
viral-sharesthe number of actions to 'Share' for the advertised messageSTRING
viral-votingsthe number of voting actions in a publicized advertised messageSTRING
tps-tpsadditional charges for using the moat serviceSTRING
tps-tpdadditional write-offs for the use of third-party data (from dmp)STRING
moat-impressionsthe number of impressionsSTRING
moat-in_viewthe number of visible impressionsSTRING
moat-never_focusedthe number of impressions in the inactive tabSTRING
moat-never_visiblethe number of impressions out of scopeSTRING
moat-never_50_perc_visiblethe number of impressions with an ad zone less than 50%STRING
moat-never_1_sec_visiblethe number of impressions with visibility less than 1 secondSTRING
moat-human_impressionsthe number of verified impressionsSTRING
moat-impressions_analyzedthe number of impressions analyzedSTRING
moat-in_view_percentthe percentage of visible impressionsSTRING
moat-human_and_viewable_percpercentage of verified impressionsSTRING
moat-never_focused_percentthe percentage of impressions in the inactive tabSTRING
moat-never_visible_percentthe percentage of impressions out of scopeSTRING
moat-never_50_perc_visible_percentthe percentage of cases with an ad visibility area of ​​less than 50%STRING
moat-never_1_sec_visible_percentpercentage of impressions with visibility less than 1 secondSTRING
moat-in_view_diff_percentthe difference in the number of visible impressionsSTRING
moat-active_in_view_timethe average time that the ad is visible in the visibility zoneSTRING
moat-attention_qualitythe level of waxingSTRING
package_idpackage_idINTEGER
ididINTEGER
namenameSTRING
age_restrictionsage_restrictionsSTRING
autobidding_modeautobidding_modeSTRING
banner_uniq_shows_limitbanner_uniq_shows_limitSTRING
budget_limitbudget_limitFLOAT
budget_limit_daybudget_limit_dayFLOAT
createdcreatedDATE
date_enddate_endSTRING
date_startdate_startSTRING
deliverydeliverySTRING
enable_utmenable_utmSTRING
mixingmixingSTRING
pricepriceFLOAT
pricelist_idpricelist_idINTEGER
shows_limitshows_limitSTRING
statusstatusSTRING
uniq_shows_limituniq_shows_limitSTRING
uniq_shows_perioduniq_shows_periodSTRING
updatedupdatedDATE
utmutmSTRING
dateDateDATE

_______________________________________________
If you have any questions – please contact us!