---
title: Search Console
description: Toob Google Search Console'i andmed ja analüüsib otsingutulemuslikkust.
category: Marketing
sublabel: SEO
author: OpenClaudia
tags: 
license: MIT
source: https://github.com/OpenClaudia/openclaudia-skills
---

# Google Search Console

Tõmba Google Search Console'i API-st otsingutulemuslikkuse andmed, indekseerimise katvus ja Core Web Vitals.

## Eeldused

Nõuab Google OAuth-i mandaate:
- `GOOGLE_CLIENT_ID`
- `GOOGLE_CLIENT_SECRET`
- Kehtiv OAuth-juurdepääsutoken `https://www.googleapis.com/auth/webmasters.readonly` õigusulatusega

Sea mandaadid failis `.env`, `.env.local` või `~/.claude/.env.global`.

### Juurdepääsutokeni hankimine

```bash
# Step 1: Authorization URL (user visits in browser)
echo "https://accounts.google.com/o/oauth2/v2/auth?client_id=${GOOGLE_CLIENT_ID}&redirect_uri=urn:ietf:wg:oauth:2.0:oob&scope=https://www.googleapis.com/auth/webmasters.readonly&response_type=code&access_type=offline"

# Step 2: Exchange code for tokens
curl -s -X POST "https://oauth2.googleapis.com/token" \
  -d "code={AUTH_CODE}" \
  -d "client_id=${GOOGLE_CLIENT_ID}" \
  -d "client_secret=${GOOGLE_CLIENT_SECRET}" \
  -d "redirect_uri=urn:ietf:wg:oauth:2.0:oob" \
  -d "grant_type=authorization_code"

# Step 3: Refresh expired token
curl -s -X POST "https://oauth2.googleapis.com/token" \
  -d "refresh_token={REFRESH_TOKEN}" \
  -d "client_id=${GOOGLE_CLIENT_ID}" \
  -d "client_secret=${GOOGLE_CLIENT_SECRET}" \
  -d "grant_type=refresh_token"
```

### Saadaolevate saitide loetlemine

```bash
curl -s -H "Authorization: Bearer ${GSC_ACCESS_TOKEN}" \
  "https://www.googleapis.com/webmasters/v3/sites" \
  | python3 -c "
import json, sys
data = json.load(sys.stdin)
for site in data.get('siteEntry', []):
    print(f\"{site['siteUrl']}  |  Permission: {site['permissionLevel']}\")
"
```

Saidi URL-i vorming on kas `https://example.com/` (URL-i prefiks) või `sc-domain:example.com` (domeeni atribuut).

---

## 1. Otsingutulemuslikkuse aruanne

Põhiaruanne: päringud, lehed, klikid, näitamised, CTR ja keskmine positsioon.

### API lõpp-punkt

```
POST https://www.googleapis.com/webmasters/v3/sites/{siteUrl}/searchAnalytics/query
```

Märkus: `{siteUrl}` peab olema URL-kodeeritud (nt `https%3A%2F%2Fexample.com%2F` või `sc-domain%3Aexample.com`).

### Parimad päringud

```bash
curl -s -X POST \
  "https://www.googleapis.com/webmasters/v3/sites/sc-domain%3Aexample.com/searchAnalytics/query" \
  -H "Authorization: Bearer ${GSC_ACCESS_TOKEN}" \
  -H "Content-Type: application/json" \
  -d '{
    "startDate": "2024-01-01",
    "endDate": "2024-03-31",
    "dimensions": ["query"],
    "rowLimit": 50,
    "startRow": 0
  }'
```

### Parimad lehed

```bash
curl -s -X POST \
  "https://www.googleapis.com/webmasters/v3/sites/sc-domain%3Aexample.com/searchAnalytics/query" \
  -H "Authorization: Bearer ${GSC_ACCESS_TOKEN}" \
  -H "Content-Type: application/json" \
  -d '{
    "startDate": "2024-01-01",
    "endDate": "2024-03-31",
    "dimensions": ["page"],
    "rowLimit": 50
  }'
```

