Analytics
π Built for Sidekick
β‘ Sidekick does this for you
shopify
sidekick
analytics
orders
Report Draft Order Conversion
Show what share of draft orders created get sent, paid, and completed versus left open or abandoned.
π Prompt
Report on draft order conversion for draft orders created in [LAST 90 DAYS]. What to calculate: Total draft orders created % that were invoiced/sent to the customer % that were completed into a paid order % still open (never invoiced or never paid) Average time from draft creation to completion, for completed drafts Average value of completed vs still-open drafts Breakdown: By whoever created the draft, if drafts are created by more than one staff account By month, to see if conversion rate is improving or declining over time Output format: Summary: total drafts, % invoiced, % completed, % still open Table: month (or staff member), drafts created, % completed, avg completion time, avg value Deliverables: Both outputs Total dollar value currently sitting in open, uncompleted draft orders β this is money left on the table thatβs worth a manual follow-up Flag if conversion rate is meaningfully different by creator, since that may point to a follow-up process gap rather than a customer-side issue
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