Recent content on Patryk Kalinowski
This is a fairly long story of why I built Balloon Navigator, what’s involved to fly with centimeters level precision when you can only use wind and how technology is shaping modern ballooning today. This is me (right) with my brother and a laptop for navigation. Table of contents: What the hell is competitive hot air ballooning? Flying with computers Principles Timeline of technology…
Balloon Navigator is an offline-first PWA made with Svelte. It supports online and offline vector maps, reading NMEA data from GPS serial port, drawing features and navigating to them, navigational aids such as windreader and saving flight tracks.
BigQuery is an amazing database. It will handle everything you throw at it, no matter the size… or cost. And things are easy to overlook: BI tool doing full table scans hourly, new hire querying SELECT * on huge dataset or ETL script stuck in a loop… You should be able to discover these before you get smacked with huge bill at the end of the month. Let’s figure out how to build a…
Data Cost Monitor is an easiest solution on the market to get an understanding what’s happening inside your BigQuery data warehouse. Lightning fast, intuitive dashboards with the most important cost and usage metrics.
Physics Movement Physics-based XR movement. Player hands collide with environment and can grab or push physics object in realistic manner. Player body can collide with physics objects and be moved around in space. Hand Gesture Recognition Real-time recognition of hand poses based on predefined templates. Smooth Input Filter Applies smoothing to XR hand movement using 1€ filter. Supports hand and…
As of 2022-11-20: Currently, you have to use the S3 API PutBucketCors to configure CORS for your bucket. ~Cloudflare The simplest way to setup CORS for your R2 bucket is to use AWS CLI. To make it work with R2 properly, you need to include --endpoint-url pointing to your R2 bucket URL. First of all, configure CLI according to instructions on Cloudflare docs You need to use put-bucket-cors command.…
Let’s say your SaaS analytics setup looks like this: You have Google Analytics 4 implemented on both marketing website and app GA4 gathers data on anonymous users on marketing website You send user_id to GA4 in app GA4 data is exported to BigQuery Now, your data contains events where user is recognized (user_id is present) and events where you only have anonymous id (user_pseudo_id in GA4) -…
I took part in webinar on ABM tech stacks hosted by Man Digital. Click on the image or here to watch the recording.
Imagine Hans from Germany, manager in ABC GmbH, rising fintech SaaS startup. He is your potential customer as you already did some fintech SaaS work and even wrote a case study on that. Hans visits your website and following pages: Homepage (/) Services (/services) Case Studies (/case-studies) Case Study: ACME Inc. (/case-studies/acme) This is promising, he might be interested in your services…
If you tried to extract data from Hubspot to your data warehouse using tools like Stitch, Segment or Fivetran, you may have noticed that it gets only the most basic stuff. There is some more detailed data hidden in Hubspot API. In this blogpost I’ll show you how to get all pageviews with full URLs for every contact in your Hubspot database. You can use this data to properly model user…
All marketing powerhouses tell you they are your golden ticket to ultimate knowledge about your customers. Grow your traffic, convert leads, and prove ROI. Track Customers and Report Your Impact on the Bottom Line Automatically record and organize every interaction customers have with your brand. Then, tie all your data to closed revenue with multi-touch revenue attribution. Gain insight into your…
There are lot of misconceptions how 3rd party cookies affect website analytics and if marketing teams should be worried when they are being blocked. I tried to explain inner workings of all this fuss as simple as possible. Behold, 3rd party cookies for dummies: When you visit WebsiteA.com which has Adtech.com tracking code, this code asks Adtech.com domain for cookie (VisitorID: 123). Since you…
Whenever I talk about work with somebody, I’m always interested in how their processes look like. I talked with freelancers, one person businesses, people from small companies up to 10 employees, bigger companies up to 50, 100 and 1000 employees and corporations. There are lot of recurring themes and most of these processes aren’t even special or in any way unique. I’d say all of…
Depending on country and industry, up to 40% of your users use adblockers. You know nothing about their activity on website, they are not on your remarketing lists and every CRM and marketing automation system reports their source as dreaded DIRECT TRAFFIC. Of course it is possible to improve it. 100% attribution sounds enticing and is worth a lot of money, so let’s try to reach it.…
Let’s say you want to include number of company employees in your blogpost, landing page or custom module. You just write a simple number, right? Fast forward few months, company is growing and you need to update this number. Are you 100% sure you know where you can find all of its occurences? At Netguru we weren’t. Landing pages created in various points in time had number of…
Today’s world, thanks to new technologies we get to use everyday, changes a lot. Computing power increases, new solutions emerge and various systems we use are getting more and more complicated. Marketing is no different. Modern marketing tools make teams work faster and more efficient in reaching their audiences. Internet and computers enable reaching huge amount of people in a scale never…
Takie coś, zatytułowane Masz przejebane, otrzymałem ostatnio na maila: Może się przedstawie. Jestem Piotr i od Września ubiegłego roku podsłuchuje WSZYSTKIE twoje rozmowy, mam dostęp do wszystkich SMS, komunikatorów i haseł kont internetowych, jak również do historii przeglądanych stron. Jak tego dokonałem? Włamałem się na twój telefon i zainfekowałem go exploitem, który automatycznie przekazywał…
Sam tekst reklamy nie wyróżnia się niczym szczególnym; konkurencja stosuje bardzo podobne. Kluczem jest kontekst - niebieskie samochody z Tesco są dosyć charakterystyczne, a jeden przyjeżdżający do sąsiada w piątek wieczorem od razu przypomina mi o konieczności sobotniej, dwugodzinnej wyprawy do sklepu. Jeden rzut oka na auto pod blokiem wystarczy, by zrozumieć USP usługi. Dwie największe…
Nie mam pojęcia, czy ludzie kupują zmywarkę pod wpływem impulsu i zabawnej reklamy, ale stojąc pomiędzy dwoma sklepami na pewno z uśmiechem pod nosem wszedłbym do Media Marktu. Wyobrażam sobie, jak na kolejnym “kreatywnym” spotkaniu w przeszklonej salce konferencyjnej ktoś sarkastycznie rzucił wierszykiem, który zabrzmiał doskonale. Podczas, gdy marki silą się na uchwycenie pozytywnych…
Cześć, tu Justyna z kredomoto.pl Czy wiesz że 87% osób biorących leasing, zawsze wybiera pierwszą otrzymaną cene i nigdzie jej nie porównuje, najczęściej na tym tracąc? Postanowiliśmy stworzyć pierwszą porównywarkę leasingów, dzięki której będzie można wybrać najlepszy i najtańszy. Jak to działa? To proste - przesyłasz nam warunki które dostałeś u kogoś innego, a my to przebijamy. 99% naszych…
This post originally appeared on Netguru blog. In every business setting, there are several dreaded, time-consuming and repetitive activities which we must carry out to keep the wheels spinning. Somebody has to do them regardless of the very low fun factor. We are a software company, though – we simplify and automate complicated things for a living, so why not do it for the boring part of our…
Paste this below your Analytics tracking code, in a template or content settings footer field: <script> ga('set', 'userId', '{% raw %}{{contact.email|md5}}{% endraw %}'); </script> How does it work? User ID enables the analysis of groups of sessions, across devices, using a unique, persistent, and non-personally identifiable ID string representing a user. The easiest solution would be of course to…
Hubspot does not provide you with any search engine for your blogs, instead pointing you to use Google search. I have prepared a very simple solution which you can use to create good looking search without redirecting your visitors to external websites. Check out working example at netguru.co. Its fast, quick and simple, but has two disadvantages - search is capped to 200 most popular blogposts…
How to find abandoned WooCommerce carts and send information to Mautic? If its your returning customer and you have him/her email in your database, it shouldnt be hard - you just have to create a simple rule: Visited Checkout Page AND Did Not Visit Order Confirmation Page But if it’s first time visitor, we have no email or any contact information except of remarketing which has much lower…
Working in online marketing, especially with automation and analytics tools, oftentimes you are watching various people activities performed on your website and their profiles. This is usually pretty basic information available publicly or submitted by given person willingly plus analytics data, like page views and e-mail opens. While this simple info seems very scarce, used smartly provides huge…
This post originally appeared on Netguru blog Not so long ago we came up against a big problem while analyzing the performance of our campaigns – there were no conversions at all. We had two versions of a campaign: blog content and sales/business content. The plan was to choose the better one. How do you choose the winner if there are seemingly no conversions? We implemented more early engagements…
This post originally appeared on Netguru blog Online marketing can be really complicated. You have to manage accounts on many advertising networks, take care of your databases, as well as set up integrations, workflows and email campaigns. Your customers are coming from absolutely everywhere - online and offline ads, newsletters, remarketing ads, referral sites and organic searches. Properly…
Some people say that blockchain is the invention of the same magnitude as internet. The idea for one supercomputer stretched around the whole planet still sounds like a science-fiction concept, but it’s already happening. Bitcoin network exceeded computing power of TOP 500 supercomputers combined few years ago. New ideas are emerging daily, new startups are funded and launching their…
patryk@patrykkalinowski.com LinkedIn
Read this case study in Polish at https://agencjawhites.pl/case-studies/jak-w-ciagu-roku-trzykrotnie-zwiekszylismy-ruch-organiczny-dla-netguru-na-rynkach-zagranicznych/
Read this case study at https://www.hotjar.com/customers/netguru/.
I build analytics infrastructure and help teams extract knowledge from data, with focus on marketing analytics. In my career I held positions such as Head of Data, Marketing Automation Lead, Demand Generation Team Leader and others. Examples of my previous work: Custom attribution models for marketing teams, Implementation of new cloud-based analytics infrastructure and data warehouse from…
I was approached by Content Manager at Netguru with a task to improve the proofreading process, which was time-consuming and tedious. The process was a complete mess. Random people pinged Content Manager on Slack using private channels – they would send text snippets and ask for help with their writing. Our external proofreaders were constantly sent materials that they were unable to access. No…
Stale rosnąca ilość działań prowadzonych w działach marketingu sprawia, że zespoły o dzisiejszych rozmiarach nie są w stanie efektywnie wykonywać wszystkich swoich zadań wykorzystując jedynie pracę ludzi. Wraz z rozwojem komputerów pojawia się coraz więcej możliwości, by tą pracę zautomatyzować - i na dodatek zautomatyzować ją w sposób, dzięki któremu klient nie zauważy, że kontaktuje się z…
AIESEC is international student organisation of 40 000 members, running multiple projects for young people to gather experience. One of those projects is University - language workshops for local students carried out by young native speakers volunteering from their countries and getting their first teaching experience. I was leading a team of four responsible for AIESEC University lead generation.…
It’s very lean and minimalistic one page app with CSV download option. I made it to solve two problems: Create multiple tagged links for one URL without repeating myself dozens of times Reduce typos while entering UTM tags by hand Main differences from other builders are: Bunch of pre-made tags you can choose by clicking on a button instead of manually typing values into input fields It…
App requires GPS signal to work. Phone GPS accuracy is not good enough - I recommend connecting external bluetooth module such as Garmin GLO. How to use Enter target position from your task sheet. App retrieves full UTM coordinates, assuming that target is in the same UTM zone as yourself. While navigating to target, app will calculate the closest point to target you can reach and tell you when to…
Desktop app to backup your Hubspot account. for Windows, Mac and Linux no SaaS: download once, own forever no cloud - files are yours no middlemen - connects directly from your computer to your Hubspot account straighforward and easy to use text interface Backs up: contacts companies contact lists blogs blogposts (without images) blog authors blog topics blog comments website & landing pages…
It’s been used as an example app in my article on How marketing automation works. It uses Ahoy gem for analytics and features segmenting users based on their activity and sending emails based on those segments.
Node.js script to create GeoJSON file with grid of MGRS zones for EPSG:4326 (WGS 84) coordinate system It’s not finished yet and has some hardcoded values which currently generate MGRS grid for country of Georgia. Please refer to the source of mgrs.js to modify it for your needs. To run example on your machine, download the project and run yarn run dev
W obecnych systemach automatyzacji marketingu moduły akcji mają różne nazwy, jednak najczęściej stosowane są dwie: workflow oraz kampania. W aplikacji marketing-automation-rails stosuję nazwę workflow, a moduł akcji umożliwia wysyłkę wiadomości email w zależności od przynależności użytkownika do segmentu. Do odnalezienia użytkowników należących do danego segmentu, workflowy korzystają z tego…
Mimo swoich wad, możliwości systemów do automatyzacji marketingu pozwalają firmom na osiągnięcie bardzo wysokich zwrotów z inwestycji w działania marketingowe. Systemy te zazwyczaj charakteryzują się wysokim stopniem skomplikowania, zarówno po stronie użytkownika, jak i programisty. System automatyzacji marketingu można podzielić na kilka modułów: analityki, segmentacji i akcji. Moduł analityki ma…
Moduł analityki funkcjonuje po stronie klienta dzięki wykorzystaniu języka JavaScript, natomiast moduł segmentacji jest zaimplementowany po stronie serwera. Moduły segmentacji mogą być napisane w dowolnym języku programowania, jednak tutaj wykorzystam język Ruby oraz framework Ruby on Rails. Istnieje wygodna biblioteka (gem) implementująca Ahoy.js w języku Ruby - ahoy_matey, która zapewnia…
Słowo “marketing” po raz pierwszy pojawiło się w słownikach w szesnastym wieku i odnosiło się do czynności kupowania i sprzedawania towarów na rynku. Nie wiadomo dokładnie, kiedy ludzkość zaczęła zajmować się marketingiem, jednak wiele wskazuje na to, że stało się to już w starożytności. W starożytnej Grecji i Rzymie już w roku 1500 p.n.e. towary były transportowane w amforach…
Netguru is one of the biggest software consultanies from Poland. With 600+ people and worldwide customers in the ranks of Volkswagen, Solaris Bank and Babbel, its operations present lots of interesting challenges. Netguru faced problem with efficient recruitment efforts: nobody knew if campaigns were successful and how many candidates applied thanks to them. No information about recruitment stages…
Wraz z upowszechnieniem się internetu pojawiały się pierwsze pomysły na dotarcie do konsumentów przy pomocy tego medium. W 1994 serwis HotWired.com (istniejący do dzisiaj jako Wired.com) jako pierwszy sprzedał powierzchnię swojej strony na banner reklamowy – to wydarzenie jest uznawane za początek marketingu internetowego. Dwadzieścia lat później, w 2014 roku, wydatki na reklamę w internecie…