Ecommerce Planning Tool based on Cohorts (Google Sheets Model) I have often and extensively dealt with the planning of e-commerce revenues in recent years. Planning by cohorts has proven to be one of the most stab Daniel Setzermann Mar 12, 2024 paid 2 min read →
Create a free Org Chart and sync with Google Sheets Recently I tried to create a free org chart from my employee list in google sheets. The org chart should be optically pleasing, support multi-team-lev Daniel Setzermann Feb 25, 2024 public 1 min read →
Quickly compress images with Automator (Mac) Although data-plans are becoming bigger and bigger the size of a webpage still matters – according to many sources the page load time drastically affe Daniel Setzermann Jul 2, 2017 public 2 min read →
A Better Campaign URL Builder for UTM Tracking Links This is a free google spreadsheet based campaign url builder for utm tracking links to be used with Google Analytics. I've created this tool with Daniel Setzermann Jun 19, 2017 public 5 min read →
How to calculate the median per group with MySQL The other day I had to calculate the median per group within MySQL. Turns out this is not as easy as it sounds mostly due to the fact that there exist Daniel Setzermann Jul 9, 2016 public 3 min read →
