Part 1: AI Tools

AI Assistants Comparison

Tool Best For Key Strength Pricing
ChatGPT Complex modeling, calculations Code Interpreter for data analysis VERIFY on openai.com
Claude Long documents, detailed writing Large context window, nuanced output VERIFY on anthropic.com
Gemini Google Workspace users Native Sheets and Docs integration VERIFY on google.com
Perplexity Research with sources Real-time search, automatic citations VERIFY on perplexity.ai

When to Use Each Tool

Task Recommended Tool
Financial modeling with calculations ChatGPT (Code Interpreter)
Analyzing lengthy reports or contracts Claude
Working in Google Sheets/Docs Gemini
Market research with citations Perplexity
Quick ad-hoc analysis Any of the above

Revenue Intelligence Platforms

Platform Best For Website
Clari Forecast accuracy, pipeline inspection clari.com
Gong Conversation intelligence, coaching gong.io
Aviso AI-driven scenario planning aviso.com

Note: Clari and Salesloft completed a merger in early December 2025. VERIFY current product packaging and branding.

Financial Planning (FP&A) Tools

Tool Type Options Best For
Spreadsheet-Native Cube, Datarails, Vena Teams keeping Excel workflows
Connected Planning Drivetrain, Planful Mid-market to enterprise modeling
SMB Focused Mosaic Accessible insights, lower complexity

CRM and Lead Generation

Platform Best For Website
Salesforce Enterprise, deep customisation salesforce.com
HubSpot Mid-market, integrated marketing/sales hubspot.com
Apollo.io Predictive lead scoring apollo.io
Drift AI chatbot lead qualification drift.com

Part 2: AI Prompts

Global AI Safety Line

Method Use When Data Needed Typical Fit
Bottom-Up Sales-driven, reliable pipeline Leads, conversion rates, deal sizes Short-term planning
Top-Down Market expansion planning Market size, share estimates Strategic planning
Weighted Pipeline Active CRM opportunities Stage probabilities, close dates Pipeline-heavy models
Time Series Stable, recurring revenue 12+ months history, 24+ for seasonality Baseline planning
Cohort-Based Subscription business Retention curves by cohort SaaS forecasting
Scenario-Based High uncertainty Multiple assumption sets Range planning

Paste this at the start of any AI prompt involving data, forecasts, or analysis:

“If unsure about any assumption, growth rate, or projection, write ‘VERIFY:’ next to it. Do not invent financial data or benchmarks. Flag all assumptions explicitly. This is for internal planning and is not financial advice. Past performance does not guarantee future results.”

Revenue Analysis Prompts

Calculation Formula
Growth Rate (New – Old) / Old × 100
CAGR ((End Value / Start Value)^(1/Years)) – 1

Trend Analysis

“analyse this revenue data and identify: (1) trends over time, (2) top performing segments, (3) areas of concern, (4) recommended actions. Present findings in a table format with supporting calculations.”

Variance Analysis

AI PROMPT

“Compare actual results to forecast. Calculate variance by line item (amount and percentage). Identify the top 3 drivers of variance. Suggest whether each variance is one-time or recurring.”

Cohort Analysis

AI PROMPT

“analyse revenue by customer cohort. Calculate retention rates at months 3, 6, and 12. Identify which cohorts are performing above or below average. Note any trends in cohort quality over time.”

Pipeline Health Check

AI PROMPT

“Review this pipeline data. Calculate weighted pipeline by stage. Identify deals at risk (aged beyond typical cycle, no recent activity). Calculate pipeline coverage ratio against target.”

Competitive Pricing Review

AI PROMPT

“Compare our pricing to these competitor data points. Identify where we are premium, at parity, or below market. Suggest positioning implications. Note any gaps in the data.”

Forecast Prompts

Calculation Formula
Weighted Pipeline Sum of (Deal Value × Stage Probability)
Pipeline Coverage Pipeline Value / Revenue Target
Velocity (Opportunities × Win Rate × Deal Size) / Cycle Length

Lead-to-Revenue Forecast

AI PROMPT

“Create a lead-to-revenue forecast for the next [X] months using these inputs: [lead volume by channel], [conversion rates by stage], [average deal size], [sales cycle length]. Provide monthly projections and a sensitivity analysis.”

Sales Capacity Forecast

AI PROMPT

“Create a sales capacity forecast using: [current ramped reps], [planned hires and start dates], [ramp time], [quota per rep], [historical attainment]. Show monthly capacity and revenue projections.”

MRR Waterfall Forecast

AI PROMPT

