sales

Percentage of orders marked as low or medium risk by Shopify's fraud analysis

Additional fees associated with the given sale

The average all-time spend for customers in your results, in your store's currency.

The average amount per order before post-order adjustments, in your store's currency.

Average order value = (gross sales - discounts) / orders

The number of bundles ordered before returned or reversed quantities are taken out. Use bundles_ordered to track bundle demand over time or by bundle_title.

The direct cost of the products sold, such as manufacturing or purchase cost, in your store's currency. Use cost_of_goods_sold with gross_profit or gross_margin to evaluate profitability.

Counts each customer one time within the selected sales, even if the customer placed more than one order.

Discount values no longer applied when discounted products are removed from orders

The amount taken off sales revenue through discounts, in your store's currency. Use discounts to track discounting over time or by groupings like discount_code.

Customs duties or import tariffs associated with sales, in your store's currency. Use duties to report duty amounts over time or by destination fields like shipping_country.

Discounts applied to gift card sales, in your store's currency. Values are negative amounts. Use gift_card_discounts to track reductions on gift card sales over time.

Gift card sales revenue before discounts and returns are taken out, in your store's currency. Use gift_card_gross_sales to see top-line gift card revenue over time.

Gift card sales revenue after discounts and returns are factored in, in your store's currency. Use gift_card_net_sales to measure gift card revenue net of those reductions.

Taxes for sales of gift cards

The share of sales kept as gross profit after cost of goods sold is factored in. Gross margin is based on sales where cost of goods sold is recorded.

Gross margin = gross profit / net sales

Sales revenue after cost of goods sold is taken out, before other operating expenses, in your store's currency.

Gross profit = net sales - cost of goods sold

Top-line sales revenue before discounts and returns are taken out, in your store's currency. Use gross_sales to see gross revenue over time or by a grouping like product or channel. It excludes taxes, shipping, duties, and fees.

Value of items removed from orders before discounts and taxes

The share of orders Shopify's fraud analysis marked as high risk, shown as a percentage. Use high_fraud_risk_rate to monitor risky orders over time or by groupings like sales_channel.

Discounts applied to specific line items, in your store's currency. Use line_item_discounts to track product-level discounting over time or by product.

The number of items sold after returned or reversed quantities are factored in. Use net_items_sold to track product movement over time or by product.

Sales revenue after discounts and sales reversals, excluding taxes, shipping, duties, and fees, in your store's currency.

Net sales = gross sales - discounts - sales reversals

Value of items removed from orders after discounts, before taxes

Net sales reversals = gross sales reversals + discount reversals

Product net sales where cost of goods sold is recorded, in your store's currency. Use net_sales_with_cost_recorded to understand the revenue base used for profit measures.

Product net sales where cost of goods sold isn't recorded, in your store's currency. Use net_sales_without_cost_recorded to find revenue missing cost data.

The number of customers whose order in your results was their first purchase. Use new_customers to track customer acquisition over time or by groupings like sales_channel.

The average lifetime number of orders placed by customers in your results. Use number_of_orders_per_customer to understand repeat purchase depth over time or by customer cohort.

Discounts applied across the entire order, in your store's currency. Use order_level_discounts to track order-wide discounting over time or by discount fields.

The number of order agreements that produced sale activity.

Counts each order one time within the selected sales, even when the order contains multiple items.

The number of orders placed by customers making their first purchase. Use orders_first_time to track first-purchase order volume over time.

The number of orders placed by customers who had bought from you before. Use orders_returning to track repeat order volume over time.

The number of items ordered before returned or reversed quantities are taken out. Use quantity_ordered to track ordered item volume over time or by product.

The average number of items ordered per order before returned or reversed quantities are taken out. Use quantity_ordered_per_order to track typical basket size over time.

The share of sales revenue assisted by a staff member, shown as a percentage. Use rate_of_staff_assisted_sales to understand how much revenue involves staff assistance over time or by retail location.

