MyTarget Source
Renta / Documentation / ETL pipelines / MyTarget Source

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.

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:

  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

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!