Template: 11 Client Reporting System β 01A SEO Tracking Sheet TEMPLATE Β· Client A sheet par thi banel.
Navo client β setup (10 min) 1. Template kholo β File β Make a copy β naam: "[Client] β SEO Tracking Sheet". 2. Dashboard tab: C1 ma domain, D2 ma pehlo mahino (e.g. 01-Nov-2026). Baki dates/months automatic. 3. Monthly Goal: B2 ma baseline (gaya mahina na clicks), C column ma target % (default 10%). 4. Gray italic example rows delete karo. 5. Sheet ni link client folder ane Master Keyword Map sathe save karo.
3 golden rules β’ Blue = tame bharo, Black = formula (haath na lagadvo). β’ Password kyarey sheet ma nahi β password manager ma. β’ Data na hoy to khali rakho, 0 nahi. GSC ma 2 divas no lag hoy chhe.
11.2.A 1. DAILY kaam (5β10 min per client)
Tab
Shu bharvu
Kyathi (exact path)
GSC Daily
Date (aaj β 2) ni row ma: Clicks, Impressions, Avg Position. CTR auto.
GSC β Performance β Search results β Date β Custom β ek j divas. Athva Report 2 dashboard (your-dashboard.vercel.app) ma te divas no data.
GSC Daily β Note
Koi badlav karyo, Google update aavyo, site down β te divas ni row ma lakho.
Google Search Status Dashboard (updates)
Page Audit & Fix
Aaje je page par kaam karyu: URL, shu badlyu, before/after.
Tamaru kaam
Backlink
Aaje banavel links: platform, live URL, target page, anchor, type, DA, status.
Tamaru kaam; DA Moz checker thi
Monthly Goal
Kai bharvanu nathi β "Pending clicks" ane "Roj ketla clicks joiye" auto update thay. Fakt joi lo.
Auto
11.2.B 2. WEEKLY kaam (dar Monday, 15 min)
Tab
Shu bharvu
Kyathi
Technical SEO (left table)
Date + Not indexed + Indexed count
GSC β Indexing β Pages (upar na 2 numbers)
Keyword Position
(Optional weekly) top 10 keywords ni position
Semrush β Position Tracking β Overview
Blog Publish
Navi publish thayeli blog: Indexed? Y/N
GSC β URL Inspection
11.2.C 3. MONTHLY kaam (mahina ni 1β3 tarikh, 45β60 min per client)
3A. Dashboard tab β mahina na column ma
Row
Kyathi levu (step-by-step)
Dhyan
Clicks, Impressions, CTR
Auto (GSC Daily mathi)
GSC Daily ma aakho mahino bharelo hovo joiye. GSC ma month total sathe 1 var match karo.