What I Do · Data

Collecting and reading website data with GA4 and GTM: events and parameters, users and sessions, UTM and channel groups, and attribution models.

Box and Whisker Chart in Google Sheets: New Box Plot vs. Excel

Box and Whisker Chart in Google Sheets: New Box Plot vs. Excel

Google SheetsExcel ReportsData Cleanup
Google Sheets Pivot Table: New Compact Layout and Excel Compatibility

Google Sheets Pivot Table: New Compact Layout and Excel Compatibility

Google SheetsPivot TablesExcel Reports
What Is RAG? How to Connect Company Data to AI for Answers

What Is RAG? How to Connect Company Data to AI for Answers

AI Basics
Excel ISNUMBER Function: Check Numbers and If a Cell Contains Text

Excel ISNUMBER Function: Check Numbers and If a Cell Contains Text

ExcelExcel FunctionsData Cleanup
How to Exclude Internal Traffic in GA4: Data and Hostname Filters

How to Exclude Internal Traffic in GA4: Data and Hostname Filters

GA4
Gemini in Google Sheets for BigQuery: Ask in Plain Language

Gemini in Google Sheets for BigQuery: Ask in Plain Language

Google SheetsGA4Work Automation
Google Ads Data Strength: Tag Gateway and Enhanced Conversions

Google Ads Data Strength: Tag Gateway and Enhanced Conversions

Google AdsAd PerformanceGTM
Excel Numbers Stored as Text: How to Convert Them to Numbers

Excel Numbers Stored as Text: How to Convert Them to Numbers

ExcelData CleanupExcel Functions
What Is Conversion Modeling? How Google Ads and GA4 Fill Gaps

What Is Conversion Modeling? How Google Ads and GA4 Fill Gaps

GA4Google AdsAd Performance
Claude Dashboards and Motion Beta: How They Work for Marketers

Claude Dashboards and Motion Beta: How They Work for Marketers

ClaudeWork AutomationGA4
Display Retargeting Setup: Google Ads Remarketing with GA4

Display Retargeting Setup: Google Ads Remarketing with GA4

Display AdsGoogle AdsGA4
Landing Page Optimization: Google Ads Landing Page Experience

Landing Page Optimization: Google Ads Landing Page Experience

Search AdsGoogle AdsAd Performance
Mask Personal Data in Excel: Hide Names and Phone Numbers with *

Mask Personal Data in Excel: Hide Names and Phone Numbers with *

ExcelExcel FunctionsData Cleanup
Excel Conditional Formatting: See Numbers as Colors, Bars, and Icons

Excel Conditional Formatting: See Numbers as Colors, Bars, and Icons

ExcelExcel ReportsData Cleanup
Google Sheets QUERY Function: Use Your Sheet Like a Database

Google Sheets QUERY Function: Use Your Sheet Like a Database

Google SheetsData Cleanup
Excel Remove Duplicates: Find, Highlight, and Remove Safely

Excel Remove Duplicates: Find, Highlight, and Remove Safely

ExcelExcel FunctionsData Cleanup
Excel PivotTable Report: Slicers and PivotCharts at a Glance

Excel PivotTable Report: Slicers and PivotCharts at a Glance

ExcelPivot TablesExcel Reports
VLOOKUP vs XLOOKUP: Which Excel Lookup Function to Use

VLOOKUP vs XLOOKUP: Which Excel Lookup Function to Use

ExcelExcel Functions
UTM Parameters and GA4 Default Channel Groups Explained

UTM Parameters and GA4 Default Channel Groups Explained

GA4Ad Performance
GA4 Users, Sessions, Engagement Rate, and Bounce Rate Explained

GA4 Users, Sessions, Engagement Rate, and Bounce Rate Explained

GA4
CPC, CPM, CTR, ROAS: How to Calculate Core Ad Metrics

CPC, CPM, CTR, ROAS: How to Calculate Core Ad Metrics

Ad PerformanceGoogle AdsSearch Ads
GA4 Events and Parameters: Automatic, Enhanced, Recommended, Custom

GA4 Events and Parameters: Automatic, Enhanced, Recommended, Custom

GA4Event Tracking
GA4 Conversion Lookback Window Now Set by the Day

GA4 Conversion Lookback Window Now Set by the Day

GA4Ad Performance
GTM Tags, Triggers, and Variables: Google Tag Manager Basics

GTM Tags, Triggers, and Variables: Google Tag Manager Basics

GTMEvent TrackingGA4
Vibe Coding a Real Tool: Building a GA4 Privacy Policy Generator

Vibe Coding a Real Tool: Building a GA4 Privacy Policy Generator

Vibe CodingGA4
Attribution Models in Google Analytics Explained

Attribution Models in Google Analytics Explained

GA4Ad Performance
Excel PivotTable Guide: What It Is, How to Create and Refresh

Excel PivotTable Guide: What It Is, How to Create and Refresh

ExcelPivot TablesExcel Reports