# 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.

Source: https://mentionx.ai/learn/looker-studio/looker-studio-ai-visibility-dashboard  
Author: Dipuck Jones, founder of MentionX  
Updated: 5 November 2026  
Level: Practitioner

**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](https://mentionx.ai/learn/measurement/track-ai-traffic-ga4), [monthly AI visibility report template](https://mentionx.ai/learn/measurement/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.*

## What are the three lanes?

| Lane | Source | Primary metrics | Common mistake |
|---|---|---|---|
| Assistant referrals | GA4 | Sessions, engaged sessions, key events by session source (chatgpt.com, perplexity.ai, gemini.google.com, …) | Mixing into Organic Search |
| Search generative | Search Console GenAI export or connector fields | Impressions, clicks by AI Mode / AI Overviews (use columns your property shows) | Calling these "ChatGPT clicks" |
| Prompt visibility | Sheets / BigQuery from scans | % prompts mentioned, share of voice vs competitors A–D, cited URL rate | Inventing daily ranks without a scan log |

## How 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](https://mentionx.ai/learn/ga4/ga4-ai-assistant-channel-regex) and [GTM AI referral traffic](https://mentionx.ai/learn/gtm/gtm-ai-referral-traffic-ga4) if tagging is incomplete. Note Direct undercount for app clicks ([AI referral traffic undercounted](https://mentionx.ai/learn/measurement/ai-referral-traffic-undercounted)).

## How 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](https://mentionx.ai/learn/search-console/search-console-generative-ai-performance-report) and [Gemini Search Console AI reports](https://mentionx.ai/learn/gemini/gemini-search-console-ai-reports).

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

Suggested schema for `ai_prompt_tracking`:

| Column | Type | Example |
|---|---|---|
| scan_date | Date | 2026-11-10 |
| engine | Text | chatgpt / perplexity / gemini / claude |
| prompt | Text | best ap automation for mid market |
| brand_mentioned | Text YES/NO | YES |
| position | Number or null | 2 |
| cited_url | Text | https://ledgerline.example/ap |
| competitor_mentioned | Text | A,C |
| notes | Text | |

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](https://mentionx.ai/learn/n8n/n8n-ai-visibility-monitoring) or MentionX exports — agents draft, humans approve outbound.

## Page layout

| Page | Content |
|---|---|
| Cover | Definitions of the three lanes + owner + cadence |
| Assistants | GA4 lane |
| Search generative | GSC lane |
| Prompt tracker | Sheet lane + engine comparison |
| Actions | Top 5 URLs to improve + owners (manual text or Sheet) |

Mirror the [executive GEO dashboard template](https://mentionx.ai/learn/templates/executive-geo-dashboard-1-page-kpi) for the one-pager version leadership wants.

## Worked example: Ledgerline

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

| Lane | 28-day snapshot (illustrative) |
|---|---|
| AI Assistant sessions | 1,940 |
| chatgpt.com share | 58% |
| GenAI export clicks | 620 |
| Prompt mention rate (40 prompts × 4 engines) | 34% |
| Competitor A mention rate | 41% |

### 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](https://mentionx.ai/learn/measurement/ai-visibility-kpis-marketing-teams).

> **Pro move:** put the three definitions in a persistent text box on every page, not only the cover. Screenshots travel without context.

## Sample 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.

## Engine 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](https://mentionx.ai/learn/claude/measure-brand-visibility-claude), [ChatGPT track](https://mentionx.ai/learn/chatgpt/chatgpt-for-marketers), [Perplexity track](https://mentionx.ai/learn/perplexity/perplexity-for-marketers), [Gemini track](https://mentionx.ai/learn/gemini/gemini-for-marketers).

## How 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](https://mentionx.ai/learn/measurement/interpreting-week-over-week-visibility-swings) and [statistical confidence for AI visibility tracking](https://mentionx.ai/learn/measurement/statistical-confidence-ai-visibility-tracking) from the appendix. If n is tiny, show a qualitative table of prompts instead of a precision percentage.

## Sheet automation options

| Method | Pros | Cons |
|---|---|---|
| Manual weekly paste from MentionX | Simple | Humans forget |
| n8n workflow writing rows | Repeatable | Needs maintenance ([n8n AI visibility monitoring](https://mentionx.ai/learn/n8n/n8n-ai-visibility-monitoring)) |
| BigQuery load then Data Studio | Scales | Needs eng |

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

## What decisions does this board unlock?

| Signal | Decision |
|---|---|
| Assistant sessions up, key events flat | Fix landing pages cited by assistants |
| GenAI impressions up, clicks flat | Improve titles/snippets for AI Mode surfaces |
| Mention rate down vs competitor A | Ship comparison and integration pages |
| Cited URLs concentrate on /blog only | Push 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.

## Common 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](https://mentionx.ai/learn/measurement/interpreting-week-over-week-visibility-swings).
- **No link to content owners.**

## Try 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.

## Quick 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.

## What 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](https://mentionx.ai/learn/looker-studio/looker-studio-cross-channel-roi-blend). Next: [Executive reporting with Looker Studio](https://mentionx.ai/learn/looker-studio/looker-studio-executive-reporting). Or return to the [Looker Studio for Marketers track](https://mentionx.ai/learn/looker-studio/looker-studio-for-marketers). Related: [Monthly AI visibility report template](https://mentionx.ai/learn/measurement/monthly-ai-visibility-report-template), [AI visibility tracker setup](https://mentionx.ai/learn/measurement/ai-visibility-tracker-setup-15-minutes), [Perplexity for Marketers](https://mentionx.ai/learn/perplexity/perplexity-for-marketers), [ChatGPT for Marketers](https://mentionx.ai/learn/chatgpt/chatgpt-for-marketers), [Claude for Marketers](https://mentionx.ai/learn/claude/claude-for-marketers).

## Common 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.
## Sources

- Analytics Help, [Default channel group](https://support.google.com/analytics/answer/9756891?hl=en)
- Search Console Help, [Generative AI performance report](https://support.google.com/webmasters/answer/16984139)
- Google Cloud, [Connect to Google Sheets](https://cloud.google.com/looker/docs/studio/connect-to-google-sheets)
- All accessed 5 Nov 2026.

## Frequently asked 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.

---

Written and reviewed by Dipuck Jones for MentionX Learn. The HTML version of this page: https://mentionx.ai/learn/looker-studio/looker-studio-ai-visibility-dashboard