Models Heatmaps · Querying PostHog Data · PostHog/skills · Skills Docs

Models Heatmaps · Querying PostHog Data · PostHog/skills · Skills Docs

Column	Type	Nullable	Description
`session_id`	String	NOT NULL	Recording session the interaction belongs to; matches `session_replay_events.session_id`.
`team_id`	Integer	NOT NULL
`distinct_id`	String	NOT NULL	Identifier of the user/device that interacted.
`x`	Integer	NOT NULL	X coordinate snapped to an NxN grid; multiply by `scale_factor` for the original pixel value.
`y`	Integer	NOT NULL	Y coordinate snapped to an NxN grid; multiply by `scale_factor` for the original pixel value.
`scale_factor`	Integer	NOT NULL	Grid resolution applied to `x`/`y` coordinates.
`viewport_width`	Integer	NOT NULL	Viewport width at capture time, stored scaled down like `x`; multiply by `scale_factor` for CSS pixels.
`viewport_height`	Integer	NOT NULL	Viewport height at capture time, stored scaled down like `y`; multiply by `scale_factor` for CSS pixels.
`pointer_target_fixed`	Boolean	NOT NULL	Whether the clicked element stays fixed when the page scrolls.
`current_url`	String	NOT NULL	URL of the page where the interaction occurred.
`timestamp`	DateTime	NOT NULL	When the interaction occurred (in UTC).
`type`	String	NOT NULL	Interaction type, e.g. ‘click’, ‘rageclick’, ‘mousemove’, ‘scrolldepth’.

SELECT
    round(x / viewport_width, 2) AS rel_x,
    y * scale_factor AS client_y,
    count() AS clicks
FROM heatmaps
WHERE current_url = 'https://example.com/pricing'
  AND type = 'click'
  AND timestamp >= now() - INTERVAL 7 DAY
GROUP BY rel_x, client_y
ORDER BY clicks DESC
LIMIT 20