Workflow · People · Opening soon

Warehouse pick rate

Upload your ShipBob pick logs and calculate pick rate by picker, by day. See daily pick rates in a table you can review and export.

Book a demo

Someone typed

“calculate pick rate per picker per hour by day from the pick logs”

The agent read it as

calculate pick rate per picker per hour by day from the ShipBob pick logs

What the agent built

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

File

ShipBob pick logs

CSV export · 34 rows

Step

Calculate daily pick rates

Step 1

Result

Daily Picker Pick Rates

17 rows

Schedule

Runs when you say

Proposed

File
ShipBob pick logs
CSV export · 34 rows
Step
Calculate daily pick rates
Step 1
Result
Daily Picker Pick Rates
17 rows
Schedule
Runs when you say
Proposed

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

Download ShipBob pick logs sample (34 rows)ShipBob: Warehouse > Picks > Pick Logs > Export

What you get back

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

Daily Picker Pick RatesSample data17 rows

Pick date	Picker	Pick rate (units/hour)	Units picked	Pick duration (hours)
2026-09-23	Chloe Park	86.5	49	0.57
2026-09-29	Darius Reed	85.9	53	0.62
2026-10-06	Faisal Khan	86.2	56	0.65
2026-10-07	Ava Chen	84.3	52	0.62
2026-10-14	Chloe Park	85.5	57	0.67
2026-10-27	Faisal Khan	87.1	61	0.70
2026-11-03	Ben Ortiz	21.4	20	0.93
2026-11-04	Chloe Park	87.8	60	0.68
2026-11-10	Darius Reed	480	240	0.50
2026-11-10	Elena Morris	83.6	46	0.55
2026-09-21	Ava Chen	74.1	42	0.57
2026-09-22	Ben Ortiz	80	56	0.70

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

How do you calculate pick rate per picker per hour by day from the pick logs?

Export the pick logs from ShipBob and upload the file. The workflow groups rows by picker and day, then calculates pick rate per hour for each group. You get daily pick rates by picker as the result.

How it works

How to use the Daily Picker Pick 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.

Daily Picker Pick Rates: questions

What export should you use?

Use the pick logs export from ShipBob. If your file includes the fields for picker, date, and picked units or picks, it can be used for this workflow.

What happens to rows that do not match the rules?

Rows that do not match the required fields or date format are left out of the result. You can review them in the source file and fix the data before running the workflow again.

How do you change the rules in words?

Change the instructions to describe the grouping and calculation you want. For example, you can group by a different time period, use a different picker field, or calculate a different rate from the same exported rows.