Tutorials · Coding is for Losers

Mastering the Lazy Way

Learn the Google Cloud stack: BigQuery, Data Studio, Sheets, Supermetrics and more.

Filtered By

traffic projection tool

data-viz

How to Forecast your Site’s Organic Traffic

Pulls organic traffic + competitor KW data to project organic traffic from an SEO campaign.

wtf is dbt

bigquery

WTF is dbt?

The best way to run, test and document your SQL models

customer retention modeling

bigquery

Modeling Customer Retention in BigQuery SQL

A flexible pattern for calculating SaaS or Ecommerce retention / rebuy rates over any time period.

advanced shopify reports

bigquery

5 Advanced Shopify Reports in BigQuery

How we analyze retention, cohorts and buyer segments in BigQuery.

WHAT IS DATA BLENDING DATA STUDIO

data-viz

How to Blend Data in Google Data Studio

A tutorial on how to combine data from multiple sources in Data Studio.

data-viz

11 Best Data Visualization Tools [2020]

All of the best tools for data visualization, ranked and reviewed based on our experience.

google bigquery data recipes

bigquery

WTF is a “Recipe”?

Our pre formatted reporting templates for delicious data analyses.

what is a data pipeline

bigquery

WTF is a Data Pipeline?

Breaking down the who, what and why of Data Pipelines.

how to find your best marketing channel

bigquery

How to Find Your Best Marketing Channel

A powerful Data Studio dashboard to help double down on what's working.

the website quality audit

bigquery

Introducing…The Website Quality Audit

By far and away, the best thing we've built to date.

bigquery SQL

bigquery

The Lazy Guide to Learning BigQuery SQL

Learn how to upgrade your Sheets using BigQuery SQL - a complete tutorial.

all the latest google data studio updates

data-viz

All the Latest Google Data Studio Hacks

Tracking Data Studio feature updates in real time, brought to you by the CIFL community.

python-and-seo

bigquery

Is Python Really Necessary for SEO?

On avoiding rabbit holes + shiny object syndrome when climbing the technical ladder.

using SQL for SEO

bigquery

How to Leverage SQL for SEO Automation

How SEO expert Cody West (and CIFL Student) Cody West automated his agency using SQL.

salesforce visualization template

data-viz

Salesforce Pipeline Visualization

This template allows you to visualize transition rates of your Salesforce pipeline in Google Sheets.

stitch vs supermetrics

bigquery

Stitch vs Supermetrics for BigQuery

Reviewing the best ETL tools on the market for building marketing data pipelines in BigQuery.

bigquery and google sheets

bigquery

Connecting Sheets and BigQuery

A bridge connecting Sheets to a BigQuery. Automates creation of BQ views, tables, and uploading of data.

google data studio tutorial

data-viz

Getting Started with Google Data Studio

Everything you need to know to use Google Data Studio as your reporting solution.