Track your goals with Cloud Function, BigQuery, and Looker Studio
Examples of solutions to track your KPIs, goals, key results, and other metrics with Google Sheets, Looker Studio, and others.
This article is part of a series: Practical solutions to track your goals.
The idea is to build a simple solution within less than a day, which is easy to maintain but doesn't necessarily scale well. If, as an engineering leader, you don't have progress-tracking solutions already in your toolset, this project should be enough to start working with many, if not the majority, of goals that require some tracking.
- (Subscribers only) Track your goals with Google Sheets and Looker Studio
- (Subscribers only) Track your goals with Google Colaboratory, Sheets, and Looker Studio
- (Free) If you are looking only for inspiration, take a look at the blog post: Simple data tracking solutions for engineering leaders
If Looker Studio boards and static data loaded from spreadsheets or CSV files are not enough for you, here I'll show how to build the simplest cloud function, which takes data points via API and stores them into Google Big Query.
The Looker Studio board described in this series of articles can be found here.
Here is the high-level architecture of such a solution:
In this article, I'm also presenting how solutions like ChatGPT or Github Copilot can help you create such a project.