Voice Notes: BigQuery Findings (Subscriber vs. Non-Subscriber)

Source: BigQuery project stxt-490006 · Author: Karen · Analysis run 2026-08-31
Supporting data for the decision to hard-gate voice mode and A/B test voice notes for non-subscribers (see D2C-5655). Three analyses below: overall event split by subscription status, non-subscriber repeat-usage and monetization, and the whale/subscriber value pattern.

1. voiceNotePlayed events: subscribed vs. non-subscribed users

VERIFIEDstxt-490006.d2c_prod.voice_note_played joined to stxt-490006.d2c_prod_dbt_stxt_analytics.fct_user_lifecycle_profile on user_id, using flag_is_subscription_payer as the subscription flag. Figures below are de-duplicated for a tracking bug described in the Methodology section.

CohortReal plays% of playsDistinct usersPlays / user
Subscribed9,66510.3%90107.4
Not subscribed84,50989.7%6,15213.7
Total94,174100%6,242
Key takeaway: subscribers are only 1.4% of users who ever trigger voiceNotePlayed, but generate 10.3% of play volume — a subscribed user plays voice notes ~7.8x more often per capita than a non-subscriber.

2. Non-subscribed users who play 2+ voice notes

VERIFIED — same join, restricted to flag_is_subscription_payer = FALSE, deduped real-play counts per user.

Engagement depth

Real playsUsers%
1 (one-and-done)1,47424%
2–41,89631%
5–91,12818%
10+1,65427%
2 or more4,67876%

Monetization by engagement depth

Play bucketUsersEver paid anythingBought tokensAvg lifetime cash
1 play1,4743 (0.2%)3$0.04
2–4 plays1,8961 (0.05%)1$0.01
5–9 plays1,1284 (0.4%)4$0.05
10+ plays1,65410 (0.6%)10$0.19
Key takeaway: 76% of non-subscribed voice-note users are repeat users, and 27% are heavy repeat listeners (10+ plays) — but across every engagement tier, under 1% have ever paid for anything, subscription or tokens (flag_is_whale = 0 in every bucket). Strong demand signal, no current monetization.

3. Whale archetype — does voice-note usage track subscriber value?

VERIFIED — from fct_user_lifecycle_profile.flag_is_whale, joined against the same de-duplicated per-user play counts, restricted to flag_is_subscription_payer = TRUE.

Subscriber play bucketUsersWhalesAvg lifetime cashAvg value score
1–4 plays290$17.0082.0
20–99 plays221$23.8289.0
5–19 plays232$28.2684.0
100+ plays161$31.5693.0
Key takeaway: whale status is exclusively a subscriber phenomenon, and among subscribers it skews toward heavier voice-note usage — zero whales in the lightest bucket (1–4 plays), roughly double the average lifetime spend in the heaviest bucket (100+ plays) vs. the lightest. Voice notes correlate with subscriber value, not just subscriber retention. LIKELY — small sample (90 users, whale counts of 0–2 per bucket), directional not precise.

Methodology note: de-duplication

Double-fire bug found in voiceNotePlayed: the same physical play is logged twice, ~3ms apart, with two different event IDs (same user_id + creator_id). Confirmed via gap analysis on consecutive same-user/creator events — 99,879 of ~182K gaps are under 1 second, a sharp spike with nothing comparable in the 1–5s range. Raw event counts run ~2x real plays. All figures above collapse events into "real plays" using a 1-second window (any same-user/creator event fired <1s after the prior one is treated as the same physical play, not a new one). Raw (undeduped) totals were 193,778 events / 6,231 users, split 10.1% subscribed / 89.9% non-subscribed by event count — the percentage split is essentially unchanged by dedup; only absolute counts and per-user averages are corrected.