📊 Agency Overview
All active client accounts · Billing & package status
—
Active Clients
of — total
—
Monthly Revenue
₹ MRR
—
Due This Week
billing renewals
—
Packages Set
clients configured
—
Config Sheet
not connected
Active Clients
— active
— total
| # | Client | Package | Retainer | Billing Day | Next Due | Status | View | Remove |
|---|
—
Keywords Page 1
—
—
Links This Month
—
—
Keywords Tracked
Total keywords
—
Avg. Position
Latest rankings
—
Improving KWs
vs previous
—
Declining KWs
vs previous
🎯 Top Keywords This Month
Loading...
| # | Keyword | Position | Prev | Change | Landing Page |
|---|
🔗 Link Building This Month
Loading...
🎯 Keyword Rankings
Live from Google Sheets · Full history tracked
—
Page 1
—
Page 2
—
Improving ▲
—
Declining ▼
—
Stagnant →
—
Not Ranking
🎯 Focus This Week
AI-scored keyword action plan
All
📗 Page 1
📘 Page 2
▲ Improving
▼ Declining
→ Stagnant
✕ Not Ranking
All Keywords — Full Table
scroll ↕
0 keywords
| # | Keyword | Current | Previous | Change | Best Ever | History (oldest→latest) | Page | Status |
|---|
▼ Declining Keywords
0
| Keyword | Now | Was | Drop |
|---|
→ Stagnant / No Change
0
| Keyword | Position | Periods Same | Page |
|---|
⚠️ Keyword Cannibalization
—
📅 This Week
Rolling 7 days
—
Links Built
this week
—
Keywords ▲
improved rank
—
Keywords ▼
dropped rank
—
Active Days
with work logged
🔗 Links by Type This Week
📈 Keyword Movers
from sheet✅ Work Done This Week
—
| Date | Type | Website / Platform | Keyword / Title | URL | Status |
|---|
📨 Reports Log
Sent reports history · Gmail · Upcoming due dates
— sent
📤 Sent Reports History
from Gmail · last synced today
| Date | Client | Type | Subject | Sent By | To |
|---|
📊 Report Tracker — Last 3 Months
📊 Report Stats
🔗 Link Building Summary
—
Links by Type
Breakdown vs Targets
Activity Breakdown
| Activity Type | Completed | Monthly Target | Progress | Status |
|---|
✅ Work Done
All activities this month
All
Bookmarking
Blog
Article
Profile
Listing
Classified
| Date | Type | Website / Platform | Keyword / Title | URL | Status |
|---|
💼 Account & Billing
Client package details · Enter details here or sync via Config Sheet (Settings)
📋 Package Details
Client Name—
Website
Industry
SEO Package
Monthly Retainer (₹)
Contract Start
Billing DayWork period tracked from this day each month
Billing Frequency
Mangools Tracker IDFor live ranking sync
Status
📦 Plan Inclusions
Select a package to see inclusions.
🔍 Google Search Console
Select a client to view GSC data
—
no data
⚙️ Settings
Connect a Config Sheet so billing data syncs across all your devices automatically
🔗 Config Sheet (Billing Sync)
Config Google Sheet ID
Create a Google Sheet with columns: Client Name | Package | Retainer | Billing Day | Start Date | Website | Industry | Status
Share it as "Anyone with the link can view", then paste the Sheet ID below.
Status values:
Share it as "Anyone with the link can view", then paste the Sheet ID below.
Status values:
Active · Paused · Stopped — set to Stopped to hide a client on all devices.
Expected sheet format (Row 1 = headers):
Client Name | Package | Retainer | Billing Day | Start Date | Website | Industry | Status
Akshar Gamma | 🏆 NEXT LEVEL | 25999 | 10 | 01 Nov 2025 | https://... | Education | Active
Client Name | Package | Retainer | Billing Day | Start Date | Website | Industry | Status
Akshar Gamma | 🏆 NEXT LEVEL | 25999 | 10 | 01 Nov 2025 | https://... | Education | Active
🔑 Google APIs — OAuth Client ID
OAuth 2.0 Client ID
Used to connect Google Search Console (and future Google Ads integration) directly via API — no CSV exports needed.
Setup (5 minutes):
1. Go to console.cloud.google.com → select your existing project (or create one)
2. APIs & Services → Enable APIs → Enable: "Search Console API" + Gmail API (needed for auto report sync)
3. APIs & Services → Credentials → your existing OAuth 2.0 Client ID → Edit
4. Under "Authorised JavaScript origins" → Add your dashboard URL (e.g.
5. Copy the Client ID below and save
Setup (5 minutes):
1. Go to console.cloud.google.com → select your existing project (or create one)
2. APIs & Services → Enable APIs → Enable: "Search Console API" + Gmail API (needed for auto report sync)
3. APIs & Services → Credentials → your existing OAuth 2.0 Client ID → Edit
4. Under "Authorised JavaScript origins" → Add your dashboard URL (e.g.
https://dashboard.deepbhardwaj.com)5. Copy the Client ID below and save
🔑 Mangools API Key (Auto-Rankings)
Mangools API Key
Enter your Mangools API key once — rankings will auto-load for every client that has a Mangools Tracker ID set in the Config Sheet (column I).
No manual CSV export needed. Rankings refresh automatically each time you open a client.
Get your API key from mangools.com → Account → API.
No manual CSV export needed. Rankings refresh automatically each time you open a client.
Get your API key from mangools.com → Account → API.
🔗 Apps Script Proxy URL (Required for Sync Now)
Proxy URL
Mangools API blocks direct browser requests (CORS). You need a one-time Google Apps Script proxy to fix this.
Steps: Open your SEO Rankings Apps Script → add the
Steps: Open your SEO Rankings Apps Script → add the
doGet function → Deploy as Web App → paste the URL here.
📊 Import Rankings from CSV (Manual Fallback)
Import from CSV Export
Only needed if you don't have an API key. In SerpWatcher: open tracker → Export → CSV. Paste below.
Rankings are saved per-client in your browser and used everywhere — Keywords tab, Overview, and This Week.
Rankings are saved per-client in your browser and used everywhere — Keywords tab, Overview, and This Week.
ℹ️ How to Deploy Online (Netlify)
Step 1: Save this file to your computer as
Step 2: Go to netlify.com → Sign up free
Step 3: Drag & drop the HTML file onto the Netlify dashboard
Step 4: Netlify gives you a live URL instantly — accessible from phone, tablet, anywhere
Step 5: Whenever you update the file, re-drag it to Netlify to redeploy in seconds
SEO_Dashboard.htmlStep 2: Go to netlify.com → Sign up free
Step 3: Drag & drop the HTML file onto the Netlify dashboard
Step 4: Netlify gives you a live URL instantly — accessible from phone, tablet, anywhere
Step 5: Whenever you update the file, re-drag it to Netlify to redeploy in seconds
📱 How to Access on Mobile
After deploying to Netlify, your dashboard URL works on any browser.
On iPhone/Android: open the URL → tap "Add to Home Screen" → it opens like an app with no browser chrome.
On iPhone/Android: open the URL → tap "Add to Home Screen" → it opens like an app with no browser chrome.