Calculate the Completion Rate:
Use the values from the columns "[Column with total task completions]" and "[Column with total task starts]" in the attached CSV to calculate the Completion Rate using the following formula:
Completion Rate = (Total Task Completions ÷ Total Task Starts) × 100
After calculating the Completion Rate, report where it lands on the following scale (higher is better):
Very Good = ≥ 90%
Good = 70–89%
Average = 50–69%
Poor = 30–49%
Very Poor = 0–29%
Next, analyze the responses in the column "[Column with qualitative explanations]" in the CSV to identify common blockers that prevent completion and provide clear, actionable suggestions for how the Completion Rate could be improved.
Completion Rate — Example Report
Summary
Completion Rate: 74.0% → Good
Total Task Starts: 500
Total Task Completions: 370
Total Failures: 130
Calculation
Completion Rate
=
370
500
×
100
=
74.0
%
Completion Rate=
500
370
×100=74.0%
Scale placement: 74.0% falls in Good (70–89%).
Key Breakdowns (from CSV)
By device
Mobile: 300 starts / 204 completions → 68.0% (Average)
Desktop: 200 starts / 166 completions → 83.0% (Good)
By funnel step (drop-off)
Step 1: Login → 480 users passed (96%)
Step 2: Form input → 410 users passed (85%)
Step 3: Review → 380 users passed (76%)
Step 4: Final confirmation → 370 users completed (74%)
Largest loss: Step 2 (form input) → 14% drop-off.
Qualitative Insights (theme analysis of explanations column)
Top themes and share of mentions:
Confusing form fields / unclear labels — 33%
“I wasn’t sure what to enter in the ID field.”
Validation errors without guidance — 27%
“Got an error message but didn’t know how to fix it.”
Session timeouts (mostly mobile) — 20%
“Lost my progress when I switched apps.”
Too many steps for simple task — 12%
Slow page reload on review step — 8%
Recommendations (prioritized)
Simplify form inputs: add placeholder examples, consolidate redundant fields.
Improve error handling: display inline, actionable fixes (e.g., “Password must be 8+ characters”).
Extend session timeouts on mobile and add autosave of progress.
Streamline flow: consider collapsing review + confirmation into one step.
Optimize review step speed by reducing server calls and enabling local validation.
Next Checks
Run usability test on form input step to validate clearer labeling.
Monitor mobile completion vs. desktop after timeout changes.
A/B test simplified flow to aim for ≥85% completion (Very Good).
Target: improve overall completion rate from 74% → ≥90%.