Open source, privacy-first web analytics. Lightweight, cookie-free Google Analytics alternative. Self-hosted or cloud.
TypeScript analyticsanalytics-dashboardclickhouseelixirgoogle-analyticsmarketingopen-source-analyticsphoenixplausible-analyticspostgresqlprivacyprivacy-friendlyself-hostedsimple-analyticsstatisticstailwindcssweb-analyticswebsite-analyticswebsite-statswebsite-tracking
INSERT INTO tmp_events_v2 (
site_id, timestamp, name, user_id,
session_id, hostname, pathname, referrer,
referrer_source, country_code, screen_size,
operating_system, browser, utm_medium,
utm_source, utm_campaign, meta.key,
meta.value, browser_version, operating_system_version,
subdivision1_code, subdivision2_code,
city_geoname_id, utm_content, utm_term,
transferred_from
)
SELECT
site_id,
timestamp,
name,
user_id,
session_id,
hostname,
pathname,
referrer,
referrer_source,
country_code,
screen_size,
operating_system,
browser,
utm_medium,
utm_source,
utm_campaign,
meta.key,
meta.value,
browser_version,
operating_system_version,
subdivision1_code,
subdivision2_code,
city_geoname_id,
utm_content,
utm_term,
transferred_from
FROM
events
INNER JOIN domains_lookup ON domains_lookup.domain = events.domain
WHERE (_partition_id = '<%= @partition %>')