Voice AI
Custom Reporting For Voice AI - Mini-Course.
Here is how most Voice AI agencies handle client billing: 1. Log into your provider dashboard. 2. See workspace-level totals. Not per-client. 3. Export data
Blog
Insights on Voice AI, GA4, and data analytics
GA4 Bigquery
How to access GA4 Sample Data in BigQuery
If you don’t have your own GA4 data in BigQuery, you can query the GA4 sample data available via BigQuery Public datasets. The sample
GA4 Bigquery
How to access BigQuery Public Data Sets
BigQuery provides many public datasets you can use for practice. A public dataset is stored in BigQuery and made available to the general public through
GA4 Bigquery
Calculating New vs Returning GA4 Users in BigQuery
First things first. Both ‘New’ and ‘Returning’ GA4 users need to be manually calculated in BigQuery. They are not available as default fields in the
GA4 Bigquery
Extracting GA4 User Properties in BigQuery
User properties in GA4 are attributes of your website visitors, such as age, gender, geographic location, language preference, membership level, etc. Technically speaking, a user
GA4 Bigquery
How to handle empty fields in GA4 BigQuery
Empty strings in query results from a GA4 BigQuery data table often indicate that certain fields are unpopulated or undefined for specific events. You should
GA4 Bigquery
First User Primary Channel Group in GA4 BigQuery
Following is the overview of my query logic for calculating the 'First User Primary Channel Group' in GA4 BigQuery: Step-1: Use the following
GA4 Bigquery
Tracking Pages With No Traffic in GA4 BigQuery
GA4 does not report on pages that received no traffic (zero pageviews) during the selected time period. However, it does report on the pages that
GA4 Bigquery
GA4 BigQuery SQL Optimization Consultant
In BigQuery, you can use a dozen different optimisation techniques to produce the same result. There's no single "best" way to
GA4 Bigquery
Extracting Geolocations in GA4 BigQuery
These are the Geolocations fields in GA4 BigQuery: In the GA4 BigQuery Export table, you can retrieve: * The value of the Continent that a user
GA4 Bigquery
Calculating First Time Users in GA4 BigQuery
You can calculate first time users via the 'user_first_touch_timestamp' field. This field tells when a user first interacted with your
GA4
GA4 Conversion Tracking (Key Events) Tutorial
What are Conversions in Google Analytics 4 (GA4)? A conversion is a goal/objective for setting up a website or mobile app. A conversion is
GA4 Bigquery
GA4 BigQuery Export Schema Tutorial
Once you understand how the GA4 data is stored in BigQuery data tables, it will become easier for you to query it. What is the
GA4 Bigquery
How to Calculate Unique Users in GA4 BigQuery.
Calculating Unique Users in GA4 BigQuery. You can calculate Unique users by counting the unique values of the 'user_pseudo_id' or '
GA4 Bigquery
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 us suppose you want to
GA4 Bigquery
GA4 BigQuery Query Optimization
In this article, I will show you how to write the same query (for extracting GA4 data in BigQuery) in 10 different ways and still
Voice AI
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 and can be incredibly useful for
Voice AI
How To Bill Your Voice AI Clients Like A Pro.
If you're building voice AI agents for clients, you need to understand how billing really works. Because it's not as simple
Data Analysis
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 various types of charts in
GA4
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 GA4 users confidently create and
GA4 Bigquery
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 consolidate data from multiple sources
GA4
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 site tag or gtag.js
Voice AI
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-specific prompts when building multi-prompt voice
GA4
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 the referrer, you first need
Voice AI
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’s easy to assume that
GA4
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. With regex, you can create
Voice AI
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 the costs and performance effects
GA4
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 of leads is form leads.
GA4
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 (aka GA4), you can learn
Voice AI
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 diligence, it could backfire. Use