How to access nested field in GA4 BigQuery data table

Consider the following data table: This data table is for Nov 17, 2025 which is denoted by events_20251117 Let

CRMs like GHL are overkill for building Voice AI Agents.

Using a CRM (like GHL) is Overkill for Voice AI Agent Development. ‘GoHighLevel’ (GHL) is a great AI-first CRM

Best Types of Charts in Excel for Data Analysis, Presentation and Reporting

This article will show you the best Excel charts for data analysis, presentation, and reporting. You will learn about the

GA4 Scopes – User, Session, Event & Item scopes

Your GA4 and Looker Studio reports may be all wrong if you don’t understand the concept of scopes. Most

Understanding the BigQuery User Interface

Google BigQuery is a product of the Google Cloud Platform. BigQuery is a data storage and management system used to

gtag.js – Google Tag in Google Analytics 4 and beyond

What is Google Tag? The Google tag is just a new name for the global site tag (gtag.js).  Global

Voice AI Knowledge Base Creation Best Practices

In this guide, I show you what content to include in the knowledge base (KB) versus the global and state-

GA4 Direct Traffic Spike: Common Causes and How to Fix Them

Understanding Referrer. To understand how direct traffic works, you first need to understand the concept of the referrer.  To understand

LLMs can hallucinate even the most reliable data sources.

When you use tools like ChatGPT, Perplexity, or other AI assistants for topics such as GA4, GTM, or BigQuery, it’

GA4 Regex (Regular Expressions) Tutorial

Understanding GA4 regex is crucial for unlocking the full potential of Google Analytics 4’s data filtering and customization capabilities.

How to build Cost Efficient Voice AI Agent

The Hidden Cost of Ignoring Tokens in Voice Agent Design. Many people new to voice agents ignore token usage because

Tracking New, Qualified and Converted Leads in GA4.

Websites where the majority of conversions happen offline, often rely on leads generation for driving sales. The most common type

Free GA4 training and tutorial with Certification

Are you looking for free GA4 training? You are at the right place. Through this tutorial on Google Analytics 4

When to Add Booking Functionality to Your Voice AI Agent.

Not all Voice AI agents require booking functionality (scheduling/rescheduling/cancelling appointments). And if you provide such functionality without due

Understanding GA4 Ecommerce Reports (Monetization Reports)

Introduction to GA4 Ecommerce Reports (Monetization Reports). Follow the steps below to access the various Ecommerce/Monetization reports in GA4:

GA4 Ecommerce Tracking via GTM: Step-by-Step Setup Guide

, Set up GA4 Ecommerce tracking via GTM with this step-by-step guide. Learn how to track transactions, product views,

How to see UTM parameters in GA4 (Google Analytics 4)

UTM parameters are the parameters recognized by Google for sending detailed information about your marketing campaigns to Google Analytics 4.

GA4 UTM parameters not working? Here is how to fix it.

GA4 often relies on UTM tracking parameters to identify traffic sources, mediums, and campaigns. So use it wherever you can.

How To Use UTM parameters in GA4 (Campaign Tracking)

What is UTM tracking in GA4 (Google Analytics 4)? GA4 UTM tracking (also known as GA4 campaign tracking) refers to

How to track AI traffic in GA4

What is AI traffic in GA4? AI traffic in GA4 refers to user interactions initiated or influenced by AI-driven

Without IP your AI company is worth nothing.

Without IP (intellectual property) your AI company is worth nothing. Imagine Lovable starts selling its codebase. Keep that in mind,

AI Automation Agency Pricing Rules

The following are the 14 Rules to pricing automation that I learned from those who came before me (the agency

Understanding Google Analytics 4 cookies – _ga cookie

GA4 cookies are the backbone of user tracking, and understanding how they work is essential for optimizing your analytics setup.

How to Prevent Toll Fraud in Retell AI

What is Toll Fraud (also called International Revenue Sharing Fraud)? Fraudsters trick people or companies into making very expensive calls

GA4 (Google Analytics 4) Measurement Protocol Tutorial

Note: Use the Data Manager API instead of the Measurement Protocol. What is the measurement protocol in GA4? The measurement

Voice AI - Build once -> Sell many -> Collect monthly forever.

I decided at the beginning of this year to niche down early in the AI space. Best decision I made.

GA4 Unassigned Traffic: Causes and How to Fix it Fast

Learn the causes of GA4 unassigned traffic and discover quick, effective solutions to fix it, ensuring accurate data tracking and

State Machine Architectures for Voice AI Agents

Voice AI agents are built with different levels of state machine architecture: Understanding these architectures is critical for building voice

Topic-8: Creating Ecommerce Purchases Report

Topic-7: Creating Items Viewed and Items Revenue Report