Fees associated with returns, in your store's currency. Use return_fees to track return fee amounts over time or by return reason.

The share of customers in your results who had bought from you before.

Returning customer rate = returning customers / customers

The number of customers who placed an order after a previous purchase. Use returning_customers to track repeat customer activity over time or by grouping.

Number of items removed from orders

Percentage of items removed from orders out of total items sold

Value removed from orders through refunds, returns, cancellations, or edits

Discounts applied to shipping charges, in your store's currency. Use shipping_charge_discounts to track shipping discount amounts over time.

Taxes charged on shipping, in your store's currency. Use shipping_charge_taxes to report shipping tax amounts over time or by destination.

The amount customers spent on shipping before shipping discounts and shipping taxes are factored into total shipping, in your store's currency. Use shipping_charges to track shipping revenue over time.

Shipping charges removed from orders

Tax amounts removed from orders

Taxes charged on sales, in your store's currency. Use taxes to report total tax amounts over time or by destination fields.

Taxes charged on sales excluding taxes from gift card sales, in your store's currency. Use taxes_excluding_gift_cards when you want tax amounts without gift card tax included.

Customer gratuities added to sales, in your store's currency. Use tips to track tip amounts over time or by retail location.

The full amount customers spent, including taxes, shipping, duties, and fees, in your store's currency.

Total sales = net sales + additional fees + duties + shipping charges + taxes

The full amount spent by customers making their first purchase, in your store's currency. Use total_sales_first_time to track revenue from newly acquired customers over time or by channel.

The full amount spent by customers who had bought from you before, in your store's currency. Use total_sales_returning to track repeat customer revenue over time or by channel.

Total value removed from orders, including products, shipping, taxes, and fees

Total sales reversals = net sales reversals + shipping reversals + sale reversal fees + tax reversals

The full shipping amount customers spent, in your store's currency. It reflects shipping charges after shipping discounts and shipping taxes are included. Use total_shipping_charges to track total shipping revenue over time.

Total shipping charges = shipping charges - shipping discounts + shipping taxes

Discount values no longer applied when discounted products are removed from orders

Value of items removed from orders before discounts and taxes

Value of items removed from orders after discounts, before taxes

Net returns = gross returns + discounts returned

Number of items removed from orders

Percentage of items removed from orders out of total items sold

Value removed from orders through refunds, returns, cancellations, or edits

Shipping charges removed from orders

Tax amounts removed from orders

Total value removed from orders, including products, shipping, taxes, and fees

Total returns = net returns + shipping returned + return fees + taxes returned

The AI agent or assistant that directly helped facilitate the sale. Values are Google AI Mode and Gemini, Microsoft Copilot, and Shop.

The unique Shopify identifier for the staff member who assisted with the retail sale. Use assisting_staff_id to filter to a specific staff member, or use it with assisting_staff_member_name to show readable labels.

The unique Shopify identifier for the billing address on the order. Use billing_address_id to filter to a specific billing address, or use billing location fields for readable results.

The unique Shopify identifier for the multi-channel app sales channel. Use channel_id to filter to a specific channel by its Shopify identifier.

Whether cost of goods sold is recorded for the product sale. You can filter by cost_is_recorded to focus on sales with or without cost data. Values are true and false.

The unique Shopify identifier for the customer on the sale. Use customer_id to break results down by customer, or use it with customer_name or customer_email to show readable labels.

The day a sale happened.

The day of week a sale happened, with values Monday through Sunday.

The unique Shopify identifier for the discount line on the sale. Use discount_line_id to filter to a specific discount application.

Whether the sale reflects the original order state before adjustments made after the order was created. You can filter by excludes_post_order_adjustments when you want original order activity. Values are true and false.

The hour a sale happened.

The hour of day a sale happened, with values 0 through 23.

Whether the sale had a discount applied. You can filter by is_discounted_sale to separate discounted sales from full-price sales. Values are true and false.

