gcp

• Own your web analytics pipeline for €0.02 per day: Snowplow, Terraform, dbt, BigQuery and Docker Running Snowplow for your (web) analytics pipeline to expensive? Here's a €0.02/day minimal, serverless version of Snowplow open source that you can deploy for your blog or website with Terraform (on GCP/BigQuery) in 5 minutes giving you full ownership of a web and app analytics pipeline from data collection to custom data models (👋 goodbye Google Analytics). Continue reading...
  snowplow GA4 gcp BigQuery Terraform dbt Docker

  29 min read
• Fetching IPv4 CIDR ranges from AWS, GCP, Azure and Cloudflare for bot detection with Python Bots usually run on one of the major cloud providers. Identifying them can be a big factor in determining the quality of your traffic. Whether that's for web analytics or threat mitigation, it's useful to have an overview of IP ranges to identify in bot scoring. Continue reading...
  bots cloud AWS gcp Azure cloudflare python

  3 min read
• Dbt In a Box: Using Google Cloud Run and BigQuery to run your dbt SQL models from a Docker container Dbt is a great tool for data transformation. Snowplow is great for collecting web analytics data. What if you could harvest the power of both for just a few cents a day by running dbt in a Docker container on Google Cloud Run Jobs? Continue reading...
  dbt snowplow BigQuery Docker gcp cloudbuild

  13 min read
• Language Detection in SQL with BigQuery Remote Functions Over the last few years SQL has really started embracing its second adolescence. That's cool, but what if you could easily extend your queries beyond the SQL domain and add in Python and Javascript based serverless functions to get real time stock information, enrich location data or: build a language detection function!? That's what we'll do. Continue reading...
  NLP BigQuery language gcp

  4 min read
• DocTags: automatically generate documentation from the notes field in Google Tag Manager (GTM) GTM DocTags is a lightweight documentation generator for Google Tag Manager. It uses the notes field on tags, triggers and variables in Google Tag Manager —does anybody even use the note field?— and grabs that and some additional info through the GTM API to create a set of markdown files. The markdown files can be stored in Google Cloud Storage and rendered at runtime with Docsify to create a fully searchable, neat looking documentation site that you can serve your developers and other team members. Continue reading...
  gtm gcp documentation

  11 min read
• Monitor Google Tag Manager version status and send notifications to Slack: the easy way (Zapier) and hard way (GCP) It's impossible to sett up a pipeline in Google Tag Manager for when new container versions are published. It'd be great to get notifications of container updates, for security reasons, to run tests, update documentation, or to get notifications in services like Slack. Let's try and build a GTM status monitor that can send a notification to Slack when a new container version is published! Continue reading...
  gtm gcp monitoring Zapier

  10 min read
• Building a complete tag monitoring solution for Google Tag Manager Do you know if all your tags are used in Google Tag Manager or if you can remove some? Do you know if they work for all your users? Or if they fire on the right dataLayer events and how long they take to execute? Follow along for a complete solution to monitor your Google Tag Manager implementation including a dashboard. Tag monitoring will allow you to understand if important tags are actually firing for real users on your site and see when they break down. Continue reading...
  gcp google-apps-script google-cloud google-sheets gtm monitoring tag-manager

  3 min read
• Using Puppeteer to automate your google analytics testing Testing your analytics setup regularly can help you prevent uncomfortable situations with your boss or client when there's been another change on the site and suddenly all your campaigns and goals have zero conversions. We will look at how to test the actual requests that are being sent to Google Analytics, Facebook, or any other place you have your tags pointed at. Continue reading...
  howto gcp google-analytics puppeteer testing browser_automation playwright

  8 min read