Introduction
The Workbook Agent helps you turn a business question into editable analysis without assembling every field, filter, calculation, and visualization manually. Describe the outcome clearly, inspect what it builds, and refine the workbook until it answers the intended question. The prompt begins the work; reviewing the fields, filters, calculations, and results makes the analysis dependable.
Getting Started with the Workbook Agent
Start in the Right Topic
Before typing your first request, ensure you're building your query in the appropriate topic. This is essential for getting the results you want:
To compare current on-the-books (OTB) data to a previous period ➝ use the Bookings topic
To view what was OTB as of a prior date or analyze pick-up ➝ use the Pick-up topic
To evaluate forecast or budget data ➝ use the Forecasts & Budgets topic
To assess rate shopping data and competitor rates ➝ use the Rate Shopping topic
📖 Need help choosing the right topic? Refer to our Insights Topics Overview for guidance.
Accessing the Feature
Location: Look for the "Workbook Agent" button in your Insights workbook
Conversation interface: The assistant opens a chat-like interface for your queries
Understanding the Query Building Process
Real-time feedback: Watch how your query changes as you refine your requests
Field selection visibility: Notice which fields the AI selects to satisfy your request
Translating business questions: The AI converts natural language to technical queries behind the scenes
Formulating Effective Queries
Be Specific and Complete
Complete requests yield accurate results the first time, saving multiple iterations
Include all key elements in your initial request:
Metrics: "Show me ADR, Occupancy, and RevPAR..."
Time period: "...for the next 90 days..."
Comparison period: "...compared to same time last year..."
Breakdown dimensions: "...broken down by segment and channel..."
Example: "Show me ADR and Revenue by channel for April 2025 compared to April 2024, sorted by Revenue descending"
Structure Multi-Part Requests Clearly
Clear structure helps the AI parse complex requests correctly, delivering precisely what you need
Instead of: "I want to see occupancy, ADR, and revenue year-to-date with monthly breakdowns showing year-over-year changes for my downtown properties focusing on groups versus transient business"
Better approach: "Show me YTD performance with monthly breakdown, comparing to last year. Include Occupancy, ADR and Revenue. Filter to downtown properties only and segment by group versus transient business."
Refinement Techniques
Iterative Query Building
This approach lets you build complex analyses incrementally while maintaining control
Begin with a basic question and refine with follow-up requests:
Start: "Show ADR and Revenue by month for this year"
Refine: "Now add Occupancy to the query"
Further refine: "Filter to only show weekends"
Final touches: "Sort by Revenue descending"
Describing Modifications Clearly
Clear modification requests ensure precise adjustments without rebuilding entire queries
Be specific about changes: "Change the date range to last 90 days"
Reference existing elements: "Keep the same metrics but change the breakdown to segment instead of channel"
Add calculations: "Add a column showing year-over-year growth percentage"
Navigating Mistakes and Making Corrections
Undoing Changes
Reset to previous state: "Go back to the previous query" or "Undo the last change"
Start fresh: "Start over with a new query" or "Reset this query"
Remove specific elements: "Remove the channel filter" or "Remove the Revenue column"
Correcting Misinterpreted Requests
Be explicit about corrections: "You misunderstood - I meant Property X, not Property Y"
Clarify ambiguities: "I meant revenue per available room, not revenue"
Provide context for terms: "By 'direct' I meant direct booking channels, not direct costs"
Version Management
Save intermediate versions: Before making substantial changes, save your current query
Use descriptive titles: Name saved queries based on their purpose for easier reference
Keep track of manual edits: After the Workbook Agent generates a query, note any manual adjustments you make
Understanding Results and Insights
Interpreting Generated Data
Check your units: Pay attention to the actual measurements (e.g., currency, percentages)
Verify time frames: Confirm that the date ranges match your intended analysis period
Understanding variance: When comparing periods, note whether differences are absolute or percentage-based
Getting Explanations
Build, don't explain: The Workbook Agent generates a query. It does not write a text answer.
Ask why in Chat: To ask why a figure changed, request analysis, or check what a metric means, use Chat.
Transitioning Between AI and Manual Analysis
Save as templates: Use successful Workbook Agent queries as starting points for similar analyses
Manual fine-tuning: Make precise adjustments to Workbook Agent-generated queries when needed
Understanding Limitations and Working Within Them
Data Availability Constraints
Cross-Topic Data: The Workbook Agent can only access data within the current topic (e.g., Bookings). For analysis combining Forecasts & Budgets, Benchmarking STR, or Pick-up data, you'll need to:
Build separate queries in each topic
Use the XLOOKUP functionality to combine them
Reference: Combining Data Sets Across Topics
Complexity Boundaries
Too Many Metrics: Queries with excessive dimensions and metrics may become unwieldy
Solution: Break into multiple focused queries
Highly Complex Calculations: Some advanced custom calculations may require manual formula creation
Solution: Start with Workbook Agent-generated query, then add calculations manually
Performance Impact: Very large datasets or highly complex queries may take longer to process
Special Cases
Custom Time Periods: Very specific date comparisons (e.g., "Compare the third Tuesday of each month") may require manual refinement
Complex Filtering Logic: Multiple nested conditions can be challenging for AI to interpret correctly
Solution: Build filters incrementally, confirming each step
Technical Constraints
Field Name Precision: The AI may occasionally confuse similarly-named fields
Example: Distinguishing between "Lead Time (Stay Date)" and "Lead Time (Arrival Date)"
Solution: Be explicit about which version you want
Advanced Visualizations: Some specialized visualizations may require manual configuration
Solution: Request the data structure you need, then customize the visualization manually
Industry-Specific Terminology and Concepts
Hospitality Metrics Understanding
The Workbook Agent understands common hospitality terms like ADR, RevPAR, STLP, and MTD
Use standard industry terminology to get the most accurate results
For specialized metrics, provide a brief definition if needed
Handling Property-Specific Terms
Property codes or custom segment names may need additional explanation
Custom field groupings or user-defined labels should be explained clearly
Consider using the exact names from your property setup for best results
Advanced Usage
Comparative Analysis
Period-over-period analysis: "Compare Q2 performance to same period last year and two years ago"
Custom date ranges: "Show me June 1-15, 2025 versus June 1-15, 2024"
Multiple comparisons: "Show this month's ADR versus STLP and Previous"
Filtering & Segmentation
Multiple filters: "Show only high-ADR segments with occupancy below 70% for next month"
Nested criteria: "Find dates where weekday occupancy is above 85% but ADR is below $150"
Exclusions: "Show all channels except OTAs for this quarter"
Visualization Guidance
Request specific chart types: "Show this in a bar chart with months on the x-axis"
Ask for pivoted data: "Pivot the query to show months across columns and segments down rows"
Request totals: "Add column totals to the query"
Common Pitfalls to Avoid
Overcomplicating Requests
Simpler requests deliver more accurate results and are easier to refine
Avoid: Extremely long, multi-part questions with many conditions
Better: Break down complex analyses into sequential, focused queries
Ambiguous Terminology
Precise terminology ensures the AI retrieves exactly what you need
Avoid: Vague terms like "performance," "results," or "data"
Better: Specify exact metrics like "ADR," "Revenue," "Occupancy," or "Units"
Assuming Context
Clear context prevents misinterpretation and rework
Avoid: References without context ("Show me the same for last month")
Better: Provide sufficient context in each request
Summary
The Workbook Agent is most useful when you want to see, validate, and directly refine analysis as it is built. Name the Topic, scope, measures, and comparison, build in small steps, and check the visible fields, filters, and results before you rely on them.
📌 Need more information? Reach out to our Advisory team via the chat with any feedback on particularly good examples you've used and/or you need any support!
