Renta / Documentation / ETL data sources / 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)

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!