Every query starts with a data type, such as Orders or Order lines, and a set of fields that become the table's columns. The data type decides what one row in your table means.
Choose a data type
Under Data, choose a data type. A short description appears under the menu.
Data type | One row per |
Orders | Order |
Order lines | Product on an order |
Products | Product variant |
Collections | Product in a collection |
Inventory | Variant at each location, at its current stock level |
Discounts | Discount applied to an order, line, or shipping |
Refunds | Refunded line, shipping refund, or adjustment |
Fulfillments | Fulfillment |
Transactions | Payment transaction on an order |
Which data type to use
Sales by product, SKU, or month: Order lines. Each row carries the product, quantity, net sales, and gross profit.
Order counts and average order value: Orders. Each order appears once, with its totals.
What you have in stock: Inventory.
How discounts performed: Discounts.
Returns and refunds: Refunds.
Choose your fields
Each data type starts with a default set of fields, shown as selected chips under Fields. The count next to the step, such as "11 of 21," shows how many are selected.
Select a selected chip to remove that field.
Select more to see every field, grouped by topic. Select a field to add it, or select Default fields or All.
Select Done to close the full list.
Column order
Columns appear in the data type's standard order, whatever order you select them in. A refresh rewrites the table in that same order, so if you need a different layout, build it on a separate sheet with formulas that point at the table.
When fields are hidden
Turning on Group and total hides Fields. Grouped tables have one column for each group and total you choose instead. Group and total your data explains how.
Field definitions
Each field has a plain name in the builder, such as Net sales or Order date. The Data Reference has a page for each data type with every field and how it's calculated.