Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Year | year | dim | |
| Year of week | yearOfWeek | dim | ||
| Year & month | yearMonth | dim | ||
| Month | month | dim | ||
| Year & week (Mon-Sun) | yearWeekIso | dim | ||
| Year & week (Sun-Sat) | yearWeek | dim | ||
| Week (Mon-Sun) | isoWeek | dim | ||
| Week (Sun-Sat) | week | dim | ||
| Day of week (Mon-Sun) | dayOfWeek | dim | ||
| Date | date | dim | ||
| Hour | hour | dim | ||
| Decaminute | dekaminute | dim | ||
| TRAFFIC SOURCE | First ad system | firstAdvEngine | dim | |
| First traffic source | firstTrafficSource | dim | ||
| First traffic source (detailed) | firstSourceEngine | dim | ||
| First referral traffic | firstReferalSource | dim | ||
| First Yandex.Direct campaign | firstDirectClickOrder | dim | ||
| Last ad system | lastAdvEngine | dim | ||
| Last traffic source | lastTrafficSource | dim | ||
| Last traffic source (detailed) | lastSourceEngine | dim | ||
| Last referral traffic | lastReferalSource | dim | ||
| Last Yandex.Direct campaign | lastDirectClickOrder | dim | ||
| Last significant ad system | lastsignAdvEngine | dim | ||
| Last significant traffic source | lastsignTrafficSource | dim | ||
| Last significant traffic source (detailed) | lastsignSourceEngine | dim | ||
| Last significant referral traffic | lastsignReferalSource | dim | ||
| Last significant Yandex.Direct campaign | lastsignDirectClickOrder | dim | ||
| REFERRER | Referrer | referer | dim | |
| Referrer protocol | refererProto | dim | ||
| Referrer domain | refererDomain | dim | ||
| Referrer path | refererPath | dim | ||
| Referer path (full) | refererPathFull | dim | ||
| Referrer, level 1 | refererPathLevel1 | dim | ||
| Referrer, level 2 | refererPathLevel2 | dim | ||
| Referrer, level 3 | refererPathLevel3 | dim | ||
| Referrer, level 4 | refererPathLevel4 | dim | ||
| Referrer, level 5 | refererPathLevel5 | dim | ||
| OUTSIDE REFERRER | External referer | externalReferer | dim | |
| External referrer protocol | externalRefererProto | dim | ||
| External referrer domain | externalRefererDomain | dim | ||
| External referrer path | externalRefererPath | dim | ||
| External referrer path (full) | externalRefererPathFull | dim | ||
| External referrer, level 1 | externalRefererPathLevel1 | dim | ||
| External referrer, level 2 | externalRefererPathLevel2 | dim | ||
| External referrer, level 3 | externalRefererPathLevel3 | dim | ||
| External referrer, level 4 | externalRefererPathLevel4 | dim | ||
| External referrer, level 5 | externalRefererPathLevel5 | dim | ||
| LOCATION | Continent | regionContinent | dim | |
| Country | regionCountry | dim | ||
| District | regionDistrict | dim | ||
| Area | regionArea | dim | ||
| City | regionCity | dim | ||
| City size | regionCitySize | dim | ||
| Browser language | browserLanguage | dim | ||
| Browser country | browserCountry | dim | ||
| Time zone on user's computer | clientTimeZone | dim | ||
| SESSION | Goal reached | goal | dim | |
| Page views (groups) | pageViewsInterval | dim | ||
| Page views | pageViewsDimension | dim | ||
| Robot | isRobotName | dim | ||
| Session parameter, level 1 | paramsLevel1 | dim | ||
| Session parameter, level 2 | paramsLevel2 | dim | ||
| Session parameter, level 3 | paramsLevel3 | dim | ||
| Session parameter, level 4 | paramsLevel4 | dim | ||
| Session parameter, level 5 | paramsLevel5 | dim | ||
| Session parameter, level 6 | paramsLevel6 | dim | ||
| Session parameter, level 7 | paramsLevel7 | dim | ||
| Session parameter, level 8 | paramsLevel8 | dim | ||
| Session parameter, level 9 | paramsLevel9 | dim | ||
| Session parameter, level 10 | paramsLevel10 | dim | ||
| ECOMMERCE | Item ID | productID | dim | |
| Item name | productName | dim | ||
| Brand | productBrand | dim | ||
| Item version | productVariant | dim | ||
| Item position | productPosition | dim | ||
| Price of a single item | productPrice | dim | ||
| Price of item | productSum | dim | ||
| Currency | productCurrency | dim | ||
| ID of purchase | purchaseID | dim | ||
| Purchase promocode | purchaseCoupon | dim | ||
| Revenue from purchase | purchaseRevenue | dim | ||
| Item category, level 1 | productCategoryLevel1 | dim | ||
| Item category, level 2 | productCategoryLevel2 | dim | ||
| Item category, level 3 | productCategoryLevel3 | dim | ||
| Item category, level 4 | productCategoryLevel4 | dim | ||
| Item category, level 5 | productCategoryLevel5 | dim | ||
| Item promocode | productCoupon | dim | ||
| Item ID of item in basket | productIDCart | dim | ||
| Name of item in basket | productNameCart | dim | ||
| Brand of item in basket | productBrandCart | dim | ||
| Item ID in order | PProductID | dim | ||
| Name of item in order | PProductName | dim | ||
| Brand of item in order | ym:s:PProductBrand | dim | ||
| Presence of purchases in session | purchaseExistsVisit | dim | ||
| Purchase amount for the session | purchaseRevenueVisit | dim | ||
| CONTENT | Page title | pageTitle | dim | |
| URL | pageURL | dim | ||
| Page protocol | pageURLProto | dim | ||
| Page domain | pageURLDomain | dim | ||
| Page path | pageURLPath | dim | ||
| Page path (full) | pageURLPathFull | dim | ||
| URL-address, level 1 | pageURLPathLevel1 | dim | ||
| URL-address, level 2 | pageURLPathLevel2 | dim | ||
| URL-address, level 3 | pageURLPathLevel3 | dim | ||
| URL-address, level 4 | pageURLPathLevel4 | dim | ||
| URL-address, level 5 | pageURLPathLevel5 | dim | ||
| URL parameter | pageURLParamName | dim | ||
| URL parameter value | pageURLParamNameAndValue | dim | ||
| Landing page | sessionStartURL | dim | ||
| Landing page protocol | sessionStartURLProto | dim | ||
| Upper level domain for landing page | sessionTopLevelDomain | dim | ||
| Landing page domain | sessionStartURLDomain | dim | ||
| Landing page path (full) | sessionStartURLPathFull | dim | ||
| Landing page path | sessionStartURLPath | dim | ||
| Landing page, level 1 | sessionStartURLPathLevel1 | dim | ||
| Landing page, level 2 | sessionStartURLPathLevel2 | dim | ||
| Landing page, level 3 | sessionStartURLPathLevel3 | dim | ||
| Landing page, level 4 | sessionStartURLPathLevel4 | dim | ||
| Landing page, level 5 | sessionStartURLPathLevel5 | dim | ||
| Exit page | sessionEndURL | dim | ||
| Exit page protocol | sessionEndURLProto | dim | ||
| Exit page domain | sessionEndURLDomain | dim | ||
| Exit page path (full) | sessionEndURLPathFull | dim | ||
| Exit page path | sessionEndURLPath | dim | ||
| Exit page, level 1 | sessionEndURLPathLevel1 | dim | ||
| Exit page, level 2 | sessionEndURLPathLevel2 | dim | ||
| Exit page, level 3 | sessionEndURLPathLevel3 | dim | ||
| Exit page, level 4 | sessionEndURLPathLevel4 | dim | ||
| Exit page, level 5 | sessionEndURLPathLevel5 | dim | ||
| BROWSER & NETWORK | Operating systems group | operatingSystemRoot | dim | |
| Operating system (detailed) | operatingSystem | dim | ||
| Browser | browser | dim | ||
| Browser version | browserAndVersionMajor | dim | ||
| Full browser version | browserAndVersion | dim | ||
| Cookies enabled | cookieEnabled | dim | ||
| Java present | javaEnabled | dim | ||
| JavaScript enabled | javascriptEnabled | dim | ||
| Browser engine | browserEngine | dim | ||
| Major-version of browser engine | browserEngineVersion1 | dim | ||
| Minor-version of browser engine | browserEngineVersion2 | dim | ||
| Build-version of browser engine | ym:s:browserEngineVersion3 | dim | ||
| Revision-version of browser engine | browserEngineVersion4 | dim | ||
| Flash enabled | flashEnabled | dim | ||
| Flash version | flashVersion | dim | ||
| Flash major version number | flashMajor | dim | ||
| Flash minor version number | flashMinor | dim | ||
| Silverlight present | silverlightEnabled | dim | ||
| Silverlight version | silverlight | dim | ||
| Silverlight major version number | silverlightMajor | dim | ||
| Silverlight average number version | silverlightMinor | dim | ||
| Silverlight minor version number | silverlightMinor2 | dim | ||
| Window size | windowClientArea | dim | ||
| Window width | windowClientWidth | dim | ||
| Window height | windowClientHeight | dim | ||
| DEVICE | Device type | deviceCategory | dim | |
| Device manufacturer | mobilePhone | dim | ||
| Device model | mobilePhoneModel | dim | ||
| Aspect ratio | screenFormat | dim | ||
| Color depth | screenColors | dim | ||
| Screen orientation | screenOrientation | dim | ||
| Resolution | screenResolution | dim | ||
| Logical width | screenWidth | dim | ||
| Logical height | screenHeight | dim | ||
| Actual resolution | physicalScreenResolution | dim | ||
| Physical width | physicalScreenWidth | dim | ||
| Physical height | physicalScreenHeight | dim | ||
| SEARCH | Keyword (Market) | marketSearchPhrase | dim | |
| First search engine | firstSearchEngineRoot | dim | ||
| First search engine (detailed) | firstSearchEngine | dim | ||
| First keyword | firstSearchPhrase | dim | ||
| Previous search engine (detailed) | prevSearchEngine | dim | ||
| Last search engine | lastSearchEngineRoot | dim | ||
| Last search engine (detailed) | lastSearchEngine | dim | ||
| Last keyword | lastSearchPhrase | dim | ||
| Last significant search engine | lastsignSearchEngineRoot | dim | ||
| Last significant engine (detailed) | lastsignSearchEngine | dim | ||
| Last significant keyword | lastsignSearchPhrase | dim | ||
| SOCIAL NETWORKS | First social network | firstSocialNetwork | dim | |
| First social networks group | firstSocialNetworkProfile | dim | ||
| Last social network | lastSocialNetwork | dim | ||
| Last social networks group | lastSocialNetworkProfile | dim | ||
| Last significant social network | lastsignSocialNetwork | dim | ||
| Last significant social networks group | lastsignSocialNetworkProfile | dim | ||
| USER/SESSION | Client ID | clientID | dim | |
| Gender | gender | dim | ||
| Age | ageInterval | dim | ||
| Category of interests | interest | dim | ||
| IP-address | ipAddress | dim | ||
| Time on site (groups) | visitDurationInterval | dim | ||
| Time on site (sec) | visitDuration | dim | ||
| Bounce | bounce | dim | ||
| Is this the user's first visit | isNewUser | dim | ||
| Sessions in history | userVisitsInterval | dim | ||
| Sessions in history (detailed) | userVisits | dim | ||
| Days since the first visit | daysSinceFirstVisitInterval | dim | ||
| Days since first session (detailed) | daysSinceFirstVisit | dim | ||
| Days since last visit | daysSincePreviousVisitInterval | dim | ||
| Time since previous session | daysSincePreviousVisit | dim | ||
| Frequency | userVisitsPeriodInterval | dim | ||
| Frequency (detailed) | userVisitsPeriod | dim | ||
| User parameter, level 1 | userParamsLevel1 | dim | ||
| User parameter, level 2 | userParamsLevel2 | dim | ||
| User parameter, level 3 | userParamsLevel3 | dim | ||
| User parameter, level 4 | userParamsLevel4 | dim | ||
| User parameter, level 5 | userParamsLevel5 | dim | ||
| VISIT | Year of first visit | firstVisitYear | dim | |
| Year of previous visit | previousVisitYear | dim | ||
| Year of penultimate visit | previousVisitStartOfYear | dim | ||
| Quarter of first visit | firstVisitStartOfQuarter | dim | ||
| Quarter of penultimate visit | previousVisitStartOfQuarter | dim | ||
| Month of first visit | firstVisitMonth | dim | ||
| Month of previous visit | previousVisitMonth | dim | ||
| Month of penultimate session | previousVisitStartOfMonth | dim | ||
| Week of first visit (Sun-Sat) | firstVisitStartOfWeek | dim | ||
| Week of first visit (Mon-Sun) | firstVisitStartOfIsoWeek | dim | ||
| Week of penultimate visit (Sun-Sat) | previousVisitStartOfWeek | dim | ||
| Week of penultimate visit (Mon-Sun) | previousVisitStartOfIsoWeek | dim | ||
| Date of first visit | firstVisitDate | dim | ||
| Date of previous visit | previousVisitDate | dim | ||
| Date and time of first visit | firstVisitDateTime | dim | ||
| Day of month of first visit | firstVisitDayOfMonth | dim | ||
| Day of month of previous visit | previousVisitDayOfMonth | dim | ||
| Day of week for first visit | firstVisitDayOfWeek | dim | ||
| Day of week of previous visit | previousVisitDayOfWeek | dim | ||
| Hour of first visit | firstVisitHour | dim | ||
| Hour and minute of first session | firstVisitHourMinute | dim | ||
| Decaminute of the first session | firstVisitDekaminute | dim | ||
| Minute of first visit | firstVisitMinute | dim | ||
| TAGS | From tags | from | dim | |
| UTM Campaign | UTMCampaign | dim | ||
| UTM Content | UTMContent | dim | ||
| UTM Medium | UTMMedium | dim | ||
| UTM Source | UTMSource | dim | ||
| UTM Term | UTMTerm | dim | ||
| Openstat Ad | openstatAd | dim | ||
| Openstat Campaign | openstatCampaign | dim | ||
| Openstat Service | openstatService | dim | ||
| Openstat Source | openstatSource | dim | ||
| GCLID presence | hasGCLID | dim | ||
| YANDEX.DISPLAY | First Yandex.Display order number | firstDisplayCampaign | dim | |
| Last Yandex.Display order number | lastDisplayCampaign | dim | ||
| Last significant Yandex.Display order number | lastsignDisplayCampaign | dim | ||
| YANDEX.DIRECT | First ad group | firstDirectBannerGroup | dim | |
| First Yandex.Direct ad | firstDirectClickBanner | dim | ||
| First ad impression criteria | firstDirectPhraseOrCond | dim | ||
| First site type | firstDirectPlatformType | dim | ||
| First site | firstDirectPlatform | dim | ||
| First keyword (Yandex.Direct) | firstDirectSearchPhrase | dim | ||
| First currency | firstCurrencyID | dim | ||
| First type of ad impression criteria | firstDirectConditionType | dim | ||
| Previous ad impression criteria | prevDirectPhraseOrCond | dim | ||
| Last ad group | lastDirectBannerGroup | dim | ||
| Last Yandex.Direct ad | lastDirectClickBanner | dim | ||
| Last ad impression criteria | lastDirectPhraseOrCond | dim | ||
| Last site | lastDirectPlatform | dim | ||
| Last significant ad group | lastsignDirectBannerGroup | dim | ||
| Last significant Yandex.Direct ad | lastsignDirectClickBanner | dim | ||
| Last significant ad impression criteria | lastsignDirectPhraseOrCond | dim | ||
| Last site type | lastDirectPlatformType | dim | ||
| Last currency | lastCurrencyID | dim | ||
| Last significant site type | lastsignDirectPlatformType | dim | ||
| Last significant site | lastsignDirectPlatform | dim | ||
| Last keyword (Yandex.Direct) | lastDirectSearchPhrase | dim | ||
| Last significant keyword (Yandex.Direct) | lastsignDirectSearchPhrase | dim | ||
| Last type of ad impression criteria | lastDirectConditionType | dim | ||
| Last signifcant type of ad impression criteria | lastsignDirectConditionType | dim | ||
| Last significant currency | lastsignCurrencyID | dim | ||
| Yandex.Direct campaign | directOrder | dim | ||
| Ad group | directBannerGroup | dim | ||
| Yandex.Direct ad | directBanner | dim | ||
| Ad impression criteria | directPhraseOrCond | dim | ||
| Site type | directPlatformType | dim | ||
| Site | directPlatform | dim | ||
| Keyword (Yandex.Direct) | directSearchPhrase | dim | ||
| Type of ad impression criteria | directConditionType | dim | ||
| Currency | directCurrency | dim | ||
| Yandex.Display order number | directDisplayCampaign | dim | ||
| SESSION | Inquiries | yanRequests | met | Requests advertising call code to, for example, the Yandex RTB system |
| Renderings | yanRenders | met | Requests to, for example, Yandex RTB-system, on which it was possible to successfully select ads for display (there were ads or banners that crossed the CPM threshold) | |
| Impressions | yanShows | met | A display is a display of an ad unit, ad or banner on a site page to its visitor. In the Yandex Advertising Network, ad impressions are determined by checking the visibility of ad units | |
| Estimated income | yanPartnerPrice | met | Estimated cost of ad impressions held in the selected report period. In rubles without VAT | |
| CPMV | yanCPMV | met | Cost per mille viewable ads, the cost of one thousand impressions of an ad unit taking into account the verification of the visibility of ad units. In rubles without VAT | |
| eCPM | yanECPM | met | Effective cost per mille, the cost of one thousand ad unit renderings. In rubles without VAT | |
| RPM | yanRPM | met | Revenue per mille, the cost of one thousand requests for all blocks, including those for which it was not possible to select ads. In rubles without VAT | |
| Impressions per rendering | yanVisibility | met | The ratio of the number of impressions to the number of renderings | |
| ARPU | yanARPU | met | Average revenue per user, average site revenue per site visitor. In rubles without VAT | |
| Renderings per visitor | yanRendersPerUser | met | The average number of renderings of YAN blocks per site visitor | |
| Estimated visit revenue | yanRevenuePerVisit | met | Average reward for displaying YAN blocks per visit. In rubles without VAT | |
| Browsing estimated income | yanRevenuePerHit | met | Average reward for displaying YAN blocks per page view. In rubles without VAT | |
| Renderings per visit | yanRendersPerVisit | met | The average number of renderings of YAN blocks in one visit to the site | |
| Renderings per pageview | yanRendersPerHit | met | The average number of renderings of YAN blocks per page view | |
| All goals reached | sumGoalReachesAny | met | Number of any conversions | |
| Conversion rate by any goal | anyGoalConversionRate | met | Conversion rate by any goal | |
| Page depth | pageDepth | met | ||
| Average page depth | avgPageDepth | met | ||
| Number of session parameters | sessionParamsNumber | met | ||
| Total session parameters | sessionSumParams | met | ||
| Average session parameters | sessionAvgParams | met | ||
| Affinity-index | sessionAffinityIndexInterests | met | ||
| GCLID percentage | sessionGCLIDPercentage | met | ||
| Robot percentage | robotPercentage | met | ||
| GOAL | Conversion per user | goalReachesPerUser | met | Average number of conversions per unique converted user |
| User conversion rate | goalUserConversionRate | met | Percentage of converted sessions among the total number of unique users | |
| Conversion rate | goalConversionRate | met | Share of conversions in the total number of visits | |
| Goals reached | goalReaches | met | Total number of conversions in all targeted visits | |
| Revenue | goalRevenue | met | Revenue | |
| Converted users | goalUsers | met | Number of unique users that reached goals | |
| Conversions | goalVisits | met | Number of converted sessions | |
| USER/SESSION | Sessions | visits | met | |
| Average time on site (sec) | avgVisitDurationSeconds | met | ||
| Average time on site (h:m:s) | avgVisitDurationHMS | met | ||
| Bounce rate | bounceRate | met | ||
| Parameters | userParams | met | ||
| ECOMMERCE | Item views | productImpressions | met | |
| Users who have viewed the item | productImpressionsUniq | met | ||
| Items added to basket | productBasketsQuantity | met | ||
| Price of items added to basket | productBasketsPrice | met | ||
| Number of users who added an item to their basket | productBasketsUniq | met | ||
| Items purchased | productPurchasedQuantity | met | ||
| Cost of items purchased | productPurchasedPrice | met | ||
| Number of users who bought items | productPurchasedUniq | met | ||
| Number of purchases | ecommercePurchases | met | ||
| Revenue | ecommerceRevenue | met | ||
| Average revenue per session | ecommerceRevenuePerVisit | met | ||
| Average revenue from purchase | ecommerceRevenuePerPurchase | met | ||
| BROWSER & NETWORK | Cookies enabled percentage | cookieEnabledPercentage | met | |
| Java enabled percentage | javaEnabledPercentage | met | ||
| JavaScript enabled percentage | jsEnabledPercentage | met | ||
| Flash enabled percentage | flashEnabledPercentage | met | ||
| Silverlight enabled | silverlightEnabledPercentage | met | ||
| Mobility percentage | mobilePercentage | met | ||
| CONTENT | Page views | pageviews | met | |
| Users | users | met | ||
| Page views in a day | pageviewsPerDay | met | ||
| Pageviews per hour | pageviewsPerHour | met | ||
| Pageviews per minute | pageviewsPerMinute | met | ||
| YANDEX.DIRECT | Clicks | directClicks | met | |
| Cost of clicks (BYN) | directBYNAdCost | met | ||
| Cost of clicks (EUR) | directEURAdCost | met | ||
| Cost of clicks (RUB) | directRUBAdCost | met | ||
| Cost of clicks (UAH) | directUAHAdCost | met | ||
| Cost of clicks (USD) | directUSDAdCost | met | ||
| Cost of clicks (YND) | directYNDAdCost | met | ||
| Average cost of session (BYN) | directBYNAdCostPerVisit | met | ||
| Average cost of session (EUR) | directEURAdCostPerVisit | met | ||
| Average cost of session (RUB) | directRUBAdCostPerVisit | met | ||
| Average cost of session (UAH) | directUAHAdCostPerVisit | met | ||
| Average cost of session (USD) | directUSDAdCostPerVisit | met | ||
| Average cost of session (YND) | directYNDAdCostPerVisit | met |