Jeremy KayeProduct EngineerGet in touch
← Work/YouTube Keyword Search Tool

YouTube Keyword Search Tool.

Automated weekly YouTube keyword tracking with derived growth metrics — built without writing a line of backend code.

Role
Design · Build
Year
2024
Stack
Make.com · Airtable · YouTube Data API
Status
LIVE
AutomationNo-codeYouTube APIData Tooling
jeremys-five-star-site-def3a0.webflow.io/tools/youtube-keyword-search-tool
The problem

There's no good way to track what creators are making around a keyword over time.

YouTube search shows you what's popular right now, not what's been uploaded recently or how specific content is trending over weeks. For brands, music managers, analysts, and creators trying to understand a niche, there was no tool that combined keyword tracking, content filtering, and longitudinal performance data in one place.

[ Hero screenshot — workflow in motion ]
The solution

A self-updating keyword database with growth metrics baked in.

YKST runs every Sunday via Make.com — querying YouTube for new uploads matching specified keywords, filtering out Shorts, non-English content, and irrelevant results, then adding the survivors to an Airtable database. At 7, 14, 30, and 60 days, it re-fetches view and subscriber counts for each video and calculates derived metrics: week-over-week growth, likes-per-view, and breakout indicators.

01

Automated ingestion

Weekly Make.com automation handles search, filtering, and database updates with no manual intervention required.

02

Longitudinal tracking

View, like, and subscriber snapshots at 7, 14, 30, and 60 days turn a single data point into a growth curve.

03

Derived metrics

Week-over-week growth, likes-per-view, and breakout flags calculated automatically — the insights, not just the raw numbers.

[ Detail · before/after ]
[ Detail · close-up ]
[ Wide screenshot ]
Update cadence
Weekly
every Sunday at 6am PST
Tracking windows
4
snapshots at 7, 14, 30, and 60 days
Example database
Active
cover songs keyword set, publicly viewable
◉ Process

How it came together

  1. 01

    Defined the use case

    Identified the core need: track what creators are uploading around specific keywords and how those videos perform over time.

  2. 02

    Built the ingestion pipeline

    Designed a Make.com scenario that queries the YouTube Data API, applies content filters, and writes matching videos to Airtable.

  3. 03

    Added longitudinal snapshots

    Built a second automation to re-fetch performance data at 7, 14, 30, and 60 days and log each snapshot as a separate record.

  4. 04

    Calculated derived metrics

    Set up Airtable formulas to calculate week-over-week growth, likes-per-view ratio, and breakout flags from the raw snapshot data.

◉ Outcome

A live, self-maintaining keyword intelligence database that surfaces breakout content and rising creators weeks before they hit mainstream discovery — available to brands, agencies, and analysts on request.

Visit live site
◉ Next project
CHK · 2026

Checker AutoGen

Fills Google Slides templates with campaign assets in seconds.

CHECKER AUTOGEN

Create a Checker Package in seconds