Prisjakt fields

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Prisjakt data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

2 metrics22 dimensions

COST

cost
Field label Cost
Description The cost including discounts
Field type metric
Data type float.currency.value

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
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
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

MARKET

market
Field label Market
Description The shop's market
Field type dimension
Data type string.text.value
segment
Field label Segment
Description Segment name
Field type dimension
Data type string.text.value
currency
Field label Currency
Description Currency
Field type dimension
Data type string.currency.code

PERFORMANCE

clicks
Field label Clicks
Description The number of clicks
Field type metric
Data type int.number.value

PRODUCT

product_name
Field label Product name
Description Name of the product
Field type dimension
Data type string.text.value
product_id
Field label Product ID
Description ID of the product
Field type dimension
Data type string.text.value
category_name
Field label Category name
Description Name of the category
Field type dimension
Data type string.text.value
category_id
Field label Category ID
Description ID of the category
Field type dimension
Data type string.text.value

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
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
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
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

SHOP

shop_name
Field label Shop Name
Description Name of the shop
Field type dimension
Data type string.text.value
shop_id
Field label Shop ID
Description ID of the shop
Field type dimension
Data type string.text.value

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year_month
Field label Year & Month
Description Year and month
Field type dimension
Data type string.time.yearmonth