Google BigQuery for Marketers and Agencies

Learn how to use SQL-powered queries in Google BigQuery to analyze marketing data and find meaningful insights.

Created by: Lachezar Arabadzhiev
Founder and CEO

Created by: SkildLabs Inc.
Building Better Learning Experience!

What Will I Learn?

• Become a technical marketer who is savvy in both digital marketing and data analysis
• Exploring eCommerce and CRM user-level data in Google Analytics 360 (Project #1)
• Write advanced queries with UNNEST, STRUCT and ARRAY_AGG
• Query multiple tables with different type of JOIN statements - INNER, LEFT and RIGHT
• Aggregate data with SUM, COUNT, GROUP BY and create aliases with AS
• Understand subqueries by using the WITH clause
• Visualize BigQuery tables and queries in Google Data Studio (Project #2)
• Identify high-value customers and activate insights in Google Ads

Requirements

• Understanding of Digital Marketing (Not Required, but Highly Recommended)
• Google BigQuery Sandbox (Free and Provided)
• Google Data Studio Account (Free and Provided)

Target audience

• Digital Marketers
• Campaign Managers
• Performance Managers
• Paid Media Managers
• SEO/SEM Specialists
• AdOps Specialists
• Digital Analysts