Yandex.Direct data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Table: AD

accountId
Display name Account ID
Field type dimension
Data type string.text.value
accountName
Display name Account name
Field type dimension
Data type string.text.value
AdFormat
Display name Ad format
Description Format of the ad impression: IMAGE — With an image, TEXT — A text ad, VIDEO — With video
Field type dimension
Data type string.text.value
AdGroupId
Display name Ad group ID
Description ID of the ad group
Field type dimension
Data type string.text.value
AdGroupName
Display name Ad group name
Description Name of the ad group
Field type dimension
Data type string.text.value
AdId
Display name Ad ID
Description The ad ID
Field type dimension
Data type string.text.value
AdNetworkType
Display name Ad network type
Description The type of advertising place where the ad is shown: SEARCH — In search results, AD_NETWORK — On ad networks
Field type dimension
Data type string.text.value
Age
Display name Age
Description The user‘s age group: one of the values AGE_0_17, AGE_18_24, AGE_25_34, AGE_35_44, AGE_45 or UNKNOWN
Field type dimension
Data type string.person.age
AvgClickPosition
Display name Avg. click position
Description Where the ad was clicked, Calculated using only clicks on the first page of Yandex search results. The top position is assigned the number 1
Field type metric
Data type float.number.value
AvgImpressionPosition
Display name Avg. impression position
Description Average display position of the ad. Calculated using only displays on the first page of Yandex search results. The top position is assigned the number 1
Field type metric
Data type float.number.value
AvgPageviews
Display name Avg. pageviews
Description The average session depth on the site, meaning the number of pages viewed
Field type metric
Data type int.number.value
Bounces
Display name Bounces
Description The number of bounces (according to Yandex.Metrica data)
Field type metric
Data type int.number.value
CampaignId
Display name Campaign ID
Description The campaign ID
Field type dimension
Data type string.text.value
CampaignName
Display name Campaign name
Description The campaign name
Field type dimension
Data type string.text.value
CampaignType
Display name Campaign type
Description The type of campaign: TEXT_CAMPAIGN, MOBILE_APP_CAMPAIGN, DYNAMIC_TEXT_CAMPAIGN
Field type dimension
Data type string.text.value
CarrierType
Display name Type of connection
Description The type of targeting criteria set by the advertiser
Field type dimension
Data type string.text.value
Clicks
Display name Clicks
Description The number of clicks
Field type metric
Data type int.number.value
Conversions
Display name Conversions
Description The number of conversions
Field type metric
Data type int.number.value
Cost
Display name Cost
Description Campaign cost in the account currency
Field type metric
Data type float.currency.value
CriterionType
Display name Targeting criteria type
Description The type of targeting criteria set by the advertiser
Field type dimension
Data type string.text.value
Currency
Display name Currency
Field type dimension
Data type string.currency.code
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Field type dimension
Data type string.time.date
ExternalNetworkName
Display name Ad exchange company name
Description The name of the ad exchange (SSP)
Field type dimension
Data type string.text.value
Gender
Display name Gender
Description The user‘s gender: GENDER_MALE, GENDER_FEMALE or UNKNOWN
Field type dimension
Data type string.person.gender
Impressions
Display name Impressions
Description Number of impressions
Field type metric
Data type int.number.value
LocationOfPresenceId
Display name User region ID
Description ID of the region where the user is located
Field type dimension
Data type string.geo.zip
LocationOfPresenceName
Display name User region name
Description Name of the region where the user is located
Field type dimension
Data type string.geo.region
MatchType
Display name Keyword match type
Description Keyword match type: RELATED_KEYWORD — Impression for a related keyword, SYNONYM — Impression for a keyword synonym, NONE — All other cases
Field type dimension
Data type string.text.value
MobilePlatform
Display name Operating system type
Description OS type: ANDROID, IOS, OTHER or UNKNOWN
Field type dimension
Data type string.text.value
Placement
Display name Ad placement website
Description Name of the site where the ad is being displayed
Field type dimension
Data type string.text.value
Revenue
Display name Revenue
Description Revenue (according to Yandex.Metrica data)
Field type metric
Data type float.currency.value
Sessions
Display name Sessions
Description Number of sessions. For mobile app ads, the number of clicks is shown as the number of visits
Field type metric
Data type int.number.value
Slot
Display name Ad display location in SERP
Description The ad display place: PREMIUMBLOCK — Premium Placement, OTHER — Other ad blocks
Field type dimension
Data type string.text.value
TargetingLocationId
Display name Targeting region ID
Description ID of the targeting region. If extended geo-targeting is used, it may differ from the region of the user's location
Field type dimension
Data type string.geo.zip
TargetingLocationName
Display name Targeting region name
Description Name of the targeting region
Field type dimension
Data type string.geo.region