Activation & onboarding review

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

Summary: Reaching a first chart is what predicts retention (62% at week 2 versus 11% otherwise). Only 33% of signups get there, and the biggest loss, 59% of signups, happens before they connect data. Most of our users are PMs and marketers who can't complete a database connection alone.

Fixes, in priority order

1. Add sample data and a skip option on the "Connect your data" screen. The most common ticket (41%) is "I don't have the database credentials." We ask non-engineers for host, port and SSL mode before they've seen any value. Sample data lets them reach a chart in minutes, and they can connect real data later. Caveat: sample-data users may retain worse than the 62% figure, which likely reflects real data. Track them as a separate cohort and prompt them to connect real data after their first chart.

2. Make it easy to get credentials from someone else. Add a "Send this to your engineer" option: a shareable link or prefilled email containing the connection form and a short setup checklist. Replace the 14-page guide with inline, per-field help. Promote CSV upload as the no-engineer path, since it's currently one of four equal options.

3. Fix the sync experience and its failures. Syncs run up to 20 minutes and cancel if the user leaves. Run them in the background, send an email when they finish, and let users start exploring once the first tables land. Then look at the 18% of tickets that say "my sync failed" and surface specific error messages. In the table-selection step, preselect a sensible default instead of listing every table.

4. Get people to a first chart without an empty canvas. We show twelve templates, then a blank chart builder. Cut the choice to two or three based on role, and auto-generate a first chart from the synced data (or sample data) that the user can edit. This targets the 41% → 33% drop and shortens time to value.

5. Remove friction at the front. Let users into the product before email verification, and enforce it later (e.g., before inviting teammates). Move the role question ahead of template selection, where it drives the default, and drop or defer team size unless something uses it. These are cheap fixes, but I'm ranking them below the others because I can't yet show they're a big loss.

6. Move the invite prompt to after the first chart. The 9% invite rate is 27% of users who reach a chart, so it's mostly a downstream symptom. Fix activation first. Then trigger the invite prompt right after a first chart is created, with a message like "Share this chart," rather than as a generic final step.

Measure first The funnel jumps from signup straight to data connection, so we can't see how many people drop at email verification, role, team size, or the connection form. Add per-screen events this sprint, before changing anything, so we can confirm the ordering above and measure each fix.

Success metrics: signup → first chart (33% today), share of users who connect real data within 7 days, sync failure rate, and week-2 retention split by sample-data versus real-data users.

To: Onboarding squad Subject: Fix access and sync before optimising chart creation

Our biggest measured loss is before data connection: 59% of signups, roughly 7,300 people, never connect a source. We ask PMs and marketers to complete a database setup that many cannot do themselves, then make a lengthy sync depend on keeping a page open.

Another 8 percentage points disappear between connection and first chart: about 20% of those who connect. Teammate invitations fall to 9% of signups, but we should establish whether collaboration is necessary for value before treating that as our next bottleneck.

First-chart users have much higher week-2 retention, 62% versus 11%. That makes chart creation a promising activation milestone, but does not prove that pushing everyone through a chart will cause better retention.

Fix in this order

1. Give users a route forward without database credentials. Offer a clearly labelled sample-data experience and make CSV upload a prominent alternative.¹ Add a setup hand-off that lets users ask a colleague to connect the source, then resume when it is ready. Replace the generic setup guide with short, source-specific instructions.

This addresses the largest measured loss and the strongest support signal: missing credentials account for 41% of onboarding tickets. That is a share of tickets, not signups, so we cannot yet quantify how much drop-off it explains. Sample data should demonstrate value while preserving a clear path to the user’s own data.

2. Make syncing durable and recoverable. Run syncs in the background so closing the page does not cancel them. Show meaningful status, explain failures and allow retries without repeating setup. Notify users when their data is ready.

A 20-minute foreground wait is a fragile requirement. Sync failures generate 18% of onboarding tickets and can waste the effort users have already invested.

3. Turn connected data into a useful first chart. Help users identify relevant tables instead of presenting every table equally. Use their chosen template to produce an editable chart from compatible data, with guided choices where mapping is needed. Do not finish template selection with an empty canvas.

This targets the roughly one in five connected users who never reach a chart. Measure whether they produce something useful, not merely whether a chart renders.

4. Remove avoidable preliminary work. Defer role and team-size questions unless their answers immediately improve setup. Review whether email verification must block exploration, retaining verification where required for account security.

These steps add friction before value, but we lack evidence that they drive the main loss.

Measure alongside delivery: instrument each screen, connection method, error and return visit. Test changes against first charts using customers’ own data, week-2 retention and trial-to-paid conversion. Track sample-data charts separately. Revisit invitations once we understand whether users need collaboration to succeed. To: Onboarding squad Subject: Fix access and sync before optimising chart creation

Our biggest measured loss is before data connection: 59% of signups, roughly 7,300 people, never connect a source. We ask PMs and marketers to complete a database setup that many cannot do themselves, then make a lengthy sync depend on keeping a page open.

Another 8 percentage points disappear between connection and first chart: about 20% of those who connect. Teammate invitations fall to 9% of signups, but we should establish whether collaboration is necessary for value before treating that as our next bottleneck.

First-chart users have much higher week-2 retention, 62% versus 11%. That makes chart creation a promising activation milestone, but does not prove that pushing everyone through a chart will cause better retention.

Fix in this order

1. Give users a route forward without database credentials. Offer a clearly labelled sample-data experience and make CSV upload a prominent alternative. Add a setup hand-off that lets users ask a colleague to connect the source, then resume when it is ready. Replace the generic setup guide with short, source-specific instructions.

This addresses the largest measured loss and the strongest support signal: missing credentials account for 41% of onboarding tickets. That is a share of tickets, not signups, so we cannot yet quantify how much drop-off it explains. Sample data should demonstrate value while preserving a clear path to the user’s own data.

2. Make syncing durable and recoverable. Run syncs in the background so closing the page does not cancel them. Show meaningful status, explain failures and allow retries without repeating setup. Notify users when their data is ready.

A 20-minute foreground wait is a fragile requirement. Sync failures generate 18% of onboarding tickets and can waste the effort users have already invested.

3. Turn connected data into a useful first chart. Help users identify relevant tables instead of presenting every table equally. Use their chosen template to produce an editable chart from compatible data, with guided choices where mapping is needed. Do not finish template selection with an empty canvas.

This targets the roughly one in five connected users who never reach a chart. Measure whether they produce something useful, not merely whether a chart renders.

4. Remove avoidable preliminary work. Defer role and team-size questions unless their answers immediately improve setup. Review whether email verification must block exploration, retaining verification where required for account security.

These steps add friction before value, but we lack evidence that they drive the main loss.

Measure alongside delivery: instrument each screen, connection method, error and return visit. Test changes against first charts using customers’ own data, week-2 retention and trial-to-paid conversion. Track sample-data charts separately. Revisit invitations once we understand whether users need collaboration to succeed.