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
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
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions