elementskit logo

How to build an AI visibility dashboard with Semrush

how to build an ai visibility dashboard semrush.png

An AI visibility dashboard reveals you whether or not AI platforms cite and suggest your model. 

We’ll allow you to construct one which places your prompt-level AI information from Semrush subsequent to your page-level Google information from Search Console, so you’ll be able to see whether or not the pages AI cites are additionally incomes clicks.

On our check website, the primary refresh surfaced a information that AI solutions cited for 50 prompts and that earned zero Google clicks.

To construct your individual model visibility dashboard for AI search, you’ll want Semrush’s AI Visibility Toolkit, Google Search Console (GSC), Google Sheets, and a paid Claude plan. The Sheet holds your information. Claude turns it right into a stay, interactive dashboard. It took me about 90 minutes to construct out this dashboard the primary time and it takes 20 minutes to replace every week with contemporary information.

What this AI visibility dashboard will present

This dashboard reveals two measurements aspect by aspect: how seen your model is in AI solutions (from Semrush) and the way your pages carry out in Google (from GSC). Particularly, it tracks:

  • AI visibility price: the share of your tracked prompts the place your model seems
  • Mentions and cited pages from Semrush’s immediate monitoring
  • Generative AI impressions from GSC’s Generative AI performance report
  • Clicks, impressions, click-through price (CTR), and common place from GSC
  • A listing of search engine optimisation and reply engine optimization (AEO) alternatives primarily based in your actual information
AI visibility dashboard showing Semrush prompt tracking, cited pages, and Google Search Console performance metrics

There are two constraints to concentrate on earlier than you start:

  1. The dashboard runs as a Claude artifact that pulls stay information out of your Google Sheet by the Google Drive connector. The connector itself is out there to everybody, however artifacts that decision connectors require a paid Claude plan (Professional, Max, Staff, or Enterprise). 
  2. You may’t share it by public hyperlink. On Staff and Enterprise plans, you’ll be able to share it inside your group, and every viewer sees information provided that their Google account can open your Sheet and their Claude account has the Drive connector. On Professional and Max, it stays non-public to you.

It is a working dashboard for whoever owns reporting, not a hyperlink you ship to management. For stakeholder reporting, you’ll be able to ask Claude to show the dashboard’s report into an HTML file they’ll open in any browser even with out the connections.

Step 1: Resolve what you need to measure

Earlier than you open any instrument, resolve what you need to measure:

  • Your goal area, plus brand-name variations AI would possibly use
  • Which AI platforms you need to observe (Semrush’s Prompt Tracking helps ChatGPT, Google AI Mode, and Gemini)
  • Location and language
  • A secure set of prompts tied to how patrons truly speak to AI
  • Your required reporting interval, similar to the newest 28 days versus the earlier 28 days

Step 2: Arrange AI immediate monitoring in Semrush

To arrange AI immediate monitoring, create a marketing campaign within the Prompt Tracking instrument, which checks a hard and fast set of prompts in opposition to the chosen AI platform day by day and data whether or not your model seems.

Select and add your prompts

Add prompts that mirror how your buyers talk to AI. In case you can, mine buyer assist tickets, gross sales calls, and discussion board posts. You may feed transcripts and textual content posts into Claude to get higher immediate choices primarily based on the patterns it sees.

Unfold your prompts throughout the total journey relatively than clustering on model phrases. I used 30 prompts, six in every of 5 teams:

  1. Buyer issues: The problems your potential clients are coping with (e.g., “I used to be simply named executor of my dad’s property and don’t know the place to start out. What do I do first?”)
  2. Product or class discovery: When your clients don’t know your services or products exists but, they usually’re looking for an answer; e.g., “Is there software program that helps executors settle an property?”
  3. Comparisons: Evaluating your model to a competitor’s model; e.g., “Which is best for [your ideal customer or one specific problem you help solve], [your brand] or [competitor]?”
  4. Product choice: Researching services or products choices past direct comparability; e.g., “What are the perfect instruments for an property with no will?”
  5. Branded questions: Questions immediately about your model; e.g., “Is [brand] legit?”

