Blog about web analyticsANALYTICS TIPS

Blog author

Maks Hapchuk

Web Analyst, Marketer

Author Maks Hapchuk photo

Leading an author's Telegram channel#AnalyticsTips

Co-founder of an educational platformPROANALYTICS.ACADEMY

Head of the analytics teamProAnalytics.Team

Co-founder of the serviceMonolytics surveys

Partners and clients

Blog about web analyticsANALYTICS TIPS

AboutAbout
Course PRO AnalyticsCourse PRO Analytics
Course PRO GTMCourse PRO GTM
Course Google Analytics 4Course Google Analytics 4
Other coursesOther courses

© 2018 - 2025. Analytics TipsPrivacy Policy

Setting up automatic import of annotations from GA4 to Google Sheets

Google Analytics 4

Mon, June 2, 2025

Setting up automatic import of annotations from GA4 to Google Sheets

This article, like many others on this blog, appeared by chance — thanks to a question in the chat. Last week, in our private PRO ANALYTICS course chat, Lena Kolisnyk asked: “Is it possible to export annotation data from GA4 into Google Sheets so that it can later be used in custom reports?” Neither I nor the students recalled a ready-made solution. However, about a month ago on LinkedIn — and later in our internal ProAnalytics.Team chat — I came across a solution by Tamás Geiger that allows you to automatically create annotations in GA4 when publishing versions in GTM using Google Apps Script.

Analyzing Unstructured Data with ChatGPT

Fri, September 6, 2024

Analyzing Unstructured Data with ChatGPT

We all know how to draw conclusions from structured data to some extent, but most people get lost when asked to analyze unstructured data. Today, I’ll try to take a closer look at this process.

What is Table Explorer in BigQuery, Why It’s a Game Changer, and How It Makes Getting Started with BigQuery Much Easier

Google BigQuery

Thu, August 1, 2024

What is Table Explorer in BigQuery, Why It’s a Game Changer, and How It Makes Getting Started with BigQuery Much Easier

Last week, the Google BigQuery team rolled out an exciting update called Table Explorer, designed to help analysts — and anyone else working with BigQuery — tackle their tasks more easily and conveniently. In short, this feature allows you to quickly explore table data in a user-friendly visual way and even write simple SQL queries.

Prefilling a Promo Code Using GTM

Wed, December 20, 2023

Prefilling a Promo Code Using GTM

This post came about accidentally, but I hope it’ll be useful to many marketers during these pre-holiday days. Today, Dima Osiuk and I were discussing the landing page for the SERVER-SIDE GTM BASICS course and thought it would be great if the promo code could be prefilled in the form automatically whenever possible.

Why GA4 Counts More Key Events (formerly conversions) Than Universal Analytics

Thu, May 11, 2023

Why GA4 Counts More Key Events (formerly conversions) Than Universal Analytics

People tend not to trust new things. And when switching from Google Analytics Universal to Google Analytics 4, they start comparing the data in both systems. As a result, they notice that the same metrics have different values. This applies to almost all metrics in both platforms — be it the number of users, sessions, key events, or even the key event rate. The values will differ between the two systems, and the first thing you need to understand is — IT’S NORMAL FOR THEM TO BE DIFFERENT.

What Is Thresholding in GA4 and How to Deal With It

Mon, May 8, 2023

What Is Thresholding in GA4 and How to Deal With It

Many of my readers have already worked with GA4 and noticed one not-so-pleasant nuance of this system: sometimes data that should appear in reports or explorations is missing. These situations vary — sometimes you see the data in Real Time reports, but then it’s gone from the standard reports. Or you might see conversions for a weekly view, but when you try to break it down by day, some conversions disappear. If you’ve experienced these or similar situations, chances are you're facing thresholding .

What to Do If GA4 Starts Sending Duplicate Events After Setting Up Key Events (earlier - conversions)

Fri, May 5, 2023

What to Do If GA4 Starts Sending Duplicate Events After Setting Up Key Events (earlier - conversions)

Lately, more and more people have been actively switching to GA4, and I keep seeing the same issue come up in various groups and chats: “I set up an event for GA4, everything looked fine at first — but after marking it as a key event (earlier - conversion), GA4 started sending duplicate events.” If you’re facing a similar issue, this article is for you.

Set a Timer for Engaged Sessions in Google Analytics 4

Tue, July 20, 2021

Set a Timer for Engaged Sessions in Google Analytics 4

Let’s walk through a simple but important configuration step in Google Analytics 4: how to set a timer for engaged sessions. Why is this important? As you may know, Google Analytics 4 does not have a bounce rate. Instead, it uses a similar metric called the Engagement rate — the ratio of engaged sessions to total sessions.

Funnel Exploration in Google Analytics 4: An Advanced Guide to Funnels

Google Analytics 4

Wed, January 13, 2021

Funnel Exploration in Google Analytics 4: An Advanced Guide to Funnels

There are many reasons to love Google Analytics 4: a new approach to data collection, new metrics, the ability to combine website and app data — and more . Among all these features, I want to highlight two in particular: Explorе and BigQuery Export. Each of them deserves its own series of articles. I’ve decided to begin with Explorations, since this functionality is more accessible.

How to Set Up Key Events (formerly Conversions) in Google Analytics 4: A Step-by-Step Guide

Google Analytics 4

Wed, December 9, 2020

How to Set Up Key Events (formerly Conversions) in Google Analytics 4: A Step-by-Step Guide

When reading the title of this article, some of you might think: “Oh, it’s just another guy telling me to flip the switch and the event becomes a key one.” If that’s the case, I recommend reading this article to the end — I’m sure you’ll discover some unexpected ways to mark an event as a key event in Google Analytics 4.

Filter articles

Category

View all #AnalyticsTips Google Analytics 4 Google Tag Manager Google Analytics Chat GPT R language Google BigQuery

BasicBigQueryChatGPTR languageAdvancedGoogle Analytics