Google BigQuery for Marketers and Agencies - 2021
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: April, 2021
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
What are the students who took the course saying?
"Very good course! I am glad that I have chosen it. Materials are easy for understanding. I was familiar with SQL before, but never worked with it in BigQuery. Now I know how to do it. Thank you very much!" - Mariia
"This course is brilliant! really! I have been collecting data with Google Analytics for a few years. But this course taught how to take that data to the next step and now I can speak to what can be done with this data, and how it can be combined with other data sources etc. I especially like the way Lachezar explains key concepts that helped me put together the puzzle of GA data to BigQuery and from there to data visulization. Thanks Lachezar." - Muhammad
"Awesome so far. It's very well explained to become a BigQuery Pro." - Venkatesh
"Yes good project data for concept demonstration." - Salil
"Very well paced and structured course, overall a good experience for people who are interested in google cloud databases" - Anand
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
- Preview00:26
- Preview01:13
- Preview02:56
- 03:42Navigating the Google BigQuery interface
- 00:24Using the BigQuery Solutions Manual
- 00:23Downloading the BigQuery course datasets
Instructor
![Lachezar Arabadzhiev](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.5 Instructor Rating
- 800 Reviews
- 3,390 Students
- 4 Courses
Hey there! I’m Lachezar Arabadzhiev and for the past five years I have helped companies harness the power of data in a variety of ways to drive business growth and innovation. I began my career as a digital marketer at Microsoft, but soon transitioned to the audience and analytics world, where I had the opportunity to work with major brands including Air Canada, RBC, Walmart, Kimberly-Clark, Nintendo, Mazda and HSBC.
Throughout all that time, I always loved teaching and developing learning programs for my fellow colleagues and friends. That passion materialised in early 2021 in the form of a brand new company that I was luckily enough to start.
I am currently the Founder and CEO of SkildLabs, where I help companies and individuals build better learning experiences through the power of education. With SkildLabs, I believe we have the ability to empower students globally and create more interactive learning experiences. How? By combining the learning tools already available and a better method for organizing learning experiences.
What about Google Data Studio?
I have been working with the Google Data Studio beta since early 2017 and have built a wide variety of visualisations and automation flows. From performance-based dashboards with joined GMP sources (GA360, CM and DV360) to audience-driven segmented views with log-level data. In addition, I am a Display and Video 360 (DV360) expert having ran the audience strategy, inventory selection and programmatic optimisation experiments for the programmatic media buying at Royal Bank of Canada (RBC).
I am also a Certified GMP expert and an official speaker at the Canadian Google Data & Analytics Summit, 2018.