--- title: "Free AI Visibility Tracker Template (Spreadsheet)" canonical: https://snezzi.com/resources/ai-visibility-tracker-template-2026/ source: https://snezzi.com/resources/ai-visibility-tracker-template-2026/ --- > Canonical page: https://snezzi.com/resources/ai-visibility-tracker-template-2026/ How to use it ## Track AI answers by hand in four steps A first baseline of 40 prompts on four engines is 160 checks. Plan on three to four hours. 1. 30 minutes ### Write 20 to 40 buyer prompts Use the questions buyers type, not your keywords. Mix category, comparison, problem and brand questions. 2. One sitting ### Run each prompt the same way Use a logged-out or private window, the same country and the same day. Log failed answers as errors, not as misses. 3. Per answer ### Record mention and citation apart Being named and being linked are different results. Note position, competitors and every cited source. 4. Monthly ### Report out of the denominator Say 12 of 40, not 30%. Then read the answers to decide whether the fix is content, the site or other sites. The template ## The 11 columns and what goes in each One row is one prompt, on one engine, on one date. Keep every column, even when the answer is a miss. What it records compared with Example What you get What it records Example Prompt The exact customer question tested What is the best CRM for a 20-person sales team? Country The market used for the check United States AI platform The AI answer tested ChatGPT Checked at When the check ran 2026-09-10 10:30 UTC Status Successful, unavailable or failed Successful Brand mentioned Whether the answer names the brand Yes Own-domain citation Whether the answer links to the brand website No Position Where the brand appears in the answer 2 Competitors mentioned Other brands in the same answer Vendor A; Vendor B Cited sources Domains or URLs the answer used industry-guide.example/report Denominator Successful checks in the reporting group 40 Filled example ## Five filled rows from one week A made-up CRM brand, tested on four engines. Notice that a mention without a link and a link without a mention are both possible. AI Visibility Tracker Template filled example Prompt Engine Status Mentioned Own link Position Competitors named Cited sources Best CRM for a 20-person sales team ChatGPT Successful Yes No 3 Vendor A; Vendor B g2.com; a review blog Best CRM for a 20-person sales team Perplexity Successful No No \- Vendor A; Vendor C reddit.com; vendor-a.com Best CRM for a 20-person sales team Google AI Overviews Unavailable \- \- \- \- No AI Overview shown Vendor A vs our brand for small teams Google AI Mode Successful Yes Yes 2 Vendor A our pricing page; capterra.com How do I stop leads going cold in a CRM Claude Successful No No \- Vendor B a YouTube tutorial; vendor-b.com Sample data for illustration. The unavailable row is left out of the denominator, so this group reads 2 of 4 successful checks. Formulas ## Four numbers worth reporting Paste these into the summary tab. Each one counts successful checks only, so a failed run never looks like a lost mention. AI Visibility Tracker Template reference table Metric What it tells you Google Sheets formula Mention rate Share of answers that name you \=COUNTIFS(F:F,"Yes",E:E,"Successful")/COUNTIF(E:E,"Successful") Citation rate Share of answers that link to your site \=COUNTIFS(G:G,"Yes",E:E,"Successful")/COUNTIF(E:E,"Successful") Average position How early you are named when named \=AVERAGEIFS(H:H,F:F,"Yes",E:E,"Successful") Share of voice Your mentions out of all brand mentions \=COUNTIFS(F:F,"Yes",E:E,"Successful")/(COUNTIFS(F:F,"Yes",E:E,"Successful")+SUMPRODUCT((E2:E1000="Successful")\*(I2:I1000<>"")\*(LEN(I2:I1000)-LEN(SUBSTITUTE(I2:I1000,";",""))+1))) Report each number with its denominator, for example 12 of 40. The share of voice formula counts competitors in column I, so separate their names with a semicolon. Split by engine before you average: ChatGPT and Google AI Mode often cite different sources for the same question. Monthly report ## What the monthly report looks like The summary tab turns the rows into one table per month. This is the AI search visibility report most teams send to leadership. What the monthly report looks like Engine Successful checks Named Mention rate Linked Citation rate Avg position Top cited domain ChatGPT 38 of 40 14 37% 5 13% 2.4 g2.com Perplexity 40 of 40 11 28% 9 23% 2.9 reddit.com Google AI Overviews 31 of 40 9 29% 6 19% 3.1 capterra.com Google AI Mode 40 of 40 12 30% 8 20% 2.6 your pricing page All engines 149 of 160 46 31% 28 19% 2.7 g2.com Sample data for illustration. AI Overviews shows 31 checks because Google did not show an AI Overview for 9 prompts. Put last month's row next to this one and read the change, not the single number. SEO and AI KPIs ## Which SEO KPIs to report next to it Pick one business goal, then the early signals that move before it. Record today's values as your baseline. A baseline is a starting point, not a result. Which SEO KPIs to report next to it KPI Type Where it comes from Review Demo requests, sign-ups or sales from organic and AI referrals Business goal GA4 key events by source Monthly Organic clicks on buyer queries Early signal Search Console, filtered to 'best', 'vs', 'pricing', 'alternative' Monthly Impressions for question queries Early signal Search Console, queries starting with how, what, which Monthly Average position for your top 20 queries Early signal Search Console performance report Monthly AI mention rate on buyer prompts Early signal This tracker Monthly AI citation rate (your site linked) Early signal This tracker Monthly AI referral visits Early signal GA4 sessions from chatgpt.com, perplexity.ai, claude.ai Monthly Activity is not a KPI. Pages published and prompts tracked tell you the work happened, not that it worked. Dashboard ## Build a Looker Studio SEO dashboard from it One report that reads Search Console, GA4 and this tracker, shared the same way every month. About an hour to set up. 1. ### Step 1 Put the tracker in Google Sheets Upload the .xlsx to Google Drive and open it with Google Sheets. Keep the column names unchanged, because Looker Studio reads them as fields. 2. ### Step 2 Add three data sources In [Looker Studio](https://lookerstudio.google.com/), add the Google Sheets connector for the tracker, the Search Console connector for your site, and the Google Analytics connector for your GA4 property. 3. ### Step 3 Page 1: the scorecards Add scorecards for organic clicks, AI mention rate, AI citation rate and AI referral sessions, each with the previous period as comparison. Worked example: Filter the GA4 scorecard to session source contains chatgpt.com, perplexity.ai or claude.ai to show AI referral sessions. 4. ### Step 4 Page 2: by engine and by query Add a bar chart of mention rate by AI platform from the tracker, a table of top cited sources, and a Search Console table of your top 20 buyer queries with clicks and position. 5. ### Step 5 Share one fixed view Set the date range to last calendar month and share view access. Send the same link every month so nobody compares different date ranges. Tools ## What you need to run it by hand All free except your time. The slow part is reading answers, not the spreadsheet. 1. 1 ### Google Sheets or Excel The download is an .xlsx file. Upload it to Google Drive if your team works in Sheets. 2. 2 ### A private browser window Logged-out answers are closer to what a new buyer sees. Personal history changes ChatGPT and Google results. 3. 3 ### A VPN for other markets AI answers change by country. Set one location per run and record it in the Country column. 4. 4 ### [Looker Studio for the monthly view](https://lookerstudio.google.com/) Connect the sheet as a data source. Build one scorecard per metric and one bar chart by engine, then share the same report each month. 5. 5 ### [Google Search Console and GA4](https://search.google.com/search-console) Put Search Console clicks and AI referral visits from chatgpt.com and perplexity.ai next to your AI numbers, so you see whether mentions bring visits. With Snezzi ## When the sheet gets too big, Snezzi runs it Snezzi is the AI visibility platform that does the work. It runs your prompts on a daily or weekly schedule and keeps every answer. 1. 01 ### Every prompt, on five engines ChatGPT, Claude, Perplexity, Google AI Overviews and Google AI Mode answer your tracked prompts on schedule. - 200 tracked prompts on the planEach prompt keeps its own country, from 39 mapped markets. - The raw answer is savedOpen any run and read exactly what the engine said, not only a score. Northstar Cloud · AI Visibility Welcome back! Here's what's happening with your organic visibility today - AI Visibility↑ 4 pts **31%** as of Oct 7 · 30/96 prompts - Share of Voice↑ 3 pts **18%** across 9 tracked brands - Top-3 Rate **68%** appearances ranked in the top 3 - AI Referral Leads↑ 24% **38** from 624 AI sessions Sample workspace, demo data 2. 02 ### Competitors, counted for you Every answer is scored for you and each tracked competitor: mention, position, sentiment and share of voice. - The same columns as this sheetWithout the hours of reading and typing. - The prompts each competitor winsSee exactly where a rival is named and you are not. Northstar Cloud · Competitors Competitors Analyze competitor visibility and market share Rank Competitor Mentions Share of voice Sentiment #1 Helio Desk 112 27% Positive #2 Reply Grid 91 22% Positive #3 Northstar Cloud · You 74 18% Positive #4 Queue Labs 45 11% Neutral #5 Resolve AI 34 8% Neutral Sample workspace, demo data 3. 03 ### Visits, next to answers AI referral traffic from GA4 and Search Console clicks sit beside your mention rate. - Referral sources by engineVisits from ChatGPT, Perplexity, Claude and other assistants, read from your GA4. - 7, 30 and 90 day trendsWith the change against the period before. Northstar Cloud · Traffic Traffic Visitors from Google and Bing search, and from AI assistants like ChatGPT, Perplexity and Claude. - AI sessions↑ 21% **624** 438 engaged (70.2%) - Share of site traffic↑ 12% **4.80%** of all sessions on the site - Page views↑ 18% **1,934** 3.1 per session - Avg duration↑ 9% **4m 18s** Bounce: 28.4% Sample workspace, demo data Proof ## Published results from Snezzi customers From our case studies of teams that track and fix AI visibility with Snezzi. They are past results, not a promise. - 0% → 34.5% AI visibility [An enterprise AI-agent company, over 12 weeks.](/case-studies/ai-saas-sales-support-case-study/) - 7,733 AI citations [The same company, through a full site migration.](/case-studies/ai-saas-sales-support-case-study/) - 6X AI mentions [A regional HVAC and roofing contractor, over 7 months.](/case-studies/home-services-company/) Free resource ## Download the AI visibility tracker An .xlsx file with all 11 columns, ready for your own prompts, markets and engines. Paste the formulas from this page into a summary tab. - Downloads straight away - Editable spreadsheet - No account or email needed Spreadsheet AI Visibility Tracker Template [Download the spreadsheet](https://docs.google.com/spreadsheets/d/1fXQfKoSZaHdMz3aRmTcFTO2VAXWj4kPjbf8g3MQmZK0/export?format=xlsx&gid=0) Questions ## AI visibility tracker questions How to run it, what to report and when a tool is worth it. What is an AI visibility tracker? An AI visibility tracker records how AI assistants answer the questions your buyers ask: whether your brand is named, whether your site is linked, where you appear, and which competitors and sources show up instead. This template does it by hand in a spreadsheet. How many prompts should I track? Start with 20 to 40 real buyer questions. Fewer than 20 swings too much week to week. More than 50 is hard to run by hand on four or five engines. Why keep mentions and citations apart? They are different results. An answer can name you without linking to you, which helps brand recall. It can also cite your page while recommending a competitor. Both need different fixes. How often should I re-run the checks? Monthly is realistic by hand. AI answers vary between runs, so treat one check as a sample and look at the trend across several months, not one week. What KPIs should I report to leadership? Pick one business goal, such as demo requests from organic and AI referrals. Then report the early signals that move first: organic clicks on buyer queries and average position from Search Console, AI mention and citation rate from this tracker, and AI referral visits in GA4. Record today's numbers as the baseline and review monthly. Can I build a Looker Studio dashboard from it? Yes. The five steps above build one: the tracker, Search Console and GA4 as data sources, a scorecard page and a by-engine page, shared with a fixed monthly date range. When does a tool make more sense than the sheet? When you track more than about 50 prompts, more than one country, or want daily data. Snezzi runs up to 200 prompts on a daily or weekly schedule for $500 a month, with a 7-day trial for $10. Keep going ## Related reading and tools - [Feature AI visibility tracking How Snezzi runs your prompts on five AI engines and scores every answer.](/features/ai-visibility-tracking/) - [Feature AI citation tracking See which pages AI engines cite for your questions, and which are yours.](/features/ai-citation-tracking/) - [Feature AI referral traffic Read visits from ChatGPT, Perplexity and Claude out of your GA4.](/features/ai-referral-traffic/) - [Blog How to measure GEO visibility A step-by-step method for measuring brand presence in AI answers.](/blog/how-to-measure-geo-visibility-complete-step-by-step-guide/) - [Pricing Snezzi pricing $500 a month for 200 tracked prompts and 15 articles, with a 7-day trial for $10.](/pricing/) - [Free template SERP Analysis Template This free SERP analysis template is a sheet for comparing the top 10 Google results, the AI Overview and the AI answers for one query, so you can see the intent, the formats that win and the questions nobody answers well.](/resources/serp-analysis-template-free/) ![](/_astro/cloud.BnQ45Ste_297Hdu.webp) ![](/_astro/cloud.BnQ45Ste_297Hdu.webp) ![](/_astro/cloud.BnQ45Ste_297Hdu.webp) Free template ## Start with the sheet, keep the habit Download the tracker and run your first 20 prompts this week. When the sheet outgrows you, Snezzi runs the same checks on a schedule. [Download the spreadsheet](https://docs.google.com/spreadsheets/d/1fXQfKoSZaHdMz3aRmTcFTO2VAXWj4kPjbf8g3MQmZK0/export?format=xlsx&gid=0) [Run the free AI audit](/ai-audit/)