Files
Pamela ChiaandJoshen Lim 4a941518e3 feat(studio): track Explorer runs and saves (#51004)
I added outcome events for Explorer query runs and successful manual
notebook saves. Existing page visits and preview toggles do not show
whether users complete queries or persist notebooks.

**Changed:**
- **Query usage:** Accepted runs from query tabs and notebook cells emit
submitted and terminal outcome events with a shared run ID. Canceled
confirmations emit no run events.
- **Notebook adoption:** Successful manual saves emit created or updated
events. Recreated notebooks count as creations. Unsaved drafts and
failed saves emit neither.
- **Event metadata:** Explorer action events use `Explorer` as their
page title.

**Note:** Assistant-generated saves are outside this PR. Custom
properties omit SQL and notebook content. Page visits still carry the
browser title, which can include a notebook name.

## To test

Tested on the staging preview:
- [x] Run valid and invalid SQL from an Explorer query tab. Each run
emits one submitted event and one matching completed or failed event
with the same run ID.
- [x] Run database and Logs notebook query cells, then add a markdown
cell. The query cells emit matching event pairs; the markdown cell emits
no query event.
- [x] Save a new notebook, then edit and save it again. The successful
saves emit created and updated events.
- [x] Cancel a guarded query. It emits no query run event.
- [ ] Recreate a notebook deleted on the server after local edits. A
successful save emits created, not updated.
- [x] Inspect an Explorer action event request. Its page title is
`Explorer`; page visits still use the browser title.
- [ ] Force a notebook save failure. It should emit no save event. This
case was not tested manually.

## Linear
- fixes GROWTH-1298


<!-- This is an auto-generated comment: release notes by coderabbit.ai
-->
## Summary by CodeRabbit

* **Analytics**
* Explorer query runs are tracked for database and log queries,
including whether they complete or fail.
* Query activity is associated with its location in Explorer, such as a
query tab or notebook cell.
  * Successful notebook saves are tracked as creations or updates.
<!-- end of auto-generated comment: release notes by coderabbit.ai -->

---------

Co-authored-by: Joshen Lim <joshenlimek@gmail.com>
2026-09-29 13:54:13 -07:00

501 lines
15 KiB
TypeScript

'use client'
import { components } from 'api-types'
import { useRouter } from 'next/compat/router'
import { usePathname } from 'next/navigation'
import Script from 'next/script'
import { useCallback, useEffect, useRef, useState } from 'react'
import { useLatest } from 'react-use'
import { useUser } from './auth'
import { hasConsented, useConsentState } from './consent-state'
import { createConsentedUrlCookieSync } from './consented-url-cookie'
import { IS_PLATFORM } from './constants'
import { useFeatureFlags } from './feature-flags'
import { post } from './fetchWrappers'
import type { FirstReferrerData, MwDiagData } from './first-referrer-cookie'
import {
isExternalReferrer,
isOAuthRedirectReferrer,
parseFirstReferrerCookie,
parseMwDiagCookie,
} from './first-referrer-cookie'
import { ensurePlatformSuffix, isBrowser } from './helpers'
import { useFirstTouchStore, useParams } from './hooks'
import {
buildSessionRecordingConfig,
posthogClient,
type CapturedNetworkRequest,
type ClientTelemetryEvent,
type SessionRecordingOptions,
} from './posthog-client'
import { TelemetryEvent } from './telemetry-constants'
import {
clearFirstTouchData,
getFirstTouchData,
type SharedTelemetryData,
} from './telemetry-first-touch-store'
import { getSharedTelemetryData, getTelemetryCookieOptions } from './telemetry-utils'
export {
buildSessionRecordingConfig,
posthogClient,
type CapturedNetworkRequest,
type ClientTelemetryEvent,
type SessionRecordingOptions,
}
export const TelemetryTagManager = () => {
const { hasAccepted } = useConsentState()
const [syncCookie] = useState(createConsentedUrlCookieSync)
const isGTMEnabled = Boolean(
IS_PLATFORM && process.env.NEXT_PUBLIC_GOOGLE_TAG_MANAGER_ID && hasAccepted
)
// Ad attribution capture is independent of GTM, so this runs even when the
// container is not configured.
useEffect(() => {
syncCookie(hasAccepted)
}, [hasAccepted, syncCookie])
if (!isGTMEnabled) return null
return (
<Script
id="consent"
strategy="afterInteractive"
dangerouslySetInnerHTML={{
__html: `(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start':new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0],j=d.createElement(s);j.async=true;j.src="https://ss.supabase.com/4icgbaujh.js?"+i;f.parentNode.insertBefore(j,f);})(window,document,'script','dataLayer','60a389s=aWQ9R1RNLVdDVlJMTU43&page=2');`,
}}
/>
)
}
function getFirstTouchAttributionProps(telemetryData: SharedTelemetryData) {
const urlString = telemetryData.page_url
try {
const url = new URL(urlString)
url.hash = ''
const params = url.searchParams
const getParam = (key: string) => {
const value = params.get(key)
return value && value.length > 0 ? value : undefined
}
const utmProps = {
...(getParam('utm_source') && { $utm_source: getParam('utm_source') }),
...(getParam('utm_medium') && { $utm_medium: getParam('utm_medium') }),
...(getParam('utm_campaign') && { $utm_campaign: getParam('utm_campaign') }),
...(getParam('utm_content') && { $utm_content: getParam('utm_content') }),
...(getParam('utm_term') && { $utm_term: getParam('utm_term') }),
}
const clickIdProps = {
...(getParam('gclid') && { gclid: getParam('gclid') }), // Google Ads
...(getParam('gbraid') && { gbraid: getParam('gbraid') }), // Google Ads (iOS)
...(getParam('wbraid') && { wbraid: getParam('wbraid') }), // Google Ads (iOS)
...(getParam('msclkid') && { msclkid: getParam('msclkid') }), // Microsoft Ads (Bing)
...(getParam('fbclid') && { fbclid: getParam('fbclid') }), // Meta (Facebook/Instagram)
...(getParam('rdt_cid') && { rdt_cid: getParam('rdt_cid') }), // Reddit Ads
...(getParam('ttclid') && { ttclid: getParam('ttclid') }), // TikTok Ads
...(getParam('twclid') && { twclid: getParam('twclid') }), // X Ads (Twitter)
...(getParam('li_fat_id') && { li_fat_id: getParam('li_fat_id') }), // LinkedIn Ads
...(getParam('bfcid') && { bfcid: getParam('bfcid') }), // Freebuff Ads
}
return {
...utmProps,
...clickIdProps,
first_touch_url: url.href,
first_touch_pathname: url.pathname,
...(url.search && { first_touch_search: url.search }),
}
} catch {
return {}
}
}
interface HandlePageTelemetryOptions {
apiUrl: string
pathname?: string
featureFlags?: Record<string, unknown>
slug?: string
ref?: string
telemetryDataOverride?: SharedTelemetryData
firstReferrerData?: FirstReferrerData | null
mwDiagData?: MwDiagData | null
}
function handlePageTelemetry({
pathname,
featureFlags,
slug,
ref,
telemetryDataOverride,
firstReferrerData,
mwDiagData,
}: HandlePageTelemetryOptions) {
if (typeof window !== 'undefined') {
const livePageData = getSharedTelemetryData(pathname)
const liveReferrer = livePageData.ph.referrer
const storedReferrer = telemetryDataOverride?.ph?.referrer
const shouldUseStoredReferrer = Boolean(
storedReferrer &&
isExternalReferrer(storedReferrer) &&
!isOAuthRedirectReferrer(storedReferrer) &&
(!isExternalReferrer(liveReferrer) || isOAuthRedirectReferrer(liveReferrer))
)
const pageData = telemetryDataOverride
? {
...livePageData,
ph: {
...livePageData.ph,
referrer: shouldUseStoredReferrer ? storedReferrer! : liveReferrer,
},
}
: { ...livePageData, ph: { ...livePageData.ph } }
const firstTouchAttributionProps: Record<string, string> = {
...(telemetryDataOverride ? getFirstTouchAttributionProps(telemetryDataOverride) : {}),
}
const firstReferrerCookiePresent = Boolean(firstReferrerData)
let firstReferrerCookieConsumed = false
if (
firstReferrerData &&
isExternalReferrer(firstReferrerData.referrer) &&
!isOAuthRedirectReferrer(firstReferrerData.referrer) &&
(!isExternalReferrer(pageData.ph.referrer) || isOAuthRedirectReferrer(pageData.ph.referrer))
) {
pageData.ph.referrer = firstReferrerData.referrer
firstReferrerCookieConsumed = true
const { utms, click_ids, landing_url } = firstReferrerData
Object.entries(utms).forEach(([key, value]) => {
const phKey = key.startsWith('utm_') ? `$${key}` : key
firstTouchAttributionProps[phKey] = value
})
Object.entries(click_ids).forEach(([key, value]) => {
firstTouchAttributionProps[key] = value
})
try {
const url = new URL(landing_url)
firstTouchAttributionProps.first_touch_url = url.href
firstTouchAttributionProps.first_touch_pathname = url.pathname
if (url.search) {
firstTouchAttributionProps.first_touch_search = url.search
} else {
delete firstTouchAttributionProps.first_touch_search
}
} catch {
// Skip if landing URL is malformed
}
}
const $referrer = pageData.ph.referrer
const $referring_domain = (() => {
if (!$referrer) return undefined
try {
return new URL($referrer).hostname
} catch {
return undefined
}
})()
if (pageData.session_id) {
document.cookie = `session_id=${pageData.session_id}; ${getTelemetryCookieOptions()}`
}
posthogClient.capturePageView({
$current_url: pageData.page_url,
$pathname: pageData.pathname,
$host: new URL(pageData.page_url).hostname,
...($referrer && { $referrer }),
...($referring_domain && { $referring_domain }),
...firstTouchAttributionProps,
$groups: {
...(slug ? { organization: slug } : {}),
...(ref ? { project: ref } : {}),
},
page_title: pageData.page_title,
...(pageData.session_id && { $session_id: pageData.session_id }),
...pageData.ph,
...Object.fromEntries(
Object.entries(featureFlags || {}).map(([k, v]) => [`$feature/${k}`, v])
),
// Only included on the initial pageview — subsequent pageviews omit firstReferrerData entirely
...(firstReferrerData !== undefined && {
first_referrer_cookie_present: firstReferrerCookiePresent,
first_referrer_cookie_consumed: firstReferrerCookieConsumed,
}),
...(mwDiagData && {
mw_diag_hit: mwDiagData.hit,
mw_diag_would_stamp: mwDiagData.would_stamp,
mw_diag_has_existing_cookie: mwDiagData.has_existing_cookie,
}),
})
}
return Promise.resolve()
}
export function handlePageLeaveTelemetry(
_API_URL: string,
pathname: string,
_featureFlags?: {
[key: string]: unknown
},
_slug?: string,
_ref?: string
) {
if (typeof window !== 'undefined') {
const pageData = getSharedTelemetryData(pathname)
posthogClient.capturePageLeave({
$current_url: pageData.page_url,
$pathname: pageData.pathname,
page_title: pageData.page_title,
...(pageData.session_id && { $session_id: pageData.session_id }),
})
}
return Promise.resolve()
}
export const PageTelemetry = ({
API_URL,
hasAcceptedConsent,
enabled = true,
organizationSlug,
projectRef,
sessionReplay,
}: {
API_URL: string
hasAcceptedConsent: boolean
enabled?: boolean
organizationSlug?: string
projectRef?: string
/** Masking policy for session replay. Omit to disable recording. */
sessionReplay?: SessionRecordingOptions
}) => {
const router = useRouter()
const pagesPathname = router?.pathname
const appPathname = usePathname()
const params = useParams()
const slug = organizationSlug || params.slug
const ref = projectRef || params.ref
const featureFlags = useFeatureFlags()
useFirstTouchStore({ enabled: enabled && IS_PLATFORM })
const pathname =
pagesPathname ?? appPathname ?? (isBrowser ? window.location.pathname : undefined)
const pathnameRef = useLatest(pathname)
const featureFlagsRef = useLatest(featureFlags.posthog)
const sendPageTelemetry = useCallback(() => {
if (!(enabled && hasAcceptedConsent)) return Promise.resolve()
return handlePageTelemetry({
apiUrl: API_URL,
pathname: pathnameRef.current,
featureFlags: featureFlagsRef.current,
slug,
ref,
}).catch((e) => {
console.error('Problem sending telemetry page:', e)
})
}, [API_URL, enabled, hasAcceptedConsent, slug, ref])
const sendPageLeaveTelemetry = useCallback(() => {
if (!(enabled && hasAcceptedConsent)) return Promise.resolve()
if (!pathnameRef.current) return Promise.resolve()
return handlePageLeaveTelemetry(
API_URL,
pathnameRef.current,
featureFlagsRef.current,
slug,
ref
).catch((e) => {
console.error('Problem sending telemetry page-leave:', e)
})
}, [API_URL, enabled, hasAcceptedConsent, slug, ref])
const hasSentInitialPageTelemetryRef = useRef(false)
const previousAppPathnameRef = useRef<string | null>(null)
useEffect(() => {
if (hasAcceptedConsent && IS_PLATFORM) {
posthogClient.init({ sessionReplay })
}
}, [hasAcceptedConsent, IS_PLATFORM, sessionReplay])
// Waiting for router.isReady before sending to avoid dynamic route placeholders
useEffect(() => {
if (
(router?.isReady ?? true) &&
enabled &&
hasAcceptedConsent &&
!hasSentInitialPageTelemetryRef.current
) {
const cookieHeader = document.cookie
const firstReferrerData = parseFirstReferrerCookie(cookieHeader)
const mwDiagData = parseMwDiagCookie(cookieHeader)
const firstTouchData = getFirstTouchData()
try {
handlePageTelemetry({
apiUrl: API_URL,
pathname: pathnameRef.current,
featureFlags: featureFlagsRef.current,
slug,
ref,
...(firstTouchData && { telemetryDataOverride: firstTouchData }),
firstReferrerData,
mwDiagData,
})
} finally {
clearFirstTouchData()
hasSentInitialPageTelemetryRef.current = true
}
}
}, [router?.isReady, enabled, hasAcceptedConsent, slug, ref])
useEffect(() => {
if (router === null) return
function handleRouteChange() {
if (!hasSentInitialPageTelemetryRef.current) return
sendPageTelemetry()
}
router.events.on('routeChangeComplete', handleRouteChange)
return () => {
router.events.off('routeChangeComplete', handleRouteChange)
}
}, [router])
useEffect(() => {
if (router !== null) return
if (
appPathname &&
previousAppPathnameRef.current !== null &&
previousAppPathnameRef.current !== appPathname
) {
sendPageTelemetry()
}
previousAppPathnameRef.current = appPathname
}, [appPathname, router, sendPageTelemetry])
useEffect(() => {
if (!enabled) return
const handleBeforeUnload = () => sendPageLeaveTelemetry()
window.addEventListener('beforeunload', handleBeforeUnload)
return () => window.removeEventListener('beforeunload', handleBeforeUnload)
}, [enabled, sendPageLeaveTelemetry])
useTelemetryIdentify(API_URL)
return null
}
type EventBody = components['schemas']['TelemetryEventBodyV2']
export function sendTelemetryEvent(API_URL: string, event: TelemetryEvent, pathname?: string) {
const consent = hasConsented()
if (!consent) return
const body: EventBody = {
...getSharedTelemetryData(pathname),
action: event.action,
custom_properties: 'properties' in event ? event.properties : {},
groups: 'groups' in event ? { ...event.groups } : {},
}
if (event.action.startsWith('explorer_')) body.page_title = 'Explorer'
if (body.groups?.project === 'Unknown') {
delete body.groups.project
if (body.groups?.organization === 'Unknown') {
delete body.groups
}
}
// keepalive lets the request survive the same-tick OAuth redirect after
// sign_in_submitted, but keepalive requests share a ~64KB in-flight quota
// page-wide, so it stays scoped to that event. Callers like useTrack
// fire-and-forget, so rejections are handled here rather than surfacing
// as unhandled promise rejections.
return post(`${ensurePlatformSuffix(API_URL)}/telemetry/event`, body, {
headers: { Version: '2' },
keepalive: event.action === 'sign_in_submitted',
}).catch((error) => {
console.error('Problem sending telemetry event:', error)
})
}
//---
// TELEMETRY IDENTIFY
//---
type IdentifyBody = components['schemas']['TelemetryIdentifyBodyV2']
export function sendTelemetryIdentify(API_URL: string, body: IdentifyBody) {
const consent = hasConsented()
if (!consent) return Promise.resolve()
return post(`${ensurePlatformSuffix(API_URL)}/telemetry/identify`, body, {
headers: { Version: '2' },
})
}
export function useTelemetryIdentify(API_URL: string) {
const user = useUser()
useEffect(() => {
if (user?.id) {
const anonymousId = posthogClient.getDistinctId()
sendTelemetryIdentify(API_URL, {
user_id: user.id,
...(anonymousId && { anonymous_id: anonymousId }),
})
// user.created_at is gotrue's immutable signup timestamp — safe to $set on
// every identify because the value never changes per user. Lets flag
// targeting distinguish brand-new signups from returning single-org users.
posthogClient.identify(user.id, {
gotrue_id: user.id,
...(user.created_at && { signup_timestamp: user.created_at }),
})
}
}, [API_URL, user?.id])
}
//---
// TELEMETRY RESET
//---
export function handleResetTelemetry(API_URL: string) {
return post(`${API_URL}/telemetry/reset`, {})
}