Depra AI

How-to

How to Track Brand Mentions in ChatGPT and AI Answers

A spreadsheet method you can run this week, with the columns, scoring rules and formulas to use, and the point where a tool saves you more time than it costs.

By · Updated · 10 min read

Four outlined panels threaded by a single line, each holding a different glyph, representing one brand monitored across several AI engines

To track brand mentions in ChatGPT and other AI answers, write 10 to 20 buying questions that do not name your brand, ask each one several times on each AI engine, and log every answer in a sheet: named or not, position, tone and cited websites. Repeat on a fixed schedule and compare the share of answers that name you from one period to the next.

The sheet below has 8 columns, the scoring rules stop two people from scoring the same answer differently, and the last section shows when an AI brand monitoring tool is worth paying for. A prompt, in this guide, is the question you type into an AI engine. For the theory behind the numbers, read how to measure AI visibility.

The 8 columns of an AI brand mentions tracking sheet
ColumnWhat to writeExample
DateThe day you asked the question15 Sep 2026
EngineChatGPT, Gemini, Perplexity or Google AI OverviewChatGPT
LanguageThe language of the question: English or HinglishHinglish
PromptThe exact question, copied from your frozen listIndia mein oily skin ke liye 500 rupees ke andar konsa face wash kharidna chahiye?
NamedYes if the answer names your brand, No if it does not, No Overview if Google showed noneYes
PositionWhere your brand comes among the brands named, 1 for first. Blank if not named2
SentimentPositive, neutral or negative, plus the sentence that names youNeutral: "YourBrand is a budget pick"
Cited sitesThe domain of every source link in the answer, separated by commasThree domains
Add a Row ID column so each question keeps one ID, a Run column (1, 2, 3) for repeat asks on the same day, and one Named column per competitor if you want share of voice. Example values are made up to show the format.

What counts as a brand mention in an AI answer?

A brand mention is any answer that names your brand in its text, whatever the spelling. Agree the rules below before your first run, write them at the top of the sheet, and keep them fixed for the whole period.

  • Count variants. Your brand name, common misspellings, your domain (yourbrand.in) and your product line name all count. List the variants in the sheet header so everyone matches the same ones.
  • Skip look-alikes. A word that matches your name but is used in its ordinary meaning does not count. A brand called Simple and the word simple are different things.
  • Position by first appearance. Number the brands in the order they first appear. If the answer names five brands and you come third, write 3. Count only brands, and leave out retailers and marketplaces unless you compete with them.
  • Sentiment by the sentence. Positive if the answer recommends or praises you, negative if it warns buyers off or leads with a drawback, neutral for a plain listing. Paste the sentence so anyone can check the call.
  • Citations in their own column. Cited sites are the source links an engine shows. A site can be cited without naming you, and you can be named with no link to your site. Log both. How to get cited by AI shows what to do with the list.
  • No Overview is a result. Google does not show an AI Overview for every search. Write No Overview, leave those rows out of your mention share, and count separately how often an Overview appears at all.

How do you set up the tracking sheet this week?

Plan about half a day of work for the first round, spread over three days. The steps below assume one person and a spreadsheet, and they use ChatGPT, Gemini, Perplexity and Google as the engines.

  • Day 1, write the questions. List 10 to 20 questions a buyer asks before choosing a product like yours. Take the wording from reviews, support chats, marketplace Q&A and sales calls. Leave your brand name out: an answer to a question that names you almost always names you back, which inflates your share.
  • Day 1, add Hinglish versions. If you sell in India, write a Hinglish version of your 5 most important questions. Hinglish is Hindi and English typed in English letters. Give each pair the same row ID.
  • Day 2, run the questions. Ask each question 3 times per chat engine, each time in a new chat, logged out or with memory off. Search Google in a private window for the AI Overview. 15 questions on 3 chat engines with 3 runs each come to 135 answers, a little over 2 hours at a minute an answer.
  • Day 3, roll up. Use the formulas further down to get your mention share per engine, your average position and your most cited sites. That first result is your baseline.
  • Every week or month, repeat. Run the same questions on the same weekday. Rewording a question starts a new trend line, so add a new row ID and keep the old one.

Why do you need several answers per question?

