The Scenario
Something is off with the traffic data in one of your Yandex Metrica counters. The session counts look wrong for the last two months and you suspect an internal IP filter is either missing, misconfigured, or duplicated across two counters that were set up at different times by different people.
You have access to the Metrica UI, but there is no bulk export for filter configurations. The only way to see all filters is to open each counter, go to Filters, and read the list on screen.
You have four counters to check. Each one may have five to twenty filters. And you do not have admin access to three of them — you have to ask the person who does, and they are in a different timezone.
The bad version:
- Screenshot the filters tab from each counter you do have access to, paste them into a doc, try to compare the lists visually
- Send a message to the admin asking for a screenshot of the other three counters, wait a day for a response
- Try to spot duplicates by reading filter strings side by side in a Google Doc, miss one because two filters differ only in operator (equals vs. contains)
This is the kind of audit task that sounds like it should take 20 minutes but routinely takes three days.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. Through the Yandex integration, it can pull the complete filter list from any counter you have access to and write every field — ID, type, attribute, operator, value — directly into your sheet.
Fetch all filters for Yandex Metrica counter 87654321 and write filter ID, field, operator, and value into columns A through D of this sheet. One row per filter. Add a header row.
What You Get
- Row 1: headers — Filter ID, Field, Operator, Value
- One row per filter, with the exact operator string Yandex stores (equals, contains, starts with, etc.)
- Value column contains the raw filter value — IP address range, URL pattern, referrer string, or whatever was configured
- Runs to completion on counters with 30+ filters without any manual pagination
What If the Data Is Not Quite Ready
Pull filters from multiple counters into one sheet with a source column
You need to compare filters across all four counters at once, not open four separate tabs.
For each counter ID listed in column A of the Counters tab, fetch all Yandex Metrica filters. Write counter ID into column A, filter ID into column B, field into column C, operator into column D, and value into column E of the Filters sheet. One row per filter across all counters.
Flag filters with duplicate values regardless of which counter they came from
Identical filter values set up on two counters are probably redundant. You want them marked before you start deleting anything.
Fetch all filters from counter 87654321 and write them into columns A through D. In column E, write "Duplicate value" for any filter whose value in column D matches another row's value exactly, and "Unique" for the rest.
Identify IP filters that fall outside expected office CIDR ranges
You know your office IP ranges. Anything else with an IP filter is either a remote worker added informally or a leftover from a contractor who no longer has access.
Fetch all filters for counter 87654321 where field is "ClientIP". Write filter ID, operator, and value into columns A through C. In column D, flag any IP value that does not fall within 192.168.1.0/24 or 10.0.0.0/8 as "Out of expected range".
Pull filters, normalize operator names, and sort by field type in one pass
Different counter configurations use slightly different operator strings for the same logical operator — "equals" vs "eq" vs "=". Before presenting the audit results you need a clean, normalized table.
Fetch all filters for counter 87654321. Normalize the operator values to full English words (equals, contains, starts with, ends with, does not equal). Sort the output by field name alphabetically. Write field, normalized operator, and value into columns A through C of the Audit tab. Add a header row.
One prompt handles the pull, the normalization, and the sort — which is three fewer manual steps between the API response and the finished audit table.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where you are running your Metrica configuration audit, then ask it to pull all filters from the counters you care about and flag the duplicates. See also: exporting goals and auditing access grants.