Activation & onboarding review

MEMO

To: Onboarding squad Re: Where we lose people, and what to fix first

Where we lose people

• Signup to connect (100% to 41%): The largest loss. Most of our users are PMs and marketers who don't have database credentials, and the flow gives them no way forward without them.
• Connect to first chart (41% to 33%): About a fifth of people who connect never build a chart. Sync and the empty canvas are the likely causes.
• First chart to invite (33% to 9%): Expected, since invites come after value. Lower priority for now.

Retention is the reason to care about the first chart: 62% of users who reach one are active in week 2, versus 11% of those who don't. This is correlational, since engaged users may be the ones who build charts, but it is the strongest signal we have.

What to fix, in order

1. Add sample data and a skip at step 5. Users without credentials currently hit a dead end. Sample data gets them to a chart in minutes, which is the milestone that predicts retention. This also targets the top support ticket (41%). Reason: highest expected impact on the number that matters.

1. Let people in before email verification, and drop the role and team screens from the critical path. Step 2 blocks all progress, and steps 3–4 ask questions before the user has seen any value. Move role and team to after the first chart, where they can personalize templates. Reason: removes the earliest friction, when drop-off is highest.

1. Rebuild the credentials path. Replace the 14-page guide with short, per-warehouse steps for Postgres, BigQuery and Snowflake, and add a "send these instructions to your data engineer" link that delivers a connect-only invite. The person who has the credentials is often not the person signing up. Reason: addresses the remaining credential tickets and the step 6 drop-off.

1. Fix sync. Let leaving the page not cancel the sync. Show partial results as tables finish. Pre-select likely tables and add search to the step 7 list. Make CSV upload the fastest route to a first chart. Reason: sync failures are the second-largest ticket category (18%), and cancellation on exit loses users mid-setup.

1. Make the first chart appear without effort. Templates (step 9) should render a live chart immediately. Replace the empty canvas at step 10 with a suggested chart the user can edit. Reason: a blank canvas is the last hurdle before the retention milestone.

1. Move team invites after the first chart, and prompt for them there. Keep the skip link. Reason: invites are useful but come after value; test this once the upstream fixes land.

Measurement

Track signup-to-first-chart as the primary metric, with week-2 retention as the outcome. Run fixes 1 and 2 as separate experiments so we can see which one moves the funnel.

To: Onboarding Squad Subject: Fixing Our Activation Funnel: Priorities & Action Plan

Where We Are Losing People

Our biggest drop-off occurs at Step 5–8 (Connect Data): 59% of signups leave without connecting a data source.

We are asking PMs and marketers for database ports, SSL modes, and passwords they do not possess. 41% of our support tickets are “I don't have credentials,” followed by 18% for failed syncs. Furthermore, requiring a 20-minute, open-tab sync kills momentum.

Because Week-2 retention jumps from 11% to 62% once a user builds their first chart, our sole objective is getting non-technical users to that "aha!" moment in under two minutes.

---

What to Fix (In Priority Order)

#### 1. Add “Explore with Sample Data” & a Clear “Skip” Button (Step 5) * What: Let users bypass database connection entirely using a fully populated e-commerce or SaaS demo dataset. * Why: This is the highest-leverage fix. It immediately unblocks the 59% who drop off at Step 5 and the 41% who lack DB credentials, giving them an instant path to create a first chart and experience the product’s value on Day 1.

#### 2. Introduce “Invite a Data Teammate” at Connection (Step 6) * What: Add a 1-click option: “Don't have credentials? Send an invite link to your data lead to connect your warehouse.” * Why: Replaces a dead end with collaboration. The PM stays in the app using sample data while the engineer handles credentials asynchronously.

#### 3. Make Syncing Asynchronous (Step 8) * What: Run syncing in the background. Notify users via email/in-app alert when ready instead of forcing them to keep a 20-minute tab open. * Why: Directly addresses our second-biggest support issue (18% sync failures/cancellations) and eliminates the drop-off caused by tab abandonment.

#### 4. Pre-Populate the Dashboard; Kill the Blank Canvas (Steps 9 & 10) * What: When a user selects a template, generate it automatically with 3–4 standard charts instead of dropping them onto an empty canvas. Prompt them to tweak one existing chart. * Why: Bridges the 8% drop-off between connecting data (41%) and creating a first chart (33%). Editing an existing chart is far lower friction than building from scratch.

#### 5. Defer Email Verification and Profiling Questions (Steps 2, 3, & 4) * What: Move verification to a non-blocking banner at the top of the app, and cut or defer the role/team-size questions until after the user creates their first chart. * Why: Every barrier before core value reduces trial-to-paid conversion. Let users reach the product before demanding administrative tasks.

---

Next Step

Let’s implement Priority 1 (Sample Data) this sprint. It requires zero infrastructure changes to our warehouse sync logic and directly targets our biggest activation leak.

To: Onboarding Squad Subject: Where onboarding is leaking—and what to fix first

The biggest loss is before a data source is connected: only 41% of signups get that far. Another 8 percentage points drop before a first chart. Just 9% of signups invite a teammate. The strongest activation signal is the chart: week-2 retention is 62% for users who reach one, versus 11% for those who don’t. Prioritize getting people to a useful chart; treat invites as a later step.

Fixes, in priority order

1. Offer a sample-data path that reaches a real first chart. Let users skip connecting their own data and explore a preloaded dataset, with a clear route to connect later. Many signups are PMs and marketers, and the most common onboarding ticket is missing database credentials (41%). A required technical connection is an especially poor first step for them. This also gives users value while they wait for access.

1. Make connecting data simpler and recoverable. Replace or supplement the 14-page guide with short, connector-specific instructions and troubleshooting. Validate credentials early, explain the required access, and offer a clear retry path. Don’t cancel a sync when someone leaves the page; send progress and failure notices and let users resume. The credential and sync tickets point to concrete blockers, and successful connection is the gateway to the high-retention chart experience.

1. Get users to a chart with fewer decisions. Replace the database-wide table list with suggested tables and plain-language descriptions; cut the 12 dashboard templates to a few recommended starting points. Provide a prebuilt chart or guided first-chart flow rather than an empty canvas. The 8-point drop between connection and first chart, plus the sync burden, suggests too much work remains after connection.

1. Remove early friction that doesn’t create value. Test deferring email verification until after users enter the product, and move role/team questions until they can personalize something useful. These steps currently delay access before users see value.

1. Make inviting a teammate contextual, not a hurdle. Keep it optional; prompt after a user has made or shared a chart, and explain the benefit. Only 9% of signups invite someone, but chart reach—not inviting—is the clearest retention signal.

Track step conversion and time-to-first-chart by path, especially sample-data versus live connection, before expanding the changes.