MyTarget Source

Renta поддерживает экспорт данных из MyTarget в следующие пункты назначения:

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

Создание интеграции в хранилище данных (DWH)

  1. Перейдите в каталог интеграций;
  2. Выберите MyTarget;
  3. Добавьте аккаунт MyTarget, в котором находятся необходимые данные;
  4. Выберите добавленный аккаунт MyTarget;
  5. Укажите место назначения, в которое вы хотите импортировать данные;
  6. Перейдите на экран настроек и установите необходимую конфигурацию:

Source type

Тип источника — состоит из уникального набора параметров и метрик, доступных для выгрузки в DWH. Каждый тип источника соответствует одноименному методу API MyTarget. 

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

Параметры — содержат список параметров и метрик, доступных для экспорта. Укажите необходимые для выгрузки параметры.

В результате Renta создаст таблицу, которая будет содержать данные выбранных параметров. Порядок выбранных параметров в интерфейсе будет соответствовать порядку столбцов таблицы.

Date range type

Диапазон дат — укажите период, за который необходимо экспортировать данные. Вы можете указать любой исторический временной интервал.

Чтобы выбрать необходимое время, введите в поле «From» дату, с которой вы хотите начать выгрузку данных, затем введите дату окончания в поле «To».

Если вы хотите, чтобы данные в таблице обновлялись ежедневно и дополнялись новыми днями, тогда в поле «To» укажите «Yesterday».
Подробная инструкция по работе с диапазоном дат

Integration name

Имя интеграции — при создании интеграции автоматически генерируется её имя. В этом поле вы можете переименовать название интеграции. Разрешены как кириллица, так и латиница, но не более 100 символов.

Название интеграции отображается на странице Integration List.

Table name

Имя таблицы — при создании интеграции автоматически генерируется имя таблицы, которая будет создана в DWH. В этом поле вы можете переименовать её.

Разрешена только латиница, цифры и символ «_».

Update time

Время обновления — вы можете указать любое время обновления, которое вам нужно. Рента обновляет интеграции ежедневно в интервале выбранного часа. 

Обычно наши пользователи выбирают время обновления интеграций рано утром, например, в 5 утра. В этом случае ваша интеграция будет обновляться в период с 5 утра до 6 утра. 

Обновление интеграций происходит по часовому поясу, выбранном в настройках вашего профайла. 

Overwrite period

Период перезаписи данных — это ретроспективное обновление данных за выбранный период.

Например, вы выбираете период перезаписи «Последние 7 дней» — это означает, что все данные за последние 7 дней будут удалены из таблицы и вставлены снова с обновленными данными.

Примечание: данная настройка доступна только в том случае, если был выбран параметр с типом date или dateTime. 

Создание интеграции в Google Spreadsheets

Воспользуйтесь бесплатным расширением, доступным в Google Workspace Marketplace. Для этого:

  1. Установите расширение Renta Spreadsheets Add-on.
  2. Затем зайдите в Google Sheets, и во вкладке Tools выберите Renta, после чего нажмите кнопку Run. 

После чего в правом сайдбаре откроется рабочая область с настройками интеграций. Подробная инструкция по созданию интеграции доступна по данной ссылке. Обратите внимание, что все созданные интеграции в Google Spreadsheets также доступны для управления в веб-версии Renta. 

Структура данных

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
 
_______________________________________________
Если у вас есть вопросы — свяжитесь с нами!