Begin with round 30 prompts. Monitored day by day, that is roughly 200 observations every week, sufficient for a secure site-wide visibility price. The entry AI Visibility Toolkit plan covers 25 prompts, so 30 means a better tier or a immediate add-on.

Group-level numbers will swing. With six prompts per group, one immediate altering strikes that group’s price by 17 factors, so deal with group adjustments as results in examine. If stakeholders need reliable group-level reporting, broaden every group to 15 or extra prompts over time, and solely add prompts that mirror actual purchaser language.

Your branded prompts will virtually all the time present your model, which lifts your general price. Report on all prompts and non-branded solely. The non-branded quantity tells you whether or not AI recommends you to individuals who do not know you but.

Maintain the identical core prompts secure for not less than a month as soon as monitoring begins. Each development line in your dashboard is determined by the immediate set staying fixed. In case you swap prompts mid-stream, you break the reporting.

Semrush Position Tracking setup screen for adding AI prompts to a campaign before starting tracking

Manage your prompts with tags

Tag every immediate with the group it belongs to, so you’ll be able to evaluate visibility throughout significant segments as a substitute of 1 blended rating. 

In your marketing campaign, open the “Tags” tab and click on “Handle tags” to create and assign them. I used one tag for every of my 5 immediate teams. The screenshot under is from my Google AI Mode marketing campaign, which tracks a smaller set of prompts throughout the identical 5 teams. Semrush additionally reveals its personal subject groupings on this view, and you may ignore these for the dashboard.

Semrush AI Visibility Tags report showing visibility, mentions, and average position for different prompt groups

Step 3: Export your Semrush AI visibility information

You’ll must export two datasets from the AI Visibility Toolkit into Google Sheets: prompt-level efficiency from the monitoring marketing campaign you arrange in step 2, and the pages AI platforms cite. 

Neither dataset is out there by the Semrush API but, so the information will get to your Sheet by export. You may schedule these exports by way of electronic mail (extra on that under).

Export prompt-level efficiency

Your immediate monitoring marketing campaign opens in a Place Monitoring view with “AI Visibility” toggled on. As soon as the information is populated (it might take a couple of hours), scroll all the way down to the “High Prompts” part and click on “View all X prompts.” Then, click on “Export” within the top-right nook and select Google Sheets.

Semrush Position Tracking export menu with Google Sheets selected for exporting AI visibility data

It’s best to see one row per immediate, with a column group for every day displaying your model’s place within the reply, the reply kind, and the touchdown web page cited. A place of “-” means your model did not seem that day. You may reshape this within the grasp Sheet step.

Export cited pages and sources

In Visibility Overview, use the platform selector to choose the identical AI platform your monitoring marketing campaign follows, so your quotation information and immediate information describe the identical platform. Then scroll all the way down to the “Subjects & Sources” part. You’re going to export the Google Sheets information for each the “Cited Sources” and “Cited Pages” tabs. 

Visibility Overview holds months of historical past even in case you created your immediate monitoring marketing campaign yesterday, as a result of Semrush builds it from its personal ongoing evaluation of the AI reply house. My check website had a mentions development going again six months on day one.

Semrush Cited Pages report listing URLs cited in AI answers and the number of prompts citing each page

What to do if export is unavailable

If the export button is grayed out or lacking, verify your entry to the marketing campaign. If another person owns it, ask them to export the reviews for you or to vary your permissions. Nothing else on this workflow wants proprietor rights.

Attain out to Semrush support in case you encounter any difficulties right here.

Step 4: Export Google Search Console information

GSC information reveals what your pages truly earn in Google, subsequent to what AI solutions say about you. Which report you employ is determined by whether or not the Generative AI efficiency report has information in your property.