AI engines rarely give the same answer twice. In our August 2026 study of 480 answers from India, two ChatGPT answers to the same question, asked within one hour, shared 54.7% of the brands they named, and two Perplexity answers shared 68.3%. A single run can show you first or absent by chance. That is why this method asks each question 3 times and adds up the results across questions: 15 questions give 45 answers per engine per round. Does ChatGPT give the same answer to everyone? explains why, and how to measure AI visibility covers how many answers you need.

How to track brand performance in ChatGPT responses over time

To track brand performance in ChatGPT responses over time, freeze your questions, ask them on a fixed schedule, and compare the share of answers that name you in one period with the period before. Report every share with the number of answers behind it, because a small sample moves a lot on its own.

A 95% confidence range shows how far a share can move by chance: it is the band the true share most likely sits in. The table shows how the range narrows as you add answers, for a brand named in half of them.

95% confidence range for a 50% mention share, by number of answers
Answers countedMention share95% range
2050%30% to 70%
5050%37% to 63%
10050%40% to 60%
13550%42% to 58%
40050%45% to 55%
Wilson score intervals, a standard formula for ranges on a yes or no count. Ranges are widest at 50% and narrower for shares near 0% or 100%.

Rules for comparing two periods

  • Keep the same questions, engines and runs per question in both periods.
  • Compare a month with the month before, or the last 4 weeks with the 4 weeks before.
  • Count a change as real only when the two ranges do not overlap. Going from 6 of 20 answers (30%) to 9 of 20 (45%) sits inside the noise.
  • Track competitors on the same answers. If every brand rose, ChatGPT may be naming more brands per answer.
  • Keep a Notes tab with what you changed and when. A before-and-after view shows timing. It does not prove cause.

Formulas for the roll-up

These assume columns A to H in the order of the table at the top: Date, Engine, Language, Prompt, Named, Position, Sentiment, Cited sites. They work in Google Sheets and Excel.

  • Mention share on ChatGPT: =COUNTIFS(B:B, "ChatGPT", E:E, "Yes") / COUNTIF(B:B, "ChatGPT")
  • Mention share in AI Overviews: =COUNTIFS(B:B, "Google AI Overview", E:E, "Yes") / (COUNTIF(B:B, "Google AI Overview") - COUNTIFS(B:B, "Google AI Overview", E:E, "No Overview"))
  • Average position on ChatGPT: =AVERAGEIFS(F:F, B:B, "ChatGPT", E:E, "Yes")
  • Hinglish share on Perplexity: =COUNTIFS(B:B, "Perplexity", C:C, "Hinglish", E:E, "Yes") / COUNTIFS(B:B, "Perplexity", C:C, "Hinglish")
  • Share of voice: your Yes count divided by the Yes counts of every tracked brand added together, you included. This needs one Named column per competitor.

How do you track Hinglish prompts next to English ones?

Give each Hinglish question the same row ID as its English twin, set the Language column, and report the two languages side by side. A single blended share hides differences between engines.

Those differences can be large. In our English vs Hinglish study, we asked 10 buying questions in both languages, 8 times each, on ChatGPT, Gemini and Perplexity from inside India on 14 Aug 2026. We compared the share of brands two answers have in common. On ChatGPT, that share was 2.2 percentage points lower for an English and a Hinglish answer than for two repeat answers in the same language. The gap was 7.8 points on Gemini and 23.4 points on Perplexity. Gemini attached sources to 90.0% of English answers and 41.3% of Hinglish answers. In the October 2026 re-run (479 answers), the gap was 0.8 points on ChatGPT, 2.0 on Gemini, no longer significant, and 28.2 on Perplexity, and Gemini attached sources to 73.4% of English and 56.3% of Hinglish answers.

  • Write Hinglish the way buyers type it. Use English letters, everyday words and English product nouns. "India mein oily skin ke liye 500 rupees ke andar konsa face wash kharidna chahiye?" reads like a real buyer. A word-for-word translation usually does not.
  • Log the answer language too. Engines usually reply in the language you used. In our August 2026 study ChatGPT answered all 80 Hinglish questions in Hinglish, while Gemini answered 8 of 80 in Hindi script.
  • Have a native speaker check each pair. In our study, 3 of 10 question pairs failed an independent review and were rewritten before any answers were counted.

