:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.
Python ab-testingai-analyticsanalyticscdpdata-warehouseexperimentsfeature-flagsjavascriptproduct-analyticspythonreactsession-replaysurveystypescriptweb-analytics
import type { Dayjs } from 'lib/dayjs'
import {
type SampleIds,
type SampleRow,
type SampleRowsSource,
buildSampleRows,
samplePersonDisplayName,
samplePropertyValue,
} from '~/queries/nodes/DataTable/sampleRows'
interface SamplePerson {
email: string
properties: Record<string, string>
daysSinceCreated: number
minutesSinceSeen: number
}
const SAMPLE_PERSONS: SamplePerson[] = [
{
email: '[email protected]',
properties: { name: 'Alice', $geoip_country_code: 'US', $browser: 'Chrome', $os: 'Mac OS X' },
daysSinceCreated: 2,
minutesSinceSeen: 1,
},
{
email: '[email protected]',
properties: { name: 'Bob', $geoip_country_code: 'GB', $browser: 'Firefox', $os: 'Windows' },
daysSinceCreated: 5,
minutesSinceSeen: 3,
},
{
email: '[email protected]',
properties: { name: 'Carol', $geoip_country_code: 'DE', $browser: 'Mobile Safari', $os: 'iOS' },
daysSinceCreated: 9,
minutesSinceSeen: 6,
},
{
email: '[email protected]',
properties: { name: 'Dave', $geoip_country_code: 'FR', $browser: 'Chrome', $os: 'Linux' },
daysSinceCreated: 14,
minutesSinceSeen: 12,
},
]
function sampleValue(key: string, sample: SamplePerson, ids: SampleIds, now: Dayjs): unknown {
const properties = { email: sample.email, ...sample.properties }
if (key === 'person_display_name') {
return samplePersonDisplayName(sample.email, ids)
}
if (key === 'person') {
return { id: ids.personId, distinct_ids: [ids.distinctId], properties }
}
if (key === 'id') {
return ids.personId
}
if (key === 'created_at') {
return now.subtract(sample.daysSinceCreated, 'day').toISOString()
}
if (key === 'last_seen_at') {
return now.subtract(sample.minutesSinceSeen, 'minute').toISOString()
}
return samplePropertyValue(key, properties)
}
export function buildSamplePersonRows(columns: string[], now: Dayjs): SampleRow[] {
return buildSampleRows(SAMPLE_PERSONS, columns, (key, sample, ids) => sampleValue(key, sample, ids, now))
}
export const SAMPLE_PERSONS_SOURCE: SampleRowsSource = {
buildRows: buildSamplePersonRows,
// pinned: the data-attr value is an autocapture selector, so renaming it breaks dashboards
dataAttr: 'persons-table-sample-data',
excludedColumns: ['person.$delete'],
}