Home Station β†’ Journey β†’ Dabbo 10 πŸ“ˆ β†’ 10.3

πŸ“ˆ 10.3 β€” Tracking Sheet Template

Dabbo 10 Β· Client Reporting System Β·

Aa Google Sheet template chhe β€” website par teni structure ane steps. Original Drive ma "Make a copy" kari ne darek client mate vaprvanu.

10.3.A Setup β€” 4 steps

  1. Drive ma template kholi "Make a copy" karo β€” darek client mate alag copy.
  2. Dashboard tab ma C1 ma domain ane D2 ma pehlo mahino (e.g. 01-Nov-2026) bharo. Baki badhi dates ane months automatic bane.
  3. Blue text = tame bharvo chho. Gray italic row = automatic, touch na karvo.
  4. Password aa sheet ma KYAREY na lakho. Login details password manager ma rakho.

10.3.B Tabs β€” kayu tab kyare update karvu ane data kyathi lavvo

TabKyare updateData kyathi
GSC DailyDAILY (aaj βˆ’ 2 divas ni date)GSC β†’ Performance β†’ Search results β†’ Date filter ek divas Β· ke Report 2 dashboard
DashboardMONTHLY (mahina ni 1–3 tarikh)GSC totals formula thi; Avg Position GSC ma month select kari; Semrush Domain Overview / Backlink Analytics; Moz; GA4
Monthly GoalMONTHLY (target set) + DAILY (pending auto)Baseline = last month clicks; target % team nakki kare
Keyword ResearchNavo keyword aave tyare + MONTHLY positionSemrush Keyword Magic / Organic Research / Keyword Gap / Position Tracking
GSC Top Queries & PagesMONTHLYGSC β†’ Performance β†’ Queries / Pages (last month)
Competitor AnalysisQUARTERLY (3 mahine)Semrush β†’ Organic Research β†’ Competitors
Page Meta AuditEk var setup + MONTHLY updateShopify/WordPress admin ke Screaming Frog
Blog PublishDar blog publish + MONTHLY 30-day dataGSC β†’ Pages filter (blog URL)
Keyword PositionMONTHLY (ke WEEKLY)Semrush Position Tracking (main) Β· GSC Queries (check)
Technical SEOWEEKLY (GSC Pages report)GSC β†’ Indexing β†’ Pages
Page Audit & FixDar kaam pachhi (DAILY log)Tame je kaam karyu te
BacklinkDar link banavya pachhiTamaru kaam + Semrush Backlink Analytics (verify)
Backlink DBNavi site male tyareMoz DA/PA/Spam checker