🚀 How to Create Custom Dimensions in BigQuery with SQL (Funnel Stage Example)

Your campaigns have names like 'Awareness_US_Q1' and 'Conversion_LATAM_Q2' — but your BigQuery table doesn't know they're TOFU or BOFU. Custom dimensions fix that. This video shows you how to use SQL to automatically label your campaigns by funnel stage based on their naming convention. ▶ WHAT YOU'LL LEARN → What a custom dimension is and how it's different from a custom metric → How to use the SQL CASE WHEN function to categorize data (works like an IF statement) → How to label campaigns as TOFU, MOFU, or BOFU based on naming conventions → How the % wildcard works in SQL LIKE statements (and why its position matters) → How to use ELSE to catch any values that don't match your conditions → How to name your new custom dimension using AS → How Porter Metrics lets you create custom dimensions without writing SQL ⏱ TIMESTAMPS 0:00 — What is a custom dimension in BigQuery? 0:17 — The use case: labeling campaigns by funnel stage 1:00 — Writing the CASE WHEN query: TOFU, MOFU, BOFU labeling 2:10 — The % wildcard in SQL LIKE: why position matters 2:55 — The ELSE operator: handling anything that doesn't match 3:30 — The result: your new funnel_stage custom dimension 4:00 — How to do this without SQL using Porter Metrics 📌 ABOUT THIS COURSE This is part of the Google BigQuery for Marketers course by Porter Metrics — built for marketing teams who want to enrich their BigQuery data with custom labels, segments, and categories based on their own campaign taxonomy. 🔗 RESOURCES → Try Porter Metrics free: https://portermetrics.com → Full BigQuery for Marketers playlist: https://www.youtube.com/playlist?list=PLh9mb-JjFjzMFGo4MTPSC3kk14b5x1tKD → Read the full article: https://portermetrics.com/en/tutorial/google-bigquery/custom-dimensions-bigquery/