Whether the sale was made in person at a physical retail (POS) location. You can filter by is_pos_sale to separate in-store sales from other sales. Values are true and false.

Whether the sale reflects an adjustment. You can filter by is_sale_adjustment to focus on adjustment activity. Values are true and false.

Label specifying whether the transaction reverses a previous sale

The unique Shopify identifier for the line item on the sale. Use line_item_id to filter to a specific item within an order.

The kind of sales line represented, such as Product, Shipping, Duty, and Tip. You can group or filter by line_type to review sales amounts by line category.

The minute a sale happened.

The month a sale happened.

The month of the year a sale happened, with values 1 through 12.

The number of months between the customer's first order and this order, reported in your store's time zone. A value of -1 means this order is the customer's first order. You can group or filter by months_since_first_purchase to analyze customer repeat timing.

Whether an order came from a customer's very first purchase (New) or a later one (Returning). You can filter or group by new_or_returning_customer to compare acquisition against repeat business. Values are New and Returning.

The unique Shopify identifier for the order. Use order_id to filter to a specific order or break results down by order, or use it with order_name to show customer-facing labels.

Label specifying whether the transaction adds or removes value from sales

The unique Shopify identifier for the physical retail location. Use pos_location_id to filter to a specific POS location, or use it with pos_location_name to show readable labels.

The unique Shopify identifier for the product, which can include multiple variants. Use product_id to filter to a specific product, or use it with product_title to show readable labels.

The unique Shopify identifier for the product variant. Use product_variant_id to filter to a specific variant, or use it with product_variant_title or product_variant_sku to show readable labels.

The quarter a sale happened.

The number of quarters between the customer's first order and this order, reported in your store's time zone. A value of -1 means this order is the customer's first order. You can group or filter by quarters_since_first_purchase to analyze customer repeat timing.

The unique Shopify identifier for the refund. Use refund_id to filter to a specific refund in sales and returns results.

The unique Shopify identifier for the sale. Use sale_id to filter to a specific sale.

The unique Shopify identifier for the sales channel where the sale happened. Use sale_sales_channel_id to filter to a specific sales channel when you need the identifier.

Name of the sales channel where the customer made a purchase

The unique Shopify identifier for the bundle connected to the sale. Use sales_line_item_group_id to filter to a specific bundle, or use it with bundle_title to show readable labels.

The second a sale happened.

The unique Shopify identifier for the shipping address on the order. Use shipping_address_id to filter to a specific shipping address, or use shipping location fields for readable results.

The unique Shopify identifier for your store. Use shop_id with shop_name to show readable store labels.

The unique Shopify identifier for the staff member associated with the order. Use staff_id to filter to a specific staff member, or use it with staff_member_name to show readable labels.

Whether the product sale was a one-time purchase or a subscription purchase. You can group or filter by subscription_or_one_time to compare subscription and one-time sales. Values are One-time and Subscription.

The week a sale happened.

The week of the year a sale happened, with values 1 through 53.

The number of weeks between the customer's first order and this order, reported in your store's time zone. A value of -1 means this order is the customer's first order. You can group or filter by weeks_since_first_purchase to analyze customer repeat timing.

The year a sale happened.

The number of years between the customer's first order and this order, reported in your store's time zone. A value of -1 means this order is the customer's first order. You can group or filter by years_since_first_purchase to analyze long-term repeat timing.

Name of the staff member assisting with the retail sale

Name of your store

City of the billing address

B2B customer associated with the billing address

Country of the billing address (e.g., United States, Canada)

Postal code of the billing address

State or province of the billing address (e.g., California, Ontario)

Date the customer most recently abandoned a cart

The customer's account state, with values Declined, Disabled, Enabled, and Invited.

The day the customer record was added, reported in your store's time zone.

The Shopify identifier for the app that created the customer.

Email address of the customer

The part of the customer's email address after the @ symbol, such as gmail.com or your company's domain.

