π 11.3 β 01A Tracking Sheet TEMPLATE
Dabbo 11 Β· 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.
11.3.A Setup β 4 steps
- Drive ma template kholi "Make a copy" karo β darek client mate alag copy.
- Dashboard tab ma C1 ma domain ane D2 ma pehlo mahino (e.g. 01-Nov-2026) bharo. Baki badhi dates ane months automatic bane.
- Blue text = tame bharvo chho. Gray italic row = automatic, touch na karvo.
- Password aa sheet ma KYAREY na lakho. Login details password manager ma rakho.
11.3.B Tabs β kayu tab kyare update karvu ane data kyathi lavvo
| Tab | Kyare update | Data kyathi |
|---|---|---|
| GSC Daily | DAILY (aaj β 2 divas ni date) | GSC β Performance β Search results β Date filter ek divas Β· ke Report 2 dashboard |
| Dashboard | MONTHLY (mahina ni 1β3 tarikh) | GSC totals formula thi; Avg Position GSC ma month select kari; Semrush Domain Overview / Backlink Analytics; Moz; GA4 |
| Monthly Goal | MONTHLY (target set) + DAILY (pending auto) | Baseline = last month clicks; target % team nakki kare |
| Keyword Research | Navo keyword aave tyare + MONTHLY position | Semrush Keyword Magic / Organic Research / Keyword Gap / Position Tracking |
| GSC Top Queries & Pages | MONTHLY | GSC β Performance β Queries / Pages (last month) |
| Competitor Analysis | QUARTERLY (3 mahine) | Semrush β Organic Research β Competitors |
| Page Meta Audit | Ek var setup + MONTHLY update | Shopify/WordPress admin ke Screaming Frog |
| Blog Publish | Dar blog publish + MONTHLY 30-day data | GSC β Pages filter (blog URL) |
| Keyword Position | MONTHLY (ke WEEKLY) | Semrush Position Tracking (main) Β· GSC Queries (check) |
| Technical SEO | WEEKLY (GSC Pages report) | GSC β Indexing β Pages |
| Page Audit & Fix | Dar kaam pachhi (DAILY log) | Tame je kaam karyu te |
| Backlink | Dar link banavya pachhi | Tamaru kaam + Semrush Backlink Analytics (verify) |
| Backlink DB | Navi site male tyare | Moz DA/PA/Spam checker |