Mastering Google Sheets, Data Studio and BigQuery

Helping you wrangle your data + automate your work, without (hardly ever) leaving the Google stack.

Acolytes of CIFL Say...

CIFL has helped me and my staff at InFlow save countless hours of trial and error learning sheets and automation. This, in turn, lets us do things the "lazy" way which saves even more time!
Mike Belasco, InFlow
It's helped me a ton, but it's been an even bigger resource for my team at Seer. I'm able to help them level up in a quick and often fun way with help from CIFL.
James Corr, Seer Interactive

The Template Vault

Access all free templates produced by CIFL. Enrolling in this course grants you one invitation to our master Trello board, where we store templates related to marketing automation + reporting. It also allows you to contribute to building new templates with us, or suggest a new template idea. 

Build your Agency Data Pipeline

Wrestle your agency's data analysis workflow completely to the ground, by building a BigQuery data pipeline to house + analyze all of your critical data.  Down with chaos! At CIFL, we operate the Agency Data Pipeline service for a number of digital agencies - ranging from SEO to eCommerce, and in size from 5 clients to 50.   This course completely opens the kimono on how we operate that service, and allows you to build + operate your own Agency Data Pipeline. The course includes:  - A detailed walkthrough of how we built our own internal data pipeline at CIFL, pulling data from 8 APIs (Google Analytics, FB Ads, and more). - Roadmapping exercises and instructions for building your own data pipeline, specific to the challenges of your work.  - A one-hour coaching session with David, commissioner of Coding is for Losers, to make sure your data pipeline tracking plan gets put into action. Many thanks to Supermetrics and Stitch for providing demo accounts for use in building the course. With love, David Commissioner, Coding is for Losers

Getting Started with BigQuery

A step-by-step guide to writing SQL + building data pipelines in BigQuery, Google's powerful database platform.  

Data Studio the Lazy Way

Google released their beautiful dashboard-building powerhouse, Data Studio, in Fall 2016.  We've been actively building dashboards with it ever since. Ascending new heights. Stretching the limits of what's possible with Data Studio.  You get the picture.   We've turned this tool inside out, and now are here to share everything we've learned. During the course, you'll master how to build Data Studio reports.   All of these dashboards are based on raw data from Google Sheets, but the same methods could be used for any data source (Google Analytics, Youtube, a database, etc):  Building a Twitter data dashboard (the course project) Connecting Mailchimp to Data Studio (template included) Building an Adwords + FB ads dashboard with Supermetrics (template included) Your team will thank you, when they bask in the beauty and elegance of your next monthly update.

The Google Sheets Query Function

The Query function is the shortcut to mastering Google Sheets. Instead of mixing up a bunch of spreadsheet formulas to get something done, you can get away with writing one Query. If you're working with data in any capacity - even if it's just to produce a monthly report - you'll want to know how to run Queries. This course teaches Querying interactively, by working through a sample analysis of Twitter data in Google Sheets.

Data Analysis the Lazy Way

‘Data analysis’ probably isn’t in your job description - it’s something you do only out of necessity.  You get asked a question about your work, and you’re expected to present the answer. You build reports, export data from tools like Google Analytics, and make charts - not the most fun part of your job. But what if it was?  This course presents a new approach to data analysis - the lazy way. Google Sheets has become a weapon of mass laziness - when combined with tools like Blockspring and Zapier, it allows you to drastically cut your time spent wrangling and analyzing data.  In this course, you’ll learn the three-part process we use at Coding is for Losers to analyze data:  Pulling data into Sheets using apps like Blockspring or Zapier  The 10 key Google Sheets formulas we use to wrangle data  Build beautiful charts and dashboards in Google Data Studio  If you’ve ever used a spreadsheet, you’re closer than you think to becoming a data analysis master. *Warning: This course is _not_ for spreadsheet beginners. 

The Lazy Toolbelt

Chefs carry knives, sculptors carry chisels. Lazy analysts and marketers carry knowledge of the Lazy Toolbelt:  Google Sheets, and Add-ons like Blockspring and Supermetrics. In this course, we follow the creation story of one Sheets template (Search Efficiency by Landing Page), in both Blockspring and Supermetrics.   You’ll learn to drastically cut the time you spend wrangling data and building reporting.   Learn to create spreadsheet automation templates your colleagues, friends, lovers, and parents (probably not grandparents though) will find a breeze to use. Learn to wield the Lazy Toolbelt.