Language associated with the customer

Full name of the customer

The customer's email marketing subscription state, with values such as Invalid, Not subscribed, Pending, and Subscribed.

All cities in the customer's history of addresses

All countries from the customer's address history. Values are country codes such as US, CA, GB, and AU.

All states or provinces from the customer's address history. Values are region codes such as US-CA, US-NY, CA-ON, and GB-ENG.

The customer's all-time spend is shown in your store's currency.

The day the customer most recently placed an order, reported in your store's time zone.

Number of orders the customer has placed across all time

The sales channel where the customer's first order was placed, shown as a channel name such as Online Store or POS.

The month of the customer's first order, reported in your store's time zone.

The quarter of the customer's first order, reported in your store's time zone.

The week of the customer's first order, reported in your store's time zone.

The day the customer placed their first order, reported in your store's time zone.

Referring channel associated with the customer's first order

Type of traffic associated with the customer's first order

Whether the customer's first order included a subscription purchase, with values true and false.

Products bought together in the customer's first order

The customer's predicted spend tier for the next year, with values Low, Medium, and High.

The customer's SMS marketing subscription state, with values such as Not subscribed, Pending, Redacted, and Subscribed.

Tag associated with the customer

Set of tags associated with the customer

A customer relationship label based on recency, frequency, and monetary spend. Values include Champions, Loyal, Needs attention, and At risk.

What the discount applies to, with values Order, Shipping, and Product.

Promotional code entered by customer or applied automatically to receive the discount

The unique Shopify identifier for the discount. Use discount_id with discount_name to show readable labels.

How the discount was triggered, with values Automatic, Manual, Discount code, and Script.

The code or title used to identify the discount.

The shipping cost before the shipping discount was applied, in your store's currency.

Display name of the shipping discount when it was applied

Title of the discount when it was applied

Whether the discount reduces the price by a fixed amount or a percentage, with values Fixed amount and Percentage.

The amount discounted, in your store's currency.

Title of the discount attached to a price rule when it was applied

The price rule's discount type, with values Fixed amount, Percentage, and App. App is used for discounts created by third-party Shopify apps.

The discount amount based on a price rule, in your store's currency.

The price rule's discount type and activation method. Values include Fixed amount (code), Percentage (automatic), Shipping (code), and Buy X Get Y (automatic).

The product name as it appeared when the item was sold.

The product type or category assigned when the item was sold.

The compare-at price of the product variant when the item was sold, in your store's currency.

The price of the product variant when the item was sold, in your store's currency.

The SKU of the product variant when the item was sold.

The variant name as it appeared when the item was sold.

The vendor assigned to the product when the item was sold.

Supplier of the product sourced through Shopify Collective

Whether the order is a B2B order, with values true and false.

Whether the order is canceled, with values true and false.

The currency the buyer saw at checkout when placing the order. Values are currency codes such as USD, CAD, EUR, and GBP.

The order's fulfillment state, with values Fulfilled, Partial, Restocked, and Unfulfilled.

Whether the order includes duties, with values true and false.

The name or number of the order as the customer sees it.

The order's payment state, such as Authorized, Paid, Partially refunded, or Pending.

The sales channel where the order was placed, shown as a channel name such as Online Store or POS.

The unique Shopify identifier for the order's sales channel. Use order_sales_channel_id with order_sales_channel to show readable channel labels.

Whether the order was referred from the Shop app or shop.app, with values true and false.

Path of the first page of the user session that resulted in the order

First page of the user session that resulted in the order

Shopify identifier for the marketing event associated with the order

Domain of the site that led to the order

The readable name of the site that led to the order.

Path of the site that led to the order

Site that led to the order

The referrer type that led to the order, such as organic or email.

External page that referred a customer and led to the order

UTM name of the campaign associated with the order

The UTM content value associated with the order, often used to distinguish ads, links, or content variations.

The UTM medium associated with the order, such as email, social, or paid search.

