PostHog

# Recent events
SELECT * FROM events ORDER BY timestamp DESC LIMIT 100

# Events by type in the last 7 days
SELECT event, count() as count
FROM events
WHERE timestamp > now() - interval 7 day
GROUP BY event
ORDER BY count DESC

# Unique users by event
SELECT event, uniq(distinct_id) as unique_users
FROM events
GROUP BY event
ORDER BY unique_users DESC

# Page views with properties
SELECT properties.$current_url as url, count() as views
FROM events
WHERE event = '$pageview'
GROUP BY url
ORDER BY views DESC
LIMIT 20

# User journey analysis
SELECT distinct_id, event, timestamp
FROM events
WHERE distinct_id = 'user-id-here'
ORDER BY timestamp ASC