Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-01-18 00:15:47
30-Day Money-Back Guarantee

This course includes:

  • 3 hours on-demand video
  • 2 articles
  • 6 downloadable resources
  • 2 practice tests
  • 2 coding exercises
  • Full lifetime access
  • Access on mobile and TV
Business Business Analytics & Intelligence Google BigQuery

Google BigQuery for Marketers and Agencies

Learn how to use SQL-powered queries in Google BigQuery to analyze marketing data and find meaningful insights.
Bestseller
Rating: 4.6 out of 54.6 (159 ratings)
746 students
Created by Lachezar Arabadzhiev
Last updated 12/2020
English
English [Auto]
30-Day Money-Back Guarantee

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
Curated for the Udemy for Business collection

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: December, 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

7 sections • 31 lectures • 2h 54m total length

  • Preview00:26
  • Preview01:13
  • Preview02:56
  • Navigating the Google BigQuery interface
    03:42
  • Using the BigQuery Solutions Manual
    00:24
  • Downloading the BigQuery course datasets
    00:23

  • 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
  • Knowledge Check
    3 questions
  • Write a SUM Query
    1 question

  • Preview04:50
  • 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
  • Knowledge Check
    3 questions

  • Preview02:48
  • 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
  • Knowledge Check
    3 questions
  • Create an INNER JOIN
    1 question

  • Setting up a public Google Analytics 360 dataset in BigQuery
    04:36
  • Understanding website traffic sources and volume (Users, Sessions and Pageviews)
    08:26
  • Preview05:35
  • 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

  • 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

  • Preview00:52

Instructor

Lachezar Arabadzhiev
Performance Analytics and Visualization Professional
Lachezar Arabadzhiev
  • 4.5 Instructor Rating
  • 460 Reviews
  • 2,049 Students
  • 2 Courses

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.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.