In case your Generative AI report has information

Open your property in GSC, go to “Efficiency,” and open the “Generative AI” report. Export it twice. As soon as with the date vary set to the final Three months, for the day by day development. As soon as set to the final 28 days, for the pages desk, so it matches your commonplace GSC window.

Google Search Console Generative AI report with impressions chart and export options for Sheets, Excel, and CSV

The export is a ZIP of separate one-dimension tables (day by day impressions, pages, nations, units). Impressions are at the moment the one metric accessible. 

There isn’t a prompt-to-click attribution; Google at the moment doesn’t offer you queries, clicks, or CTR information. The pages desk is aggregated throughout the entire date vary relatively than damaged out by day.

In case your Generative AI report is empty

The Generative AI report is out there to each property, nevertheless it reveals information solely as soon as your pages get sufficient impressions in AI Overviews and AI Mode. If yours is empty or skinny, use the usual “Search outcomes” efficiency report as a substitute. Export page-level clicks, impressions, CTR, and common place for 2 matched 28-day home windows.

Finish every export window 2-Three days earlier than right now, as a result of the most recent GSC information is incomplete and can undercount. Maintain the home windows the identical size so interval comparisons are constant.

Word that that is general Google Search efficiency, not AI-specific visibility, so label it that method in your dashboard. 

Step 5: Manage every thing in a single grasp Google Sheet

Put each export into one Google Sheet with a hard and fast tab construction. Mine ended up with seven information tabs, every holding one dataset:

  • semrush_prompts: prompt-level outcomes reshaped to at least one row per immediate per day, with columns for date, immediate, platform, tag, place, and cited touchdown web page
  • semrush_cited_pages: the cited pages export, stamped with a snapshot date
  • semrush_source_domains and semrush_topics: the Visibility Overview exports, identical stamping (subjects is non-obligatory)
  • gsc_genai_daily and gsc_genai_pages: the day by day desk out of your 3-month Generative AI export and the pages desk out of your 28-day one
  • gsc_pages: commonplace page-level GSC information, one row set per 28-day window

Here’s a immediate you’ll be able to feed to Claude together with all of the exports to have it construct the sheet for you:

On future weekly updates, I will connect the present grasp sheet (downloaded as .xlsx) plus new exports. 

Claude generated master sheet containing tracked AI prompts, tags, positions, platforms, and landing pages

Step 6: Flip the Google Sheet right into a stay Claude artifact

Subsequent, we’ll flip the Sheet right into a dashboard by asking Claude to construct a stay artifact that reads the Sheet by your Google Drive connector.

Join the Google Sheet to Claude

Join Google Drive in Claude’s connector settings, then verify Claude can open the grasp Sheet earlier than asking for something visible. The connector lets the artifact re-read the stay Sheet on demand, so it updates each time you add the brand new information.

Claude connectors settings showing Google Drive and Semrush connected for accessing dashboard data

Inform Claude what to incorporate

Immediate Claude to construct the visible dashboard linked to your grasp sheet. Be sure to exchange [sheet name] along with your Sheet’s identify and [domain] along with your area:

The freshness warnings cease you from presenting stale information as present, and the “evaluate, by no means mix” instruction retains information separate. The chance part in that immediate is how the dashboard makes suggestions primarily based on the information.

In your first construct, the prompt-tracking charts will present only some days of information. That is anticipated.

On our check website, the primary refresh flagged three issues that went straight onto the content material plan. Step Eight walks by each.

Step 7: Take a look at that the dashboard updates accurately

The entire level of the dashboard is to trace visibility over time, so that you’ll need to ensure it updates correctly. Take a look at the connection by altering one quantity within the Sheet and confirming it strikes within the dashboard. 

Edit a clicks worth within the “gsc_pages” tab, refresh the artifact, and verify that the matching KPI card adjustments. Examine the data-freshness stamp reveals the present learn, then undo the edit.

