Tabellab
Marketing Analytics Intermediate

AI Search Visibility & Answer Engines: Prompt Sets, Mention & Citation Share, Share of Voice, AI Referral Traffic & Content Gap Scoring

Measure how visible a brand is in AI assistants and answer engines. You will code a prompt set into mention and citation rates, weight prompts by demand, separate mentions from citations, calculate share of voice against competitors and weight it by position, split results by assistant, map referral traffic from AI assistants and judge its landing pages, then score content gaps, analyse cited sources, track rates over time with a trend and a forecast, put a margin of error on every rate, test a content update against a control group, audit sentiment and accuracy, build a cluster × assistant heat map, run a head-to-head against one rival, project referral growth, explore a what-if revenue grid, prioritise a backlog by value per hour and finish with a scorecard per assistant. 20 hands-on labs, fictional Quillfern Outdoors data, every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This course teaches the measurement side of visibility in AI search and answer engines, entirely in spreadsheet labs. You work as the analyst of Quillfern Outdoors, a fictional online retailer of hiking and camping gear, and build the workflow step by step: a fixed prompt set coded into mention and citation rates, demand weights, citation share, share of voice against competitors, position weighting, a breakdown by assistant, referral traffic from AI assistants and the pages it lands on. The second half goes deeper with content gap scoring, cited-source analysis, weekly tracking with trend and forecast, margins of error, a content update test with a control group, a sentiment and accuracy audit, a cluster by assistant heat map, a head-to-head against one rival, a what-if revenue grid and a prioritised backlog, and ends with a scorecard per assistant. Every task is checked instantly. All companies, prompts and numbers are fictional and all benchmarks are illustrative.

Why learn with Tabellab

  • Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
  • Verifiable certificatePass the final exam and get a certificate with a public verification code.
  • Try before you buyLesson 1 is free, with no sign-up or card needed.
  • Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint

Lessons

  1. Your First AI Visibility Audit: a Prompt Set, Mention Rate, Citation Rate and the Rate by IntentLabFree
  2. Weighting the Prompt Set: Demand Weights, the Weighted Mention Rate with SUMPRODUCT and the Gap to the Simple AverageLab Locked
  3. Mentions vs Citations: Citation Share, Linked-Mention Share, the Overall Share from Totals and a ChartLab Locked
  4. Share of Voice vs Competitors: Total Mentions, Share of Voice, Rank and the Gap to the LeaderLab Locked
  5. Position in the Answer: a Weighted Score with SUMPRODUCT, Prominence per Mention and the Weighted Share of VoiceLab Locked
  6. One Prompt Set, Four Assistants: Runs, Mention Rate and Citation Rate per Assistant with SUMIFS and the Strongest AssistantLab Locked
  7. Referral Traffic from AI Assistants: a Channel Mapping with XLOOKUP, Sessions per Channel, Conversion Rate and the AI ShareLab Locked
  8. Which Pages Earn from AI Referrals: Engagement Rate, Conversion Rate, Revenue per Session, an Index with ROUND and a ChartLab Locked
  9. Content Gap Scoring: Gap to the Best Competitor, a Score from Demand and Business Value, Rank, Priority Labels and a ChartLab Locked
  10. Where the Answers Come From: Cited Domains, Citation Share by Source Type, Uncovered Third-Party Pages and an Outreach RuleLab Locked
  11. Tracking over Time: Weekly Mention Rate, a 4-Week Rate, the Trend with SLOPE, a FORECAST.LINEAR Projection and a Line ChartLab Locked
  12. Noise or Signal: Standard Error, Margin of Error, the Lower Bound and the Runs Needed for a Reliable Mention RateLab Locked
  13. Did the Content Update Work? Before and After Rates, a Control Group and the Difference-in-DifferencesLab Locked
  14. Tone and Truth: Sentiment Counts, Net Sentiment, Error Rate per Assistant with SUMIFS and a Rule that Flags Wrong AnswersLab Locked
  15. The Cluster × Assistant Grid: Mention Rates with Two-Criteria SUMIFS and Mixed References, the Spread per Cluster and a Heat MapLab Locked
  16. Head-to-Head with a Competitor: Exclusive and Shared Answers, Presence Rate, Co-Mention Share and Prompts Where You LeadLab Locked
  17. Forecasting AI Referrals: Month-over-Month Growth, the Compound Monthly Rate, a Linear and a Compound Projection and a Line ChartLab Locked
  18. What-If Grid: Citation Rate × Click Rate, Monthly Revenue with Mixed References, the Citation Rate Needed and the Target ZoneLab Locked
  19. Prioritising the Backlog: Extra Mentions per Hour, Rank, Cumulative Hours in Rank Order and a Do-or-Later DecisionLab Locked
  20. Final Project: AI Visibility Scorecard by Assistant with Mention Rate, Share of Voice, Citation Share, Referral Sessions, Status Flags and a Combo ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy