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
Run in Sidekick
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

  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