Cacheworthy

I'm back! Welcome to Cacheworthy

Business of Data AMA (Nov 20, 2020)

How our BigQuery Data Pipeline Process has Evolved

Customer Retention Modeling in BigQuery SQL (SaaS + Ecommerce)

5 Advanced Ecommerce Reports (Shopify + BigQuery)

Shopify Cohort Analysis in BigQuery

Campaign Type Mapping in Sheets + BigQuery

Why Use BigQuery for Google + FB Ads Data?

Shopify Buyer Segmentation [Backyard Analytics]

CRO "Leak Finder" Template in Google Data Studio

BigQuery Pricing: How Much Does it Cost?

Graduating from Sheets to BigQuery

BigQuery Data Pipeline for Digital Agencies

Meta Tag Rewrite Checker (Search Console + ScreamingFrog)

BigQuery Partitioning and Clustering, Explained

Working with JSON data in BigQuery

How Google Cloud Functions et al fit with BigQuery

Data Pipeline Stories (Scott Zakrajsek of Sproutward)

Data Pipeline Stories (Ahmad Kanani of Siavak)

How to Productize Your Agency's Services

How We Automated an SEO Agency - 155% Increase in REVENUE

Data Studio News: Filter on click, drilldowns, advanced date ranges, and more

Why SQL is Vital For Marketers (You Already Know It...)

Master the VLOOKUP Function

Why Learn the Query Function

Working with Freelancers in Google Sheets

BigQuery Recipes: Website Quality Audit

Filtering BigQuery data with WHERE

Deduping query results in BigQuery

Using math + CASE statements in BigQuery

Intro to Data Build Tool (DBT)

Using analytic (window) functions in BigQuery

Joining tables in BigQuery SQL

Writing your first BigQuery query

Aggregate by day, week and month in BigQuery

Unnesting RECORD arrays in BigQuery SQL

WITH statements in BigQuery SQL

Using GROUP BY in BigQuery to aggregate metrics

Getting Started with BigQuery

Reviewing Stitch vs Supermetrics for BigQuery

CIFL BigQuery Connector Add-on for Google Sheets

The Traffic Projection Tool (Google Sheets)

Matching Column Headers in a Sheets Query

What Happens When You Uninstall Google Analytics?

Running SQL Models on a Schedule with Sinter

Connect your DBT SQL models to BigQuery

Pushing Google Analytics data to BigQuery with Stitch

Pulling Data from APIs into Google Sheets

The Analytics Tracking Plan for Digital Agencies

Scheduling BigQuery Uploads with Google Apps Script Triggers