Data Analysis Recipes

Break out your oven mitts for these piping hot data analysis templates.


The Website Quality Audit

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


Introducing CIFL Recipes for BigQuery

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

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.


Shopify + Google Analytics Buyer Segmentation

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


The Google Analytics Conversion Index

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


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.


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.


Salesforce Pipeline Visualization

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.