08bf49eaec
ref https://linear.app/tryghost/issue/ANAL-27/setup-tinybird-project-and-cicd ref https://github.com/tinybirdco/web-analytics-starter-kit/blob/main/tinybird/pipes/analytics_sessions.pipe - These datasources and pipes work together to define the main endpoints we need for our stats dashboard - They are based on the web analytics starter kit from tinybird - We've updated them to handle site_uuid - There's more to do to pipe the member-related and post-related data through the system yet
21 lines
565 B
Plaintext
21 lines
565 B
Plaintext
NODE analytics_sessions_1
|
|
DESCRIPTION >
|
|
Aggregate by session_id and calculate session metrics
|
|
|
|
SQL >
|
|
SELECT
|
|
site_uuid,
|
|
toDate(timestamp) AS date,
|
|
session_id,
|
|
anySimpleState(device) AS device,
|
|
anySimpleState(browser) AS browser,
|
|
anySimpleState(location) AS location,
|
|
minSimpleState(timestamp) AS first_hit,
|
|
maxSimpleState(timestamp) AS latest_hit,
|
|
countState() AS hits
|
|
FROM analytics_hits
|
|
GROUP BY date, session_id, site_uuid
|
|
|
|
TYPE MATERIALIZED
|
|
DATASOURCE analytics_sessions_mv
|