AI Search & AEO Visibility Dashboard

AI Search & AEO Visibility Dashboard measures how visible your brand is in AI-generated answers. Build a library of the prompts your buyers ask, run them in each AI engine on a regular schedule and log one row per answer: whether you were mentioned, whether your domain was cited as a source, your position among the brands named, sentiment, accuracy, which competitors appeared and the main third-party source cited.

The workbook turns those results into a 0-100 AI visibility score per answer (mention, citation, position and sentiment, with weights you can change), plus mention rate, citation rate, share of voice, average position and top-pick answers. The Dashboard filters by engine, topic and number of weeks and compares each figure with the previous period of the same length.

Engines & Competitors scores every engine side by side and shows a brand-by-engine mention matrix with share of voice and rank for you and up to five competitors. Trends covers twelve weeks of every metric, per engine and per competitor, with line charts. Each prompt gets a status of Winning, Contested, Gap or Invisible, and the Dashboard lists the biggest content gaps where a competitor is named and you are not.

Sources counts which third-party sites the engines cite, by engine, and flags high-priority sites where you are not yet present. It also counts which of your own pages get cited and when. An accuracy watch lists the latest answers that got your facts wrong, and the Action Plan links each optimization task to a prompt so you can see whether its mention rate moves after you ship.

The Response Log holds 2,000 tests. Over 25,000 formulas sit in locked cells and protection has no password, so you can unprotect any tab to customise it. Sample data from a fictional brand and fictional competitors is included so you can see every tab working before you add your own. Built for Microsoft Excel (desktop or Excel for the web) and contains no macros.