SQL Joins for Marketers: INNER, LEFT, RIGHT, and FULL JOIN
HomeGoogle BigQuery for MarketersModule 4 BigQuery Tutorial SQL Joins in BigQuery: How to Combine Marketing Data Tables Santiago Cardozo Marketing Manager at Porter March 19, 2026 A JOIN is the SQL operation that merges two or more tables based on a shared column. In BigQuery, you use JOINs to combine your marketing data sources: Meta […]
How to Create Custom Dimensions in BigQuery with SQL
HomeGoogle BigQuery for MarketersModule 4 BigQuery Tutorial How to Create Custom Dimensions in BigQuery With SQL Santiago Cardozo Marketing Manager at Porter March 19, 2026 A custom dimension is a label you assign to rows in your BigQuery table based on conditions you define. Instead of reporting on raw campaign names, you group campaigns into […]
How to Create Custom Metrics in BigQuery with SQL
HomeGoogle BigQuery for MarketersModule 4 BigQuery Tutorial How to Create Custom Metrics in BigQuery With SQL Santiago Cardozo Marketing Manager at Porter March 19, 2026 A custom metric is a calculation you run on your BigQuery table to produce a metric that does not exist as a column in the original data. Your ad platforms […]
SQL for Marketers: SELECT, FROM, WHERE, ORDER BY, and LIMIT
HomeGoogle BigQuery for MarketersModule 4 BigQuery Tutorial SQL for Marketers: BigQuery Basics You Need to Know Santiago Cardozo Marketing Manager at Porter March 19, 2026 SQL is the language you use to query data in Google BigQuery. You do not need a computer science background to use it. The core operators are simple, and once […]
Data Blending in BigQuery
HomeGoogle BigQuery for MarketersModule 4 BigQuery Tutorial Data Blending in Google BigQuery: How to Combine Marketing Data Sources Santiago Cardozo Marketing Manager at Porter March 19, 2026 Data blending in BigQuery means combining multiple marketing data sources into one unified table. Instead of looking at Meta Ads in one report and Google Ads in another, […]
How to Send and Monitor Marketing Data in BigQuery
HomeGoogle BigQuery for MarketersModule 3 BigQuery Tutorial How to Send and Monitor Your Marketing Data in BigQuery Santiago Cardozo Marketing Manager at Porter March 19, 2026 After configuring your data sources, metrics, dimensions, date range, filters, write mode, and schedule in Porter Metrics, you are ready to send your data to BigQuery. This is the […]
BigQuery Write Modes: Overwrite, Append, and Update
HomeGoogle BigQuery for MarketersModule 3 BigQuery Tutorial BigQuery Write Modes Explained: Overwrite, Append, and Update Santiago Cardozo Marketing Manager at Porter March 19, 2026 When Porter Metrics loads data into your BigQuery table, it follows a write mode that you set. The write mode controls what happens to the existing data in your table when […]
How to Schedule Marketing Data Updates in BigQuery
HomeGoogle BigQuery for MarketersModule 3 BigQuery Tutorial How to Schedule Your Marketing Data Pipeline to BigQuery Santiago Cardozo Marketing Manager at Porter March 19, 2026 Once your Porter Metrics query is configured, you set a schedule that tells Porter when to run. Every day at that time, Porter extracts fresh data from your marketing platforms […]
Date Ranges, Filters, and Sorting in BigQuery
HomeGoogle BigQuery for MarketersModule 3 BigQuery Tutorial How to Set Date Ranges, Filters, and Sorting in BigQuery With Porter Metrics Santiago Cardozo Marketing Manager at Porter March 19, 2026 Before your marketing data lands in BigQuery, you control exactly what data goes in. Porter Metrics lets you set date ranges, apply filters, and configure sorting […]
How to Select Metrics and Dimensions in BigQuery
HomeGoogle BigQuery for MarketersModule 3 BigQuery Tutorial How to Select Metrics and Dimensions for BigQuery With Porter Metrics Santiago Cardozo Marketing Manager at Porter March 19, 2026 When you send marketing data to BigQuery, you choose which metrics and dimensions to include. This determines what columns appear in your BigQuery table and what you can […]