When should you switch from a spreadsheet to an AI brand monitoring tool?

Switch when filling the sheet takes more time than acting on it. Daily tracking of 20 questions on 3 chat engines is 60 answers a day before any repeats, about 1,800 a month, which nobody scores by hand. The usual signs: you skip runs, two people score the same answer differently, or you want daily numbers.

LLM brand monitoring tools, also sold as AI brand monitoring or AI visibility tools, run the questions for you, store the answers and do the scoring. They differ on engines, countries, languages and price. The best AI visibility tools compares them.

What Depra AI does

Depra AI's AI visibility tracking runs this method for you. It asks your questions to ChatGPT with web search, Gemini and Google AI Overviews every day and to Perplexity every week (daily on Enterprise), from inside your chosen country, in English and Hinglish, with multi-language support. It stores every full answer and records whether you were named, your position, the tone with the quoted sentence, and the cited pages, for you and your competitors. Questions that already contain your brand name are left out of your scores by default. You can export answers as CSV, and your report shows a confidence range.

On Starter, ₹1,999 a month plus GST, 16 prompt slots in one market cover 8 questions in English and Hinglish, with up to 1,568 scheduled checks in a 31-day month. The ChatGPT visibility tracker page covers the ChatGPT side, and Depra AI pricing lists every plan.

What the sheet does better

A sheet costs only time, and you can add any engine, including Enterprise add-ons such as Claude or Microsoft Copilot. You can also test answers while logged in with your own memory on. Depra AI does not capture logged-in answers.

Frequently asked

How do I track brand mentions in ChatGPT for free?

Use a spreadsheet. Write 10 to 20 buying questions without your brand name, ask each one 3 times in a new chat on ChatGPT, and log whether each answer names you, your position, the tone and the cited sites. Divide your mentions by total answers, then repeat monthly with the same questions.

How many times should I ask each question?

At least 3 times per engine per round, in a new chat each time, then add the results up across your questions. The total is what matters: at a 50% share, 20 answers give a range of about 30% to 70%, and 100 answers narrow it to about 40% to 60%.

What is AI brand monitoring?

AI brand monitoring means checking what AI engines such as ChatGPT, Gemini and Perplexity say about your brand when people ask about your category: how often you are named, next to which competitors, in what tone and with which sources. It is also called LLM brand monitoring, because these engines run on large language models.

Should I track questions that include my brand name?

Keep them separate. A question that names you gets a mention almost every time, so it inflates your share. Use those questions to check how AI describes you, and report your mention share from questions that do not name you.

Can I use Google Sheets to track AI brand mentions?

Yes. The 8 columns and the formulas above work in Google Sheets and Excel. If you move to Depra AI later, it exports answers as CSV, which opens in either. It has no direct Google Sheets connection. For a layout, see an AI visibility report your team can use.

Which AI engines should I track in India?

Start with ChatGPT, Gemini, Perplexity and Google AI Overviews, in English and Hinglish. In the August 2026 wave of our study, Perplexity and Gemini changed their brand lists for Hinglish questions far more than ChatGPT did. In the October 2026 re-run, the gap held on Perplexity (28.2 points) and fell to 2.0 points on Gemini, so English-only tracking on Perplexity misses part of what Indian buyers see.

What is a good AI mention rate?

There is no standard number. Compare against your own trend and against competitors on the same questions. A 30% share is strong if the next brand sits at 10% and weak if it sits at 70%.

Does Depra AI do this for me?

Yes. Depra AI asks your buying questions to ChatGPT with web search, Gemini and Google AI Overviews daily and to Perplexity weekly (daily on Enterprise), from inside your country, in English and Hinglish, with multi-language support. It stores every answer and scores mentions, position, sentiment and share of voice for you and your competitors. Starter, Growth and Scale start with 7 days free, no card needed. Your first free scan runs before the trial. After the trial, Starter costs ₹1,999 a month plus GST.

Stop filling the sheet by hand

Depra AI asks your buying questions to ChatGPT, Gemini and Google AI Overviews daily and Perplexity weekly (daily on Enterprise), and stores every answer. Start with a one-time free AI audit: 5 English questions on 4 AI engines. No signup, no card.

Keep reading