Home Station β†’ Journey β†’ Dabbo 11 πŸ“ˆ β†’ 11.2

πŸ“ˆ 11.2 β€” SEO Tracking Sheet β€” Daily + Monthly bharvani SOP (Report 1)

Dabbo 11 Β· Client Reporting System Β·

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)

TabShu bharvuKyathi (exact path)
GSC DailyDate (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 β†’ NoteKoi badlav karyo, Google update aavyo, site down β€” te divas ni row ma lakho.Google Search Status Dashboard (updates)
Page Audit & FixAaje je page par kaam karyu: URL, shu badlyu, before/after.Tamaru kaam
BacklinkAaje banavel links: platform, live URL, target page, anchor, type, DA, status.Tamaru kaam; DA Moz checker thi
Monthly GoalKai 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)

TabShu bharvuKyathi
Technical SEO (left table)Date + Not indexed + Indexed countGSC β†’ Indexing β†’ Pages (upar na 2 numbers)
Keyword Position(Optional weekly) top 10 keywords ni positionSemrush β†’ Position Tracking β†’ Overview
Blog PublishNavi publish thayeli blog: Indexed? Y/NGSC β†’ 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

RowKyathi levu (step-by-step)Dhyan
Clicks, Impressions, CTRAuto (GSC Daily mathi)GSC Daily ma aakho mahino bharelo hovo joiye. GSC ma month total sathe 1 var match karo.
Avg PositionGSC β†’ Performance β†’ Date: Custom (1 thi mahina na chhella divas) β†’ "Average position" cardDaily positions nu average NA karo β€” GSC no period value j sacho.
Authority ScoreSemrush β†’ Domain Overview β†’ domain β†’ target countryMahine ek j divase (e.g. 1st) lo, jethi compare saro thay.
DA / PA / Spam ScoreMoz Link Explorer (free) β†’ domainFormat: 8 / 22 / 9%
Total Backlinks, Referring DomainsSemrush β†’ Backlink Analytics β†’ OverviewDA PA SOP (06 Off-Page β†’ 07) sathe match.
New / Lost Referring DomainsSemrush β†’ Backlink Analytics β†’ Referring Domains β†’ New / Lost tab β†’ last 30 daysLost vadhe to link reclamation.
Keywords in Top 10Semrush β†’ Organic Research β†’ Positions β†’ filter "Top 10"Target country database j.
Organic Keywords, Organic TrafficSemrush β†’ Organic Research β†’ OverviewTraffic Semrush no estimate chhe β€” GSC clicks sathe compare na karo, trend juo.
Organic Users, Sessions, Engagement rate, Key eventsGA4 β†’ Reports β†’ Acquisition β†’ Traffic acquisition β†’ date = mahino β†’ row "Organic Search"Key events = leads/orders. 0 hoy to tracking check (Report 3 golden rule 3).
Organic RevenueGA4 same report β†’ Total revenue (ke Shopify β†’ Analytics β†’ Sessions by referrer: Search)GA4 ane Shopify match nahi thay β€” source lakho.
Indexed / Not indexedAuto (Technical SEO tab ni mahina ni chhelli entry)Weekly entry bharvi jaruri.

3B. Biji tabs

TabMonthly shu karvuKyathi
Monthly GoalNavo mahino: baseline auto aave; target % confirm karoTeam decision
GSC Top Queries & PagesTop 10 branded + top 10 non-branded queries, top 10 pagesGSC β†’ Performance β†’ last month β†’ Queries / Pages β†’ Export
Keyword PositionMahina na column ma dar keyword ni position. Latest + Change auto.Semrush β†’ Position Tracking β†’ Rankings (mahina na end ni date)
Keyword ResearchNavi keywords add; Current Position update; Status (Planned β†’ Live β†’ Tracking)Semrush Keyword Magic / Keyword Gap / Organic Research (legend tab ma)
Blog PublishDar blog: Position, Clicks, Impressions (last 30 days)GSC β†’ Performance β†’ Page filter = blog URL
Technical SEO (right table)Not indexed reasons + pages count + actionGSC β†’ Indexing β†’ Pages β†’ "Why pages aren't indexed"
Page Meta AuditNavi pages add, filled Yes/No update; summary autoShopify/WordPress admin ke Screaming Frog export
Competitor AnalysisQUARTERLY: top competitors refreshSemrush β†’ Organic Research β†’ Competitors β†’ Export

11.2.D 4. Semrush thi data β€” quick map

JarurSemrush toolSheet ma kya
Domain strengthDomain Overview β†’ Authority ScoreDashboard
BacklinksBacklink Analytics (Overview, Referring Domains, New/Lost)Dashboard + Backlink
RankingsOrganic Research β†’ PositionsDashboard + Keyword Research
Monthly positionsPosition TrackingKeyword Position
CompetitorsOrganic Research β†’ CompetitorsCompetitor Analysis
Missing keywordsKeyword GapKeyword Research (Source = Keyword Gap)
Navi keywordsKeyword Magic ToolKeyword Research
Site issuesSite AuditTechnical SEO note + Page Audit & Fix

11.2.E 5. GSC thi data β€” quick map

JarurGSC jagyaSheet ma kya
Daily clicks/impr/positionPerformance β†’ Search results (date filter)GSC Daily
Month avg positionPerformance β†’ custom monthDashboard
Top queries/pagesPerformance β†’ Queries / PagesGSC Top Queries & Pages
Index statusIndexing β†’ PagesTechnical SEO
Blog performancePerformance β†’ Pages filterBlog Publish
Navo page index?URL InspectionBlog Publish (Indexed?)

11.2.F 6. Common mistakes

  • Daily CTR nu average lai ne monthly CTR lakhvu β€” khotu. CTR = mahina na clicks Γ· impressions (sheet auto kare chhe).
  • Daily position nu average β€” khotu. GSC no month value lo.
  • Data na hoy tyare 0 lakhvu β€” graphs ane totals bagde. Khali rakho.
  • Semrush ane GSC traffic compare karvu β€” Semrush estimate chhe.
  • Semrush ma khoto country database β€” client na market no j lo.
  • Passwords sheet ma β€” security risk. Sheet share thay chhe.

11.2.G 7. Checklist

  • Daily: GSC Daily row (aaj βˆ’ 2) bharyo
  • Daily: Page Audit & Fix + Backlink log update
  • Weekly: Technical SEO index count
  • Monthly: Dashboard column (Semrush + Moz + GA4) bharyo
  • Monthly: Keyword Position + Top Queries + Blog Publish update
  • Monthly: Goal achievement joyo, next month target set
  • Monthly report (11.7) ane Report 2/3 sathe numbers match

Related stops: 11.1 Start Here, 11.4 Report 2 Handbook, 11.5 Live Report SOP; 11.7 Monthly Client Report; 2.6 Keyword Research Guide (Master Keyword Map).