BigQuery & SQL for Marketers and Marketing Analysts with GA4 and More...

Zenler Player

Your course is loading. Hang tight.

What is BigQuery Preview
BigQuery Signup and Pricing Preview
Signup for BigQuery
Google Analytics 4+ BigQuery Integration
BigQuery Interface
GA4 Data in Big Query
Reference
Untitled lesson

First SQL statement
Narrowing down result set with WHERE
Using multiple conditions in WHERE with AND and OR
Excluding Columns from the result set
Selecting unique values e.g. list of events
Counting the records e.g. count of events
Dealing with Records or Arrays - Unnest statement
Join
Using alias
Outer Join
Calculating Totals
Sorting the result set
Sub Queries
Rolling Up the Result Set a various levels
Common Table Expressions (CTEs)
Ranking The Values in the Result Set

Dealing with event_timestamp field
Import A CSV File in BigQuery
Saving Queries Part 1
Saving Queries (Views) Part 2

List of BigQuery SQL Functions
Extracting Parts of Date and Time Field

Introduction
Acquisition Report
All traffic drivers for the users - Building block of the attribution model
Last Touch Traffic Source
First Touch Traffic Source
First Touch and Last Touch
All Touchpoint
Ordering Each Customers Touchpoints -Build Attributions
User acquisition: First user default channel grouping
Traffic acquisition: Session default channel group
Engagement: Events: Event name
Conversions: Event name
Pages and screens: Page title and screen class
Purchases

Looker Studio + BigQuery

Introduction
Query last N days of Data
Getting Page Path from page_location field
How many pages views does it take to conversion
Item Categories Viewed By a Visitor

CSV Upload not using first column as header

Best Practices

Message from Anil
Many more lectures to come...