Shopify data warehouse table groups

  • Updated on Oct 2, 2025
  • Published on Aug 5, 2025
Prev Next

Table: SALES

customer_city
Display name City
Description The city of the customer
Field type dimension
Data type string.geo.city
customer_country
Display name Country
Description The country of the customer
Field type dimension
Data type string.geo.country
customer_country_code
Display name Country code
Description The country code of the customer
Field type dimension
Data type string.geo.country.twolettercode
customer_created_at
Display name Account created datetime
Description The date and time the customer was added to the online store
Field type dimension
Data type string.time.datetime
customer_email
Display name Email
Description The email of the customer
Field type dimension
Data type string.text.email
customer_first_name
Display name First name
Description The first name of the customer
Field type dimension
Data type string.text.value
customer_id
Display name Customer ID
Description The unique identifier of the customer
Field type dimension
Data type string.text.value
customer_last_name
Display name Last name
Description The last name of the customer
Field type dimension
Data type string.text.value
customer_last_order_created_at
Display name Last order created datetime
Description The date and time the last order of the customer was created
Field type dimension
Data type string.time.datetime
customer_lifetime_duration
Display name Account age in days
Description The amount of days since the customer was first added to the online store
Field type dimension
Data type string.text.value
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
discounts
Display name Discounts
Description The total amount of discounts applied on the order
Field type metric
Data type float.currency.value
gross_sales
Display name Gross sales
Description The total price for the line item without any discounts applied
Field type metric
Data type float.currency.value
items
Display name Items
Description The amount of the line item. Please note that this field will be removed on 2025-01-30
Field type metric
Data type int.number.value
line_item_id
Display name Line item ID
Description ID of the line item row
Field type dimension
Data type string.text.value
line_item_is_gift_card
Display name Is gift card
Description Whether or not the line item is a gift card
Field type dimension
Data type bool
line_item_type
Display name Line item type
Description Type classification by Supermetrics. Possible values are "Product", "Refund", "Order adjustment", and "Shipping"
Field type dimension
Data type string.text.value
net_sales
Display name Net sales
Description The net sales of the line
Field type metric
Data type float.currency.value
order_cancelled_at
Display name Order cancelled datetime
Description The date and time of the order cancellation
Field type dimension
Data type string.time.datetime
order_channel
Display name Channel
Description The sales channel of the order
Field type dimension
Data type string.text.value
order_closed_at
Display name Order closed datetime
Description The date and time the order was closed
Field type dimension
Data type string.time.datetime
order_confirmed
Display name Order confirmed
Description Whether inventory has been reserved for the order
Field type dimension
Data type bool
order_created_at
Display name Order created datetime
Description The date and time the order was created
Field type dimension
Data type string.time.datetime
order_currency_code
Display name Currency
Description The currency code of the order
Field type dimension
Data type string.currency.code
order_discount_code
Display name Discount reason
Description The reason for the applied order's item-level discount
Field type dimension
Data type string.text.value
order_display_fulfillment_status
Display name Fulfillment status
Description Represents the order's current fulfillment status. Valid values are: unfulfilled, partial, fulfilled, restocked
Field type dimension
Data type string.text.value
order_email
Display name Order email
Description The email associated with the order
Field type dimension
Data type string.text.email
order_fully_paid
Display name Fully paid
Description Whether the order is fully paid or not
Field type dimension
Data type bool
order_id
Display name Order ID
Description The unique identifier of the order
Field type dimension
Data type string.text.value
order_is_returning_customer
Display name Is returning customer
Description Whether the customer is returning or not
Field type dimension
Data type bool
order_landing_page_url
Display name Landing page URL
Description The URL of the landing page
Field type dimension
Data type string.text.url
order_location
Display name Location name
Description The location name
Field type dimension
Data type string.text.value
order_name
Display name Order name
Description The name of the order
Field type dimension
Data type string.text.value
order_note
Display name Order note
Description The note on the order
Field type dimension
Data type string.text.value
order_referral_code
Display name Referral code
Description Referral code that led the customer making the order to the store. However this is set when a customer first enters the store. So if they have been to the store previously without a referral, then the referral code will stay empty even if they would later visit the store via a referral link
Field type dimension
Data type string.text.value
order_referrer_url
Display name Order referrer URL
Description The web page the customer clicked a link on that sent them to the online store that led to the order
Field type dimension
Data type string.text.url
order_shipping_description
Display name Shipping description
Description Description of the shipping selected for the order
Field type dimension
Data type string.text.value
order_utm_content
Display name UTM content
Description A/B testing and content-targeted ads to differentiate ads or links that point to the same URL
Field type dimension
Data type string.text.value
order_utm_medium
Display name UTM medium
Description The ad medium, such as email or cost-per-click (cpc)
Field type dimension
Data type string.text.value
order_utm_name
Display name UTM campaign name
Description The name that you give a promotion or campaign to identify it
Field type dimension
Data type string.text.value
order_utm_source
Display name UTM source
Description Identifies a search engine, a newsletter name, or other source
Field type dimension
Data type string.text.value
order_utm_term
Display name UTM term
Description The keywords associated with an ad
Field type dimension
Data type string.text.value
price
Display name Price
Description The price of the product
Field type dimension
Data type float.currency.value
product_id
Display name Product ID
Description The unique identifier of the product
Field type dimension
Data type string.text.value
returns
Display name Returns
Description The total amount refunded for the order
Field type metric
Data type float.currency.value
shipping
Display name Shipping
Description The total shipping amount including returns
Field type metric
Data type float.currency.value
shop_id
Display name Store ID
Description The unique identifier of the store
Field type dimension
Data type string.text.value
shop_name
Display name Store name
Description The name of the store
Field type dimension
Data type string.text.value
sku
Display name SKU
Description Variant SKU number
Field type dimension
Data type string.text.value
tax
Display name Tax
Description The total amount of tax for the line. Takes returns into account
Field type metric
Data type float.currency.value
total_sales
Display name Total sales
Description The total sales for line
Field type metric
Data type float.currency.value
variant_id
Display name Variant ID
Description The unique identifier of the product variant
Field type dimension
Data type string.text.value

Table: PRODUCT_LIST

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
description
Display name Description
Description Description of the product
Field type dimension
Data type string.text.value
image_src
Display name Image URL
Description The image URL of the product
Field type dimension
Data type string.text.url
price
Display name Price
Description The price of the product
Field type dimension
Data type float.currency.value
product_created_at
Display name Product created datetime
Description The date and time the product was created
Field type dimension
Data type string.time.datetime
product_id
Display name Product ID
Description The unique identifier of the product
Field type dimension
Data type string.text.value
sku
Display name SKU
Description Variant SKU number
Field type dimension
Data type string.text.value
title
Display name Product title
Description The title of the product
Field type dimension
Data type string.text.value
type
Display name Type
Description The type of the product
Field type dimension
Data type string.text.value
variant_id
Display name Variant ID
Description The unique identifier of the product variant
Field type dimension
Data type string.text.value
variant_title
Display name Variant title
Description The title of the product variant
Field type dimension
Data type string.text.value
vendor
Display name Vendor
Description The vendor of the product
Field type dimension
Data type string.text.value