Direct answer
A 30% workaround rate is good news and a warning. It proves the problem is real enough that people act on it, and it also means we are competing with something that already half works. I would find out what the workarounds are and what they cost users, size the market by what people pay to keep the problem tolerable, build first what replaces the workaround's critical steps, and pivot only if no segment exists where our product clearly beats the workaround's total cost.
Terms. A workaround is anything a person uses instead of a dedicated solution (a spreadsheet, a script, a competitor tool, a manual process). Segmentation means splitting respondents into groups whose behaviour differs.
Switching cost means everything a user gives up by changing tools (time to migrate, retraining, lost habits). A price anchor is the figure customers already compare any price against. A wedge is a narrow entry point where you clearly win, used to get a first foothold. Parity means matching a competitor on a feature, so that it stops being a reason to stay.
1. Segment the 30%
Split by company size, role, frequency of the problem, and workaround type. Compare against the 70% without one: do they lack the problem, or have it and tolerate it? The survey cannot answer that, so ask directly.
2. Follow-up interviews
Interview a handful from each workaround type until answers repeat (new interviews stop teaching you anything new). Ask about the last time they used it, what it costs in hours and money, what breaks, who maintains it, and what they tried before.
3. Verify the workaround
Ask for a screen-share or the artefact itself. Self-reports are often optimistic: a "solution" people mention may be abandoned, rarely used, or a poor fit.
4. Market sizing and prioritization
Count three tiers: no workaround, a free workaround, a paid workaround. A paid workaround shows willingness to pay and sets a price anchor. A free one means we must beat it on effort saved plus switching cost. Size each tier separately, then sum only the tiers you can credibly win.
Worked example (illustrative numbers)
400 respondents, 30% = 120 with workarounds: 70 spreadsheets, 30 paid vendors, 20 manual (70 + 30 + 20 = 120).
Turning that into tier sizes. Suppose the survey is a fair sample of 50,000 target companies (an assumption to check). Then 30% = 15,000 have a workaround and 35,000 do not. Within the 15,000, the survey shares are 70/120, 30/120 and 20/120, so spreadsheets = 8,750, paid vendors = 3,750, manual = 2,500 (sum 15,000). The free tier (spreadsheets plus manual) is 11,250, the paid tier is 3,750. The paid 3,750 prove people pay and give the price anchor. The 11,250 free-workaround companies are the main market, but only the share for whom the time cost exceeds our price plus switching cost is winnable.
Testing the price against the workaround. A spreadsheet user losing 5 hours a week at $40 an hour pays 5 x 40 x 52 = $10,400 a year in time. A $2,400 subscription is about 23% of that, so on time alone it breaks even if it removes about 23% of that work (roughly 1.2 of the 5 hours a week). Buyers also weigh switching cost and the risk that the tool underdelivers, so I would want it to remove well over half of the hours before calling it an easy sell. That comparison is the test because a buyer weighs the price against the cost they already bear. Hours and hourly cost are self-reported, so verify them in the follow-up interviews before using them.
Prioritize in this order, with the reason for each: (1) import from the workaround, because switching cost is the main barrier and 8,750 spreadsheet users start with data they will not retype; (2) the steps that cost users the most time, because that is the value the price is compared against; (3) parity with the paid vendor on the core job, because the 3,750 paid users will not move while a key capability is missing; (4) differentiators last, because they only matter once the first three stop users from leaving.
5. When this is a reason to pivot
- Workaround users say it is good enough, cheap and rarely breaks.
- A paid incumbent is entrenched (it holds the customers and their habits, with long contracts or heavy integration) and we cannot beat it on cost or quality.
- No segment exists where workaround cost exceeds our price plus switching cost, and that is large enough for the plan.
The pivot can be a different segment (for instance the 70% if the pain is real but untreated), a narrower wedge (the workaround's weakest step), or stopping.
Pitfalls
Counting every workaround user as demand double-counts them with the sizing of the whole market, and treating "has a workaround" as "has no problem" throws away the best evidence you have.