The UTM source associated with the order, such as Google, Facebook, or a newsletter.

The UTM term associated with the order, often used for paid search keywords or other tracked terms.

Total unique products in the same order

The number of unique product variants in the same order, with each SKU counted a single time.

The product names that appear in the same order.

The Shopify product identifiers for products in the same order.

The product variant labels that appear in the same order, such as size, color, or style combinations.

The unique Shopify identifier for the company. Use company_id with company_name to show readable company labels.

Name of the company that placed the order

The unique Shopify identifier for the company location. Use company_location_id with company_location_name to show readable company location labels.

The company location or branch that placed the order

Marketing channel that referred the customer to place the order

The marketing medium that referred the customer to place the order, such as email, social, or search.

The marketing platform that referred the customer to place the order, such as Google, Facebook, or Instagram.

The type of traffic that led to the order, such as organic, paid, or direct.

The platform or channel where the marketing activity was deployed, such as Email, Facebook, Google, or Instagram.

The type of marketing activity that led to the order, such as Ad, Affiliate, Newsletter, or Retargeting. PLA means Product Listing Ads, and SEO means Search Engine Optimization.

Market you've defined in Shopify, like a geographical market or customer group

Markets or customer segments associated with the order

The reason specified for the order cancellation, such as Customer, Other, Fraud, or Inventory.

The fraud risk level Shopify assigned to the order, with values Low, Medium, High, None, and Pending.

Whether the order has met Shopify Protect fulfillment requirements, including proper shipping and tracking, with values true and false.

Whether the order qualifies for Shopify Protect, with values true and false.

Whether the order has full Shopify Protect coverage against fraud, with values true and false.

Tag associated with the order

Set of tags associated with the order

Unique identifier for the rollout or feature flag exposed to the order

All rollout or feature flag identifiers exposed to the order.

Unique identifier for the specific treatment exposed to the order

Array of all treatment identifiers exposed to the order

The AI agent or assistant that referred the session to your online store, with values ChatGPT, Google AI Mode and Gemini, Microsoft Copilot, and Shop.

Name of the marketing channel or platform that drove the marketing engagement

The unique Shopify identifier for the marketing activity. Use marketing_activity_id with marketing_activity_title to show readable activity labels.

Current status of the marketing activity (such as Active or Paused)

Name of the marketing activity

URL parameter key for the marketing activity

URL parameter value for the marketing activity

Unique ID that Shopify uses to identify the marketing automation

Channel through which the marketing activity is delivered

Unique identifier for the associated marketing event

The marketing platform that created the marketing activity, shown as a platform name.

The host name of the session landing page.

The path of the session landing page.

The URL of the first page viewed in the session.

External page that led to an online store session

UTM name of the campaign associated with the session

The UTM content value associated with the session, often used to distinguish ads, links, or content variations.

The UTM medium associated with the session, such as email, social, or paid search.

The UTM source associated with the session, such as Google, Facebook, or a newsletter.

The UTM term associated with the session, often used for paid search keywords or other tracked terms.

Name of your physical retail location

The product's current publishing state, with values Active, Archived, Draft, Suspended, and Unlisted.

Display name of the product that your customers see

Type (category) that you've assigned to the product

Vendor of the product

Collection associated with the product

Set of collections associated with the product

The app that created the product, shown as an app name.

Tag associated with the product

Set of tags associated with the product

The ABC grade assigned to the product variant based on its share of revenue. A-grade variants account for about 80% of revenue, B-grade for 15%, and C-grade for 5%.

SKU of the product variant

Display name of the product variant

Whether the return is unverified, with values true and false.

The reason the item was returned, such as Changed my mind, Damaged or defective, Too big, or Received the wrong item.

The unique Shopify identifier for the bundle product. Use bundle_product_id with bundle_title to show readable bundle labels.

The bundle name as it appeared when the bundle was created.

Whether the line item is a bundle, with values true and false.

City of the shipping address