Watch Queue
Queue
Watch QueueQueue
The next video is starting
Loading...
-
-
-
-
Sign in to like videos, comment, and subscribe.
Watch Queue
Queue
__count__/__total__
-
-
BigQuery SQL for Marketers
-
Getting Started with BigQuery - Duration: 5 minutes, 23 seconds.
-
Writing your first BigQuery query - Duration: 5 minutes, 44 seconds.
-
Filtering BigQuery data with WHERE - Duration: 4 minutes, 49 seconds.
-
Using math + CASE statements in BigQuery - Duration: 5 minutes, 19 seconds.
-
Using GROUP BY in BigQuery to aggregate metrics - Duration: 4 minutes, 35 seconds.
-
Aggregate by day, week and month in BigQuery - Duration: 9 minutes, 15 seconds.
-
Unnesting RECORD arrays in BigQuery SQL - Duration: 6 minutes, 7 seconds.
-
Joining tables in BigQuery SQL - Duration: 10 minutes.
-
WITH statements in BigQuery SQL - Duration: 6 minutes, 6 seconds.
-
Using analytic (window) functions in BigQuery - Duration: 7 minutes, 35 seconds.
-
Deduping query results in BigQuery - Duration: 5 minutes, 17 seconds.
-
Intro to Data Build Tool (DBT) - Duration: 3 minutes, 11 seconds.
This item has been hidden -
-
Tools for Digital Agencies (Google Sheets + BigQuery)
Walkthroughs of CIFL tools built specifically for digital agencies - using Google Sheets, Data Studio and BigQuery to automate your strategy, campaign and reporting workflows.-
Pulling Data from APIs into Google Sheets - Duration: 8 minutes, 52 seconds.
-
Google Sheets Project Management Template - Duration: 5 minutes, 22 seconds.
-
Connect BigQuery to Google Sheets (Push + Query) - Duration: 13 minutes.
-
Data Studio Dashboard: Facebook Ads + Adwords (via Supermetrics) - Duration: 11 minutes.
-
Scheduling BigQuery Uploads with Google Apps Script Triggers - Duration: 4 minutes, 11 seconds.
-
CIFL BigQuery Connector Add-on for Google Sheets - Duration: 9 minutes, 7 seconds.
-
Pushing Google Analytics data to BigQuery with Stitch - Duration: 6 minutes, 21 seconds.
-
The Traffic Projection Tool (Google Sheets) - Duration: 11 minutes.
-
Competitor Keyword Research with Google Sheets and SEMrush - Duration: 5 minutes, 10 seconds.
-
Connect your DBT SQL models to BigQuery - Duration: 7 minutes, 19 seconds.
-
WTF is the Agency Data Pipeline? - Duration: 4 minutes, 54 seconds.
-
The Analytics Tracking Plan for Digital Agencies - Duration: 11 minutes.
This item has been hidden -
-
Google Sheets Workouts
-
Working with Freelancers in Google Sheets - Duration: 3 minutes, 33 seconds.
-
Master the VLOOKUP Function - Duration: 3 minutes, 23 seconds.
-
Why Learn the Query Function - Duration: 3 minutes, 29 seconds.
-
Why SQL is Vital For Marketers (You Already Know It...) - Duration: 6 minutes, 35 seconds.
-
Data Studio News: Filter on click, drilldowns, advanced date ranges, and more - Duration: 4 minutes, 24 seconds.
This item has been hidden -
-
Getting Started with Google Data Studio
-
Why I switched to Google Data Studio - Duration: 3 minutes, 53 seconds.
-
How to connect a data source to Google Data Studio - Duration: 2 minutes, 37 seconds.
-
How to build a simple table in Google Data Studio - Duration: 2 minutes, 25 seconds.
-
How to create time series charts in Google Data Studio - Duration: 3 minutes, 59 seconds.
-
How to style charts using themes in Google Data Studio - Duration: 57 seconds.
-
What's Report-level vs Page-level in Data Studio? - Duration: 4 minutes, 35 seconds.
-
Building Calculated Fields in Data Studio - Duration: 6 minutes, 4 seconds.
-
Adding Date and Control Filters in Data Studio - Duration: 5 minutes, 57 seconds.
-
WTF are Dimensions and Metrics in Data Studio? - Duration: 5 minutes, 2 seconds.
-
Prepping your Google Sheet for Life as a Data Studio Source - Duration: 4 minutes, 35 seconds.
This item has been hidden -
-
Advanced Google Sheets Formulas
-
The Google Sheets Query: Forget your other Functions - Duration: 5 minutes, 27 seconds.
-
Date comparisons in Google Sheets queries: why so complex? - Duration: 3 minutes, 47 seconds.
-
Query multiple Google Sheets: importrange + {} = friends - Duration: 5 minutes, 57 seconds.
-
Google Sheets QUERY vs SQL: what’s the difference? - Duration: 7 minutes, 23 seconds.
-
How to get creative with VLOOKUP in Google Sheets - Duration: 116 seconds.
-
Dropdown menus in Google Sheets reports - Duration: 5 minutes, 48 seconds.
-
Nesting + joining queries in Google Sheets - Duration: 4 minutes, 53 seconds.
-
Debugging Sheets query errors - #REF, #VALUE and #N/A - Duration: 8 minutes, 42 seconds.
-
Make pivot tables with the Google Sheets query - Duration: 3 minutes, 1 second.
-
Matching Column Headers in a Sheets Query - Duration: 6 minutes, 55 seconds.
This item has been hidden -
-
Google Sheets Automation Templates
-
Social Listening with Google Sheets, Twitter and Reddit APIs - Duration: 6 minutes, 9 seconds.
-
Google Sheets Editorial Calendar Template (using Zapier) - Duration: 7 minutes.
-
Content Audit with Google Sheets, Analytics and Ahrefs - Duration: 6 minutes, 57 seconds.
-
Conversion Funnel Analytics w Supermetrics and Zapier - Duration: 7 minutes, 29 seconds.
-
Automate your Startup w Google Sheets (CIFL + OKDork) - Duration: 14 minutes.
-
Google Sheets formula hacks for Marketers - Duration: 9 minutes, 27 seconds.
-
Data Studio Dashboard: Facebook Ads + Adwords (via Supermetrics) - Duration: 11 minutes.
-
Google Search Console Keyword Cannibalization Checker - Duration: 7 minutes, 32 seconds.
-
Search Performance Anomaly Detection in Sheets (w Google Search Console) - Duration: 7 minutes, 57 seconds.
-
SEMrush Domain Keyword Tracking in Google Sheets - Duration: 6 minutes, 19 seconds.
-
Measuring Search Efficiency by Page in Sheets (w Google Analytics + Search Console) - Duration: 7 minutes, 33 seconds.
-
Competitor Keyword Research with Google Sheets and SEMrush - Duration: 5 minutes, 10 seconds.
This item has been hidden -