Yandex Market Source

Renta supports data export from Yandex Market 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 Yandex Market;
  3. Add a Yandex Market account that has the necessary data;
  4. Choose the added Yandex Market 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
mainContains all statistics for the whole Market.
offersAllows you to filter information about store offers that are published on Yandex.Market.

Campaign

If there are many advertising campaigns available, then you can choose the necessary one here.

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.

Type of date

Allows users to group their data by type of date: date of event or date of report.

Click type

Allows users to filter their data by type of click: all click, normal click or click on the phone number.

Spending filter

Allows users to filter their data by type of spending: either with a discount or without.

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
clicksThe number of clicks.INTEGER
dateThe date for which statistics are given for resourcesDATE
showsNumber of hitsINTEGER
spendingThe cost of clicks in arbitrary units, including VAT.FLOAT
mobile_clicksNumber of clicks on the proposal according to the type of statistics specified in the type parameter.INTEGER
mobile_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
mobile_showsNumber of impressions for the proposal according to the type of statistics specified in the type parameter.INTEGER
campaign_idStore IDINTEGER
campaign_domainStore URLSTRING
campaign_stateStore statusSTRING
placeGroup_Not_Specified_clicksPlacement clicksINTEGER
placeGroup_Not_Specified_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
placeGroup_Not_Specified_showsNumber of hitsINTEGER
placeGroup_mobile_Not_Specified_clicksPlacement mobile clicksINTEGER
placeGroup_mobile_Not_Specified_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
placeGroup_mobile_Not_Specified_showsNumber of hitsINTEGER
placeGroup_Yandex_Market_Search_clicksPlacement clicksINTEGER
placeGroup_Yandex_Market_Search_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
placeGroup_Yandex_Market_Search_showsNumber of hitsINTEGER
placeGroup_mobile_Yandex_Market_Search_clicksPlacement mobile clicksINTEGER
placeGroup_mobile_Yandex_Market_Search_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
placeGroup_mobile_Yandex_Market_Search_showsNumber of hitsINTEGER
placeGroup_Cards_Of_The_Goods_clicksPlacement clicksINTEGER
placeGroup_Cards_Of_The_Goods_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
placeGroup_Cards_Of_The_Goods_showsNumber of hitsINTEGER
placeGroup_mobile_Cards_Of_The_Goods_clicksPlacement mobile clicksINTEGER
placeGroup_mobile_Cards_Of_The_Goods_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
placeGroup_mobile_Cards_Of_The_Goods_showsNumber of hitsINTEGER
placeGroup_Yandex_Market_clicksPlacement clicksINTEGER
placeGroup_Yandex_Market_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
placeGroup_Yandex_Market_showsNumber of hitsINTEGER
placeGroup_mobile_Yandex_Market_clicksPlacement mobile clicksINTEGER
placeGroup_mobile_Yandex_Market_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
placeGroup_mobile_Yandex_Market_showsNumber of hitsINTEGER
placeGroup_Yandex_Search_clicksPlacement clicksINTEGER
placeGroup_Yandex_Search_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
placeGroup_Yandex_Search_showsNumber of hitsINTEGER
placeGroup_mobile_Yandex_Search_clicksPlacement mobile clicksINTEGER
placeGroup_mobile_Yandex_Search_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
placeGroup_mobile_Yandex_Search_showsNumber of hitsINTEGER
placeGroup_Default_Clause_clicksPlacement clicksINTEGER
placeGroup_Default_Clause_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
placeGroup_Default_Clause_showsNumber of hitsINTEGER
placeGroup_mobile_Default_Clause_clicksPlacement mobile clicksINTEGER
placeGroup_mobile_Default_Clause_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
placeGroup_mobile_Default_Clause_showsNumber of hitsINTEGER
placeGroup_Top_6_clicksPlacement clicksINTEGER
placeGroup_Top_6_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
placeGroup_Top_6_showsNumber of hitsINTEGER
placeGroup_mobile_Top_6_clicksPlacement mobile clicksINTEGER
placeGroup_mobile_Top_6_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
placeGroup_mobile_Top_6_showsNumber of hitsINTEGER
placeGroup_Other_Places_clicksPlacement clicksINTEGER
placeGroup_Other_Places_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
placeGroup_Other_Places_showsNumber of hitsINTEGER
placeGroup_mobile_Other_Places_clicksPlacement mobile clicksINTEGER
placeGroup_mobile_Other_Places_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
placeGroup_mobile_Other_Places_showsNumber of hitsINTEGER
placeGroup_Unknown_clicksPlacement clicksINTEGER
placeGroup_Unknown_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
placeGroup_Unknown_showsNumber of hitsINTEGER
placeGroup_mobile_Unknown_clicksPlacement mobile clicksINTEGER
placeGroup_mobile_Unknown_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
placeGroup_mobile_Unknown_showsNumber of hitsINTEGER
clicksThe number of clicks.INTEGER
dateThe date for which statistics are given for resourcesDATE
spendingThe cost of clicks in arbitrary units, including VAT.FLOAT
offerNameOffer nameSTRING
offerIdOffer IDSTRING
offerUrlOffer urlSTRING
feedIdFeed IDSTRING
mobile_clicksNumber of clicks on the proposal according to the type of statistics specified in the type parameter.INTEGER
mobile_spendingThe cost of clicks on the proposal according to the type of statistics specified in the type parameter, in arbitrary units, including VAT.FLOAT
campaign_idStore IDINTEGER
campaign_domainStore URLSTRING
campaign_stateStore statusSTRING
utm_campaignutm_campaignSTRING
utm_contentutm_contentSTRING
utm_sourceutm_sourceSTRING
utm_mediumutm_mediumSTRING
utm_termutm_termSTRING

_______________________________________________
If you have any questions – please contact us!