If a piece of the dashboard goes empty after a Sheet edit, evaluate your column headers in opposition to the unique construction. They should match precisely.

Step 8: Evaluate the dashboard and prioritize actions

Use the dashboard to resolve what to work on subsequent. This is how we learn the three findings from our check website’s first refresh:

  • A web page AI cites that earns no Google clicks: Our executor guidelines was cited for 50 prompts and earned zero clicks. AI platforms already belief the web page, so the work is on the Google aspect. Discover a key phrase it may well realistically rank for, refresh the web page round it, and build links to it.
  • Rivals cited the place you are not: Our competitor list was led by domains cited for seven prompts every. Open these prompts and browse what will get cited. That is your checklist of comparability and class content material to create, and of listicles to get talked about in.
  • A complete immediate group with no presence: We had zero visibility throughout all six customer-problem prompts. One weak web page does not clarify that. It factors to lacking content material, so these six prompts turned the temporary for brand spanking new top-of-funnel items.

As your historical past builds, look ahead to these patterns too:

  • A web page rating nicely in Google however rarely cited by AI often wants clearer construction: direct solutions, descriptive headings, and present dates that make passages straightforward to carry
  • A web page dropping mentions after a content material change is your early warning to evaluation the edit
  • Subjects enhancing throughout each AI solutions and Google search are your proof of what works, so doc what these pages have in widespread

You’ll additionally see an “Alternatives” part, the place Claude opinions the overlap between GSC and Semrush information and offers you recommendations on the way to enhance your AI visibility. 

AI visibility dashboard opportunities section comparing Google traffic, AI citations, prompts, and competitor sources

For instance, a web page can rank nicely in Google and nonetheless by no means seem in ChatGPT. ChatGPT pulls from its own web index, so a powerful Google rating does not assure a quotation. Examine whether or not the web page solutions the tracked immediate immediately, and whether or not the sources ChatGPT does cite for that immediate point out you. If Bing and Copilot matter to you, Semrush’s Place Monitoring instrument tracks Bing rankings, and you may add that information to the dashboard with one further export.

Step 9: Replace the dashboard every week

You’ll must replace the Sheet on a hard and fast weekly routine to maintain the information correct. Every week, ideally on the identical day:

  1. Export the newest immediate monitoring information (or accumulate it from the scheduled export electronic mail)
  2. Export the newest Cited Pages  and Cited Sources tables from Visibility Overview
  3. Export the newest GSC information, ending the window 2-Three days prior
  4. Append the brand new rows with the brand new snapshot date, then carry the up to date file into the identical Google Sheet with File > Import > Substitute spreadsheet. In case you import it as a brand new file, the dashboard can preserve studying the outdated one. 
  5. Refresh the artifact and ensure the freshness stamps up to date
  6. Word any main content material adjustments or campaigns within the Sheet, so subsequent month you’ll be able to join actions to causes

Whenever you replace the sheet, preserve the following pointers in thoughts: 

  • Maintain the identical headers
  • Stamp each Semrush export batch with its snapshot date
  • Append new rows relatively than changing outdated ones so that you get comparability information 
  • Normalize URLs constantly throughout tabs

In case you don’t normalize URLs, GSC can report a few of your pages twice; as soon as with a trailing slash and as soon as with out. In case your page-level numbers ever look absurdly low, URL variants are the very first thing to verify.

Construct your AI visibility dashboard

A model visibility dashboard for AI search reveals you ways usually AI cites and mentions your model, subsequent to what those self same pages earn in Google.

Open the AI Visibility Toolkit, create your first monitoring marketing campaign, and write 30 prompts the way in which your patrons truly ask. Then join that information along with your grasp sheet and construct the dashboard in Claude.

And if it is advisable to present the dashboard to stakeholders, ask Claude to show the artifact right into a shareable HTML file with the identical information.

Related Post

1 Comment

Leave a Reply

Your email address will not be published. Required fields are marked *