The Scenario
You are three weeks into a quarterly analytics governance audit. One of the requirements is a complete inventory of every goal configured across your company's Yandex Metrica counters — goal ID, name, type, and conversion step — documented in a Google Sheet so the analytics committee can review for duplicates, deprecated events, and goals that no longer map to live pages.
There are eleven counters across five properties.
The only way to see goals right now is to log into Metrica, open each counter, click into the goals tab, and read them off the screen one by one. Nobody wrote them down the last time they were set up.
The bad version:
- Open the Metrica UI for counter one, click Goals, manually type each goal ID, name, and type into your sheet
- Switch to counter two, repeat the process, realize three goals are named almost identically and you are not sure which is which
- Finish six counters, take a break, come back and realize you forgot to capture the conversion step details for four of them and have to go back
The committee presentation is next Thursday. The audit document is supposed to be done by Tuesday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. Connect it to Yandex Metrica through the built-in integration, and you can pull the full goal list for any counter directly into the sheet — without opening the Metrica UI.
Fetch all goals configured for Yandex Metrica counter ID 12345678 and write goal ID, name, type, and conversion step description into columns A through D of this sheet, starting at row 2. Add a header row.
What You Get
- Row 1: headers — Goal ID, Goal Name, Type, Conversion Step
- One row per goal from row 2 onward
- Type reflects what Yandex returns: url, number, duration, event
- Conversion step description includes the condition or target URL where applicable
- If the counter has no goals configured, SheetXAI writes a note in A2 rather than leaving the sheet blank
What If the Data Is Not Quite Ready
Multiple counters, one sheet with a column to distinguish them
You need goals from all eleven counters in one document, not eleven separate tabs.
Fetch all goals for each Yandex Metrica counter listed in column A of the Counters tab. For each counter, write the counter ID into column A, counter name into column B, goal ID into column C, goal name into column D, type into column E, and conversion step into column F of the Goals sheet. One row per goal.
Filter out goals of a specific type before writing
Your committee only wants to review URL-type goals for this pass. Event goals are out of scope.
Fetch all goals for Yandex Metrica counter 12345678. Write only the goals where type is "url" into columns A through D — goal ID, name, type, target URL. Skip any goal where type is not "url".
Flag goals whose target URL is no longer reachable
Documentation of a broken goal is worse than no documentation. You want to know which goal URLs still resolve before the report goes to the committee.
Fetch all goals for counter 12345678 where type is "url". For each goal, check whether the target URL returns a 200 status. Write goal ID, name, type, and target URL into columns A through D. In column E, write "Live" or "Dead" based on the status check.
Pull goals, deduplicate by name, and flag suspiciously similar entries in one pass
Three goals named "Lead Form Submit", "Lead Form Submission", and "lead-form-submit" are almost certainly the same event set up three times.
Fetch all goals for counter 12345678 and write them into columns A through D. Then in column E, flag any goal whose name is within two characters of another goal's name in the list — mark those rows as "Possible duplicate" so I can review them before the audit meeting.
The cleaner approach is to capture the data and flag the structural issues in the same pass, rather than hunting for duplicates manually after the export.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where you are building your analytics audit, then point it at your Metrica counter and ask it to pull the full goal inventory with duplicate flagging built in. See also: exporting traffic filters and auditing access grants.