Org dashboard-grain content analytics (usage, staleness, connection health).
Which dashboards are used or stale, and whether connections are healthy — a dashboard-grain sibling to GET /v1/orgs/{orgId}/analytics/performance (element-grain) (DVT-1217). Admin or owner only (audit:read). The data object shape is frozen — field names are a client contract.
Query-derived numbers (dashboards[].renders/runs/errorCount, connections[], and the all-time last-render signal folded into staleness/dashboards[].lastViewedAt) see at most 365 days of query_executions retention (QUERY_TELEMETRY_RETENTION_DAYS, default 365) — "never rendered" means "no render on record" within that window, not "never rendered, ever." dashboard_views (the viewsSource=events signal) is likewise retained 365 days.
viewsSource is "events" when this org has at least one dashboard_views row in the window (checked before actorType/dashboardId narrowing), else "derived" (view/viewer counts are approximated from query_executions dashboard-render rows instead).
The staleness and connections sections honor only the days filter — narrowing by actorType/connectionId/dashboardId would make "stale" or "unhealthy" a lie for a dashboard/connection that is actually busy outside the narrowed slice. dashboards[].views/viewers honor actorType + dashboardId but never connectionId (dashboard_views has no connection concept); dashboards[].renders/runs/errorCount honor all three filters.
Request
- Base URL: http://localhost:8080
- URL: http://localhost:8080/v1/orgs/{orgId}/analytics/content
- Auth: one of:
- API key in cookie dvt_session
- HTTP bearer
Query parameters
Rolling window in calendar days. Default 30; clamped to [1, 365]. Out-of-range or non-integer values are silently clamped/defaulted.
Narrow dashboards[].renders/runs/errorCount to a single warehouse connection. Does not affect staleness or connections (see above). A malformed UUID is silently ignored (no filter applied), never a 400.
Narrow the dashboards leaderboard to a single dashboard. Does not affect staleness or connections (see above). A malformed UUID is silently ignored (no filter applied), never a 400.
Narrow to a single actor type. Does not affect staleness or connections (see above). Any value other than user, api_key, or agent is silently ignored (no filter applied), never a 400.
Response
Org content-analytics result.
Changes
No recorded changes to this operation across all 1 revision of this API.