4 PMA report types covering sitemaps, page performance, query performance, and the full flexible insights view — plus a strong native MCP for live coverage errors, URL inspection, and Semrush keyword enrichment.
gsc_compare_periods)fetch_gsc_data via report-engine for scheduled pullsGrouped by report type. Filter to find a field fast. formula fields are computed — use their component fields in SQL.
| Field name | Label | Type |
|---|---|---|
errors | Error | NUMBER |
warnings | Valid With Warnings | NUMBER |
submitted | Discovered URLs | NUMBER |
submitted_web | Submitted Web | NUMBER |
submitted_image | Submitted Image | NUMBER |
submitted_news | Submitted News | NUMBER |
submitted_video | Submitted Video | NUMBER |
isPending | Is Pending | NUMBER |
isSitemapsIndex | Is Sitemaps Index | NUMBER |
| Field name | Label | Type |
|---|---|---|
path | Sitemap | STRING |
siteUrl | Site URL | STRING |
type | Type | STRING |
lastDownloaded | Last Downloaded | STRING |
lastSubmitted | Last Submitted | STRING |
configName | Site | STRING |
date | Date And Time | STRING |
dataFreshness | Data Freshness | STRING |
year | Yearformula | STRING |
quarter | Quarterformula | STRING |
| Field name | Label | Type |
|---|---|---|
ctr | CTRformula | NUMBER |
clicks | Clicks | NUMBER |
impressions | Impressions | NUMBER |
position | Position | NUMBER |
| Field name | Label | Type |
|---|---|---|
page | Page | STRING |
searchType | Search Type | STRING |
aggregationType | Aggregation Type | STRING |
siteUrl | Site URL | STRING |
configName | Site | STRING |
date | Date And Time | STRING |
dataFreshness | Data Freshness | STRING |
year | Yearformula | STRING |
quarter | Quarterformula | STRING |
year_quarter | Year Quarterformula | STRING |
isInterpolated | PMA Is Interpolated? | BOOLEAN |
| Field name | Label | Type |
|---|---|---|
ctr | CTRformula | NUMBER |
clicks | Clicks | NUMBER |
impressions | Impressions | NUMBER |
position | Position | NUMBER |
| Field name | Label | Type |
|---|---|---|
query | Query | STRING |
searchType | Search Type | STRING |
aggregationType | Aggregation Type | STRING |
siteUrl | Site URL | STRING |
configName | Site | STRING |
date | Date And Time | STRING |
dataFreshness | Data Freshness | STRING |
year | Yearformula | STRING |
quarter | Quarterformula | STRING |
year_quarter | Year Quarterformula | STRING |
| Field name | Label | Type |
|---|---|---|
ctr | CTRformula | NUMBER |
clicks | Clicks | NUMBER |
impressions | Impressions | NUMBER |
position | Position | NUMBER |
| Field name | Label | Type |
|---|---|---|
query | Query | STRING |
page | Page | STRING |
device | Device | STRING |
country | Country | STRING |
country_code | Country Code | STRING |
country_code_alpha_3 | Country Code Alpha 3 | STRING |
searchType | Search Type | STRING |
search_appearance | Search Appearance | STRING |
aggregationType | Aggregation Type | STRING |
siteUrl | Site URL | STRING |
configName | Site | STRING |
date | Date And Time | STRING |
dataFreshness | Data Freshness | STRING |
isInterpolated | PMA Is Interpolated? | BOOLEAN |
Tools across mechanic-mcp-server (gsc_*), hedgehog-report-engine (fetch_gsc_data), and the Semrush MCP for keyword intelligence beyond GSC data.
| Tool | Data points / capability |
|---|---|
gsc_search_performance | Clicks, impressions, CTR, position — by query, page, device, or country for any date range. |
gsc_top_queries | Top queries by clicks/impressions with position data. |
gsc_top_pages | Top performing pages by organic click volume. |
gsc_compare_periods | Automated period-over-period comparison with delta calculations. |
gsc_coverage_errors | Pages not indexed, redirect errors, crawl anomalies — not available in PMA. |
gsc_url_inspect | Live URL inspection: index status, canonical, last crawl, rich result eligibility — not available in PMA. |
gsc_list_sites | Lists all verified Search Console properties. |
fetch_gsc_data | Scheduled or custom GSC pulls via the report engine. |
keyword_research (Semrush) | Keyword volume, difficulty, CPC, SERP features — enriches GSC queries with search intelligence not in GSC itself. |
organic_research (Semrush) | Competitor organic positions and traffic estimates for any domain. |