Renta supports data export from Yandex Metrica to following destinations:
- Google BigQuery
- Clickhouse
- SQL Server
- Google Spreadsheets
Integration creating in data warehouse (DWH)
- Go to integrations catalog;
- Select Yandex Metrica;
- Add a Yandex Metrica account that has the necessary data;
- Choose the added Yandex Metrica account;
- Specify the destination you want to import the data into;
- Go to the settings screen and set necessary configuration:
Counter
Specify the Yandex.Metrica counter from which you want to upload the required data.
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 |
|---|---|
| sessions | A sequence of actions (activity) performed on the website by a single user (on a single tag). |
| pageviews | Loading one of a website's pages when a user navigates to it. |
| clicks | Users clicks on different websites objects. |
| userParameters | Custom data. |
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 |
|---|---|---|
| ym:s:visits | Total number of visits. | FLOAT |
| ym:s:pageviews | Number of page views on the site in the reporting period. | FLOAT |
| ym:s:users | Number of unique users. | FLOAT |
| ym:s:goal | Share of conversions in the total number of visits. | FLOAT |
| ym:s:goal | Percentage of converted sessions among the total number of unique users. | FLOAT |
| ym:s:goal | Number of unique users that reached goals. | FLOAT |
| ym:s:goal | Number of converted sessions. | FLOAT |
| ym:s:goal | Total number of conversions in all targeted visits. | FLOAT |
| ym:s:goal | Average number of conversions per unique converted user. | FLOAT |
| ym:s:goal | Revenue. | FLOAT |
| ym:s:goal | Revenue. | FLOAT |
| ym:s:anyGoalConversionRate | Conversion rate by any goal. | STRING |
| ym:s:sumGoalReachesAny | Number of any conversions. | FLOAT |
| ym:s:paramsNumber | Number of times a visit parameter is met. | FLOAT |
| ym:s:sumParams | Average value of session parameter. Calculated if a session parameter value is represented numerically. | FLOAT |
| ym:s:avgParams | Average value of session parameter. Calculated if a session parameter value is represented numerically. | FLOAT |
| ym:s:percentNewVisitors | Percentage of unique visitors visiting the site in the reporting period, the activity of which is calculated from their very first visit to the site and continuing through the entire data-collection period. | FLOAT |
| ym:s:newUsers | Number of new users. | FLOAT |
| ym:s:newUserVisitsPercentage | Percentage of new users' sessions. | FLOAT |
| ym:s:upToDaySinceFirstVisitPercentage | Share of visits by those known for less than one day. | STRING |
| ym:s:upToWeekSinceFirstVisitPercentage | Percentage of sessions by users known for 1-7 days. | FLOAT |
| ym:s:upToMonthSinceFirstVisitPercentage | Percentage of sessions by users known for 8-31 days. | FLOAT |
| ym:s:upToQuarterSinceFirstVisitPercentage | Percentage of sessions by users known for 32-90 days. | FLOAT |
| ym:s:upToYearSinceFirstVisitPercentage | Percentage of sessions by users known from 91 to 365 days. | FLOAT |
| ym:s:overYearSinceFirstVisitPercentage | Share of visits by those known for more than 365 days. | FLOAT |
| ym:s:oneVisitPerUserPercentage | Share of visits by visitors with one visit (visitor's first visit). | FLOAT |
| ym:s:upTo3VisitsPerUserPercentage | Share of users visits with 2-3 visits. | FLOAT |
| ym:s:upTo7VisitsPerUserPercentage | Percentage of sessions by users with 4-7 sessions. | FLOAT |
| ym:s:upTo31VisitsPerUserPercentage | Percentage of sessions by users with 8-31 sessions. | FLOAT |
| ym:s:over32VisitsPerUserPercentage | Share of visits by users, who visited more than 32 times. | FLOAT |
| ym:s:oneDayBetweenVisitsPercentage | Percentage of sessions by users with a session frequency of one time in a period of 1 day. This includes users who had more than two sessions which occurred on different days. | FLOAT |
| ym:s:upToWeekBetweenVisitsPercentage | Percentage of user sessions with a session frequency of once in a period of 2‑7 days. This includes users who have more than two sessions and on more than one day. | FLOAT |
| ym:s:upToMonthBetweenVisitsPercentage | Percentage of user sessions with a session frequency of once in a period of 8‑31 days. This includes users who have more than two sessions and on more than one day. | FLOAT |
| ym:s:overMonthBetweenVisitsPercentage | Percentage of sessions by users with a session frequency of one time in a period of more than 31 days. This includes users who have more than two sessions which occurred on different days. | FLOAT |
| ym:s:upToDayUserRecencyPercentage | Percentage of sessions by users who returned to the site the next day. | FLOAT |
| ym:s:upToWeekUserRecencyPercentage | Percentage of sessions by users, returning to the site after 2-7 days. | FLOAT |
| ym:s:upToMonthUserRecencyPercentage | Percentage of sessions by users, returning to the site after 8-31 days. | FLOAT |
| ym:s:upToQuarterUserRecencyPercentage | Percentage of sessions by users, returning to the site after 32-90 days. | FLOAT |
| ym:s:upToYearUserRecencyPercentage | Percentage of sessions by users who returned to the site within 91-365 days. | FLOAT |
| ym:s:overYearUserRecencyPercentage | Percentage of sessions by users who returned to the site after more than 365 days. | FLOAT |
| ym:s:avgDaysBetweenVisits | Average number of days between user visits. | FLOAT |
| ym:s:avgDaysSinceFirstVisit | Average time elapsed since first visit in days. | FLOAT |
| ym:s:userRecencyDays | Average time since penultimate visit in days. | FLOAT |
| ym:s:manPercentage | Percentage of men. | FLOAT |
| ym:s:womanPercentage | Percentage of women. | FLOAT |
| ym:s:under18AgePercentage | Percentage of visits by those younger than 18 years old. | FLOAT |
| ym:s:upTo24AgePercentage | Percentage of visits by those between 18-24 years old. | FLOAT |
| ym:s:upTo34AgePercentage | Percentage of visits by those between 25-34 years old. | FLOAT |
| ym:s:upTo44AgePercentage | Percentage of visits by those between 35-45 years old. | FLOAT |
| ym:s:upTo54AgePercentage | Percentage of sessions by users from 45 to 55 years old. | FLOAT |
| ym:s:over54AgePercentage | Percentage of sessions by users over 55 years old. | FLOAT |
| ym:s:cookieEnabledPercentage | Percentage of sessions and hits with cookies enabled. | FLOAT |
| ym:s:javaEnabledPercentage | Share of visits and hits with Java support. | FLOAT |
| ym:s:jsEnabledPercentage | Percentage of sessions and hits with JavaScript support. | FLOAT |
| ym:s:flashEnabledPercentage | Percentage of sessions and hits with Flash support. | FLOAT |
| ym:s:silverlightEnabledPercentage | Share of visits and hits with Silverlight support. | FLOAT |
| ym:s:mobilePercentage | Percentage of visits and hits made with mobile devices. | FLOAT |
| ym:s:blockedPercentage | Percentage of sessions with ad blockers. | FLOAT |
| ym:s:productImpressions | The total number of product information page views across all sessions. | FLOAT |
| ym:s:productImpressionsUniq | The number of users who viewed the product information for at least one item. | FLOAT |
| ym:s:productBasketsQuantity | The number of items added to basket, total for all sessions. | FLOAT |
| ym:s:productBasketsPrice | Cost of items added to basket, total for all sessions. | FLOAT |
| ym:s:productBasketsUniq | The number of users who added at least one item to their basket over the sum total of their sessions. | FLOAT |
| ym:s:productPurchasedQuantity | Number of items purchased in total for all sessions. | FLOAT |
| ym:s:productPurchasedPrice | Cost of all items purchased, total for all sessions. | STRING |
| ym:s:productPurchasedUniq | The number of users who bought at least one item over the sum total of all sessions. | FLOAT |
| ym:s:ecommercePurchases | Number of purchases. | FLOAT |
| ym:s:ecommerceRevenue | Total revenue for all sessions. It is sent to revenue field when items are purchased, or is automatically calculated as the sum of the prices of all items associated with the purchase. | FLOAT |
| ym:s:ecommerceRevenuePerVisit | Average revenue per session. | FLOAT |
| ym:s:ecommerceRevenuePerPurchase | Average revenue from purchase. | FLOAT |
| ym:s:offlineCalls | Number of calls. | FLOAT |
| ym:s:offlineCallsMissed | Number of missed calls. | FLOAT |
| ym:s:offlineCallsMissedPercentage | Percentage of missed calls. | FLOAT |
| ym:s:offlineCallsFirstTimeCaller | Number of first-time callers. | FLOAT |
| ym:s:offlineCallsFirstTimeCallerPercentage | Percentage of missed calls. | FLOAT |
| ym:s:offlineCallsUniq | Number of calls from unique phone numbers. | FLOAT |
| ym:s:offlineCallTalkDurationAvg | Average time of call. | STRING |
| ym:s:offlineCallHoldDurationTillAnswerAvg | Average waiting time. | STRING |
| ym:s:offlineCallHoldDurationTillMissAvg | Average time on hold before hanging up. | STRING |
| ym:s:offlineCallDurationAvg | Average call duration. | STRING |
| ym:s:offlineCallRevenueAvg | Average revenue from offline callss. | STRING |
| ym:s:offlineCallRevenue | Revenue from offline calls. | STRING |
| ym:s:yanRequests | Requests for ad code sent to the Yandex RTB system, for instance. | FLOAT |
| ym:s:yanRenders | Requests to the Yandex RTB system, for instance, that resulted in successfully selecting ads to serve (there were ads or banners over the CPM threshold). | FLOAT |
| ym:s:yanShows | An impression is when an ad block, ad, or banner on a site page is shown to a site user. In the Yandex Advertising Network, the viewability of ad blocks is considered when registering ad impressions. | FLOAT |
| ym:s:yanPartnerPrice | Estimated cost of impressions in the selected report period (in rubles, without VAT). | STRING |
| ym:s:yanCPMV | Cost per mille viewable ads: the cost of one thousand actual impressions of the ad block (with verification of ad visibility), in rubles without VAT. | STRING |
| ym:s:yanECPM | Effective cost per mille: the cost of one thousand renderings of the ad block, in rubles without VAT. | STRING |
| ym:s:yanRPM | Revenue per mille: the cost of one thousand requests for all ad blocks, including blocks that didn't have an ad matched to them. Cost is in rubles without VAT. | STRING |
| ym:s:yanVisibility | Ratio of the number of impressions to the number of renderings. | STRING |
| ym:s:yanARPU | Average revenue per user: the site's average revenue per user, in rubles without VAT. | FLOAT |
| ym:s:yanRendersPerUser | Average number of renderings of YAN blocks per site user. | FLOAT |
| ym:s:yanRevenuePerVisit | Average revenue for displaying YAN blocks per session, in rubles without VAT. | STRING |
| ym:s:yanRevenuePerHit | Average revenue for displaying YAN blocks per pageview, in rubles without VAT. | STRING |
| ym:s:yanRendersPerVisit | Average number of renderings of YAN blocks per site session. | FLOAT |
| ym:s:yanRendersPerHit | Average number of renderings of YAN blocks per pageview. | FLOAT |
| ym:s:affinityIndexInterests | The ratio of the percentage of users with a specific interest on this site to the average percentage of users with this interest on all internet websites. | STRING |
| ym:s:GCLIDPercentage | Percentage of visits with GCLID tag. | FLOAT |
| ym:s: | Traffic source. | STRING |
| ym:s: | Second level of traffic sources | STRING |
| ym:s: | Ad system. | STRING |
| ym:s: | From which sites were clicks to a site. | STRING |
| ym:s: | Yandex.Direct ad campaign. | STRING |
| ym:s: | Yandex.Direct ad group. | STRING |
| ym:s: | Title of Yandex.Direct ad. | STRING |
| ym:s: | Ad impression criteria. Criteria can be a keyword, or retargeting criteria. | STRING |
| ym:s: | Type of Yandex.Direct ad site. | STRING |
| ym:s: | Yandex.Direct ad site. | STRING |
| ym:s: | Keyword of last click by Yandex.Direct ad. | STRING |
| ym:s: | Type of ad impression criteria. | STRING |
| ym:s: | Currency set in Yandex.Direct for ad campaigns. | STRING |
| ym:s: | Yandex.Display order number. | STRING |
| ym:s: | ID of top-level search engine hierarchy. | STRING |
| ym:s: | Refined search engine. | STRING |
| ym:s: | Keyword from search engine. | STRING |
| ym:s: | Traffic source - social network ID. | STRING |
| ym:s: | Social network page. | STRING |
| ym:s:referer | Referrer URL | STRING |
| ym:s:refererProto | Referrer protocol. | STRING |
| ym:s:refererDomain | Referrer domain. | STRING |
| ym:s:refererPathFull | Part of URL of referrer, comes immediately after the domain. Unlike simple path, it also contains parameters section and fragment. | STRING |
| ym:s:refererPath | Part of the referrer URL right after the domain up to ? (parameter section), # (fragment section) or up to end of a string. For example, for the page http://news.yandex.ru/quotes/1.html the path is /quotes/1.html, for http://news.yandex.ru/ it is /, and for http://news.yandex.ru it is an empty string. | STRING |
| ym:s:refererPathLevel1 | First level URL of referrer. For example, in http://ya.ru/1/2/3/4.html , the first level URL is http://ya.ru/. | STRING |
| ym:s:refererPathLevel2 | Second level URL of referrer. For example, in http://ya.ru/1/2/3/4.html , the second level URL is http://ya.ru/1/. | STRING |
| ym:s:refererPathLevel3 | Third level URL of referrer. For example, in http://ya.ru/1/2/3/4.html , the third level URL is http://ya.ru/1/2. | STRING |
| ym:s:refererPathLevel4 | Fourth level of URL referrer. For example, in http://ya.ru/1/2/3/4.html , the fourth level URL is http://ya.ru/1/2/3/. | STRING |
| ym:s:refererPathLevel5 | Fifth level URL of referrer. For example, in http://ya.ru/1/2/3/4.html , the fifth level URL is http://ya.ru/1/2/3/4.html. | STRING |
| ym:s:externalReferer | URL of the external referrer for the "Link traffic" source | STRING |
| ym:s:externalRefererProto | External referrer protocol. | STRING |
| ym:s:externalRefererDomain | External referrer domain. | STRING |
| ym:s:externalRefererPathFull | Part of the external referrer URL address right after the domain. Unlike a simple path, this part also contains the sections of parameters and fragment. | STRING |
| ym:s:externalRefererPath | Part of the external referrer URL right after the domain up to ? (parameter section), # (fragment section) or to the end of a string. For example, for the page http://news.yandex.ru/quotes/1.html the path is /quotes/1.html, for http://news.yandex.ru/ it is /, and for http://news.yandex.ru it is an empty string. | STRING |
| ym:s:externalRefererPathLevel1 | First level URL of external referrer. For example, in http://ya.ru/1/2/3/4.html , the first level URL is http://ya.ru/. | STRING |
| ym:s:externalRefererPathLevel2 | Second level URL of external referrer. For example, in http://ya.ru/1/2/3/4.html , the second level URL is http://ya.ru/1/. | STRING |
| ym:s:externalRefererPathLevel3 | Third level URL of external referrer. For example, in http://ya.ru/1/2/3/4.html , the third level URL is http://ya.ru/1/2/. | STRING |
| ym:s:externalRefererPathLevel4 | Fourth level URL of external referrer. For example, in http://ya.ru/1/2/3/4.html , the fourth level URL is http://ya.ru/1/2/3/. | STRING |
| ym:s:externalRefererPathLevel5 | Fifth level URL of external referrer. For example, in http://ya.ru/1/2/3/4.html , the fifth level URL is http://ya.ru/1/2/3/4.html. | STRING |
| ym:s:from | From label. | STRING |
| ym:s:UTMCampaign | Name of ongoing ad campaign | STRING |
| ym:s:UTMContent | Ad | STRING |
| ym:s:UTMMedium | Marketing tool | STRING |
| ym:s:UTMSource | Source of click | STRING |
| ym:s:UTMTerm | Keywords | STRING |
| ym:s:openstatAd | Ad | STRING |
| ym:s:openstatCampaign | Ad campaign | STRING |
| ym:s:openstatService | Ad service | STRING |
| ym:s:openstatSource | Placement location | STRING |
| ym:s:hasGCLID | Tags present GCLID | STRING |
| ym:s:goal | Dimension by achieved goal. Allows you to group sessions by goal IDs | STRING |
| ym:s:pageViewsInterval | Number of page views in a visit or page depth, grouped by ranges. | STRING |
| ym:s:pageViews | Number of page views in a visit or page depth. Views exclude a page refresh in an interval of less than 15 seconds. | STRING |
| ym:s:visitDurationInterval | Time on site, divided into groups. | STRING |
| ym:s:visitDuration | Time on site in seconds. | STRING |
| ym:s:bounce | Was this visit a bounce taking into account bounce rate. If the page has been viewed for more than 15 seconds, then the visit is not considered a bounce. | STRING |
| ym:s:isRobot | The user is suspected to be a robot | STRING |
| ym:s:isTurboPage | Turbo page. | STRING |
| ym:s:startURL | Landing page. | STRING |
| ym:s:startURLProto | Landing page protocol. | STRING |
| ym:s:topLevelDomain | Upper level domain for landing page. | STRING |
| ym:s:startURLDomain | Landing page domain. | STRING |
| ym:s:startURLPathFull | Part of URL of landing page, comes immediately after the domain. Unlike simple path, it also contains parameters section and fragment | STRING |
| ym:s:startURLPath | Part of the landing page URL right after the domain up to ? (parameter section), # (fragment section) or up to the end of a string. For example, for the page http://news.yandex.ru/quotes/1.html the path is /quotes/1.html, for http://news.yandex.ru/ it is /, and forhttp://news.yandex.ru it is an empty string | STRING |
| ym:s:startURLPathLevel1 | First level URL of landing page. For example, in http://ya.ru/1/2/3/4.html , the first level URL is http://ya.ru/. | STRING |
| ym:s:startURLPathLevel2 | Second level URL of landing page. For example, in http://ya.ru/1/2/3/4.html , the second level URL is http://ya.ru/1/. | STRING |
| ym:s:startURLPathLevel3 | Third level URL of landing page. For example, in http://ya.ru/1/2/3/4.html , the third level URL is http://ya.ru/1/2/. | STRING |
| ym:s:startURLPathLevel4 | Fourth level URL of landing page. For example, in http://ya.ru/1/2/3/4.html , the fourth level URL is http://ya.ru/1/2/3/. | STRING |
| ym:s:startURLPathLevel5 | Fifth level URL of landing page. For example, in http://ya.ru/1/2/3/4.html , the fifth level URL is http://ya.ru/1/2/3/4.html. | STRING |
| ym:s:endURL | Exit page. | STRING |
| ym:s:endURLProto | Exit page protocol. | STRING |
| ym:s:endURLDomain | Exit page domain. | STRING |
| ym:s:endURLPathFull | Part of URL of exit page, comes immediately after the domain. Unlike simple path, it also contains parameters section and fragment | STRING |
| ym:s:endURLPath | Part of the exit page URL right after the domain up to? (parameter section), # (fragment section) or up to the end of a string. For example, for the page http://news.yandex.ru/quotes/1.html the path is /quotes/1.html, for http://news.yandex.ru/ it is /, and for http://news.yandex.ru it is an empty string | STRING |
| ym:s:endURLPathLevel1 | First level URL of exit page. For example, in http://ya.ru/1/2/3/4.html , the first level URL is http://ya.ru/. | STRING |
| ym:s:endURLPathLevel2 | Second level URL of exit page. For example, in http://ya.ru/1/2/3/4.html , the second level URL is http://ya.ru/1/. | STRING |
| ym:s:endURLPathLevel3 | Third level URL of exit page. For example, in http://ya.ru/1/2/3/4.html , the third level URL is http://ya.ru/1/2/. | STRING |
| ym:s:endURLPathLevel4 | Fourth level URL of exit page. For example, in http://ya.ru/1/2/3/4.html , the fourth level URL is http://ya.ru/1/2/3/. | STRING |
| ym:s:endURLPathLevel5 | Fifth level URL of exit page. For example, in http://ya.ru/1/2/3/4.html , the fifth level URL is http://ya.ru/1/2/3/4.html. | STRING |
| ym:s:paramsLevel1 | Session parameter, level 1. | STRING |
| ym:s:paramsLevel2 | Session parameter, level 2. | STRING |
| ym:s:paramsLevel3 | Session parameter, level 3. | STRING |
| ym:s:paramsLevel4 | Session parameter, level 4. | STRING |
| ym:s:paramsLevel5 | Session parameter, level 5. | STRING |
| ym:s:paramsLevel6 | Session parameter, level 6. | STRING |
| ym:s:paramsLevel7 | Session parameter, level 7. | STRING |
| ym:s:paramsLevel8 | Session parameter, level 8. | STRING |
| ym:s:paramsLevel9 | Session parameter, level 9. | STRING |
| ym:s:paramsLevel10 | Session parameter, level 10. | STRING |
| ym:s:date | Date of visit in format YYYY-MM-DD. | DATE |
| ym:s:dateTime | Date and time of the session in YYYY-MM-DD HH:mm:ss format (in the time zone of the tag). | DATE |
| ym:s:isNewUser | Is this the user's first visit. | STRING |
| ym:s:userVisitsInterval | Number of user's visits during entire data collection period, interval. | STRING |
| ym:s:userVisits | Number of user's visits during entire data collection period. | STRING |
| ym:s:daysSinceFirstVisitInterval | Number of days since user's first visit, interval. | STRING |
| ym:s:daysSinceFirstVisit | Number of days since visitor's first visit. | STRING |
| ym:s:daysSincePreviousVisitInterval | Number of days since the user's penultimate visit, interval. | STRING |
| ym:s:daysSincePreviousVisit | Number of days since visitor's penultimate visit. | STRING |
| ym:s:userVisitsPeriodInterval | Average number of days between visits, interval. | STRING |
| ym:s:userVisitsPeriod | Average number of days between visits. | STRING |
| ym:s:firstVisitDate | Date of visitor's first visit in the format YYYY-MM-DD. | DATE |
| ym:s:firstVisitDateTime | Date and time of visitor's first visit in the format YYYY-MM-DD HH:mm:ss. | DATE |
| ym:s:previousVisitDate | Date of visitor's previous visit in the format YYYY-MM-DD. | STRING |
| ym:s:gender | User's gender. | STRING |
| ym:s:ageInterval | User age, interval | STRING |
| ym:s:interest | Category of visitors' commercial interests. | STRING |
| ym:s:regionContinent | Continents where site users are located. | STRING |
| ym:s:regionCountry | Countries where site users are located. | STRING |
| ym:s:regionDistrict | Districts where site users are located. | STRING |
| ym:s:regionArea | Oblasts where site users are located. | STRING |
| ym:s:regionCity | Cities where site users are located. | STRING |
| ym:s:regionCitySize | City size by pop. | STRING |
| ym:s:browserLanguage | Browser language. | STRING |
| ym:s:browserCountry | Browser country. | STRING |
| ym:s:clientTimeZone | Time zone on user's computer. | STRING |
| ym:s:ipAddress | The user's IPv4/IPv6 address with last 1/8 bytes respectively reset to zero. For example, 77.88.21.0/2001:db8:85a3::. | STRING |
| ym:s:deviceCategory | The type of device used for the session. | STRING |
| ym:s:mobilePhone | Device manufacturer. | STRING |
| ym:s:mobilePhoneModel | Device model. | STRING |
| ym:s:operatingSystemRoot | Operating systems group. | STRING |
| ym:s:operatingSystem | Operating system (detailed). | STRING |
| ym:s:browser | User's browser. | STRING |
| ym:s:browserAndVersionMajor | Name and version of browser. | STRING |
| ym:s:browserAndVersion | Browser and its full version. | STRING |
| ym:s:cookieEnabled | Cookie. | STRING |
| ym:s:javaEnabled | Java present. | STRING |
| ym:s:javascriptEnabled | JavaScript present. | STRING |
| ym:s:hasAdBlocker | Presence of ad blockers. | STRING |
| ym:s:browserEngine | User's browser engine. | STRING |
| ym:s:browserEngineVersion1 | First number in user's browser engine version. | STRING |
| ym:s:browserEngineVersion2 | Second number in user's browser engine version. | STRING |
| ym:s:browserEngineVersion3 | Third number (usually the build number) of the user's browser engine version. | STRING |
| ym:s:browserEngineVersion4 | Fourth number (usually the revision number) of the user's browser engine version. | STRING |
| ym:s:flashEnabled | Presence of Flash. | STRING |
| ym:s:flashVersion | Flash version. | STRING |
| ym:s:flashMajor | Flash major. | STRING |
| ym:s:flashMinor | Flash minor. | STRING |
| ym:s:silverlightEnabled | Presence of silverlight. | STRING |
| ym:s:silverlight | Silverlight. | STRING |
| ym:s:silverlightMajor | Silverlight major. | STRING |
| ym:s:silverlightMinor | Silverlight minor. | STRING |
| ym:s:silverlightMinor2 | Silverlight minor 2. | STRING |
| ym:s:screenFormat | Ratio of screen width to height. For example, 16:9. | STRING |
| ym:s:screenColors | Depth of screen color in bytes. For example, 24. | STRING |
| ym:s:screenOrientation | Screen orientation. | STRING |
| ym:s:screenResolution | Screen resolution. For example, 1920х1080. | STRING |
| ym:s:screenWidth | Logical screen width. | STRING |
| ym:s:screenHeight | Logical screen height. | STRING |
| ym:s:physicalScreenResolution | Actual screen resolution based on data device pixel ratio. For example, 1920х1080. | STRING |
| ym:s:physicalScreenWidth | Physical width of screen based on device pixel ratio data. | STRING |
| ym:s:physicalScreenHeight | Physical screen height based on device pixel ratio data. | STRING |
| ym:s:windowClientArea | Size of the client's browser window, for example 1920х1080. | STRING |
| ym:s:windowClientWidth | Client browser window width. | STRING |
| ym:s:windowClientHeight | Client browser window height. | STRING |
| ym:s:productID | Item ID in order. | STRING |
| ym:s:productName | Name of item in order. | STRING |
| ym:s:productBrand | Brand of item in order. | STRING |
| ym:s:productVariant | Item version. | STRING |
| ym:s:productPosition | Item position. | STRING |
| ym:s:productPrice | Price of a single item. | STRING |
| ym:s:productSum | Price of item. | STRING |
| ym:s:productCurrency | Currency. | STRING |
| ym:s:purchaseID | ID of purchase. | STRING |
| ym:s:purchaseCoupon | Purchase promocode. | STRING |
| ym:s:purchaseRevenue | Revenue from purchase. | STRING |
| ym:s:productCategoryLevel1 | Item category, level 1. | STRING |
| ym:s:productCategoryLevel2 | Item category, level 2. | STRING |
| ym:s:productCategoryLevel3 | Item category, level 3. | STRING |
| ym:s:productCategoryLevel4 | Item category, level 4. | STRING |
| ym:s:productCategoryLevel5 | Item category, level 5. | STRING |
| ym:s:productCoupon | Item promocode. | STRING |
| ym:s:productIDCart | Item ID in basket. | STRING |
| ym:s:productNameCart | Name of item in basket. | STRING |
| ym:s:productBrandCart | Brand of item in basket. | STRING |
| ym:s:PProductID | Item ID in order. | STRING |
| ym:s:PProductName | Name of item in order. | STRING |
| ym:s:PProductBrand | Brand of item in order. | STRING |
| ym:s:purchaseExistsVisit | Presence of purchases in session. | STRING |
| ym:s:purchaseRevenueVisit | Purchase amount for the session. | STRING |
| ym:s:offlineCallTag | Tag label. | STRING |
| ym:s:offlineCallMissed | Missed/Answered. | STRING |
| ym:s:offlineCallFirstTimeCaller | First-time/Repeat. | STRING |
| ym:s:offlineCallHoldDuration | Waiting time. | STRING |
| ym:s:offlineCallTalkDuration | Duration of conversation. | STRING |
| ym:s:yanPageID | Ad site. | STRING |
| ym:s:yanBlockID | Ad block. | STRING |
| ym:s:yanUrl | Page with advertising events. | STRING |
| ym:s:yanUrlPathLevel1 | Page with advertising events, level 1. | STRING |
| ym:s:yanUrlPathLevel2 | Page with advertising events, level 2. | STRING |
| ym:s:yanUrlPathLevel3 | Page with advertising events, level 3. | STRING |
| ym:s:yanUrlPathLevel4 | Page with advertising events, level 4. | STRING |
| ym:pv:pageviews | Number of page views on the site in the reporting period. | FLOAT |
| ym:pv:users | Number of unique users. | FLOAT |
| ym:pv:pageviewsPerDay | Average page depth per day. | FLOAT |
| ym:pv:pageviewsPerHour | Average number of hits per hour | FLOAT |
| ym:pv:pageviewsPerMinute | Average number of hits per minute. | FLOAT |
| ym:pv:cookieEnabledPercentage | Percentage of sessions and hits with cookies enabled. | FLOAT |
| ym:pv:javaEnabledPercentage | Share of visits and hits with Java support. | FLOAT |
| ym:pv:jsEnabledPercentage | Percentage of sessions and hits with JavaScript support. | FLOAT |
| ym:pv:flashEnabledPercentage | Percentage of sessions and hits with Flash support. | FLOAT |
| ym:pv:silverlightEnabledPercentage | Share of visits and hits with Silverlight support. | FLOAT |
| ym:pv:mobilePercentage | Percentage of visits and hits made with mobile devices. | FLOAT |
| ym:pv:blockedPercentage | Percentage of sessions with ad blockers. | FLOAT |
| ym:pv:title | Page title. | STRING |
| ym:pv:URL | URL. | STRING |
| ym:pv:URLProto | Page protocol. | STRING |
| ym:pv:URLDomain | Domain page. | STRING |
| ym:pv:URLPathFull | Part of URL of page, comes immediately after the domain. Unlike simple path, it also contains parameters section and fragment | STRING |
| ym:pv:URLPath | Part of the page URL right after the domain up to? (parameter section), # (fragment section) or up to the end of a string. For example, for the page http://news.yandex.ru/quotes/1.html the path is /quotes/1.html, for http://news.yandex.ru/ it is /, and for http://news.yandex.ru it is an empty string | STRING |
| ym:pv:URLPathLevel1 | First level URL of page. For example, in http://ya.ru/1/2/3/4.html , the first level URL is http://ya.ru/. | STRING |
| ym:pv:URLPathLevel2 | Second level URL of page. For example, in http://ya.ru/1/2/3/4.html , the second level URL is http://ya.ru/1/. | STRING |
| ym:pv:URLPathLevel3 | Third level URL of page. For example, in http://ya.ru/1/2/3/4.html , the third level URL is http://ya.ru/1/2/ | STRING |
| ym:pv:URLPathLevel4 | Fourth level URL of page. For example, in http://ya.ru/1/2/3/4.html , the fourth level URL is http://ya.ru/1/2/3/. | STRING |
| ym:pv:URLPathLevel5 | Fifth level URL of landing page. For example, in http://ya.ru/1/2/3/4.html , the fifth level URL is http://ya.ru/1/2/3/4.html. | STRING |
| ym:pv:URLParamName | URL parameter. | STRING |
| ym:pv:URLParamNameAndValue | URL parameter value. | STRING |
| ym:pv:referer | Referrer URL | STRING |
| ym:pv:refererProto | Referrer protocol. | STRING |
| ym:pv:refererDomain | Referrer domain. | STRING |
| ym:pv:refererPathFull | Part of URL of referrer, comes immediately after the domain. Unlike simple path, it also contains parameters section and fragment. | STRING |
| ym:pv:refererPath | Part of the referrer URL right after the domain up to ? (parameter section), # (fragment section) or up to end of a string. For example, for the page http://news.yandex.ru/quotes/1.html the path is /quotes/1.html, for http://news.yandex.ru/ it is /, and for http://news.yandex.ru it is an empty string. | STRING |
| ym:pv:refererPathLevel1 | First level URL of referrer. For example, in http://ya.ru/1/2/3/4.html , the first level URL is http://ya.ru/. | STRING |
| ym:pv:refererPathLevel2 | Second level URL of referrer. For example, in http://ya.ru/1/2/3/4.html , the second level URL is http://ya.ru/1/. | STRING |
| ym:pv:refererPathLevel3 | Third level URL of referrer. For example, in http://ya.ru/1/2/3/4.html , the third level URL is http://ya.ru/1/2. | STRING |
| ym:pv:refererPathLevel4 | Fourth level of URL referrer. For example, in http://ya.ru/1/2/3/4.html , the fourth level URL is http://ya.ru/1/2/3/. | STRING |
| ym:pv:refererPathLevel5 | Fifth level URL of referrer. For example, in http://ya.ru/1/2/3/4.html , the fifth level URL is http://ya.ru/1/2/3/4.html. | STRING |
| ym:pv:from | From label. | STRING |
| ym:pv:UTMCampaign | Name of ongoing ad campaign | STRING |
| ym:pv:UTMContent | Ad | STRING |
| ym:pv:UTMMedium | Marketing toolxs | STRING |
| ym:pv:UTMSource | Source of click | STRING |
| ym:pv:UTMTerm | Keywords | STRING |
| ym:pv:openstatAd | Ad | STRING |
| ym:pv:openstatCampaign | Ad campaign | STRING |
| ym:pv:openstatService | Ad service | STRING |
| ym:pv:openstatSource | Placement location | STRING |
| ym:pv:hasGCLID | Tags present | STRING |
| ym:pv:date | Date of page view in the format YYYY-MM-DD. | DATE |
| ym:pv:dateTime | Date and time of page view in the format YYYY-MM-DD HH:mm:ss. | DATE |
| ym:pv:gender | User's gender. | STRING |
| ym:pv:ageInterval | User age, interval | STRING |
| ym:pv:regionContinent | Continents where site users are located. | STRING |
| ym:pv:regionCountry | Countries where site users are located. | STRING |
| ym:pv:regionDistrict | Districts where site users are located. | STRING |
| ym:pv:regionArea | Oblasts where site users are located. | STRING |
| ym:pv:regionCity | Cities where site users are located. | STRING |
| ym:pv:regionCitySize | City size by pop. | STRING |
| ym:pv:browserLanguage | Browser language. | STRING |
| ym:pv:browserCountry | Browser country. | STRING |
| ym:pv:clientTimeZone | Time zone on user's computer. | STRING |
| ym:pv:ipAddress | IP address. | STRING |
| ym:pv:deviceCategory | The type of device used for the session. | STRING |
| ym:pv:mobilePhone | Device manufacturer. | STRING |
| ym:pv:mobilePhoneModel | Device model. | STRING |
| ym:pv:operatingSystemRoot | Operating systems group. | STRING |
| ym:pv:operatingSystem | Operating system (detailed). | STRING |
| ym:pv:browser | User's browser. | STRING |
| ym:pv:browserAndVersionMajor | Name and version of browser. | STRING |
| ym:pv:browserAndVersion | Browser and its full version. | STRING |
| ym:pv:cookieEnabled | Cookie. | STRING |
| ym:pv:javaEnabled | Java present. | STRING |
| ym:pv:javascriptEnabled | JavaScript present. | STRING |
| ym:pv:hasAdBlocker | Presence of ad blockers. | STRING |
| ym:pv:browserEngine | User's browser engine. | STRING |
| ym:pv:browserEngineVersion1 | First number in user's browser engine version. | STRING |
| ym:pv:browserEngineVersion2 | Second number in user's browser engine version. | STRING |
| ym:pv:browserEngineVersion3 | Third number (usually the build number) of the user's browser engine version. | STRING |
| ym:pv:browserEngineVersion4 | Fourth number (usually the revision number) of the user's browser engine version. | STRING |
| ym:pv:flashEnabled | Flash present. | STRING |
| ym:pv:flashVersion | Flash version. | STRING |
| ym:pv:flashMajor | Flash major. | STRING |
| ym:pv:flashMinor | Flash minor. | STRING |
| ym:pv:screenFormat | Ratio of screen width to height. | STRING |
| ym:pv:screenColors | Depth of screen color in bytes. | STRING |
| ym:pv:screenOrientation | Screen orientation. | STRING |
| ym:pv:screenResolution | Screen resolution. | STRING |
| ym:pv:screenWidth | Logical screen width. | STRING |
| ym:pv:screenHeight | Logical screen height. | STRING |
| ym:pv:physicalScreenResolution | Actual screen resolution based on data device pixel ratio. | STRING |
| ym:pv:physicalScreenWidth | Physical width of screen based on device pixel ratio data. | STRING |
| ym:pv:physicalScreenHeight | Physical screen height based on device pixel ratio data. | STRING |
| ym:pv:windowClientArea | Size of the client's browser window. | STRING |
| ym:pv:windowClientWidth | Client browser window width. | STRING |
| ym:pv:windowClientHeight | Client browser window height. | STRING |
| ym:ad:visits | Total number of visits. | FLOAT |
| ym:ad:clicks | Total number of clicks on the ad. | FLOAT |
| ym:ad: | Total cost of clicks from Yandex.Direct. | FLOAT |
| ym:ad: | Average cost per click from Yandex.Direct. | FLOAT |
| ym:ad:goal | Cost Per Action: the quotient when the total click cost for paid visits is divided by the number of goals reached during visits. | FLOAT |
| ym:ad:goal | Average cost of a converted session from Yandex.Direct. | FLOAT |
| ym:ad:directOrder | Yandex.Direct ad campaign. | STRING |
| ym:ad:directBannerGroup | Yandex.Direct ad group. | STRING |
| ym:ad:directBanner | Yandex.Direct ad | STRING |
| ym:ad:directPhraseOrCond | Ad impression criteria. | STRING |
| ym:ad:directPlatformType | Type of Yandex.Direct ad site. | STRING |
| ym:ad:directPlatform | Yandex.Direct ad site. | STRING |
| ym:ad:directSearchPhrase | Keyword of last click by Yandex.Direct ad. | STRING |
| ym:ad:directConditionType | Type of ad impression criteria. | STRING |
| ym:ad:currency | Currency set in Yandex.Direct for ad campaigns. | STRING |
| ym:ad:displayCampaign | Yandex.Display order number. | STRING |
| ym:up:params | Number of parameters. | FLOAT |
| ym:up:users | Number of unique users. | FLOAT |
| ym:up:paramsLevel1 | Session parameter, level 1. | STRING |
| ym:up:paramsLevel2 | Session parameter, level 2. | STRING |
| ym:up:paramsLevel3 | Session parameter, level 3. | STRING |
| ym:up:paramsLevel4 | Session parameter, level 4. | STRING |
| ym:up:paramsLevel5 | Session parameter, level 5. | STRING |
Quotes and limits
Important note: Renta doesn’t provide any restrictions like amount of accounts, connectors, integrations or inserting date range.
Limits for Yandex Metrica:
- Number of requests from a single IP address – 30 per sec
Link to the official documentation
_______________________________________________
If you have any questions – please contact us!