Tabellab

The Cluster × Assistant Grid: Mention Rates with Two-Criteria SUMIFS and Mixed References, the Spread per Cluster and a Heat Map

Lesson 15 of 20 Lab 🔒 Locked

Lessons in this course

  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