### Päringu ja lehe kombinatsioon

```bash
curl -s -X POST \
  "https://www.googleapis.com/webmasters/v3/sites/sc-domain%3Aexample.com/searchAnalytics/query" \
  -H "Authorization: Bearer ${GSC_ACCESS_TOKEN}" \
  -H "Content-Type: application/json" \
  -d '{
    "startDate": "2024-01-01",
    "endDate": "2024-03-31",
    "dimensions": ["query", "page"],
    "rowLimit": 100,
    "dimensionFilterGroups": [{
      "filters": [{
        "dimension": "page",
        "operator": "contains",
        "expression": "/blog/"
      }]
    }]
  }'
```

### Saadaolevad mõõtmed

| Mõõde | Kirjeldus |
|-----------|-------------|
| `query` | Otsingupäring |
| `page` | URL |
| `country` | Riigi kood (ISO 3166-1 alpha-3) |
| `device` | `DESKTOP`, `MOBILE`, `TABLET` |
| `date` | Üksikkuupäev |
| `searchAppearance` | Rikastatud tulemuse tüüp |

### Vastuse parsimine

```bash
curl -s -X POST "..." | python3 -c "
import json, sys
data = json.load(sys.stdin)
print(f\"{'Query':<50} {'Clicks':>8} {'Impr':>8} {'CTR':>8} {'Pos':>6}\")
print('-' * 82)
for row in data.get('rows', []):
    keys = ' + '.join(row.get('keys', []))
    print(f\"{keys:<50} {row['clicks']:>8} {row['impressions']:>8} {row['ctr']*100:>7.1f}% {row['position']:>6.1f}\")
"
```

---

## 2. Otsingutulemuslikkus kuupäeva järgi

Jälgi päringute ja lehtede päevatrende.

```bash
curl -s -X POST \
  "https://www.googleapis.com/webmasters/v3/sites/sc-domain%3Aexample.com/searchAnalytics/query" \
  -H "Authorization: Bearer ${GSC_ACCESS_TOKEN}" \
  -H "Content-Type: application/json" \
  -d '{
    "startDate": "2024-01-01",
    "endDate": "2024-03-31",
    "dimensions": ["date"],
    "rowLimit": 1000
  }'
```

Konkreetse päringu jälgimiseks aja jooksul:

```bash
curl -s -X POST \
  "https://www.googleapis.com/webmasters/v3/sites/sc-domain%3Aexample.com/searchAnalytics/query" \
  -H "Authorization: Bearer ${GSC_ACCESS_TOKEN}" \
  -H "Content-Type: application/json" \
  -d '{
    "startDate": "2024-01-01",
    "endDate": "2024-03-31",
    "dimensions": ["date"],
    "dimensionFilterGroups": [{
      "filters": [{
        "dimension": "query",
        "operator": "equals",
        "expression": "your target keyword"
      }]
    }]
  }'
```

---

## 3. Indekseerimise katvus (URL Inspection API)

Kontrolli, kas konkreetne URL on indekseeritud.

### Lõpp-punkt

```
POST https://searchconsole.googleapis.com/v1/urlInspection/index:inspect
```

### Näidis-curl

```bash
curl -s -X POST \
  "https://searchconsole.googleapis.com/v1/urlInspection/index:inspect" \
  -H "Authorization: Bearer ${GSC_ACCESS_TOKEN}" \
  -H "Content-Type: application/json" \
  -d '{
    "inspectionUrl": "https://example.com/page-to-check",
    "siteUrl": "sc-domain:example.com"
  }'
```

### Vastuse väljad