“Create an MRR forecast for [X] months. Starting MRR: [amount]. Historical averages: New [X], Expansion [X], Contraction [X], Churn [X]. Provide a monthly waterfall table and ending ARR.”

Three-Scenario Forecast

AI PROMPT

“Create conservative, base case, and optimistic scenarios for [time period]. Variables to model: [list with ranges]. Provide a comparison table and identify decision triggers for each scenario.”

Quarterly Forecast Update

“Update the annual forecast based on Q[X] results. Original forecast: [X]. YTD actual: [X]. Provide revised quarterly projections, variance analysis, and updated assumptions.”

Complaint Response Prompts

Guest Complaint Response

“Draft a response to this guest complaint using the HEARD framework. Acknowledge the specific issue, apologize sincerely, offer a concrete resolution, and close with follow-up commitment. Keep tone warm but professional.”

Online Review Response

“Draft a response to this negative review. Keep it brief (under 100 words). Acknowledge the issue, apologize, explain one action taken, and invite private follow-up. Do not be defensive.”

Internal Incident Summary

“Summarize this complaint for internal documentation. Include: guest name, date, issue summary, root cause (if known), resolution provided, recovery gesture, follow-up status, and recommendations to prevent recurrence.”

Meeting and Communication Prompts

Meeting Preparation

AI PROMPT

“Summarize the key points from this document. Create a bullet list of discussion topics and potential questions I should be prepared to answer.”

Executive Summary

AI PROMPT

“Create an executive summary of this report in 3-5 bullet points. Focus on: key findings, implications, and recommended actions. Keep language direct and avoid jargon.”

Email Draft

“Draft a professional email to [recipient] about [topic]. Tone should be [formal/friendly/urgent]. Include: context, key message, specific ask, and next steps.”

Part 3: Forecasting

Forecasting Methods

Forecasting Formulas

Growth and Trend

Pipeline

Note: Velocity is a heuristic. VERIFY stage consistency and cycle definition.

SaaS / Recurring Revenue

Forecast Accuracy

If Actual values can be zero or near zero, consider Mean Absolute Error or scaled errors instead of MAPE.

Forecast Categories

Example thresholds (VERIFY your internal definitions):

Time Series Data Requirements

At least 12 monthly points helps estimate a baseline trend

Ideally at least two full seasonal cycles for seasonality

For monthly seasonality, this often means 24+ months

Data requirements are method-specific. VERIFY for your approach.

Stage Probability Guidance

Probabilities should be based on recent win rates

Use data that reflects current process, pricing, and ICP

VERIFY the lookback window that best reflects present conditions

Update probabilities quarterly with recent performance data

Part 4: Service Recovery

Service Recovery Frameworks

HEARD (Detailed Recovery)

LAST (Quick Recovery)

Other Common Frameworks

Most frameworks emphasize listening, apology, action, and closure.

The Service Recovery Paradox

Some studies find that strong recovery can raise satisfaction above no-failure cases, under specific conditions.

The paradox, when it appears, is more likely after:

A one-time failure (not a pattern)

An exceptional recovery (exceeds expectations)

Swift response

Genuine empathy and personalization

Caution: The paradox does not justify allowing failures. Prevention remains the priority.

Script Building Blocks

Empathy Phrases

“I completely understand why you feel that way.”

“That sounds incredibly frustrating.”

“I would feel the same way in your position.”

Ownership Phrases

“Let me take responsibility for getting this resolved.”

“My name is [name], and I will own this until it is fixed.”

“This is on us, and I am going to make it right.”

Clarity Phrases

“Here is exactly what I will do next.”

“You will hear from me by [specific time].”

“Let me confirm: you would like [summary]. Is that correct?”

Boundary Phrases

“While I am not able to offer [X], I can absolutely do [Y].”

“Our policy does limit [X], but here is what I am empowered to do.”

Appreciation Phrases

“Thank you for telling us directly. It gives us a chance to fix this.”

“I appreciate you giving us the opportunity to make this right.”

Do Not Say / Say Instead

Complaint Scripts by Situation

Room or Facility Issue

Opening: “Thank you for letting us know. I am sorry you are dealing with this.”

Resolve: “I can send engineering immediately, or move you to a different room. Which would work better?”

Recovery: “I would like to offer [amenity/late checkout] as an apology.”

Service Delay

Opening: “I am very sorry for the wait. Your time is valuable.”

Resolve: “Right now, I can have [service] with you in [time].”

Recovery: “Given the delay, I would like to [waive fee/provide complimentary item].”

Staff Attitude

