Data Analysis Recipes

Break out your oven mitts for these piping hot data analysis templates built in Google Sheets, BigQuery and Data Studio.

BigQuery

The Website Quality Audit

Run automated Website Quality Audits in BigQuery across your sites each month, to keep your SEO workflow humming.

BigQuery

Introducing CIFL Recipes for BigQuery

Let CIFL run data analysis workflows in BigQuery on your team's behalf.

Data Studio

Automated FB and IG Data Studio Dashboard

Roll up your organic Facebook + Instagram data into one sexy Google Data Studio dashboard.

Data Studio

Forecast your Site’s Organic Traffic

Google Sheets + Data Studio templates to translate your keyword rankings into a 1-year organic traffic forecast.

BigQuery

Shopify + Google Analytics Buyer Segmentation

A BigQuery template to find your Shopify store's best customers and the marketing channels that brought them.

BigQuery

The Google Analytics Conversion Index

A BigQuery data pipeline template to surface your top converting Google Analytics channels and landing pages.

Sheets

How to Find Quick Win Keywords

A Google Sheets template for using Search Console data to find keywords ripe for moving up to the 1st page in search results.

Sheets

The SEO Content Audit Template

In this Sheets report template for SEO, we weave together data from 6 sources into one table: Google Analytics, Search Console, ScreamingFrog, Ahrefs, Majestic, and Moz.

Sheets

Salesforce Pipeline Visualization

Inspired by startup investor Christoph Janz, this template allows you to visualize transition rates of your Salesforce pipeline in Google Sheets.

Ready to automate your business?

Let's automate your marketing + ops processes in Sheets, Data Studio and BigQuery.

FIND OUT MORE