| Väli | Kirjeldus |
|-------|-------------|
| `inspectionResult.indexStatusResult.coverageState` | `Submitted and indexed`, `Crawled - currently not indexed` jne |
| `inspectionResult.indexStatusResult.robotsTxtState` | `ALLOWED` või `DISALLOWED` |
| `inspectionResult.indexStatusResult.indexingState` | `INDEXING_ALLOWED` või `INDEXING_NOT_ALLOWED` |
| `inspectionResult.indexStatusResult.lastCrawlTime` | Millal Googlebot viimati roomas |
| `inspectionResult.indexStatusResult.crawledAs` | `DESKTOP` või `MOBILE` |
| `inspectionResult.mobileUsabilityResult.verdict` | `PASS`, `FAIL` või `VERDICT_UNSPECIFIED` |

---

## 4. Saidikaardid

Loetle ja kontrolli saidikaartide olekut.

### Saidikaartide loetlemine

```bash
curl -s -H "Authorization: Bearer ${GSC_ACCESS_TOKEN}" \
  "https://www.googleapis.com/webmasters/v3/sites/sc-domain%3Aexample.com/sitemaps" \
  | python3 -c "
import json, sys
data = json.load(sys.stdin)
for sm in data.get('sitemap', []):
    print(f\"URL: {sm['path']}\")
    print(f\"  Type: {sm.get('type','')}  |  Submitted: {sm.get('lastSubmitted','')}\")
    print(f\"  URLs discovered: {sm.get('contents',[{}])[0].get('submitted','?')}  |  Indexed: {sm.get('contents',[{}])[0].get('indexed','?')}\")
    print()
"
```

### Saidikaardi esitamine

```bash
curl -s -X PUT -H "Authorization: Bearer ${GSC_ACCESS_TOKEN}" \
  "https://www.googleapis.com/webmasters/v3/sites/sc-domain%3Aexample.com/sitemaps/https%3A%2F%2Fexample.com%2Fsitemap.xml"
```

---

## 5. Võimaluste tuvastamine

Kasuta Search Console'i andmeid SEO-võimaluste leidmiseks.

### Madalal rippuvad viljad: palju näitamisi, madal CTR

Päringud, millel on palju näitamisi, kuid madal CTR, viitavad sellele, et pealkiri/kirjeldus vajab optimeerimist.

```bash
# Pull queries, then filter for: impressions > 100 AND ctr < 0.03 AND position < 20
curl -s -X POST \
  "https://www.googleapis.com/webmasters/v3/sites/sc-domain%3Aexample.com/searchAnalytics/query" \
  -H "Authorization: Bearer ${GSC_ACCESS_TOKEN}" \
  -H "Content-Type: application/json" \
  -d '{
    "startDate": "2024-01-01",
    "endDate": "2024-03-31",
    "dimensions": ["query", "page"],
    "rowLimit": 1000
  }' | python3 -c "
import json, sys
data = json.load(sys.stdin)
print('== Low CTR Opportunities (High impressions, low CTR, good position) ==')
print(f\"{'Query':<40} {'Page':<40} {'Impr':>6} {'CTR':>7} {'Pos':>5}\")
for row in data.get('rows', []):
    if row['impressions'] > 100 and row['ctr'] < 0.03 and row['position'] < 20:
        print(f\"{row['keys'][0]:<40} {row['keys'][1][-40:]:<40} {row['impressions']:>6} {row['ctr']*100:>6.1f}% {row['position']:>5.1f}\")
"
```

### Löögikaugus: positsioon 5–20

Päringud, mis asetsevad 1.–2. lehel ja mida saaks sisu optimeerimisega esiviisikusse nihutada.

```bash
# Filter for position between 5 and 20 with decent impressions
curl -s -X POST "..." | python3 -c "
import json, sys
data = json.load(sys.stdin)
print('== Striking Distance Keywords (Position 5-20) ==')
opps = [r for r in data.get('rows',[]) if 5 <= r['position'] <= 20 and r['impressions'] > 50]
opps.sort(key=lambda x: x['impressions'], reverse=True)
for row in opps[:30]:
    print(f\"{row['keys'][0]:<50} Pos: {row['position']:>5.1f}  Impr: {row['impressions']:>6}  Clicks: {row['clicks']:>4}\")
"
```

