Categories: Analytics

Creating a marketing data pipeline with Google Sheets, Supermetrics, CIFL and BigQuery

With zero coding, a small investment, and a little bit of time, you can create your own BigQuery data warehouse of marketing data. In the video below, I walk through how to set this up using these tools:

  • Google Sheets – if you haven’t switched to Sheets from Excel yet, you are either a VBA dinosaur, or you are not taking advantage of the astounding capabilities of spreadsheet automation.
  • Supermetrics for Google Sheets – I don’t mention this in the video, but Supermetrics also has a connector for BigQuery. We manage a lot of clients and pull data from a lot of sources. For our purposes, the solution I describe here is WAY more affordable, but if you manage a small number of accounts (one, for example) and a few sources of data, you may want to check that out.
  • The CIFL Connector for BigQuery – seriously, give these guys some love. This is the best free thing since the summer of ’67.
  • Google BigQuery – infinitely scalable, pennies or dollars per month for the needs of a typical small agency or marketing team. Also makes a great back end for Google Data Studio dashboards.

The main benefits of this approach for us are:

  • A blazing-fast, easy-to-scale back end for Google Data Studio reports
  • A historical record of client data

I LOVE collaborating on this type of thing, so please comment below if you have questions or ideas, and let me know if you’d like help getting your own warehouse set up!

Nico Brooks

Nico loves marketing analytics, running, and analytics about running. He's Two Octobers' Head of Analytics, and loves teaching. Learn more about Nico or read more blogs he has written.

Recent Posts

Digital Marketing Updates: April 2025

New this month: take a look at BlueSky, hide ads on Reddit, more control in…

2 days ago

Anaytics Roundup – Updates from March 2025

Product updates in Google's analytics world, thoughts on AI and workflow, great articles about attribution…

3 days ago

BigQuery GA4 transfer service first impressions

GA4's new BigQuery Transfer Service populates reportable data, but the data is fairly shallow. Get…

3 days ago