TutorialPractitioner7 min read

AI search visibility dashboard in Looker Studio

Build a Looker Studio board for AI Assistant referrals, Search Console AI data and MentionX-style prompt tracking in Sheets.

Dipuck Jones
Written by Founder of MentionX · 13+ years in B2B SaaS growth and SEO
Reviewed
Short answer

An AI visibility dashboard is the board leadership asks for after they hear "ChatGPT is the new homepage." Build it as three honest lanes — GA4 AI Assistant referrals, Search Console Generative AI surfaces, and a prompt-tracking Sheet for citation checks — never as one fake "AI traffic" number. This lesson wires the board in Data Studio and links the Academy measurement track.

Key takeaways
  • Three lanes, three scorecard groups, one cover that defines them.
  • GA4 AI Assistant ≠ Search Console Generative AI ≠ prompt mention rate.
  • Put MentionX-style scans in Sheets or BigQuery, then connect.
  • Weekly cadence beats real-time theatre.
  • Link deep dives: Track AI traffic in GA4, monthly AI visibility report template.

Checked 5 November 2026 (CET) against Google Cloud Data Studio documentation, the Data Studio product page, the Looker Studio-is-Data-Studio blog post, connector help pages and the Analytics Help pages cited in Sources. Google renames and moves features often, so confirm labels and limits in your own account. "Our view" marks MentionX opinion. Ledgerline is a fictional company used for illustration.

01What are the three lanes?

LaneSourcePrimary metricsCommon mistake
Assistant referralsGA4Sessions, engaged sessions, key events by session source (chatgpt.com, perplexity.ai, gemini.google.com, …)Mixing into Organic Search
Search generativeSearch Console GenAI export or connector fieldsImpressions, clicks by AI Mode / AI Overviews (use columns your property shows)Calling these "ChatGPT clicks"
Prompt visibilitySheets / BigQuery from scans% prompts mentioned, share of voice vs competitors A–D, cited URL rateInventing daily ranks without a scan log

02How do you build lane 1 (GA4)?

  1. Reuse the GA4 owner data source.
  2. Scorecard: sessions where Session default channel group = AI Assistant.
  3. Table: Session source, Sessions, Engaged sessions, Key events, filtered to AI Assistant.
  4. Time series of AI Assistant sessions.
  5. Optional: landing page table filtered to AI Assistant for content winners.
  6. Caption: "Excludes AI Mode and AI Overviews (those are Organic Search / Search Console)."

Cross-check GA4 AI Assistant channel regex and GTM AI referral traffic if tagging is incomplete. Note Direct undercount for app clicks (AI referral traffic undercounted).

03How do you build lane 2 (Search Console Generative AI)?

  1. Prefer a weekly Sheet export from the Generative AI performance report until you confirm connector fields in-account.
  2. Columns to aim for: Date, Search appearance / surface, Impressions, Clicks (match your UI).
  3. Scorecards split by surface when available.
  4. Caption linking Search Console generative AI performance report and Gemini Search Console AI reports.

04How do you build lane 3 (prompt tracking Sheet)?

Suggested schema for ai_prompt_tracking:

ColumnTypeExample
scan_dateDate2026-11-10
engineTextchatgpt / perplexity / gemini / claude
promptTextbest ap automation for mid market
brand_mentionedText YES/NOYES
positionNumber or null2
cited_urlTexthttps://ledgerline.example/ap
competitor_mentionedTextA,C
notesText

Connect Sheets with 15-minute or longer freshness. Scorecards:

  • Mention rate = COUNT of YES / COUNT of rows (chart-level).
  • Mentions by engine (stacked bar).
  • Top cited URLs table.
  • Competitor co-mention table (keep competitors as A–D in Academy examples; real brands OK on client boards).

Automate scans with n8n AI visibility monitoring or MentionX exports — agents draft, humans approve outbound.

05Page layout

PageContent
CoverDefinitions of the three lanes + owner + cadence
AssistantsGA4 lane
Search generativeGSC lane
Prompt trackerSheet lane + engine comparison
ActionsTop 5 URLs to improve + owners (manual text or Sheet)

Mirror the executive GEO dashboard template for the one-pager version leadership wants.

06Worked example: Ledgerline

Ledgerline is a fictional accounts-payable software company. Details are illustrative.

Lane28-day snapshot (illustrative)
AI Assistant sessions1,940
chatgpt.com share58%
GenAI export clicks620
Prompt mention rate (40 prompts × 4 engines)34%
Competitor A mention rate41%

Walkthrough

  1. Marketing tried one "AI traffic" scorecard; the CMO rejected it after a confusing QBR.
  2. Three-lane cover fixed the vocabulary in a week.
  3. Prompt Sheet highlighted missing /integrations citations.
  4. Weekly Slack used a scheduled PDF of the Assistants page only.
  5. They aligned KPIs with AI visibility KPIs for marketing teams.