Opening: “I am truly sorry you felt spoken to that way.”

Acknowledge: “Regardless of intent, the impact on you matters most.”

Action: “I will address this directly with the team member.”

Billing Dispute

Opening: “Thank you for bringing this to my attention.”

Clarify: “Here is how the charge appears and what it relates to.”

Resolve: “Here are the options: [adjust/remove/explain]. Which feels fair to you?”

Online Review Response Template

Dear [Name],

Thank you for sharing your experience. I am sorry that your stay fell short of your expectations and our standards.

You mentioned [specific issue]. We take full responsibility. Since your stay, we have [action taken].

I would welcome the chance to speak with you at [contact] and personally oversee your next visit.

[Your Name, Title]

Part 5: Empowerment and Escalation

Sample Empowerment Matrix

VERIFY and customise for your organisation.

Key principle: Poor reviews can reduce demand and pricing power. Small recovery gestures can be cost-effective compared with reputational damage.

Escalation Decision Tree

Safety or legal issue? → Escalate immediately

Media or public relations risk? → Escalate immediately

Beyond my empowerment level? → Escalate to next level

Guest requests manager? → Honor the request

Repeat complaint from same guest? → Escalate for review

Within my authority and solvable now? → Resolve and document

Response Time Targets

VERIFY targets for your operation.

Part 6: Benchmarks

VERIFY all benchmarks for your industry, stage, and context.

SaaS Metrics (General Guidance)

Pipeline Coverage (General Guidance)

Coverage needs depend on win rates and deal velocity.

MAPE Targets

Some teams target low double-digit MAPE for stable, mature revenue lines. VERIFY targets by forecast horizon, volatility, and business model.

Part 7: Checklists

Before Using AI Output

Numbers verified against source data

Calculations spot-checked manually

Claims checked for VERIFY tags

Tone appropriate for audience

No hallucinated facts or made-up sources

Compliant with company policies

Before Running a Forecast

Data is current and complete

Definitions are consistent

Outliers identified and explained

Source documented

Before Presenting a Forecast

Assumptions documented and labeled

VERIFY tags on unvalidated assumptions

Sensitivity analysis completed

Ranges provided, not just point estimates

Comparison to prior forecasts included

Risks and opportunities noted

Forecast Accuracy Improvement

Review forecast vs. actual monthly

Identify patterns in errors

Update conversion rates quarterly

Remove stale pipeline deals

Validate assumptions against recent data

Document reasons for significant misses

Service Recovery Completion

Guest felt heard (confirmed understanding)

Sincere apology delivered

Concrete action taken or scheduled

Recovery gesture offered (if appropriate)

Follow-up commitment made

Incident documented for team learning

Data Quality Check

Data updated within acceptable window

No gaps or missing periods

Metrics defined consistently

Outliers identified

Source documented

Part 8: Training Tips

AI Tool Adoption

Start with one tool for one use case

Build prompt templates for common tasks

Document what works in a shared playbook

Review outputs before sharing externally

Update prompts as you learn what works

Forecasting Discipline

Document every assumption explicitly

Assign an owner to each assumption

Set review dates for key assumptions

Update forecasts regularly (weekly for pipeline, monthly for financial)

Present ranges, not false precision

Track forecast changes to identify bias

Service Recovery Training

Role-play scenarios in pre-shift briefings

Build familiarity through repetition

Create a non-blame culture for empowerment

Document and share recovery wins

Clarify escalation paths clearly

Reinforce the “why” behind recovery gestures

Part 9: Common Mistakes

AI Usage Mistakes

Forecasting Mistakes

Service Recovery Mistakes

Part 10: Resources

Tool Websites

Pricing Pages

Further Reading

SaaS Capital Retention Benchmarks

Bessemer State of the Cloud

CFI Financial Modeling Guide

Gartner Peer Insights

G2 Grid Reports

Emergency Contacts Template

Fill in for your organisation:

Five Things to Remember Every Day

Listen first. Let people finish before responding.

Own it. Take responsibility, even when fault is unclear.

Be specific. Vague promises erode trust.

Follow up. Close every loop you open.

Verify. AI helps, but human judgment decides.

Disclaimer

This quick reference card summarizes guidance from AI Crash Course materials. All frameworks, formulas, prompts, and scripts should be customised for your organisation, verified against current policies, and adapted to local regulations. Items marked VERIFY require confirmation before use. Benchmarks are general guidance and vary by industry and context. AI-generated outputs are not substitutes for professional judgment. AI Crash Course is not responsible for decisions made using this reference.

