Order Management 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick order-management reporting

On-Time Delivery Rate Report

Pull a live report of what share of orders arrived within their promised delivery window, by carrier and method.

đź“‹ Prompt
Run in Sidekick
I want to track what percentage of orders actually arrive within the delivery window we promise at checkout. Here are the details:

Store name: [YOUR STORE NAME]
Promised delivery windows by shipping method: [e.g., Standard: 5-7 days, Express: 2-3 days]
Date range to analyze: [e.g., last 30 days]

Please build:


  A ShopifyQL report pulling delivered orders from the last [DATE RANGE], with shipping method, carrier, order date, and delivered date.
  A calculated column comparing actual delivery time to the promised window for that shipping method, flagging each order as “On-Time” or “Late”.
  A summary breakdown showing on-time percentage by shipping method and, separately, by carrier, so I can see whether a specific carrier is dragging down the average.
  A trend view comparing this period’s on-time rate to the prior period, so I can see if it’s improving or worsening.
  A list of the worst-performing lane (carrier + region combination) if the data supports it, to prioritize where to investigate first.
  A recommendation for how often to re-run this report (e.g., weekly) and where to log the results for tracking over time, such as an order note pattern or a saved report.


The goal is a repeatable, data-backed answer to “are we actually hitting our shipping promises,” not a guess based on complaint volume.

How to Use

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions