2026-03-25
Optimize BigQuery Cost
Discover how to significantly reduce your BigQuery costs by mastering the nuances of different storage types and data architecture. We break down the technical details and provide real-world examples to help you optimize your setup for maximum efficiency.
2026-03-14
Conversational Analytics in BigQuery
Conversational analytics in BigQuery lets users ask questions about their data in natural language instead of writing SQL. AI-powered data agents translate the questions into queries, analyze the data, and return answers with text, tables, or charts.
2026-01-23
Build a Data-Driven Marketing Foundation for 2026
Data-driven marketing in 2026 starts with a strong foundation today. Learn how to improve tracking accuracy, implement Google Tag Manager Server-side, activate first-party data, audit privacy.
2025-11-30
Click Attribution, Incrementality & MMM
In this post you will learn how click attribution, incrementality testing and marketing mix modelling each help you understand the real impact of your marketing. You will also see when to use each method.
2025-11-28
Generative AI Functions in BigQuery to Analyze Qualitative Data
Generative AI in BigQuery makes it easy to analyse qualitative data directly with SQL. You can summarise feedback, classify sentiment and turn unstructured text into clear insights with just a few queries.
2025-11-16
Backfill Aggregated Google Analytics 4 Data to BigQuery
When you connect Google Analytics 4 to BigQuery your raw event export only starts from the day the link is activated, so what happens to your historical data. This post shows how the built-in BigQuery Data Transfer.
2025-11-09
Setting up Dataform Repository actAs Permissions
Google announced that Dataform will start enforcing stricter actAs checks. Learn how to enforce act-as permissions in Dataform step by step so your pipelines always run under the right service account.
2025-11-05
The Data Foundations Every Business Needs Before Using AI
Before jumping into AI, make sure your data foundation is solid. Define key metrics, centralize your data, and ensure compliance with privacy laws. Without clean, structured, and reliable data, even the best AI tools.
2025-11-05
Navigating Privacy and Compliance in Tracking and Measurement
Digital marketing and tracking have never been more important, but expectations are higher than ever. With GDPR and ePrivacy, companies need to find the right balance between the rewards of better insights.
2025-09-22
Choosing the Right Analytics Tool: Beyond Google Analytics
There are many alternatives to Google Analytics that offer more control, privacy, and insights. This article explores tools like Matomo, Piwik PRO, Mixpanel, and Amplitude, comparing features, pricing, and capabilities.
2025-09-22
Ctrl Digital Partners with Piwik PRO
Ctrl Digital is now an official partner of Piwik PRO, the privacy-focused analytics suite built for GDPR, HIPAA and global compliance.
2025-09-16
Case: Axis Communications
Axis Communications partnered with Ctrl Digital to build a secure, scalable analytics foundation. By standardizing Matomo on-premise, implementing Server-side Google Tag Manager, and optimizing BigQuery reporting with Dataform.
2025-08-29
Safari’s New Tracking Prevention on Click IDs – Impact & Solutions
Safari's upcoming tracking prevention update will strip click IDs like gclid, fbclid, and msclkid from URLs, severely impacting conversion tracking. This will make attributing conversions difficult, affecting campaign optimization.
2025-08-26
Setting Up a Dataform Repository in Google BigQuery
Dataform is a development environment built to manage SQL-based data workflows in BigQuery. It helps you structure, test, and document your SQL in a more organized way, similar to how software engineers work with code.
2025-06-24
Case: Apotek Hjärtat
Discover how Ctrl Digital supports Apotek Hjärtat, one of Sweden’s largest online pharmacies, with secure tracking, Google Tag Manager Server-side and advanced analytics in BigQuery. A trusted partnership focused on compliance, performance, and data protection.
2025-05-12
Microsoft Ads Now Requires Consent Mode - Is Your Tracking Ready?
Microsoft requires that Consent Mode is implemented to continue tracking conversions with Bing Ads (UET). If you’ve seen a sudden drop in conversions, this might be the root cause.
2025-04-25
GTM Server Side - Extend Your Cookie Lifetime with IP Alignment
As server-side tagging has become a hygiene factor for many businesses through Google Tag Manager Server-side (GTMss), one critical aspect that is often overlooked is IP alignment.
2025-03-31
Introduction to the Data Transfer for Google Analytics 4
Explore the new Google Analytics 4 Data Transfer to BigQuery – a free feature that gives you ready-made tables with your Google Analytics 4 data. It makes reporting faster, analysis easier, and data more accessible.
2025-03-28
Building a Marketing Data Warehouse in BigQuery
This post will guide you through the why and how of creating your own MDW using Google BigQuery, a powerful cloud data warehouse, and leveraging data integration tools to simplify the process.
2025-03-26
Why Google Tag Manager Server-side matters for Your Business
Google Tag Manager Server-side tagging is a powerful solution that shifts tracking from the browser to a dedicated server, providing better data control, enhanced security, and improved website performance.
2025-02-19
Meta’s New Health & Wellness Ads Restrictions
In January 2025, Meta introduced new advertising restrictions, reducing the amount and type of data that certain industries can track and use for ad optimization.
2025-02-06
GA4 Items Data for Non-Ecommerce Events
GA4 doesn’t support items data in non-ecommerce events, but with BigQuery, you can extract, structure, and analyze it for deeper insights.
2025-01-17
Beginner’s Guide to Working with GA4 Data in BigQuery
Learn how to work with GA4 data in BigQuery in this beginner’s guide. Follow step-by-step instructions to get started with data analysis and reporting.
2024-12-18
Getting Started With Dataform
Simplify complex BigQuery workflows with Dataform, transforming chaos from GA4 and ad platform data into actionable insights.
2024-11-18
Microsoft Ads Consent Mode
To align with data privacy regulations, Microsoft introduced Consent Mode, which advertisers need to adhere to in order to ensure continued functionality.
2024-11-11
Google Tag Manager Server-side Advantages
Discover how Google Tag Manager Server-side improves data privacy, compliance, and tracking efficiency by consolidating data streams and enabling full control over third-party sharing.
2024-11-05
RFM Segmentation Using BigQuery: Part 2
This blog post is the second part of our three-part Data Activation Series, where we’re exploring how to leverage customer data effectively using BigQuery and machine learning techniques.
2024-11-01
Offline Conversions Google Ads
Tracking offline conversions is challenging, especially when the customer journey stretches over days or weeks. Imagine you run a SaaS or streaming service.
2024-10-15
Ruling Against Use of Meta Pixel - Part 3
In this final part of our Meta Pixel series. we explores its technical workings and offer a solution for simplifying the process of checking its implementation on websites.
2024-10-03
Ruling Against Use of Meta Pixel - Part 2
Following IMY's verdict against Avanza Bank's use of the Meta pixel, we conducted an audit of 35 major Swedish banks, credit institutions, and financial service companies to explore best practices, which we detail in our blog series.
2024-09-24
Ruling Against Use of Meta Pixel
The ruling against Avanza Bank, Apoteket AB, and Apohem highlighted significant privacy violations due to their use of the Meta Pixel.
2024-09-15
RFM Segmentation Using Bigquery: Part 1
This series will walk you through how to use customer data effectively, starting with the basics of RFM segmentation and culminating in activating data.
2023-02-21
Podcast: Migrating to Google Analytics 4
Ted Solomon recently guested one of Sweden's most popular podcasts about marketing to discuss how companies and marketers can make the switch to Google Analytics 4.
2023-01-29
Incrementality Testing
Incrementality testing is a statistical method used to determine the impact of a specific marketing or advertising campaign on the performance of a business.
2022-10-17
An Introduction to Apple Search Ads
Apple Search Ads (ASA) give you the possibility to reach users in a cost-efficient way, combining a highly interested audience with powerful targeting.
2022-02-03
Google Analytics & Legal Requirements
The use of GA is not illegal per se, not even in Austria. But the way you choose to implement it, and the data you choose to collect, is what dictates the legality of the service.
2022-01-26
Server-side Tagging
With the advent of new and shifting privacy regulations and cookie extinctions, data gaps and governance issues will be major challenges for marketing teams. Server-side tagging addresses many of these issues from a technical standpoint.
2021-01-14
Certified Segment Partner
We’re happy to call ourselves an official Certified Segment Partner. Segment is a single platform that collects, stores, and routes your user data to hundreds of tools with the flick of a switch.