[Feature Request] Native calculated metrics in ShopifyQL / Analytics — retail fundamentals missing

Shopify Plus
1

Store URL

What feedback do you want?

Hi Shopify community,

As a Shopify Plus retailer, I’m missing two basic retail KPIs in Analytics:

Average item price = Net sales ÷ Net quantity

Average items per order = Net quantity ÷ Number of orders

ShopifyQL doesn’t support custom calculated columns, forcing merchants to export CSVs for basic math. These are standard metrics in any retail analytics tool.

My request: allow derived metrics in ShopifyQL (e.g. net_sales / net_quantity AS avg_item_price) or add them as native options in the configuration panel.

Please upvote if you need this too!

2

Hey :waving_hand:

ShopifyQL already supports calculated metrics.

We have a section in our Help Docs on this, and you can try it yourself in the Analytics exploration view:

formulas
formulas3372×1788 395 KB

Calculated metrics can be used in visualizations and are exported, too. Here’s an example CSV export of the above:

"Day","Net sales","Net items sold","Average item price","Orders","Average items per order"
"2020-09-17",13.18,1,13.18,1,1
"2020-11-16",0,1,0,1,1
"2021-03-05",51.243,7,7.32,5,1.4
"2021-03-10",-12.645,0,,0,
"2021-03-17",0,1,0,1,1
"2021-03-24",25.042,2,12.521,2,1
"2021-05-10",12.124,1,12.124,1,1
"2021-05-11",12.103,1,12.103,1,1
"2021-09-27",67.702,2,33.851,1,2
"2021-10-26",-66.182,-2,33.091,0,
"2021-11-17",4.367,1,4.367,1,1
"2023-03-23",0,1,0,0,
"2024-05-01",60,6,10,1,6
"2024-09-10",0,1,0,1,1
"2024-12-03",0,1,0,1,1
"2025-01-20",9.99,1,9.99,1,1
"2025-02-28",0,1,0,1,1
"2025-09-16",50,1,50,1,1
"2025-11-17",200,4,50,1,4
"2026-01-17",10,1,10,1,1
"2026-06-06",158.41,1,158.41,1,1
"2026-06-11",48.62,1,48.62,1,1
"2026-06-14",41.85,1,41.85,1,1

Hope this helps! Let us know if you have any more feedback.