get_advanced_search_analytics
Query Google Search Console search analytics with pagination, sorting, regex filters, and multi-filter AND logic to extract targeted SEO performance data up to 25,000 rows per call.
Instructions
Power query: up to 25,000 rows per call with pagination, sorting, regex and multi-filter AND logic.
Args:
site_url: Exact property from list_properties (defaults to GSC_SITE_URL)
start_date: YYYY-MM-DD (defaults to days ago)
end_date: YYYY-MM-DD (defaults to latest day)
dimensions: comma list or array, e.g. "query,page,device"
search_type: web, image, video, news, discover, googleNews
row_limit: Max rows (1-25000, default 1000)
start_row: Offset for pagination (use next_start_row from the previous page)
sort_by: clicks, impressions, ctr or position (applied to returned rows)
sort_direction: descending or ascending (ascending position = best rankings first)
filter_dimension: Single filter dimension (query, page, country, device, searchAppearance)
filter_operator: equals, notEquals, contains, notContains, includingRegex, excludingRegex
filter_expression: Value for the single filter
filters: JSON array of filters (AND). Overrides the single-filter args.
data_state: "all" (default) or "final"
days: Look-back window when start_date is omitted (default 28)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| days | No | ||
| filters | No | ||
| sort_by | No | clicks | |
| end_date | No | ||
| site_url | No | ||
| row_limit | No | ||
| start_row | No | ||
| data_state | No | ||
| dimensions | No | query | |
| start_date | No | ||
| search_type | No | web | |
| sort_direction | No | descending | |
| filter_operator | No | contains | |
| filter_dimension | No | ||
| filter_expression | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |