CIFL/The Template Vault

  • Free

The Template Vault

Wrangle your marketing data with access to every Google Sheets template, Data Studio report, and BigQuery recipe we've ever published.

Everything, ever. Really.

Unlimited, and unpaid access to everything we've ever published on CIFL.  Automate your work in Sheets, Data Studio and BigQuery like never before.

Important to Note!!!!
This Template Vault is meant for digital marketers - while anyone can benefit from these templates, most of them are designed for a few key marketing data analysis areas:

  1. Paid Media
  2. SEO
  3. E-commerce
  4. General Agency Mgmt
If that's not your bag, we recommend checking out the more greenfield tutorials on CIFL around BigQuery, Data Studio and the like.

Contents

Getting Acquainted

How to use this Vault, and how to reach us if you need help.
1) Join us on Slack
2) All the links

Agency Life

Anything related to project management or agency-wide reporting.
Agency Project Management (Sheets)

E-commerce + Lead gen

Automating email list + e-com shop reporting.  
Mailchimp Analytics (Data Studio)
Conversion Funnel Analytics (Sheets)
Shopify Price + Product Updater (Sheets)

Paid Acquisition

Anything related to paid media, and automating your way to glory in Sheets, Data Studio and BigQuery.
Facebook + Google Ads Dashboard (Data Studio)

SEO

Automating the nitty gritty SEO workflows, like site audits and reporting.
Forecast Organic Traffic (Data Studio)
Automated SEO Content Audit (Sheets)
Monthly Keyword Tracking (Data Studio)
Meta Tag Rewrite Checker (Sheets)
SERP Anomaly Detection (Sheets)

Advanced Automations

When you're ready to break out of Sheets and into something more powerful, this is a good place to start.
Website Quality Audit (BigQuery)
Shopify + Google Analytics Buyer Segmentation (BigQuery)
Analytics Tracking Plan (BigQuery)
SEO API Starter (Sheets)

Mastering Google Sheets, Data Studio and BigQuery

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