keepcalculator

06 Numbers and Powers

Workflow Automation: What to Measure First

Card No. 06·68746 · Updated · Standard formula, shown below

Before you automate any workflow, you must measure its current baseline performance—specifically cycle time, cost per run, error rate, and throughput—so you have a comparison point to prove the automation’s value and to set realistic targets. You also need to measure the stability and variability of those metrics, because a process that fluctuates wildly will need different automation design than one that is steady. This article explains exactly which metrics to capture, how to capture them, and how to use them to define success before you write a single automation rule.

Why Baseline Measurement Matters

Most automation projects fail not because the tool is bad, but because the team cannot articulate what “better” looks like. If you don’t know your current cycle time, you cannot claim that automation reduced it from 45 minutes to 5 minutes. If you don’t track error rates, you cannot prove that automation improved quality. A baseline gives you three things: a justification for the project, a target for the design, and a way to measure success after launch.

Without a baseline, you also risk automating a process that is already broken. If the current process has a 30% error rate because the input data is messy, automation will simply produce errors faster. Measuring first helps you spot these root causes before you invest in software.

Which Metrics to Capture (and Which to Ignore)

Focus on four core metrics that are directly tied to business outcomes. Ignore vanity metrics like “number of steps automated” or “hours of work moved” because they do not correlate with value.

  • Cycle time: The total time from start to finish for one unit of work. Measure in minutes or hours, and record the average, median, and standard deviation. The median is more useful than the average if you have outliers.
  • Cost per run: The fully loaded cost of completing one unit manually, including labor, materials, and overhead. If you pay an employee $30/hour and the task takes 10 minutes, that is $5 per run in labor alone.
  • Error rate: The percentage of runs that require rework, correction, or rejection. This is often the most compelling metric for automation because errors are expensive and visible.
  • Throughput: How many units you can complete per hour or per day. Automation often increases throughput, but only if the process is not bottlenecked elsewhere.

Also measure the variability of these metrics. If your cycle time ranges from 10 to 90 minutes depending on the day, your automation design must handle peak loads differently than if it were steady at 45 minutes.

How to Collect the Data

You do not need a complex analytics tool to get a baseline. Start by observing the process for one to two weeks and recording each run manually in a spreadsheet. If the process is digital, you can often pull timestamps from your CRM, ticketing system, or database logs. For manual tasks, use a time-tracking app or simply ask the person doing the work to note start and end times.

For cost per run, calculate the fully loaded labor cost (salary plus benefits, taxes, and overhead) divided by the number of working hours in a year (roughly 2,080 for full-time). Then multiply by the average cycle time. Add any material costs, software licenses, or fees that are consumed per run.

For error rate, review a sample of at least 30 completed runs and count how many had to be redone or corrected. If you have a QA step, the percentage of items that fail QA is your error rate.

Common Mistakes in Pre-Automation Measurement

The most frequent mistake is measuring only the happy path. If a process takes 10 minutes when everything goes smoothly but 60 minutes when data is missing, you must capture both scenarios. Otherwise, your automation may be designed for the ideal case and fail in real conditions.

Another mistake is measuring a single week that happens to be unusual—for example, the week after a holiday or during a system upgrade. Collect data over a full business cycle, or at least two weeks, to get a representative sample.

Finally, do not forget to measure the cost of the automation itself. A common misconception is that automation is free; in reality, the software, integration, and ongoing support have real costs that must be included in your ROI calculation.

How to Use the Baseline to Set Targets

Once you have your baseline, set targets that are realistic but ambitious. For cycle time, a 50–80% reduction is often achievable for well-defined, rule-based tasks. For error rate, aim for near zero, but be aware that automation can introduce its own errors if the input data is messy. For cost per run, you should see a drop proportional to the labor time eliminated, but remember that you still pay for the automation tool and any human oversight.

Use the baseline to decide whether the process is even worth automating. A rule of thumb: if the process takes less than 5 minutes per run and happens fewer than 10 times a month, the setup cost of automation may not be justified. If it takes hours and happens daily, automation is likely a high-value target.

Comparing Automation Tools: What to Measure in the Tool

When evaluating automation software, measure the same metrics you captured for your baseline, but now for the tool itself. Key criteria include:

  • Setup time: How many hours does it take to build the automation? This is part of your implementation cost.
  • Maintenance burden: How often do you need to update the automation when the underlying system changes? Look for tools with low-code or no-code interfaces that non-developers can maintain.
  • Scalability: Can the tool handle your peak volume without slowing down? Test with twice your normal load.
  • Error handling: What happens when the automation encounters an unexpected input? Does it stop, skip, or alert someone? This directly affects your error rate after automation.

Also consider the human cost: who will build and maintain the automation, and what is their hourly rate? A tool that takes 40 hours to set up will cost you $2,000–$4,000 in labor alone, which may or may not be worth it depending on your monthly savings.

Frequently Asked Questions

How long should I measure the baseline?

At least two weeks, or one full business cycle if your process is weekly or monthly. This captures normal variation without waiting too long to start the project. If the process is highly seasonal, measure during both a busy and a slow period.

What if I don’t have any data on error rates?

Start tracking now. For the next 30 runs, mark each one as pass or fail. If you cannot wait, estimate conservatively—use 10% if you suspect errors are common, or ask the person doing the work for their rough estimate. Even a rough baseline is better than none.

Should I measure time in minutes or hours?

Use minutes for tasks that take under an hour, and hours for longer tasks. The key is consistency—always use the same unit when comparing before and after.

Is it worth automating a process that only takes 2 minutes?

Only if it happens very frequently (hundreds of times per month) or if the error rate is high. A 2-minute task done 500 times a month is 16.7 hours of work—automation could save meaningful time. But if it happens 10 times a month, the setup cost likely outweighs the benefit.

What is the single most important metric to measure?

Cycle time is the most universally useful because it is easy to measure and directly reflects efficiency. However, error rate often has the highest financial impact because errors lead to rework, customer dissatisfaction, and compliance issues. Measure both, but if you can only track one, choose cycle time for simplicity and error rate for impact.

How do I measure cost per run if the process involves multiple people?

Add up the labor time of all people involved, then multiply by their respective hourly rates. If one person spends 5 minutes and another spends 15 minutes, the total is 20 minutes of labor. Use the blended average rate if their pay differs significantly.

Related

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.

More cards in this drawer

The whole Numbers and Powers drawer →