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 | |
| Query | Start date | system_metadata.query_date_range_start | dim | The start date of the requested query |
| End date | system_metadata.query_date_range_end | dim | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | dim | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | dim | All filters used in the query | |
| Start | system_metadata.query_date_start | dim | When the query was started | |
| End | system_metadata.query_date_end | dim | When the query completed | |
| Duration | system_metadata.query_duration | dim | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | dim | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | dim | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | dim | The Supermetrics users that created the data source login connections |