Keyword analysis
Score, filter, and remove keywords — changes save to your sheet automatically
Total keywords
—
from your sheet
Non-branded
—
worth scoring
Avg position
—
non-branded only
Removed
0
marked this session
Filters
Keyword type
Google page
Score range
Status
Connect your Google Sheet to load data
Trends
Position and impressions over time — non-branded keywords
Average position over time
Lower number = better ranking
Total impressions over time
Rising line = more Thai users seeing your site
Score distribution
How your keywords are spread across score brackets
Page distribution
How many keywords rank on each Google page
Token analysis
Individual words ranked by performance — green = use more, red = remove from titles
Top tokens by average score
Words that consistently appear in high-scoring keywords
Token details
Frequency, clicks, and avg score per word
Load keyword data first
Connect your Google Sheet
One-time setup — takes about 10 minutes
Step 1 — Enter your sheet details
Google Sheet ID
Tab name (exact)
Google API Key
The Sheet ID is the long string in your Google Sheets URL between
The API key lets this dashboard read your sheet. See Step 2 below for how to get it free.
Status column: In your Google Sheet Scores tab, add a column header
/d/ and /edit.The API key lets this dashboard read your sheet. See Step 2 below for how to get it free.
Status column: In your Google Sheet Scores tab, add a column header
Status in column I (the first empty column after your 8 existing columns). Leave all rows blank — the dashboard uses this to track which keywords your team has removed.
Step 2 — Get a free Google API key (read-only, safe)
Go to console.cloud.google.com → select your existing project (the one you made for Apps Script)
Search "Google Sheets API" in the top bar → click Enable
Go to APIs & Services → Credentials → Create Credentials → API Key. Copy the key that appears.
Click Restrict Key → under API restrictions → select Google Sheets API only. This keeps the key safe — it can only read sheets, nothing else.
Go to your Google Sheet → click Share → change to "Anyone with the link can view". This lets the API key read it without signing in.
Paste the API key above and click Test connection.
Step 3 — Column mapping
Tell the dashboard which column letter each field is in your Scores sheet. Default assumes: A=Query, B=Clicks, C=Impressions, D=CTR, E=Position, F=Score, G=Type, H=Page
Query col
Clicks col
Impressions col
CTR col
Position col
Score col
Type col
Status col (col I)
Step 4 — Host on your company server
Download this HTML file (it is a single self-contained file — no framework, no build step, no npm)
Copy it to any folder on your company server — it works as a plain static HTML file. No Node.js, no PHP needed.
Open it in a browser. Enter your Sheet ID, tab name, and API key in the Setup page. They save to localStorage so you only do this once per browser.
Share the URL of the file on your server with your team. Everyone sees the same data. When you re-pull GSC data to the sheet weekly, just click Refresh data in the sidebar.