How to Find Your Least Profitable Project Type
Not all project types pay equally. Here is how to use your time logs to find the ones quietly draining your margin.
Most freelancers can name their best client. Fewer can name their worst project type. Those are different things, and confusing them costs money.
A great client can still bring you a project type that bleeds hours. The relationship feels good. The invoices get paid. But when you look at what you actually earned per hour, the number is embarrassing.
The fix is not about firing anyone. It is about knowing which category of work consistently underperforms before you say yes to more of it.
Start With Categories, Not Clients
Pull your time data for the last six months. Group every project by type, not by client. Design retainer. Development project. Strategy session. Content production. Whatever fits your work.
Now calculate total hours logged per category, total invoiced per category, and effective hourly rate per category.
That last number is the one that matters. It is not what you quoted. It is what you actually earned per hour after everything was done.
Some project types will surprise you. The work you find easy often takes longer than you think because it feels low-stakes. The work you dread might pay better because you scope it carefully.
The Hidden Cost of Familiar Work
There is a trap in comfortable work. Because it does not feel hard, you do not protect it. You let it expand. A client adds a meeting. You answer a question that turns into a consultation. You do a round of revisions that was never in the scope.
None of that gets logged separately. It just bleeds into the project hours. And when you calculate what you earned, it looks like a bad project. Really it was a bad category with no boundaries.
This is why logging matters at the task level, not just the project level. If you can see that strategy calls consistently go 40 percent over the logged estimate, that is a pricing signal. If content revisions add half a day every single time, that is a scope signal.
What the Data Usually Shows
When freelancers run this exercise honestly, a few patterns show up.
Flat-rate projects almost always have a lower effective rate than hourly ones because the estimate was built on optimism. Project types with lots of client interaction cost more time than the deliverable itself. Work that involves waiting, like waiting for feedback or approvals, inflates the calendar without adding billable hours.
None of this is obvious until you look at the numbers.
How to Use This Information
Once you know which project types underperform, you have a few choices.
You can raise the rate for that type. If you have been doing it for years and clients keep hiring you for it, the market will probably hold a higher price. You can tighten the scope. Build the boundaries in before the project starts so the hours do not expand by default. You can stop offering it. If the margin is consistently bad and you do not enjoy the work, that is an easy decision.
Or you can keep things exactly the same but at least stop being surprised by the outcome.
Time Tracking Makes This Possible
You cannot run this analysis from memory. You cannot run it from an invoice history that only shows totals. You need the hours, broken down by project and task, over a long enough window to see the pattern.
A tool like Time-Trak logs those hours in real time, attached to the right project and client, so when you want to do this kind of review you are not reconstructing anything. You are just reading the data that already exists.
The goal is not to optimize everything to death. The goal is to stop repeating the same underpriced mistake in a different project name.
Track your time, bill every minute.
Time-Trak is a native Mac and Windows time tracker with a floating timer, automatic screenshots, and one-click invoicing.
Free during beta.
Download Time-Trak →macOS + Windows · Floating widget · Auto screenshots