What Is the Order Lifecycle Report?
The Order Lifecycle Report in Data Export follows checkout attempts from their creation date to a completed checkout, where applicable. It helps you see when a shopper began checkout and whether a completion date was recorded.
The report uses Cart Date—the abandoned checkout creation date—as its reporting date. Each checkout record includes quantities and checkout values, making it useful for reviewing potential sales associated with incomplete attempts rather than treating them as earned revenue.
Use the Completed Date alongside Cart Date to distinguish completed checkouts from those without a recorded completion, and to examine the time between checkout creation and completion for recovered attempts.
Report Overview
- Report period
- Based on Cart Date (abandoned checkout created date); select the relevant date range.
- Data included
- Cart Date, Completed Date, Quantity, Subtotal Price, Total Tax, and Total Price.
- Best for
- Checking incomplete checkout value, completion patterns, and potential recovery follow-up.
- Export options
- Excel, CSV, TXT, and PDF.
- Automation
- Schedule email delivery daily, weekly, or monthly after saving the report.
What Can You Learn from the Checkout Lifecycle?
1. Which checkout attempts remain incomplete
Review missing Completed Date values to identify checkout attempts that have no recorded completion. This is a starting point for follow-up, not proof that every checkout is recoverable.
Example: a checkout created on Monday still has no Completed Date on Tuesday.
What you can do: Filter for blank Completed Date and prioritize follow-up based on store policy.
2. How much value is associated with incomplete checkouts
Total Price makes it possible to assess the value tied to unresolved checkout attempts. These amounts are potential sales, not confirmed lost revenue or guaranteed future orders.
Example: three incomplete checkouts have a combined Total Price of $240.
What you can do: Sort incomplete attempts by Total Price to review higher-value opportunities first.
3. How long completion can take
For completed attempts, comparing Cart Date and Completed Date shows elapsed time between checkout creation and checkout completion. The report fields do not explain why a shopper delayed.
Example: a checkout created on Friday is completed on Sunday.
What you can do: Review completion delays before choosing follow-up timing.
4. What the checkout composition looks like
Quantity, Subtotal Price, Total Tax and Total Price help describe the basket sizes and amounts associated with checkout attempts. They do not establish profitability or payment settlement.
Example: an incomplete checkout contains four items with a recorded subtotal and tax.
What you can do: Compare checkout amounts and quantities when deciding what to investigate.
What Should You Check First in This Report?
Start with fields that distinguish unfinished checkout activity from completed purchases.
- Completed Date: Identify blank values before treating a checkout as incomplete.
- Cart Date: Confirm the selected reporting window reflects when checkouts were created.
- Total Price: Sort unresolved attempts by potential checkout value, without counting this as actual sales.
- Cart Date versus Completed Date: Look for unusually long elapsed periods among completed checkouts.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Reviewing checkout drop-offs | Find attempts without a recorded Completed Date within the Cart Date range. |
| Prioritizing checkout follow-up | Sort incomplete checkout attempts by Total Price. |
| Examining recovery timing | Compare Cart Date and Completed Date on completed checkouts. |
| Reviewing the value of incomplete attempts | Use subtotal, tax, and total fields to assess amounts tied to checkout activity. |
| Reporting on a campaign period | Filter a Cart Date range to examine checkouts created during that period. |
How to Create This Report in Data Export
Start with the premade Order Lifecycle Report so the six core checkout fields are already arranged.
- Open Data Export in your Shopify admin and find the premade Order Lifecycle Report.
- Open the report and review Cart Date, Completed Date, Quantity, Subtotal Price, Total Tax and Total Price.
- Choose the Cart Date range; optionally filter for a blank Completed Date to focus on incomplete attempts.
- Adjust fields or sorting if needed, then save the report.
- Export the report or configure a daily, weekly, or monthly email schedule for your team.
Make the Most of This Report
Use these four checks to keep your checkout analysis useful and interpretable.
01 / DATE WINDOW
Anchor analysis to Cart Date. A checkout created earlier may complete within a later period.
02 / OPEN CHECKOUTS
Filter for blank Completed Date when working through unresolved attempts; do not assume every blank is permanently lost.
03 / VALUE
Treat Total Price on an incomplete checkout as potential value, not booked revenue.
04 / SHARING
Export only the fields needed by recipients and use scheduled delivery to keep follow-up review consistent.
Frequently Asked Questions
What date determines which checkouts appear in the report?
Cart Date is the report date basis. It is the date the abandoned checkout was created.
How can I find checkouts that are not completed?
Filter for records with a blank Completed Date, then review their Cart Date and amounts.
Does Total Price mean revenue has been earned?
No. Total Price describes the amount tied to a checkout attempt. For an incomplete checkout, it represents potential value rather than confirmed revenue.
Can I see how long a checkout took to complete?
For checkouts with both dates, compare Cart Date and Completed Date. The result is the elapsed time between recorded creation and completion.
Can I export or schedule the report?
You can export Excel, CSV, TXT and PDF files and schedule daily, weekly and monthly email delivery.