Epic 15 — R1 Telemetry

[fupelaqu]

Epic 15 — R1 Telemetry

Tracking issue for Epic 15, which instruments R1's launch-success metrics before R1 ships (a hard R1 launch blocker per the roadmap). Two surfaces: customer-side product-instance telemetry (all five surfaces, all tiers incl. Community, opt-out by config) and business-side launch metrics (trial→paid funnel, downloads, R1 success dashboard).

Delivered via the dev-epic-stories orchestration as one draft PR + issue per impacted repo, base release-r1.

Stories & PRs

Story	Summary	PRs (draft)
15.1 Driver download analytics	JFrog + portal download ingestion → download_events + Grafana	license-server #78, web #3, SoftClient4ES #108 (merged into release-r1)
15.2 Daily product-instance ping (5 surfaces)	InstancePing CQRS ingestion + JDBC/ADBC/sidecar/federation/REPL emission; opt-out softclient4es.telemetry.enabled	SoftClient4ES #117, extensions #29, jdbc #17, arrow #101, license-server #84
15.3 JOIN query counter	Per-venue JOIN counter on TelemetryCollector (3-row disaggregation); reset/flush wiring; ships in the 15.2 ping	SoftClient4ES #111, extensions #27, arrow #99
15.4 Trial → paid conversion funnel	r1_funnel_snapshot table + daily snapshot job + Grafana funnel dashboard + WoW-drop alert	license-server #82, SoftClient4ES #113
15.5 R1 success-criteria dashboard	Composite "did R1 work?" Grafana dashboard + r1_sales_signals	license-server (this run), SoftClient4ES docs (this run)
15.6 Privacy doc + opt-out documentation	Customer-facing privacy page (all five surfaces) in both docs systems	web #6, SoftClient4ES #115

Resolved launch values (project lead)

• Paid-customer-signups 90-day R1 target = 5
• Telemetry retention window = 13 months
• Privacy / data-deletion contact = sales@softclient4es.com

Stacking / merge order

• 15.2's elasticsql / softclient4es-extensions / softclient4es-arrow PRs are stacked on feature/15.3 — merge 15.3 (Story 15.3: JOIN query counter — elasticsql (TelemetryCollector + TelemetryData) #111/bulk from file (json, json array, parquet, delta lake) #27/Story 14.1: ORDER BY ... NULLS FIRST / NULLS LAST #99) first.
• 15.5 panels for not-yet-merged dependencies ship in collapsed "Pending" rows; promote to flat panels once 15.2/15.3/15.4 merge.

Follow-ups before R1 launch (non-blocking)

• Run the deferred Docker/Postgres integration test suites for 15.2 (per-surface ping specs, REPL session ping, license-server route tests) in CI.
• Provision the Grafana Postgres datasource GF_DATASOURCE_POSTGRES_PASSWORD + read-only role + live kubeseal (shared 15.1/15.4/15.5 ops follow-up).
• Optionally add a dedicated licensing_trials_activated counter (15.4 OQ-1).