Skip to content

Open source, privacy-first web analytics. Lightweight, cookie-free Google Analytics alternative. Self-hosted or cloud.

1.0 KB
Raw Blame
INSERT INTO tmp_sessions_v2 (
site_id, session_id, sign, user_id, hostname, timestamp, start, is_bounce, entry_page, 
exit_page, pageviews, events, duration, referrer, referrer_source, country_code, 
screen_size, operating_system, browser, utm_medium, utm_source, utm_campaign, browser_version, 
operating_system_version, subdivision1_code, subdivision2_code, city_geoname_id, utm_content, 
utm_term, transferred_from, entry_meta.key, entry_meta.value
)
SELECT
  site_id,
  session_id, sign, user_id, hostname, timestamp, start, is_bounce, entry_page, 
  exit_page, pageviews, events, duration, referrer, referrer_source, country_code, 
  screen_size, operating_system, browser, utm_medium, utm_source, utm_campaign, browser_version, 
  operating_system_version, subdivision1_code, subdivision2_code, city_geoname_id, utm_content, 
  utm_term, transferred_from, entry_meta.key, entry_meta.value
FROM
  sessions
INNER JOIN domains_lookup ON domains_lookup.domain = sessions.domain
WHERE (_partition_id = '<%= @partition %>')