HomeIntegrationsShopify Reporting ToolShopify Metrics and Dimensions

Shopify Metrics and Dimensions

Field group	Field	Type	Data type	Description
Sales	Total sales amount	METRIC	FLOAT	The total sales of order amount
Sales	Gross sales amount	METRIC	FLOAT	The total price for order and lineItem without any discounts applied
Sales	Discount amount	METRIC	FLOAT	The total amount of discounts applied on the order and line
Sales	Refund amount	METRIC	FLOAT	The total amount refunded for the order
Sales	Net sales amount	METRIC	FLOAT	The net sales of the Order
Sales	Shipping amount	METRIC	FLOAT	The total shipping amount including returns
Sales	Tax amount	METRIC	FLOAT	The total amount of tax for the order & line. Takes returns into account
Sales	Tips	METRIC	FLOAT	The total tips received.
Sales	Duties	METRIC	FLOAT	The total amount of duties based on the orders. Duties appear by default only on applicable reports for stores that have enabled the collection of duties and import tax at checkout.
Sales	Gross profit	METRIC	FLOAT	The amount of money your business makes from selling products, after subtracting the cost of producing or buying those products. Calculated by subtracting the cost from net sales.
Sales	Gross margin	METRIC	RATIO	The percentage of money left from your sales after subtracting the cost of producing or buying the products. It's calculated by dividing your gross profit by your net sales and multiplying by 100
Order	Orders	METRIC	INTEGER	The total number of orders placed.
Order	Item quantity (Deprecated)	METRIC	INTEGER	Use 'Net quantity', this field has been deprecated. The quantity of the items in order.
Order	Product sales quantity (Deprecated)	METRIC	INTEGER	Use 'Net quantity', this field has been deprecated. The quantity of the products
Order	Ordered quantity	METRIC	INTEGER	The quantity of a product or item that has been ordered
Order	Returned quantity	METRIC	INTEGER	The quantity of a product or item that has been returned by a customer
Order	Net quantity	METRIC	INTEGER	The quantity of a product or item that remains after accounting for both ordered and returned quantities
Order	Avg order value	METRIC	FLOAT	The average of order total sales
Product	Inventory value	METRIC	INTEGER	The sell value of the product inventory
Product	Inventory quantity	METRIC	INTEGER	The product quantity in inventory
Product	Cost of goods sold	METRIC	FLOAT	The total cost of all the units of goods sold.
Customer	Customer count	METRIC	INTEGER	The total count of the customers
Customer	Customer order count	METRIC	INTEGER	The total count of the customers order
Customer	Customer Avg order amount	METRIC	FLOAT	The Average order amount of the customers
Customer	New customers	METRIC	INTEGER	A new customer(first-time customer) is a customer who placed their first order with your store.
Customer	Returning customers	METRIC	INTEGER	A returning customer is a customer who placed an order, and whose order history already includes at least one order.
Payments	Gross payments	METRIC	FLOAT	The amount paid by the transactions before refunds.
Payments	Refunded payments	METRIC	FLOAT	The total amount refunded across the transactions.
Payments	Net payments	METRIC	FLOAT	Equates to total amount paid - the total amount refunded.
Payments	Transactions	METRIC	INTEGER	The number of payment transactions.
Time	Year	DIMENSION	YEAR	Group results by year.
Time	Year month	DIMENSION	YEARMONTH	Group results by year and month name in short. Represented in the format 2022-Feb.
Time	Year month number	DIMENSION	YEAR_MONTH_NUMBER	Group results by year and month number. Represented in the format 2022-02.
Time	Month	DIMENSION	MONTHNAME	Group results by name of the month.
Time	Month number	DIMENSION	MONTH	Group results by the month number.
Time	Year Week(sun-sat)	DIMENSION	YEAR_WEEK	Group result by year and week. Represented in the format 2022-47.
Time	Year Week(mon-sun)	DIMENSION	YEAR_ISO_WEEK	Group result by year and ISO week. Represented in the format 2022-48.
Time	Week number(sun-sat)	DIMENSION	WEEK_NUMBER	Group results by week of the year. Represented in week number format.
Time	Week number(mon-sun)	DIMENSION	WEEK_ISO_NUMBER	Group results by ISO week of the year. Represented in week number format.
Time	Week start date(sun-sat)	DIMENSION	WEEK_START_DATE	Group results by week of the year. Represented by start date of the week.
Time	Week start date(mon-sun)	DIMENSION	WEEK_ISO_START_DATE	Group results by ISO week of the year. Represented by start date of the ISO week.
Time	Date	DIMENSION	DATE	Group results by date.
Time	Hour	DIMENSION	HOUR	Group results by hour.
Store	Store name	DIMENSION	STRING	The name of the shopify store.
Store	Store ID	DIMENSION	STRING	The unique identifier for the shopify store.
Product	Product title	DIMENSION	STRING	The title of the product
Product	Product ID	DIMENSION	STRING	The unique identifier of the product
Product	Variant title	DIMENSION	STRING	The title of the product variant
Product	Variant ID	DIMENSION	STRING	The unique identifier of the product variant
Product	Variant SKU	DIMENSION	STRING	The Stock Keeping Unit of the variant
Product	Product tags	DIMENSION	STRING	Tags attached to the product
Product	Product status	DIMENSION	STRING	The status of the product. The possible values can be ACTIVE, ARCHIVED, DRAFT.
Product	Product price	DIMENSION	FLOAT	The price of the product
Product	Product comparison price	DIMENSION	FLOAT	The compared at price of the product
Product	Cost per item	DIMENSION	FLOAT	Cost of the inventory item
Product	Product description	DIMENSION	STRING	Description of the product
Product	Product vendor	DIMENSION	STRING	The vendor of the product
Product	Product type	DIMENSION	STRING	The type of the product
Product	Product category	DIMENSION	STRING	The name of the product category. For example, Dog Beds
Product	Product category full name	DIMENSION	STRING	The full name of the product category. For example, Animals & Pet Supplies > Pet Supplies > Dog Supplies > Dog Beds.
Product	Product image URL	DIMENSION	IMAGE_URL	The image URL of the product
Product	Product URL	DIMENSION	URL	A link to the product.
Product	Product URL (Decoded)	DIMENSION	DECODED_URL	A decoded link to the product.
Product	Is gift card	DIMENSION	STRING	Whether or not the product is a gift card
Product	Variant image URL	DIMENSION	IMAGE_URL	The image URL of the variant
Product	SEO title	DIMENSION	STRING	The title of the SEO
Product	SEO description	DIMENSION	STRING	The description of the SEO
Product	Product created date	DIMENSION	DATE	The date the product was created
Product	Product created datetime	DIMENSION	DATETIME	The date and time the product was created
Product	Product updated date	DIMENSION	DATE	The date the product was updated
Product	Product updated datetime	DIMENSION	DATETIME	The date and time the product was updated
Product	Product published date	DIMENSION	DATE	The date the product was published
Product	Product published datetime	DIMENSION	DATETIME	The date and time the product was published
Line Item	Line item name	DIMENSION	STRING	The name of the product in the line item.
Line Item	Line item ID	DIMENSION	STRING	ID of the line item row
Line Item	Line item price	DIMENSION	FLOAT	The variant unit price in the line item, without discounts applied, in shop currency.
Line Item	Line item SKU	DIMENSION	STRING	The Stock Keeping Unit of the variant from the LineItem.
Order	Order name	DIMENSION	STRING	The name of the order
Order	Order ID	DIMENSION	STRING	The unique identifier of the order
Order	Order note	DIMENSION	STRING	The note on the order
Order	Order tags	DIMENSION	STRING	Tags attached to the order
Order	Payment status	DIMENSION	STRING	The payment status of the order
Order	Sale kind	DIMENSION	STRING	The type of order action that the sale represents. The possible sale kinds: ORDER, RETURN, UPDATE
Order	Sale item type	DIMENSION	STRING	The line item type assocated with the sale. The possible line item types for a sale record: ADJUSTMENT, GIFT_CARD, PRODUCT, SHIPPING, TIP.
Order	Order created date	DIMENSION	DATE	The date the order was created
Order	Order created datetime	DIMENSION	DATETIME	The date and time the order was created
Order	Order closed datetime	DIMENSION	DATETIME	The date the order was closed
Order	Order cancelled datetime	DIMENSION	DATETIME	The date of the order cancellation
Order	App client title	DIMENSION	STRING	Title of the app that created the order
Order	Shipping address 1	DIMENSION	STRING	The street address of the shipping address
Order	Shipping address 2	DIMENSION	STRING	An optional additional field for the street address of the shipping address
Order	Shipping phone	DIMENSION	STRING	The phone number at the shipping address
Order	Shipping post code	DIMENSION	STRING	The postal code (zip, postcode, Eircode, …) of the shipping address
Order	Shipping city	DIMENSION	STRING	The city, town, or village of the shipping address
Order	Shipping province	DIMENSION	STRING	The region of the shipping address, such as the province, state, or district
Order	Shipping province code	DIMENSION	STRING	The two-letter code of the region (for example, province, state, or prefecture) of the shipping address
Order	Shipping country	DIMENSION	STRING	The name of the country of the shipping address
Order	Billing address 1	DIMENSION	STRING	The street address of the billing address
Order	Billing address 2	DIMENSION	STRING	An optional additional field for the street address of the billing address
Order	Billing phone	DIMENSION	STRING	The phone number at the billing address
Order	Billing post code	DIMENSION	STRING	The postal code (for example, zip, postcode, or Eircode) of the billing address
Order	Billing city	DIMENSION	STRING	The city, town, or village of the billing address
Order	Billing province	DIMENSION	STRING	The region of the billing address, such as the province, state, or district.
Order	Billing province code	DIMENSION	STRING	The two-letter code of the region (for example, province, state, or prefecture) of the billing address
Order	Billing country	DIMENSION	STRING	The name of the country of the billing address
Order	Billing company	DIMENSION	STRING	The name of the customer's company or organization.
Order	Channel	DIMENSION	STRING	The sales channel of the order
Order	Is order confirmed	DIMENSION	BOOLEAN	Whether order has been confirmed or not
Order	Is order cancelled	DIMENSION	BOOLEAN	Whether the order has been cancelled or not
Order	Currency code	DIMENSION	STRING	The currency code of the order
Order	Order email	DIMENSION	STRING	The email associated with the order
Order	Fully paid	DIMENSION	BOOLEAN	Whether the order is fully paid or not
Order	Discount code	DIMENSION	STRING	The reason for the applied order-level discount
Order	POS location name	DIMENSION	STRING	If the order was processed using shopify POS, then this returns the location.
Order	Location name	DIMENSION	STRING	The location name
Order	Shipping description	DIMENSION	STRING	Description of the shipping selected for the order
Order	Fulfillment status	DIMENSION	STRING	Represents the order's current fulfillment status. Valid values are: unfulfilled, partial, fulfilled, restocked
Traffic source	FV: Date	DIMENSION	DATE	The first visit date
Traffic source	FV: Landing page URL	DIMENSION	URL	The first visit URL of the landing page
Traffic source	FV: Referral code	DIMENSION	STRING	First visit referral code used for the order
Traffic source	FV: Referrer URL	DIMENSION	URL	The web page link the customer first clicked that sent them to the online store
Traffic source	FV: Source	DIMENSION	STRING	The First visit Source from which the customer visited the store, such as a platform (Facebook, Google), email, direct, a website domain, QR code, or unknown.
Traffic source	FV: Source Type	DIMENSION	STRING	The marketing tactic from which the customer first visited the store : ABANDONED_CART - An abandoned cart recovery email, AD - An ad, such as a Facebook ad, AFFILIATE - An affiliate link, DIRECT - A direct visit to the online store, LINK - A link, LOYALTY - A loyalty program, MESSAGE - A messaging app, such as Facebook Messenger, NEWSLETTER - A newsletter, NOTIFICATION - A notification in the Shopify admin, POST - A blog post, RETARGETING - A retargeting ad, SEO - Search engine optimization, STOREFRONT_APP - A popup on the online store, TRANSACTIONAL - A transactional email.
Traffic source	FV: UTM content	DIMENSION	STRING	First Visit UTM Content. Identifies specific content in a marketing campaign. Used to differentiate between similar content or links in a marketing campaign to determine which is the most effective.
Traffic source	FV: UTM term	DIMENSION	STRING	The AD medium of a marketing campaign from which the customer first visited the store.
Traffic source	FV: UTM medium	DIMENSION	STRING	The AD medium of a marketing campaign from which the customer first visited the store.
Traffic source	FV: UTM source	DIMENSION	STRING	First visit source. The source of traffic to the merchant's store, such as Google or an email newsletter
Traffic source	FV: UTM campaign	DIMENSION	STRING	The name of a marketing campaign from which the customer first visited the store.
Traffic source	LV: Date	DIMENSION	DATE	The first visit date
Traffic source	LV: Landing page URL	DIMENSION	URL	The last visit URL of the landing page
Traffic source	LV: Referral code	DIMENSION	STRING	Last visit Referral code used for the order
Traffic source	LV: Referrer URL	DIMENSION	URL	The web page link the customer clicked last that sent them to the online store
Traffic source	LV: Source	DIMENSION	STRING	The source from which the customer last visited the store, such as a platform (Facebook, Google), email, direct, a website domain, QR code, or unknown.
Traffic source	LV: Source Type	DIMENSION	STRING	The marketing tactic from which the customer last visited the store : ABANDONED_CART - An abandoned cart recovery email, AD - An ad, such as a Facebook ad, AFFILIATE - An affiliate link, DIRECT - A direct visit to the online store, LINK - A link, LOYALTY - A loyalty program, MESSAGE - A messaging app, such as Facebook Messenger, NEWSLETTER - A newsletter, NOTIFICATION - A notification in the Shopify admin, POST - A blog post, RETARGETING - A retargeting ad, SEO - Search engine optimization, STOREFRONT_APP - A popup on the online store, TRANSACTIONAL - A transactional email.
Traffic source	LV: UTM content	DIMENSION	STRING	Last Visit UTM Content. Identifies specific content in a marketing campaign. Used to differentiate between similar content or links in a marketing campaign to determine which is the most effective.
Traffic source	LV: UTM term	DIMENSION	STRING	The keywords associated with an ad from which the customer last visited the store.
Traffic source	LV: UTM medium	DIMENSION	STRING	The AD medium of a marketing campaign from which the customer last visited the store.
Traffic source	LV: UTM source	DIMENSION	STRING	Source from which the customer last visited the store, such as a platform (Facebook, Google), email, direct, a website domain, QR code, or unknown.
Traffic source	LV: UTM campaign	DIMENSION	STRING	The name of a marketing campaign from which the customer last visited the store.
Customer Details	Customer first name	DIMENSION	STRING	The first name of the customer
Customer Details	Customer last name	DIMENSION	STRING	The last name of the customer
Customer Details	Customer ID	DIMENSION	STRING	The unique identifier of the customer
Customer Details	Customer email	DIMENSION	STRING	The email of the customer
Customer Details	Customer type	DIMENSION	STRING	Whether the customer a Returing customer (Customers whose order history includes two or more orders) or a First-time customer.
Customer Details	Customer tags	DIMENSION	STRING	List of tags that have been added to the customer.
Customer Details	Last order created date	DIMENSION	DATE	The date the last order of the customer was created
Customer Details	Account age in days	DIMENSION	STRING	The amount of days since the customer was first added to the online store
Customer Details	Account created date	DIMENSION	DATE	The date the customer was added to the online store
Customer Details	Is Returning customer	DIMENSION	STRING	Whether the customer a returing customer(Customers whose order history includes two or more orders) or not.
Customer Geo	Country	DIMENSION	COUNTRY	The country of the customer
Customer Geo	Country code	DIMENSION	COUNTRY_CODE	The country code of the customer
Customer Geo	City	DIMENSION	CITY	The city of the customer
Payments	Transaction ID	DIMENSION	STRING	The unique identifier of the transaction.
Payments	Transaction kind	DIMENSION	STRING	The type of transaction.
Payments	Payment method	DIMENSION	STRING	The payment method that the customers used. If you mark an order as paid and select Other as the payment method, then the report will show the payment method as Manual.
Payments	Transaction created date	DIMENSION	DATE	The date when the transaction was created.
Payments	Transaction created datetime	DIMENSION	DATETIME	The date and time when the transaction was created.
Payments	Transaction processed date	DIMENSION	DATE	The date when the transaction was processed.
Payments	Transaction processed datetime	DIMENSION	DATETIME	The date and time when the transaction was processed.
Payments	Accelerated checkout	DIMENSION	STRING	The accelerated checkout the customers used, if applicable, such as Shop Pay or Apple Pay.
Payments	Credit card	DIMENSION	STRING	Type of credit card that the customers used, if applicable.

Integrations

Category

Shopify Metrics and Dimensions