Skip to content
Academy
Marketing Academy · Field Work●Marketing Fundamentals
MiniAudit· 30 minutes

Find the Leak: Auditing a Self-Serve Signup Funnel

Squarespace

Objective: Given a synthetic step-by-step signup funnel with drop-off numbers for a website-builder product, identify where time-to-value is being lost and which step is the highest-leverage fix.

You're a growth PM at Squarespace. A new self-serve signup flow launched last month and weekly trial-to-paid conversion dropped. You've pulled the funnel's step-by-step numbers to find out where.

Walk the funnel, flag the step with the steepest drop-off relative to how far the user already is from value, and recommend the single change most likely to shorten time-to-value.

Before you start

What you'll need

Free path (everything below is enough to finish)

FreeLay out the funnel steps and compute drop-off percentages

Free, and pivot-table friendly for a 5-row funnel export

The process

1 step

Step 01 of 01

Time-to-Value (TTV)

Time-to-Value is the duration it takes a new user to experience their first win, and minimizing it is the single most effective lever for improving activation rate.

Given this funnel, which drop-off is a normal signup-friction loss, and which one is actually a time-to-value problem, a step where the user is close to their first win but leaves anyway?

Google Sheets— Import the funnel export, one row per step, with a `users_reached` and `dropoff_pct` column.

Procedure

  1. List all 5 funnel steps with users reached and drop-off percentage at each
  2. Mark which steps happen before the user has seen any real output from the product (pre-value) and which happen after (post-value)
  3. Flag the step with the highest drop-off that occurs after the user is already close to a first win
  4. Write the one recommended fix for that specific step
Sample output
STEP           USERS   DROPOFF
Signup form     1,000    12%
Email verify      880     8%
Template pick      810    35%  <- FLAGGED
Domain connect     527    15%
First publish      448     -

FLAGGED STEP: Template pick. Users have already verified their email (committed) and are one click from seeing a live site (near value), yet lose over a third of the funnel here.

Healthy

The steepest post-commitment drop-off sits right before the user would see their first real output.

Unhealthy

Treating the signup-form drop-off (12%) as the priority because it's the first number in the list, when it's normal top-of-funnel friction, not a time-to-value problem.

What this means

A user who already verified their email has invested effort; losing 35% of them one step before they'd see a live site means the template picker itself, not the product's value, is the barrier.

So what do I do about it?

SymptomActionEffort
35% drop-off at template selection, right before first publishCut the template choice to 3 curated options with a 'skip, use default' path so the first published site appears fasterhalf day
EitherYou or a developer can handle this, depending on your access.

Final deliverable

A funnel audit table flagging the highest-leverage drop-off step with a specific recommended fix.

See a reference example
Sample output
Navattic Signup Funnel Audit (excerpt)

STEP              USERS   DROPOFF
Account created    1,200    10%
Connect data source  1,080  40%  <- FLAGGED
Build first demo      648   18%
Share demo link        531    -

FLAGGED STEP: Connect data source. Users already created an account (committed) and are two steps from their first published demo (near value), but 40% abandon at the data-connection step.

RECOMMENDATION: Add a 'use sample data' skip option so users can reach a first demo before connecting their own source.

Success criteria

You're done when you can:

  • Correctly separates pre-value friction from a genuine time-to-value leak
  • Flags the step with the steepest post-commitment drop-off, not just the largest raw number