### Kannibaliseerimise tuvastamine

Leia päringud, kus mitu lehte konkureerivad sama märksõna pärast.

```bash
# Pull query+page data, then group by query to find duplicates
curl -s -X POST "..." | python3 -c "
import json, sys
from collections import defaultdict
data = json.load(sys.stdin)
query_pages = defaultdict(list)
for row in data.get('rows', []):
    query_pages[row['keys'][0]].append({
        'page': row['keys'][1],
        'clicks': row['clicks'],
        'impressions': row['impressions'],
        'position': row['position']
    })
print('== Keyword Cannibalization (multiple pages for same query) ==')
for query, pages in sorted(query_pages.items(), key=lambda x: -sum(p['impressions'] for p in x[1])):
    if len(pages) > 1:
        total_impr = sum(p['impressions'] for p in pages)
        if total_impr > 100:
            print(f\"\nQuery: {query} ({total_impr} total impressions)\")
            for p in sorted(pages, key=lambda x: -x['impressions']):
                print(f\"  {p['page'][-60:]}  Pos: {p['position']:.1f}  Impr: {p['impressions']}  Clicks: {p['clicks']}\")
"
```

---

## Töövoog: täielik otsingutulemuslikkuse audit

Kui küsitakse täielikku GSC auditit:

1. **Üldnäitajad**: kogu klikid, näitamised, keskmine CTR, keskmine positsioon viimase 90 päeva vs eelneva 90 päeva kohta
2. **Top 30 päringut**: klikkide järgi, koos CTR-i ja positsiooniga
3. **Top 20 lehte**: klikkide järgi, koos CTR-i ja positsiooniga
4. **Seadmete jaotus**: lauaarvuti vs mobiili tulemuslikkus
5. **Madalal rippuvad viljad**: palju näitamisi + madal CTR võimalused
6. **Löögikaugus**: positsiooni 5–20 märksõnad optimeerimispotentsiaaliga
7. **Kannibaliseerimine**: päringud mitme konkureeriva lehega
8. **Indekseerimise katvus**: kontrolli pisteliselt olulisi URL-e
9. **Saidikaardi tervis**: veendu, et saidikaardid on esitatud ja indekseeritud

### Aruande vorming

```
## Search Console Audit: {domain}
### Period: {date range}

### Summary
| Metric | Current | Previous | Change |
|--------|---------|----------|--------|
| Clicks | X | Y | +Z% |
| Impressions | X | Y | +Z% |
| Avg CTR | X% | Y% | +Z pp |
| Avg Position | X | Y | +Z |

### Top Queries
| Query | Clicks | Impressions | CTR | Position |
|-------|--------|-------------|-----|----------|
| ...   | ...    | ...         | ... | ...      |

### Optimization Opportunities

#### Title/Description Optimization (High Impressions, Low CTR)
1. "{query}" - {impressions} impressions, {ctr}% CTR, position {pos}
   - Page: {url}
   - Recommendation: ...

#### Content Optimization (Striking Distance)
1. "{query}" - position {pos}, {impressions} impressions
   - Action: Add {query} to H2, expand section on {topic}

#### Cannibalization Fixes
1. "{query}" appears on {n} pages
   - Consolidate to: {best_url}
   - Redirect/noindex: {other_urls}
```

---

## Päringupiirangud

- Search Analytics API: 1200 päringut minutis
- URL Inspection API: 2000 kontrolli päevas atribuudi kohta
- Andmete värskus: otsinguandmed on tavaliselt 2–3 päeva ajast maas

## Levinud vead

| Viga | Põhjus | Lahendus |
|-------|-------|-----|
| 403 | Puudub juurdepääs sellele atribuudile | Kinnita omandiõigus GSC-s |
| 400 | Kehtetu kuupäevavahemik | Kuupäevad peavad jääma viimase 16 kuu sisse |
| Tühjad read | Filtritele ei vasta ükski andmerida | Laienda kuupäevavahemikku või eemalda filtrid |