Google BigQuery for Marketers and Agencies
4.7 (16 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
50 students enrolled

Google BigQuery for Marketers and Agencies

Learn how to use SQL-powered queries in Google BigQuery to analyze marketing data and find meaningful insights.
Highest Rated
4.7 (15 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
50 students enrolled
Last updated 6/2020
English
English [Auto]
Current price: $72.99 Original price: $104.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 2 articles
  • 6 downloadable resources
  • 2 Practice Tests
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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)
Description

LATEST CONTENT UPDATE: June, 2020


Welcome to Google BigQuery for Marketers and Agencies, the Google BigQuery course that focuses on growing the technical knowledge and expertise of the marketing professional! This course is designed to bridge the gap between data analysis and digital marketing, and help you become a data-driven decision-maker. The course curriculum is put together in a progressive fashion, starting with an introduction to the most useful SQL queries for marketers, the role of both BigQuery and SQL in the larger data ecosystem, and then diving into two hands-on projects, where you can use everything you have learned.


By the end of the course, you will be able to:

  • Explore eCommerce and CRM user-level data in Google Analytics 360 (Project #1)

  • Visualize active queries and data tables in Google Data Studio (Project #2)

  • Explore semi-structured data with ARRAY_AGG, UNNEST and STRUCT

  • Filter values with the WHERE clause to identify insights

  • Ingest .CSV files and create permanent BigQuery tables

  • Combine multiple data tables with different types of JOINs - INNER, LEFT and RIGHT

  • Aggregate data with SUM, COUNT and GROUP BY

  • Create nested queries by using the WITH clause


Who is the instructor?

Lachezar Arabadzhiev is a digital markitech with 4+ years of experience in performance analytics and data visualization. Lachezar began his career as a digital marketer at Microsoft, but soon transitioned to the measurement and analytics world, where he has had the opportunity to work with major brands such as Air Canada, RBC, Kimberly-Clark, Mazda and HSBC.

Lachezar has been working with Data Studio and BigQuery since early 2017 and has built a wide variety of visualizations and automation flows. From performance-based dashboards with joined GMP sources (Google Analytics 360, Campaign Manager and Display & Video 360) to audience-driven segmentation views with user-level eCommerce data.

Lachezar is a certified GMP expert and an official speaker at the Canadian Google Data & Analytics Summit, 2018.

Who this course is for:
  • Digital Marketers
  • Campaign Managers
  • Performance Managers
  • Paid Media Managers
  • SEO/SEM Specialists
  • AdOps Specialists
  • Digital Analysts
Course content
Expand all 31 lectures 02:54:01
+ Getting started with Google BigQuery
6 lectures 09:05
Navigating the Google BigQuery interface
03:42
Using the BigQuery Solutions Manual
00:24
Downloading the BigQuery course datasets
00:23
+ Creating and querying tables with SQL in Google BigQuery
6 lectures 34:33
Ingesting a CSV dataset into BigQuery and creating a table
06:20
Writing your first query with the SELECT, FROM and LIMIT clauses
06:09
Aggregating data with SUM, COUNT, GROUP BY and creating aliases with AS
06:14
Filtering values with WHERE and sorting data with ORDER BY
06:27
Understanding subqueries by using the WITH clause
06:01
Exporting your queries and results into a BigQuery table
03:22

Now it is time to test what you have learned in this section with a little recap quiz! :)

Knowledge Check
3 questions
+ Exploring semi-structured data with ARRAY_AGG, UNNEST and STRUCT
4 lectures 28:03
Grouping values together with STRUCT to define array hierarchy
06:58
Creating an array in an existing flattened table with ARRAY_AGG
08:17
Filtering and unnesting arrays with UNNEST
07:58

Now it is time to test what you have learned in this section with a little recap quiz! :)

Knowledge Check
3 questions
+ Combing multiple tables with different JOIN statements
4 lectures 23:15
Joining tables with a one-to-one relationship (INNER and LEFT JOINs)
09:55
Calculating percentage difference within a JOIN
03:17
Introducing multiple JOIN keys in many-to-many table relationships
07:15

Now it is time to test what you have learned in this section with a little recap quiz! :)

Knowledge Check
3 questions
+ Project 1: Exploring eCommerce and CRM user-level data in Google Analytics 360
6 lectures 47:35
Setting up a public Google Analytics 360 dataset in BigQuery
04:36
Understanding website traffic sources and volume (Users, Sessions and Pageviews)
08:26
Part 1: Analyzing best-selling products and categories with WHERE and UNNEST
06:53
Part 2: Analyzing best-selling products and categories with WHERE and UNNEST
08:18
Identifying high-value customers to find CRM matches and activate insights
13:47
Practical Activity
3 questions
+ Project 2: Visualizing BigQuery tables and queries in Google Data Studio
4 lectures 30:38
Connecting your BigQuery table to Data Studio
10:27
Visualizing your table by using different chart types
08:25
Writing Custom SQL queries directly in Data Studio
08:42
Using the Google Data Studio Explorer for generating insights faster
03:04
Practical Activity
2 questions