GA4 is the standard today – and at the same time one of the most frequent causes of incorrect marketing decisions. Not because Google Analytics 4 is “bad”, but because the measurement chain has become more complex: consent, browser restrictions, event-based tracking, e-commerce implementations, cross-domain flows, payment providers. At our…
Many marketing teams are familiar with this: The GA4 numbers feel “somehow wrong.” Campaign reports don’t match shop revenue, the ratio of (direct) / (none) is increasing, conversions are disappearing – and the feeling lingers: ” Our Google Analytics numbers are wrong. “ Typical questions in everyday marketing are: “Why…
At SEACAMP in Jena on May 8, 2025, I gave a comprehensive presentation on SEA Reporting Dashboards. For those who couldn’t attend or would like to deepen their knowledge, I summarize here the most important content and detailed practical examples. Why Professional Dashboards? Agency dashboards create a unified communication standard,…
In the dynamic world of e-commerce, it is crucial for online marketing managers to constantly keep an overview of sales activities. An effective monitoring system can help prevent revenue losses and quickly respond to changes. In this context, a specially developed Google Apps Script that integrates Google BigQuery offers a…
Are you already using Matomo and want to expand your web analytics in a data-driven way? Then you’ve come to the right place. Here you’ll learn how to close these gaps using Google Looker Studio and the Matomo API, taking individual web analyses to a new level. Why Matomo? Matomo…
Google Search Console offers a powerful Bulk Data Export feature that allows website operators to store and analyze extensive search data in Google BigQuery. In this blog post, you’ll learn how to set up and optimally use the Bulk Data Export in Google Search Console. Why use Bulk Data Export?…
Matomo is a powerful web analytics tool that provides detailed insights into the behavior and characteristics of website visitors. A central component of these analyses is the API endpointLive.getLastVisitsDetails , which provides a comprehensive overview of recent visits to a website. This is not raw tracking data, but rather processed…
Introduction Definition of N-Gram Analysis N-Gram analysis is a method in natural language processing (NLP) and computational linguistics used to examine text and data by analyzing sequences of N consecutive elements or tokens (e.g., words or letters). It helps to identify patterns, frequencies, and relationships between elements in larger text…
The article shows the transfer of Google Ads API data to Google BigQuery using custom reporting, which can be configured individually. Possible transmission routes You can transfer the Google Ads API data into BigQuery in several ways. One option is to create an ETL (Extract, Transform, Load) process using a…
Who hasn’t experienced this in everyday agency life? A client’s online shop releases new products, but no one at the ads agency notices because the people responsible for product maintenance don’t communicate regularly with the various agency partners. In the end, such new products are casually mentioned at the next…