Calculation Formula
Net New MRR New + Expansion – Contraction – Churn
Net Revenue Retention (Starting MRR + Expansion – Contraction – Churn) / Starting MRR
Implied ARR MRR × 12
Months to Payback CAC / (ARPU × Gross Margin)
LTV ARPU × Gross Margin × (1 / Churn Rate)
Metric Formula Notes
MAPE Avg of |Actual – Forecast| / Actual × 100 Undefined when Actual = 0
Forecast Bias (MPE) Avg of (Forecast – Actual) / Actual × 100 Positive = over-forecasting
Mean Error Avg of (Forecast – Actual) Use for dollar bias
Category Probability Description
Commit >80% High confidence, verbal or written commitment
Best Case 50-80% Strong signals, no major blockers
Upside <50% Early stage or significant risk factors
Step Action Example Phrase
Hear Listen fully, no interruptions “Please tell me what happened.”
Empathize Acknowledge feelings “I can understand why that would be frustrating.”
Apologize Sincere, specific apology “I am truly sorry this happened.”
Resolve Take concrete action “Here is what I can do right now.”
Diagnose Identify root cause “I want to make sure this does not happen again.”
Step Action
Listen Full attention, confirm understanding
Apologize “I am sorry this happened.”
Solve Take immediate action
Thank “Thank you for bringing this to our attention.”
Framework Steps
LEARN Listen, Empathize, Apologize, React, Notify
HEART Hear, Empathize, Apologize, Respond, Thank
LEAP Listen, Empathize, Apologize, Problem-solve
Avoid Use Instead
“That’s not my department.” “Let me connect you with the right person.”
“I’m sorry you feel that way.” “I’m sorry this happened.”
“We’re short-staffed.” “I apologize for the delay.”
“That’s our policy.” “Let me see what I can do within our guidelines.”
“Calm down.” “I understand this is frustrating.”
“You should have…” “Next time, we can…”
“I’ll try.” “I will [specific action] by [time].”
Role Can Offer Without Approval Must Escalate
Front-line Staff Apology, small amenity, minor adjustment Rate adjustment over $X, room move, refund
Supervisor Upgrade, meal credit up to $X, moderate adjustment Full night refund, compensation over $X
Manager on Duty Full night comp, significant credit, future stay offer Legal issues, safety incidents, media
General Manager Full authority within policy Corporate escalation, legal claims
Complaint Type Target Response Time
In-person, guest present Immediate
Phone call Resolve during call or callback within 1 hour
Email Same business day, ideally within 4 hours
Online review Within 24-48 hours
Post-stay letter Within 3-5 business days
Metric Early Stage Growth Stage Mature
Net Revenue Retention 90-100% 100-120% 110-130%
Gross Margin 60-70% 70-80% 75-85%
CAC Payback 18-24 months 12-18 months <12 months
Sales Cycle Suggested Coverage
Short (<30 days) 2-3x target
Medium (30-90 days) 3-4x target
Long (>90 days) 4-5x target
Mistake Problem Solution
Trusting numbers blindly AI can hallucinate data Verify against source
Vague prompts Poor output quality Be specific about format and requirements
No safety line Unverified assumptions Include global safety line
Single source Incomplete picture Use multiple queries or tools
Mistake Problem Solution
Happy ears Believing optimistic signals Verify with multiple contacts
Sandbagging Underforecasting to guarantee beats Track accuracy, hold to best estimates
Ignoring churn Forecasting only new business Always model gross and net
Static assumptions Using outdated rates Update quarterly with recent data
Single-point forecasts False precision Use ranges and scenarios
Ignoring seasonality Missing patterns analyse 2+ years of data
Mistake Problem Solution
Interrupting Guest feels unheard Let them finish
Defensive language Escalates tension Own the problem
Over-promising Sets up second failure Commit only to what you can deliver
Generic apology Feels insincere Be specific
No follow-up Guest feels forgotten Always close the loop
Blaming others Unprofessional Take ownership
Tool Website
ChatGPT chat.openai.com
Claude claude.ai
Gemini gemini.google.com
Perplexity perplexity.ai
Clari clari.com
Gong gong.io
Salesforce salesforce.com
HubSpot hubspot.com
Tool Pricing Page
OpenAI openai.com/pricing
Anthropic anthropic.com/pricing
Google Gemini one.google.com/about/plans
Perplexity perplexity.ai/pro
Situation Contact Phone/Channel
Manager on Duty
General Manager
Security
Engineering
Corporate Escalation
Legal/Risk
PR/Communications