Google Search Console
Your site's organic search data: clicks, impressions, CTR, average position, sitemaps.
The Google Search Console connector brings your site's organic search data into the sheet: clicks, impressions, CTR, average position, plus data about submitted sitemaps.
The connector automatically uses the right data source based on the dimensions chosen: choosing dimensions like Sitemap Path or Last Submitted queries sitemap data; otherwise it queries search performance (clicks/impressions/queries). The two data families are never mixed in the same report.
Full official reference: metrics and dimensions.
Permessi richiesti
webmasters.readonly: Needed to read data for the verified sites on your Google Search Console account.
Metriche disponibili
| Metrica | Periodo | Aggregazione | Note |
|---|---|---|---|
| Clicks | |||
| Impressions | |||
| CTR (%) | Weighted average on clicks/impressions, not a direct sum of the row values. | ||
| Average Position | Weighted average on impressions, not a direct sum of the row values. | ||
| Submitted URLs | |||
| Sitemap Errors | |||
| Sitemap Warnings |
Dimensioni disponibili
| Dimensione | Note |
|---|---|
| Date | |
| Query | |
| Page (Full URL) | |
| Country | |
| Device | |
| Search Appearance | |
| Sitemap Path | |
| Last Submitted | |
| Last Downloaded | |
| Sitemap Type |
Limiti noti
- Max 25,000 rows per reportGoogle's Search Analytics API accepts at most 25,000 rows per call: if your site has more query/page combinations than that in the requested period, anything beyond the limit does not appear in the report. The sheet shows a warning when this limit is reached.
- "Indexed" not available for sitemapsGoogle's official sitemap API only returns "Submitted" URLs, no longer a count of those actually indexed: some tools still show an "Indexed" number because they estimate it by cross-referencing other sources, this connector only reports the API's direct data.