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 | ||
Quarter | quarter | 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 | ||
ACCOUNT | Account ID | accountId | dim | |
Account name | accountName | dim | ||
Currency | Currency | dim | ||
CAMPAIGN | Campaign ID | CampaignId | dim | The campaign ID |
Campaign name | CampaignName | dim | The campaign name | |
Campaign type | CampaignType | dim | The type of campaign: TEXT_CAMPAIGN, MOBILE_APP_CAMPAIGN, DYNAMIC_TEXT_CAMPAIGN | |
AD | Ad format | AdFormat | dim | Format of the ad impression: IMAGE — With an image, TEXT — A text ad, VIDEO — With video |
Ad group ID | AdGroupId | dim | ID of the ad group | |
Ad group name | AdGroupName | dim | Name of the ad group | |
Ad ID | AdId | dim | The ad ID | |
Ad network type | AdNetworkType | dim | The type of advertising place where the ad is shown: SEARCH — In search results, AD_NETWORK — On ad networks | |
Ad destination URL | Href | dim | Link to the advertiser's website | |
TARGET GROUP | Targeting criteria | Criterion | dim | The name or text of the targeting criteria set by the advertiser |
Targeting criteria ID | CriterionId | dim | The ID of the targeting criteria set by the advertiser | |
Targeting criteria type | CriterionType | dim | The type of targeting criteria set by the advertiser | |
Retargeting list | RlAdjustmentId | dim | ID of a retargeting list used for applying bid adjustments for website users | |
USER | Age | Age | dim | 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 |
Gender | Gender | dim | The user‘s gender: GENDER_MALE, GENDER_FEMALE or UNKNOWN | |
LOCATION | User region ID | LocationOfPresenceId | dim | ID of the region where the user is located |
User region name | LocationOfPresenceName | dim | Name of the region where the user is located | |
Targeting region ID | TargetingLocationId | dim | ID of the targeting region. If extended geo-targeting is used, it may differ from the region of the user's location | |
Targeting region name | TargetingLocationName | dim | Name of the targeting region | |
KEYWORDS | Matched keyword | MatchedKeyword | dim | The matched keyword |
Keyword match type | MatchType | dim | Keyword match type: RELATED_KEYWORD — Impression for a related keyword, SYNONYM — Impression for a keyword synonym, NONE — All other cases | |
DEVICE | User device type | Device | dim | The type of device the ad was shown on: DESKTOP, MOBILE or TABLET |
Operating system type | MobilePlatform | dim | OS type: ANDROID, IOS, OTHER or UNKNOWN | |
Type of connection | CarrierType | dim | The type of targeting criteria set by the advertiser | |
DISPLAY | Ad display location in SERP | Slot | dim | The ad display place: PREMIUMBLOCK — Premium Placement, OTHER — Other ad blocks |
Ad placement website | Placement | dim | Name of the site where the ad is being displayed | |
Part of the ad clicked | ClickType | dim | The type of connection: CELLULAR — Mobile connection, STATIONARY — Wi-Fi or wired internet access, UNKNOWN — The type couldn‘t be detected | |
Ad exchange company name | ExternalNetworkName | dim | The name of the ad exchange (SSP) | |
AD METRICS | Impressions | Impressions | met | Number of impressions |
Clicks | Clicks | met | The number of clicks | |
Cost | Cost | met | Campaign cost in the account currency | |
Cost (EUR) | Cost_eur | met | Campaign cost converted to euros | |
Cost (GBP) | Cost_gbp | met | Campaign cost converted to British pounds | |
Cost (USD) | Cost_usd | met | Campaign cost converted to US dollars | |
CTR (%) | Ctr | met | CTR as a percent | |
Avg. click position | AvgClickPosition | met | 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 | |
CPC | AvgCpc | met | Average cost per click | |
Avg. impression position | AvgImpressionPosition | met | 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 | |
Weight impressions | WeightedImpressions | met | WeightedImpressions = Impressions × AvgTrafficVolume / 100 | |
SITE METRICS | Bounce rate (%) | BounceRate_perc | met | The percentage of bounces in the total number of sessions (according to Yandex.Metrica data) |
Bounces | Bounces | met | The number of bounces (according to Yandex.Metrica data) | |
Sessions | Sessions | met | Number of sessions. For mobile app ads, the number of clicks is shown as the number of visits | |
Avg. pageviews | AvgPageviews | met | The average session depth on the site, meaning the number of pages viewed | |
CONVERSIONS | Conversion rate (%) | ConversionRate_perc | met | Conversions as a percent of the total number of sessions |
Conversions | Conversions | met | The number of conversions | |
Cost per conversion | CostPerConversion | met | The average cost of reaching a goal (according to Yandex.Metrica data): the ratio of the cost of clicks to the number of conversions | |
Revenue | Revenue | met | Revenue (according to Yandex.Metrica data) | |
Profit | Profit | met | Calculated as the total revenue for goals minus the cost of clicks | |
Return on investment | GoalsRoi | met | The return on investment in advertising, up to two decimal places |