Workflow · Stock and products · Opening soon

Cart abandonment rate

Use a Shopify analytics export to work out cart abandonment rate by day and device. Divide abandoned checkouts by checkouts started for each row.

Book a demo

Someone typed

“calculate cart abandonment rate by day and device from checkouts started and orders completed”

The agent read it as

Calculate cart abandonment rate by day and device from Shopify analytics report: checkouts started vs orders completed by day and device, with Abandoned / checkouts started.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

Shopify analytics report: checkouts started vs orders completed by day and device

CSV export · 42 rows

Step

Calculate abandonment rates

Step 1

Result

Cart abandonment rates

42 rows

Schedule

Runs when you say

Proposed

File
Shopify analytics report: checkouts started vs orders completed by day and device
CSV export · 42 rows
Step
Calculate abandonment rates
Step 1
Result
Cart abandonment rates
42 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 42 rows came out.

Download Shopify analytics report: checkouts started vs orders completed by day and device sample (42 rows)Shopify Analytics: Reports > Behavior > Checkout behavior > Export

What you get back

The result of that run, the rows to look at first.

Cart abandonment ratesSample data42 rows

Date	Device type	Cart abandonment rate (%)	Abandoned checkouts	Checkouts started	Orders completed
2026-10-31	desktop	25	13	52	39
2026-10-31	mobile	44.3	27	61	34
2026-10-31	tablet	35.7	5	14	9
2026-11-01	desktop	34	16	47	31
2026-11-01	mobile	39.7	27	68	41
2026-11-01	tablet	41.7	5	12	7
2026-11-02	desktop	31.5	17	54	37
2026-11-02	mobile	37.5	24	64	40
2026-11-02	tablet	37.5	6	16	10
2026-11-03	desktop	28.8	17	59	42
2026-11-03	mobile	38	27	71	44
2026-11-03	tablet	46.7	7	15	8

42 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you calculate cart abandonment rate by day and device?

Export the Shopify analytics report with checkouts started and orders completed by day and device. Calculate abandoned checkouts, then divide that by checkouts started for each row. The result is a daily cart abandonment rate by device.

How it works

How to use the Cart abandonment rates workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Cart abandonment rates: questions

What export should you use?

Use a spreadsheet-style export that has the fields you need for the calculation, here checkouts started, orders completed, day, and device. The rows should already be broken out in the way you want to analyse them.

What happens to rows that do not match?

Rows that do not have the fields needed for the rule cannot be calculated in that step. You can leave them out or handle them separately, depending on the workflow rules you set.

How do you change the rules in words?

Edit the step so it matches the wording of the calculation you want. For example, you can change the fields, the grouping, or the formula used for each row.