Yandex.Metrica data warehouse table groups

Prev Next

Table: SESSIONS

ageInterval
bounce
browser
browserAndVersion
browserAndVersionMajor
browserCountry
browserEngine
browserEngineVersion1
browserEngineVersion2
browserEngineVersion4
browserLanguage
clientTimeZone
cookieEnabled
cookieEnabledPercentage
date
daysSinceFirstVisit
daysSinceFirstVisitInterval
daysSincePreviousVisit
daysSincePreviousVisitInterval
deviceCategory
ecommercePurchases
ecommerceRevenue
externalReferer
externalRefererDomain
externalRefererPath
externalRefererPathFull
externalRefererPathLevel1
externalRefererPathLevel2
externalRefererPathLevel3
externalRefererPathLevel4
externalRefererPathLevel5
externalRefererProto
firstAdvEngine
firstCurrencyID
firstDirectBannerGroup
firstDirectClickBanner
firstDirectClickOrder
firstDirectConditionType
firstDirectPhraseOrCond
firstDirectPlatform
firstDirectPlatformType
firstDirectSearchPhrase
firstDisplayCampaign
firstReferalSource
firstSearchEngine
firstSearchEngineRoot
firstSearchPhrase
firstSocialNetwork
firstSocialNetworkProfile
firstSourceEngine
firstTrafficSource
firstVisitDate
firstVisitDateTime
firstVisitDayOfMonth
firstVisitDayOfWeek
firstVisitDekaminute
firstVisitHour
firstVisitHourMinute
firstVisitMinute
firstVisitMonth
firstVisitStartOfIsoWeek
firstVisitStartOfQuarter
firstVisitStartOfWeek
firstVisitYear
flashEnabled
flashMajor
flashMinor
flashVersion
from
gender
goal
hasGCLID
interest
ipAddress
isNewUser
isRobotName
javaEnabled
javaEnabledPercentage
javascriptEnabled
jsEnabledPercentage
lastAdvEngine
lastCurrencyID
lastDirectBannerGroup
lastDirectClickBanner
lastDirectClickOrder
lastDirectConditionType
lastDirectPhraseOrCond
lastDirectPlatform
lastDirectPlatformType
lastDirectSearchPhrase
lastDisplayCampaign
lastReferalSource
lastSearchEngine
lastSearchEngineRoot
lastSearchPhrase
lastsignAdvEngine
lastsignCurrencyID
lastsignDirectBannerGroup
lastsignDirectClickBanner
lastsignDirectClickOrder
lastsignDirectConditionType
lastsignDirectPhraseOrCond
lastsignDirectPlatform
lastsignDirectPlatformType
lastsignDirectSearchPhrase
lastsignDisplayCampaign
lastsignReferalSource
lastsignSearchEngine
lastsignSearchEngineRoot
lastsignSearchPhrase
lastsignSocialNetwork
lastsignSocialNetworkProfile
lastsignSourceEngine
lastsignTrafficSource
lastSocialNetwork
lastSocialNetworkProfile
lastSourceEngine
lastTrafficSource
marketSearchPhrase
mobilePercentage
mobilePhone
mobilePhoneModel
openstatAd
openstatCampaign
openstatService
openstatSource
operatingSystem
operatingSystemRoot
pageDepth
pageviews
pageViewsDimension
pageViewsInterval
paramsLevel1
paramsLevel10
paramsLevel2
paramsLevel3
paramsLevel4
paramsLevel5
paramsLevel6
paramsLevel7
paramsLevel8
paramsLevel9
physicalScreenHeight
physicalScreenResolution
physicalScreenWidth
PProductID
PProductName
prevDirectPhraseOrCond
previousVisitDate
previousVisitDayOfMonth
previousVisitDayOfWeek
previousVisitMonth
previousVisitStartOfIsoWeek
previousVisitStartOfMonth
previousVisitStartOfQuarter
previousVisitStartOfWeek
previousVisitStartOfYear
previousVisitYear
prevSearchEngine
productBasketsPrice
productBasketsQuantity
productBasketsUniq
productBrand
productBrandCart
productCategoryLevel1
productCategoryLevel2
productCategoryLevel3
productCategoryLevel4
productCategoryLevel5
productCoupon
productCurrency
productID
productIDCart
productImpressions
productImpressionsUniq
productName
productNameCart
productPosition
productPrice
productPurchasedPrice
productPurchasedQuantity
productPurchasedUniq
productSum
productVariant
purchaseCoupon
purchaseExistsVisit
purchaseID
purchaseRevenue
purchaseRevenueVisit
referer
refererDomain
refererPath
refererPathFull
refererPathLevel1
refererPathLevel2
refererPathLevel3
refererPathLevel4
refererPathLevel5
refererProto
regionArea
regionCity
regionCitySize
regionContinent
regionCountry
regionDistrict
robotPercentage
screenColors
screenFormat
screenHeight
screenOrientation
screenResolution
screenWidth
sessionAffinityIndexInterests
sessionEndURL
sessionEndURLDomain
sessionEndURLPath
sessionEndURLPathFull
sessionEndURLPathLevel1
sessionEndURLPathLevel2
sessionEndURLPathLevel3
sessionEndURLPathLevel4
sessionEndURLPathLevel5
sessionEndURLProto
sessionGCLIDPercentage
sessionParamsNumber
sessionStartURL
sessionStartURLDomain
sessionStartURLPath
sessionStartURLPathFull
sessionStartURLPathLevel1
sessionStartURLPathLevel2
sessionStartURLPathLevel3
sessionStartURLPathLevel4
sessionStartURLPathLevel5
sessionStartURLProto
sessionSumParams
sessionTopLevelDomain
silverlight
silverlightEnabled
silverlightEnabledPercentage
silverlightMajor
silverlightMinor
silverlightMinor2
users
userVisits
userVisitsInterval
userVisitsPeriod
userVisitsPeriodInterval
UTMCampaign
UTMContent
UTMMedium
UTMSource
UTMTerm
visitDuration
visitDurationInterval
visits
windowClientArea
windowClientHeight
windowClientWidth
ym:s:browserEngineVersion3
ym:s:PProductBrand

