Weighting the Prompt Set: Demand Weights, the Weighted Mention Rate with SUMPRODUCT and the Gap to the Simple Average
Lessons in this course
- Your First AI Visibility Audit: a Prompt Set, Mention Rate, Citation Rate and the Rate by IntentFree
- Weighting the Prompt Set: Demand Weights, the Weighted Mention Rate with SUMPRODUCT and the Gap to the Simple Average Locked
- Mentions vs Citations: Citation Share, Linked-Mention Share, the Overall Share from Totals and a Chart Locked
- Share of Voice vs Competitors: Total Mentions, Share of Voice, Rank and the Gap to the Leader Locked
- Position in the Answer: a Weighted Score with SUMPRODUCT, Prominence per Mention and the Weighted Share of Voice Locked
- One Prompt Set, Four Assistants: Runs, Mention Rate and Citation Rate per Assistant with SUMIFS and the Strongest Assistant Locked
- Referral Traffic from AI Assistants: a Channel Mapping with XLOOKUP, Sessions per Channel, Conversion Rate and the AI Share Locked
- Which Pages Earn from AI Referrals: Engagement Rate, Conversion Rate, Revenue per Session, an Index with ROUND and a Chart Locked
- Content Gap Scoring: Gap to the Best Competitor, a Score from Demand and Business Value, Rank, Priority Labels and a Chart Locked
- Where the Answers Come From: Cited Domains, Citation Share by Source Type, Uncovered Third-Party Pages and an Outreach Rule Locked
- Tracking over Time: Weekly Mention Rate, a 4-Week Rate, the Trend with SLOPE, a FORECAST.LINEAR Projection and a Line Chart Locked
- Noise or Signal: Standard Error, Margin of Error, the Lower Bound and the Runs Needed for a Reliable Mention Rate Locked
- Did the Content Update Work? Before and After Rates, a Control Group and the Difference-in-Differences Locked
- Tone and Truth: Sentiment Counts, Net Sentiment, Error Rate per Assistant with SUMIFS and a Rule that Flags Wrong Answers Locked
- The Cluster × Assistant Grid: Mention Rates with Two-Criteria SUMIFS and Mixed References, the Spread per Cluster and a Heat Map Locked
- Head-to-Head with a Competitor: Exclusive and Shared Answers, Presence Rate, Co-Mention Share and Prompts Where You Lead Locked
- Forecasting AI Referrals: Month-over-Month Growth, the Compound Monthly Rate, a Linear and a Compound Projection and a Line Chart Locked
- What-If Grid: Citation Rate × Click Rate, Monthly Revenue with Mixed References, the Citation Rate Needed and the Target Zone Locked
- Prioritising the Backlog: Extra Mentions per Hour, Rank, Cumulative Hours in Rank Order and a Do-or-Later Decision Locked
- Final Project: AI Visibility Scorecard by Assistant with Mention Rate, Share of Voice, Citation Share, Referral Sessions, Status Flags and a Combo Chart Locked