Project, Dataset, and Table Setup in BigQuery
HomeGoogle BigQuery for MarketersModule 3 BigQuery Tutorial How to Set Up Your BigQuery Project ID, Dataset, and Table Name Santiago Cardozo Marketing Manager at Porter March 19, 2026 After you connect your marketing accounts and authenticate BigQuery in Porter Metrics, the next step is selecting where your data will land. This means choosing your BigQuery […]
How to Authenticate BigQuery: Google Login vs Service Account
HomeGoogle BigQuery for MarketersModule 3 BigQuery Tutorial How to Authenticate BigQuery: Google Login vs Service Account Santiago Cardozo Marketing Manager at Porter March 19, 2026 To send marketing data from Porter Metrics into Google BigQuery, you need to authenticate your BigQuery account. There are two ways to do this: Google login and service account. They […]
How to Connect Marketing Accounts to BigQuery
HomeGoogle BigQuery for MarketersModule 3 BigQuery Tutorial How to Connect Your Marketing Accounts to BigQuery With Porter Metrics Santiago Cardozo Marketing Manager at Porter March 19, 2026 Before your marketing data flows into BigQuery, you need to authenticate each data source. This means connecting your Meta Ads account, your Google Ads account, your Google Analytics […]
How to Blend Multiple Data Sources in BigQuery
HomeGoogle BigQuery for MarketersModule 3 BigQuery Tutorial How to Blend Multiple Marketing Data Sources in BigQuery Santiago Cardozo Marketing Manager at Porter March 19, 2026 If you want to see Meta Ads, Google Ads, and Google Analytics 4 data in a single BigQuery table, you have two options. You write SQL JOIN queries to combine […]
BigQuery Datasets and Tables
HomeGoogle BigQuery for MarketersModule 2 BigQuery Tutorial Google BigQuery Datasets and Tables: How Data Is Organized Santiago Cardozo Marketing Manager at Porter March 19, 2026 Google BigQuery organizes all data in a three-level hierarchy: projects contain datasets, and datasets contain tables. Understanding this structure is the first step to setting up your marketing data warehouse […]
Google BigQuery Studio Overview
HomeGoogle BigQuery for MarketersModule 2 BigQuery Tutorial Google BigQuery Studio: A Complete Interface Overview Santiago Cardozo Marketing Manager at Porter March 19, 2026 Google BigQuery Studio is the browser-based interface where you write SQL queries, explore your datasets, and view your results. You access it through the Google Cloud console at console.cloud.google.com/bigquery. You do not […]
BigQuery Organizations, Projects, and Billing
HomeGoogle BigQuery for MarketersModule 2 BigQuery Tutorial Google BigQuery: Organizations, Projects, and Billing Explained Santiago Cardozo Marketing Manager at Porter March 19, 2026 Before you start loading data into BigQuery, you need to understand how Google Cloud organizes your resources. The structure has three levels: organizations, projects, and billing accounts. Getting this right from the […]
Create a Google Cloud Account
HomeGoogle BigQuery for MarketersModule 2 BigQuery Tutorial How to Create a Google Cloud Account for BigQuery Santiago Cardozo Marketing Manager at Porter March 19, 2026 Creating a Google Cloud account takes about five minutes. Once you have one, you get access to Google BigQuery, Looker Studio, Cloud Storage, and every other Google Cloud service. You […]
Google Sheets vs Looker Studio vs BigQuery
HomeGoogle BigQuery for MarketersModule 1 BigQuery Tutorial Google Sheets vs Looker Studio vs BigQuery: Which Should You Use? Santiago Cardozo Marketing Manager at Porter March 19, 2026 Google Sheets, Looker Studio, and Google BigQuery all help marketing teams work with data. But they are not interchangeable. Each tool is built for a different scale and […]
Marketing ETL vs General ETL Tools
HomeGoogle BigQuery for MarketersModule 1 BigQuery Tutorial Marketing ETL Tools vs General ETL Tools: What Is the Difference? Santiago Cardozo Marketing Manager at Porter March 19, 2026 Both marketing ETL tools and general ETL tools move data from your sources into a destination like Google BigQuery. But they are built for different users, with different […]