Introduction to GA4 BigQuery for Marketers and Planners (2025)
We introduce ways to utilize GA4 data in BigQuery. Using the GA4 BigQuery demo data from the Google Merchandise Store (https://www.googlemerchandisestore.com/) available publicly in BigQuery, we provide hands-on practice with basic SQL queries and introduce methods for marketers and planners to easily utilize GA4 BigQuery data.
65 learners
Level Beginner
Course period Unlimited
News
15 articles
Subject: How to use Microsoft Clarity for Digital Marketers
Date/Time: March 14th (Sat) 1:30 PM ~ 3:00 PM
How to participate: Pre-registration is required after clicking the Zoom link below https://us06web.zoom.us/meeting/register/nfbIgaP9Q9KIg8Dx4KB4yA
Content
- How to install Clarity
- Basic usage (Heatmaps, Session Recording, GA4/Google Ads integration)
- Analysis of specific behavior patterns using filters
- Analysis methods using Copilot
- Clarity event types and how to set up custom events
Others
- Course materials and replays are not provided.
- We will proceed while looking at the Clarity demo account.
Lecture Link
Google Analytics (GA4+GTM) Course for Practitioners: https://inf.run/Jxd6i
GA4 Practical Reports for Immediate Use: https://inf.run/JR68B
GA4 BigQuery Introduction for Marketers and Planners: https://inf.run/f6p3F
Looker Studio Practice for Data Analysis https://inf.run/fwaZW
GA4 Google Analytics Ecommerce Setup Practice for Marketers: https://inf.run/HZpQ5
Microsoft Clarity Analysis, Easier than GA4 https://inf.run/PQbew
Google Analytics (GA4) Certification (GAIQ) Practice Question Explanations for Practical Use 2026 https://inf.run/pnXfc
I am sharing the video from the last webinar. This is the unedited version.
You can follow along with hands-on practice covering the basics of creating GA4 reports.
The replay video will be available for one week only. (It is scheduled to be set to private next week.)
Please take note.
Lecture LinkGoogle Analytics (GA4+GTM) Course for Practitioners: https://inf.run/Jxd6i
Practical GA4 Business Reports for Immediate Use: https://inf.run/JR68B
GA4 BigQuery Introduction for Marketers and Planners: https://inf.run/f6p3F
Looker Studio Practice for Data Analysis https://inf.run/fwaZW
GA4 Google Analytics Ecommerce Setup Practice for Marketers: https://inf.run/HZpQ5
Microsoft Clarity Analysis: Easier than GA4
Google Analytics (GA4) Certification (GAIQ) Practice Exam Questions & Explanations for Practical Use 2026
This is a reminder for the free webinar this Saturday (1:30 PM). We will be conducting a hands-on session on creating GA4 reports.
Please note that replay videos and teaching materials will not be provided.
Free webinar (challenge) application link: https://inf.run/zdkay
Reference Course Links
Google Analytics (GA4+GTM) Course for Practitioners: https://inf.run/Jxd6i
Ready-to-use GA4 Practical Reports: https://inf.run/JR68B
GA4 BigQuery Introduction for Marketers and Planners: https://inf.run/f6p3F
Looker Studio Practice for Data Analysis https://inf.run/fwaZW
GA4 Google Analytics Ecommerce Setup Practice for Marketers: https://inf.run/HZpQ5
Microsoft Clarity Analysis: Easier than GA4
Google Analytics (GA4) Certification (GAIQ) Exam Practice Questions and Explanations for Practical Use 2026
- Date & Time: Saturday, December 6th, 1:00 PM ~ 3:00 PM
- Zoom Link: https://us06web.zoom.us/j/87190385104?pwd=aMx8GMujNFxpYFEExZLa4Hubi9D5JO.1
- Content: We will be conducting a scenario to analyze the behavior of incoming users based on actual traffic.
- Lecture materials and replay videos are not provided.
The basic usage of Microsoft Clarity can be found in the video below.
The installation and basic usage are explained in my existing courses.
Practical GA4 Reports You Can Use Right Away (+Microsoft Clarity): https://inf.run/hhgER
Watch Previous Seminar Recording
- Microsoft Clarity Funnel Feature Setup: https://youtu.be/3LaXyyOuCgc
- How to set up Microsoft Clarity for monitoring payment abandonment: https://youtu.be/zEcCf-_ttCQ
Join GA4 Study Open Chat Room: https://open.kakao.com/o/gEz1aqPc
- Date & Time: Saturday, 12/6, 2:30 PM ~ 4:00 PM
- Zoom Link: https://us06web.zoom.us/j/88118160248?pwd=DuxHeUqyobaUZnME3tbyhrk3qbabxs.1
- Content: Rather than covering installation or basic usage methods, I'll focus on explaining specific features to enhance your productivity.
- It's not difficult, but there are cases where you need to utilize some Google Tag Manager settings, so it would be good to have an understanding of this aspect.
- Lecture materials and replay videos are not provided.
For basic usage of Microsoft Clarity, please refer to the video below.
Installation and basic usage instructions are also explained in my existing lectures.
Practical GA4 Reports You Can Use Right Away (+Microsoft Clarity): https://inf.run/hhgER
Other Course Links
Google Analytics for Professionals (GA4+GTM) Course: https://inf.run/Jxd6iPractical GA4 Reports You Can Use Right Away: https://inf.run/JR68B
Intro to GA4 BigQuery for Marketers and Planners: https://inf.run/f6p3F
Data Analysis with Looker Studio Practice https://inf.run/fwaZW
Hands-on GA4 Google Analytics E-commerce Setup for Marketers: https://inf.run/HZpQ5
[Free Webinar] 11/29(Sat) - How to Use Microsoft Clarity to Maximize Its Effectiveness
- Date & Time: Saturday, 11/29, 1:00 PM - 3:00 PM
- Zoom Link: https://us06web.zoom.us/j/83822787546?pwd=8kNgC8ZlbohWUNg5Zcja0Ed4256roc.1
- Content: I plan to focus on explaining specific features to enhance usability rather than installation or basic usage methods.
- It's not difficult, but there are cases where you need to utilize some Google Tag Manager settings, so it would be good to have an understanding of this area.
- Course materials and replay videos are not provided.
Please refer to the video below for basic usage of Microsoft Clarity.
Installation and basic usage methods are also explained in my existing lectures.
Ready-to-Use GA4 Practical Reports (+Microsoft Clarity): https://inf.run/hhgER
I'm trying to finish setting up the e-commerce that I was working on previously.
This is a simple practice session for setting up only the purchase event.
- Date: Sunday, November 2nd at 10 AM (approximately 1 hour duration)
- Zoom link: https://us06web.zoom.us/j/83950970055?pwd=nCRGjEc4UCbRCuZ7WpraCeVavg3SQF.1You need to have GA4 and GTM connected to the Cafe24 demo shopping mall to practice.
ChatGPT usage is included to some extent.
Course materials and replay videos are not provided.
Reference
Google Analytics (GA4+GTM) Course for Practitioners: https://inf.run/Jxd6iPractical GA4 Reports You Can Use Right Away: https://inf.run/JR68B
Introduction to GA4 BigQuery for Marketers and Planners: https://inf.run/f6p3F
Looker Studio Practice for Data Analysis https://inf.run/fwaZW
GA4 Study Open Chat Room: https://open.kakao.com/o/gEz1aqPc
[Free Webinar 9/20(Sat) 1:30 PM ~ 3:00 PM] GAIQ Past Exam Questions Solved While Learning GA4 Practical Skills - Session 1
This is a course where you learn GAIQ practice questions, which are called Google Analytics certification(?), through hands-on practice + theoretical explanations using actual GA4 demo accounts.
In fact, GAIQ is almost an open-book format exam, so it's easy to obtain,
Getting GAIQ certification doesn't mean you can use GA4 (Google Analytics).
In this study, we will sequentially learn how to use GA4 based on actual GA4 exam questions.
This is a study targeting complete beginners in Google Analytics.
It will be conducted a total of about 4 times, and is scheduled to take place every Saturday.
* Teaching materials and recorded videos are not provided.
Zoom Link: https://us06web.zoom.us/j/85902616305?pwd=6J2M0dAfPnwni61Kay9bRMQu0PCI1d.1
GA4 Study Open Chat Room: https://open.kakao.com/o/gEz1aqPc
Reference Lectures
Google Analytics (GA4+GTM) Course for Practitioners: https://inf.run/Jxd6i
Practical GA4 Reports You Can Use Right Away: https://inf.run/JR68B
GA4 BigQuery Introduction for Marketers and Planners: https://inf.run/f6p3F
Looker Studio Practice for Data Analysis https://inf.run/fwaZW
