Build a Shipping Analytics Dashboard

Help me build a ShopifyQL report on shipping performance using my store’s live order data.

Time period: [e.g., last 90 days]
Carriers used: [e.g., USPS, UPS, FedEx]
Metrics to include:

  Shipping cost per order
  Delivery time by carrier
  Order fulfillment status/time (order placed → fulfilled → delivered)
  Shipping cost as a percentage of order revenue


Please:


  Build a ShopifyQL query/report pulling shipping cost, carrier, and fulfillment data from my actual orders for [TIME_PERIOD].
  Break the results down by carrier so I can compare cost and delivery time across [CARRIERS_USED].
  Show shipping cost as a percentage of revenue where possible.
  Run the report and show me the results.
  Export the report so I can review it outside the admin.


Flag anything in the data that stands out (e.g., a carrier with notably higher cost or slower delivery) directly from the numbers — not general shipping advice.