--- title: "Prisjakt metrics and dimensions" slug: "prisjakt-fields" description: "Explore the Prisjakt metrics and dimensions available through Supermetrics. Find every data field you need to build your marketing reports." updated: 2026-03-05T14:13:41Z published: 2026-03-05T14:13:41Z canonical: "docs.supermetrics.com/prisjakt-fields" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt > Use this file to discover all available pages before exploring further. # Prisjakt metrics and dimensions > Supermetrics brings all your Prisjakt data into [Google Sheets](https://workspace.google.com/marketplace/app/supermetrics/523876908005), [Looker Studio](https://supermetrics.com/products/looker-studio), [Power BI](https://supermetrics.com/products/power-bi), [Excel](https://supermetrics.com/products/excel), [BigQuery](https://supermetrics.com/products/bigquery), [Snowflake](https://supermetrics.com/products/snowflake), [Redshift](https://supermetrics.com/products/amazon-redshift), [Azure](https://supermetrics.com/products/azure-synapse) 2 metrics23 dimensionsSearch fields ### COST | \| cost \| \| --- \| \| \\| Field label \\| Cost \\| \\| --- \\| --- \\| \\| Description \\| The cost including discounts \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Cost \| \| Description \| The cost including discounts \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | --- | | cost | | \| Field label \| Cost \| \| --- \| --- \| \| Description \| The cost including discounts \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Cost | | Description | The cost including discounts | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | ### DATASOURCE | \| dataSourceName \| \| --- \| \| \\| Field label \\| 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](/apidocs/field-data-types#text) \\| \\| Destinations \\| API, Data warehouse \\| \| \| Field label \| 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](/apidocs/field-data-types#text) \| \| Destinations \| API, Data warehouse \| | | --- | | dataSourceName | | \| Field label \| 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](/apidocs/field-data-types#text) \| \| Destinations \| API, Data warehouse \| | | Field label | 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](/apidocs/field-data-types#text) | | Destinations | API, Data warehouse | | \| system_metadata.data_source_logins \| \| --- \| \| \\| Field label \\| Data source logins \\| \\| --- \\| --- \\| \\| Description \\| The data source login accounts that were used to authenticate against the data source \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Data source logins \| \| Description \| The data source login accounts that were used to authenticate against the data source \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | system_metadata.data_source_logins | | \| Field label \| Data source logins \| \| --- \| --- \| \| Description \| The data source login accounts that were used to authenticate against the data source \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | Field label | Data source logins | | Description | The data source login accounts that were used to authenticate against the data source | | Field type | dimension | | Data type | [string.text.json](/apidocs/field-data-types#text) | | \| system_metadata.data_source_login_owners \| \| --- \| \| \\| Field label \\| Data source login owners \\| \\| --- \\| --- \\| \\| Description \\| The Supermetrics users that created the data source login connections \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Data source login owners \| \| Description \| The Supermetrics users that created the data source login connections \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | system_metadata.data_source_login_owners | | \| Field label \| Data source login owners \| \| --- \| --- \| \| Description \| The Supermetrics users that created the data source login connections \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | Field label | Data source login owners | | Description | The Supermetrics users that created the data source login connections | | Field type | dimension | | Data type | [string.text.json](/apidocs/field-data-types#text) | ### MARKET | \| market \| \| --- \| \| \\| Field label \\| Market \\| \\| --- \\| --- \\| \\| Description \\| The shop's market \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Market \| \| Description \| The shop's market \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | market | | \| Field label \| Market \| \| --- \| --- \| \| Description \| The shop's market \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Market | | Description | The shop's market | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| segment \| \| --- \| \| \\| Field label \\| Segment \\| \\| --- \\| --- \\| \\| Description \\| Segment name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Segment \| \| Description \| Segment name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | segment | | \| Field label \| Segment \| \| --- \| --- \| \| Description \| Segment name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Segment | | Description | Segment name | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| currency \| \| --- \| \| \\| Field label \\| Currency \\| \\| --- \\| --- \\| \\| Description \\| Currency \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Currency \| \| Description \| Currency \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | currency | | \| Field label \| Currency \| \| --- \| --- \| \| Description \| Currency \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | Field label | Currency | | Description | Currency | | Field type | dimension | | Data type | [string.currency.code](/apidocs/field-data-types#currency) | ### PERFORMANCE | \| clicks \| \| --- \| \| \\| Field label \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| The number of clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Clicks \| \| Description \| The number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | --- | | clicks | | \| Field label \| Clicks \| \| --- \| --- \| \| Description \| The number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Clicks | | Description | The number of clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | ### PRODUCT | \| product_name \| \| --- \| \| \\| Field label \\| Product name \\| \\| --- \\| --- \\| \\| Description \\| Name of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product name \| \| Description \| Name of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | product_name | | \| Field label \| Product name \| \| --- \| --- \| \| Description \| Name of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Product name | | Description | Name of the product | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| product_id \| \| --- \| \| \\| Field label \\| Product ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product ID \| \| Description \| ID of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | product_id | | \| Field label \| Product ID \| \| --- \| --- \| \| Description \| ID of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Product ID | | Description | ID of the product | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| category_name \| \| --- \| \| \\| Field label \\| Category name \\| \\| --- \\| --- \\| \\| Description \\| Name of the category \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Category name \| \| Description \| Name of the category \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | category_name | | \| Field label \| Category name \| \| --- \| --- \| \| Description \| Name of the category \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Category name | | Description | Name of the category | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| category_id \| \| --- \| \| \\| Field label \\| Category ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the category \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Category ID \| \| Description \| ID of the category \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | category_id | | \| Field label \| Category ID \| \| --- \| --- \| \| Description \| ID of the category \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Category ID | | Description | ID of the category | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### QUERY | \| system_metadata.query_date_range_start \| \| --- \| \| \\| Field label \\| Start date \\| \\| --- \\| --- \\| \\| Description \\| The start date of the requested query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Start date \| \| Description \| The start date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | --- | | system_metadata.query_date_range_start | | \| Field label \| Start date \| \| --- \| --- \| \| Description \| The start date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Start date | | Description | The start date of the requested query | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| system_metadata.query_date_range_end \| \| --- \| \| \\| Field label \\| End date \\| \\| --- \\| --- \\| \\| Description \\| The end date of the requested query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| End date \| \| Description \| The end date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | system_metadata.query_date_range_end | | \| Field label \| End date \| \| --- \| --- \| \| Description \| The end date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | End date | | Description | The end date of the requested query | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| system_metadata.query_timezone \| \| --- \| \| \\| Field label \\| Timezone \\| \\| --- \\| --- \\| \\| Description \\| The timezone that is supplied to the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.timezone](/apidocs/field-data-types#time) \\| \| \| Field label \| Timezone \| \| Description \| The timezone that is supplied to the query \| \| Field type \| dimension \| \| Data type \| [string.time.timezone](/apidocs/field-data-types#time) \| | | system_metadata.query_timezone | | \| Field label \| Timezone \| \| --- \| --- \| \| Description \| The timezone that is supplied to the query \| \| Field type \| dimension \| \| Data type \| [string.time.timezone](/apidocs/field-data-types#time) \| | | Field label | Timezone | | Description | The timezone that is supplied to the query | | Field type | dimension | | Data type | [string.time.timezone](/apidocs/field-data-types#time) | | \| system_metadata.query_filters \| \| --- \| \| \\| Field label \\| Filters \\| \\| --- \\| --- \\| \\| Description \\| All filters used in the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Filters \| \| Description \| All filters used in the query \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | system_metadata.query_filters | | \| Field label \| Filters \| \| --- \| --- \| \| Description \| All filters used in the query \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | Field label | Filters | | Description | All filters used in the query | | Field type | dimension | | Data type | [string.text.json](/apidocs/field-data-types#text) | | \| system_metadata.query_date_start \| \| --- \| \| \\| Field label \\| Start \\| \\| --- \\| --- \\| \\| Description \\| When the query was started \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Start \| \| Description \| When the query was started \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | system_metadata.query_date_start | | \| Field label \| Start \| \| --- \| --- \| \| Description \| When the query was started \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Start | | Description | When the query was started | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| system_metadata.query_date_end \| \| --- \| \| \\| Field label \\| End \\| \\| --- \\| --- \\| \\| Description \\| When the query completed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| End \| \| Description \| When the query completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | system_metadata.query_date_end | | \| Field label \| End \| \| --- \| --- \| \| Description \| When the query completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | End | | Description | When the query completed | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| system_metadata.query_duration \| \| --- \| \| \\| Field label \\| Duration \\| \\| --- \\| --- \\| \\| Description \\| The duration in seconds of the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.duration.seconds](/apidocs/field-data-types#duration) \\| \| \| Field label \| Duration \| \| Description \| The duration in seconds of the query \| \| Field type \| dimension \| \| Data type \| [int.duration.seconds](/apidocs/field-data-types#duration) \| | | system_metadata.query_duration | | \| Field label \| Duration \| \| --- \| --- \| \| Description \| The duration in seconds of the query \| \| Field type \| dimension \| \| Data type \| [int.duration.seconds](/apidocs/field-data-types#duration) \| | | Field label | Duration | | Description | The duration in seconds of the query | | Field type | dimension | | Data type | [int.duration.seconds](/apidocs/field-data-types#duration) | | \| system_metadata.query_accounts \| \| --- \| \| \\| Field label \\| Accounts \\| \\| --- \\| --- \\| \\| Description \\| A list of accounts of which the data was pulled from \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Accounts \| \| Description \| A list of accounts of which the data was pulled from \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | system_metadata.query_accounts | | \| Field label \| Accounts \| \| --- \| --- \| \| Description \| A list of accounts of which the data was pulled from \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | Field label | Accounts | | Description | A list of accounts of which the data was pulled from | | Field type | dimension | | Data type | [string.text.json](/apidocs/field-data-types#text) | | \| system_metadata.query_excluded_accounts \| \| --- \| \| \\| Field label \\| Excluded invalid accounts \\| \\| --- \\| --- \\| \\| Description \\| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Excluded invalid accounts \| \| Description \| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | system_metadata.query_excluded_accounts | | \| Field label \| Excluded invalid accounts \| \| --- \| --- \| \| Description \| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | Field label | Excluded invalid accounts | | Description | A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting | | Field type | dimension | | Data type | [string.text.json](/apidocs/field-data-types#text) | ### SHOP | \| shop_name \| \| --- \| \| \\| Field label \\| Shop Name \\| \\| --- \\| --- \\| \\| Description \\| Name of the shop \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shop Name \| \| Description \| Name of the shop \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | shop_name | | \| Field label \| Shop Name \| \| --- \| --- \| \| Description \| Name of the shop \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Shop Name | | Description | Name of the shop | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| shop_id \| \| --- \| \| \\| Field label \\| Shop ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the shop \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shop ID \| \| Description \| ID of the shop \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | shop_id | | \| Field label \| Shop ID \| \| --- \| --- \| \| Description \| ID of the shop \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Shop ID | | Description | ID of the shop | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### TIME | \| today \| \| --- \| \| \\| Field label \\| Today \\| \\| --- \\| --- \\| \\| Description \\| Today's date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \\| Destinations \\| API, Data warehouse \\| \| \| Field label \| Today \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| \| Destinations \| API, Data warehouse \| | | --- | | today | | \| Field label \| Today \| \| --- \| --- \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| \| Destinations \| API, Data warehouse \| | | Field label | Today | | Description | Today's date, e.g. 2017-01-31 | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | Destinations | API, Data warehouse | | \| year_month \| \| --- \| \| \\| Field label \\| Year & Month \\| \\| --- \\| --- \\| \\| Description \\| Year and month \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & Month \| \| Description \| Year and month \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| | | year_month | | \| Field label \| Year & Month \| \| --- \| --- \| \| Description \| Year and month \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| | | Field label | Year & Month | | Description | Year and month | | Field type | dimension | | Data type | [string.time.yearmonth](/apidocs/field-data-types#time) |