Skip to content

Blog

Dense business essays and tech insights, written where experience meets code.

BigQuery ObjectRef Guide: Analyze Images and Docs in SQL
Measurement

BigQuery ObjectRef Guide: Analyze Images and Docs in SQL

BigQuery ObjectRef points to images, audio and PDFs in Cloud Storage so SQL can pass them to Gemini. GA on Oct 22. Covers permissions, first query and checks.

·6 min read
BigQuery Column Aliases and Cross-Region Table Copy Now GA
Measurement

BigQuery Column Aliases and Cross-Region Table Copy Now GA

BigQuery column aliases can now be reused in the same SELECT and WHERE. GA on October 15: how to enable them, name conflicts to check, and cross-region copy limits.

·4 min read
BigQuery AI.AGG Function: Syntax, Limits, and Cost Tips
Measurement

BigQuery AI.AGG Function: Syntax, Limits, and Cost Tips

BigQuery AI.AGG aggregates text or images across rows by meaning and returns one summary. GA on October 13, 2026. See syntax, input limits, and cost notes.

·5 min read
GA4 Certification Free: Skillshop Steps to Your Badge
Measurement

GA4 Certification Free: Skillshop Steps to Your Badge

Earn the GA4 certification free on Skillshop's Analytics Academy by scoring 80% or higher. Steps, passing score, retake wait, 1-year validity and where to find it.

·5 min read
Google Analytics GA4 Setup: Sign Up, Install, Find Measurement ID
Measurement

Google Analytics GA4 Setup: Sign Up, Install, Find Measurement ID

Set up Google Analytics (GA4) in order: account, property, data stream. Add the tag with your measurement ID, then confirm it in the Realtime report.

·6 min read
CRM Meaning, Types, and Marketing Message Rules in Korea
Measurement

CRM Meaning, Types, and Marketing Message Rules in Korea

CRM records and tracks customer data and interactions. Learn the 3 CRM types, 4 steps of CRM marketing, and rules for sending Kakao Alimtalk and promotional messages.

·6 min read
UTM Parameters: How to Build Links and Check Them in GA4
Measurement

UTM Parameters: How to Build Links and Check Them in GA4

Fill in utm_source, utm_medium and utm_campaign, build the link, then check it in GA4 Traffic acquisition. Includes value naming tips and common mistakes.

·8 min read

Planning a new project?

Browse the archive, or reach out for a casual chat over coffee.