Marvin Blum Kugelschieber

💭

Working on Pirsch

Full-stack software engineer, co-founder of Emvi. Working on Pirsch Analytics, a privacy-friendly web analytics solution.

Kugelschieber / schema.sql

Last active October 16, 2025 07:48

Pirsch Schema

	CREATE TABLE pirsch.event
	(
	`client_id` UInt64,
	`time` DateTime64(3, 'UTC'),
	`duration_seconds` UInt32 DEFAULT 0,
	`path` String,
	`language` LowCardinality(String),
	`country_code` LowCardinality(FixedString(2)),
	`referrer` String,
	`referrer_name` String,

Kugelschieber / sample.js

Created October 18, 2024 10:45

Pirsch Funnel Visualization Example (ChartJS)

	// Incomplete ChartJS demo code.

	import {Chart} from "chart.js";
	import {
	BarController,
	BarElement,
	CategoryScale,
	Chart,
	Filler,
	LinearScale,

Kugelschieber / script.js

Last active August 13, 2024 11:24

Pirsch Custom Event Form Submission

	<script>

	function findFormTitle(node) {
	const tag = node.tagName;

	if (tag === "H1" \|\| tag === "H2" \|\| tag === "H3" \|\| tag === "H4") {
	return node.innerText;
	}

	for (const child of node.children) {

Kugelschieber / links-with-keywords.html

Created March 7, 2024 11:01

Tracking links with specific keywords in the URL.

	<p>
	<a href="https://example.com">Link 1</a>
	<a href="https://example.com/mountain">Link 2</a>
	<a href="https://example.com/unreleated">Link 3</a>
	<a href="https://example.com/sea">Link 4</a>
	</p>

	<script>
	const keywords = [
	"sea",

Kugelschieber / internal-links.js

Last active February 7, 2024 10:27

Tracking internal links using custom events

	function addLinks() {
	const links = document.getElementsByTagName("a");

	for (const link of links) {
	if (!link.hasAttribute("pirsch-ignore") && !link.classList.contains("pirsch-ignore")) {
	addInternalLink(link);
	}
	}
	}

Kugelschieber / index.html

Last active December 2, 2023 17:10

Pirsch Vimeo Video Tracking Demo

	<!DOCTYPE html>
	<html>
	<head>
	<title>Vimeo Pirsch Demo</title>

	<!-- Add the Pirsch extended script to support page views and events. -->
	<script defer src="https://api.pirsch.io/pirsch-extended.js"
	id="pirschextendedjs"
	data-code="YOUR_PIRSCH_CODE"></script>

Kugelschieber / index.html

Last active December 2, 2023 17:10

Pirsch YouTube Video Tracking Demo

	<!DOCTYPE html>
	<html>
	<head>
	<title>YouTube Pirsch Demo</title>

	<!-- Add the Pirsch extended script to support page views and events. -->
	<script defer src="https://api.pirsch.io/pirsch-extended.js"
	id="pirschextendedjs"
	data-code="YOUR_PIRSCH_CODE"></script>

Kugelschieber / code.gs

Created May 12, 2023 13:04

Pirsch Analytics Google Sheets API Integration

	const PIRSCH_CLIENT_ID = ScriptProperties.getProperty('client_id');
	const PIRSCH_CLIENT_SECRET = ScriptProperties.getProperty('client_secret');

	function onOpen() {
	var ui = SpreadsheetApp.getUi();
	ui.createMenu("Pirsch Analytics")
	.addItem('Get Visitors', 'pasteVisitorsToSheet')
	.addToUi();
	}

Kugelschieber / index.html

Created April 19, 2023 09:55

Track scroll position on an article using Pirsch Analytics

	<!DOCTYPE html>
	<html>
	<head>
	<title>Reading Percentage Demo</title>
	<style type="text/css">
	body {
	max-width: 800px;
	padding: 40px;
	margin: 0 auto;
	font-family: sans-serif;

Kugelschieber / pirsch-event-cookie.js

Created February 25, 2023 00:36

Send an event once to Pirsch

	document.addEventListener("DOMContentLoaded", () => {
	setTimeout(() => {
	if (!document.cookie.includes("pirsch30sec")) {
	pirsch("Stayed for at least 30 seconds");
	document.cookie = "pirsch30sec=1; path=/";
	}
	}, 30000);
	});