07Sample weekly narrative (for Slack or PDF note)

AI visibility week {n}
- Assistants: {sessions} sessions ({wow}% wow); top source {source}
- Search generative: {genai_clicks} clicks (export)
- Prompt mention rate: {rate}% on {n_prompts} prompts × {n_engines} engines
- Action: {owner} to ship {url} fixes by {date}

Keep the narrative next to the dashboard so screenshots do not lose the story.

08Engine coverage vs traffic coverage

Prompt tracking might include Claude and others that send little or no web referrer. That is fine — lane 3 is about answers, lane 1 is about visits. See Claude visibility, ChatGPT track, Perplexity track, Gemini track.

09How do you keep sample sizes honest?

Small prompt sets swing wildly week to week. Publish the denominator next to every mention-rate scorecard (n = prompts × engines × days). Link interpreting week-over-week visibility swings and statistical confidence for AI visibility tracking from the appendix. If n is tiny, show a qualitative table of prompts instead of a precision percentage.

10Sheet automation options

MethodProsCons
Manual weekly paste from MentionXSimpleHumans forget
n8n workflow writing rowsRepeatableNeeds maintenance (n8n AI visibility monitoring)
BigQuery load then Data StudioScalesNeeds eng

Agents draft; humans approve anything customer-facing. Do not auto-tweet scan results from a dashboard webhook.

11What decisions does this board unlock?

SignalDecision
Assistant sessions up, key events flatFix landing pages cited by assistants
GenAI impressions up, clicks flatImprove titles/snippets for AI Mode surfaces
Mention rate down vs competitor AShip comparison and integration pages
Cited URLs concentrate on /blog onlyPush product and docs pages into the citation set

If the board does not change a backlog item within two weeks, it is decoration. Tie each lane to an owner in the Actions page.

12Common mistakes

  • One number for all AI.
  • Prompt scores without timestamps or engine labels.
  • Treating MentionX position like Google rank.
  • Daily panic on small prompt samples — see interpreting week-over-week visibility swings.
  • No link to content owners.

13Try it yourself

Create the three-lane cover. Wire GA4 AI Assistant. Add a 10-row illustrative prompt Sheet. Add a GenAI Sheet stub. Schedule a weekly email to yourself.

14Quick quiz

1. Name the three lanes.

Answer: GA4 AI Assistant referrals; Search Console Generative AI; prompt-tracking Sheet/warehouse.

2. Where do AI Mode impressions belong?

Answer: Search Console Generative AI lane (not GA4 AI Assistant).

3. Why timestamp every prompt row?

Answer: So week-over-week mention rate is computable and auditable.

15What should you check before the next lesson?

  • Cover definitions live on every page.
  • Prompt schema includes engine + date + YES/NO.
  • No single "AI traffic" mega-metric.

Previous: Cross-channel ROI with blended Looker Studio data. Next: Executive reporting with Looker Studio. Or return to the Looker Studio for Marketers track. Related: Monthly AI visibility report template, AI visibility tracker setup, Perplexity for Marketers, ChatGPT for Marketers, Claude for Marketers.

16Common questions

What should an AI visibility dashboard include? Three lanes: GA4 AI Assistant referrals (ChatGPT, Perplexity, Gemini app and similar), Search Console Generative AI performance for AI Mode and AI Overviews, and a prompt-tracking Sheet for citation and recommendation checks.

Can MentionX scan results feed Looker Studio? Yes. Export or sync scan results into Google Sheets or BigQuery, then connect that table. Keep engine, prompt, date, mentioned (yes/no), position and cited URL as columns.

Should AI Mode sit in the same scorecard as ChatGPT referrals? No. AI Mode and AI Overviews are Search generative surfaces (Search Console). ChatGPT and similar assistants are referral traffic (GA4 AI Assistant). Report them in separate scorecards.

Questions people ask

3 answers

What should an AI visibility dashboard include?

Three lanes: GA4 AI Assistant referrals (ChatGPT, Perplexity, Gemini app and similar), Search Console Generative AI performance for AI Mode and AI Overviews, and a prompt-tracking Sheet for citation and recommendation checks.

Can MentionX scan results feed Looker Studio?

Yes. Export or sync scan results into Google Sheets or BigQuery, then connect that table. Keep engine, prompt, date, mentioned (yes/no), position and cited URL as columns.

Should AI Mode sit in the same scorecard as ChatGPT referrals?

No. AI Mode and AI Overviews are Search generative surfaces (Search Console). ChatGPT and similar assistants are referral traffic (GA4 AI Assistant). Report them in separate scorecards.

Sources

  1. Analytics Help, Default channel groupsupport.google.com
  2. Search Console Help, Generative AI performance reportsupport.google.com
  3. Google Cloud, Connect to Google Sheetscloud.google.com
  4. All accessed 5 Nov 2026.
Written and reviewed by Dipuck JonesHow we research and testReport an error