Table: PAGEVIEWS

ageInterval
browser
browserAndVersion
browserAndVersionMajor
browserCountry
browserEngine
browserEngineVersion1
browserEngineVersion2
browserEngineVersion4
browserLanguage
clientTimeZone
cookieEnabled
cookieEnabledPercentage
date
deviceCategory
flashEnabled
flashEnabledPercentage
flashMajor
flashMinor
flashVersion
from
gender
hasGCLID
ipAddress
javaEnabled
javaEnabledPercentage
javascriptEnabled
jsEnabledPercentage
mobilePercentage
mobilePhone
mobilePhoneModel
openstatAd
openstatCampaign
openstatService
openstatSource
operatingSystem
operatingSystemRoot
pageTitle
pageURL
pageURLDomain
pageURLParamName
pageURLParamNameAndValue
pageURLPath
pageURLPathFull
pageURLPathLevel1
pageURLPathLevel2
pageURLPathLevel3
pageURLPathLevel4
pageURLPathLevel5
pageURLProto
pageviews
pageviewsPerDay
pageviewsPerHour
pageviewsPerMinute
physicalScreenHeight
physicalScreenResolution
physicalScreenWidth
referer
refererDomain
refererPath
refererPathFull
refererPathLevel1
refererPathLevel2
refererPathLevel3
refererPathLevel4
refererPathLevel5
refererProto
regionArea
regionCity
regionCitySize
regionContinent
regionCountry
regionDistrict
screenColors
screenFormat
screenHeight
screenOrientation
screenResolution
screenWidth
silverlight
silverlightEnabled
silverlightMajor
silverlightMinor
silverlightMinor2
users
UTMCampaign
UTMContent
UTMMedium
UTMSource
UTMTerm
windowClientArea
windowClientHeight
windowClientWidth
ym:s:browserEngineVersion3

Table: USER_PARAMETERS

date
userParams
userParamsLevel1
userParamsLevel2
userParamsLevel3
userParamsLevel4
userParamsLevel5
users

Table: YANDEX_DIRECT

date
directBanner
directBannerGroup
directBYNAdCost
directBYNAdCostPerVisit
directClicks
directConditionType
directCurrency
directDisplayCampaign
directEURAdCost
directEURAdCostPerVisit
directOrder
directPhraseOrCond
directPlatform
directPlatformType
directRUBAdCost
directRUBAdCostPerVisit
directSearchPhrase
directUAHAdCost
directUAHAdCostPerVisit
directUSDAdCost
directUSDAdCostPerVisit
directYNDAdCost
directYNDAdCostPerVisit
visits