AI Assistant
Natural Language Analytics
Example Queries
Example Queries
Pipeline and Revenue
Leads and Contacts
Activities and Engagement
Cases and Support
Dashboard
Saving Charts to Dashboard
After running an analytics query, you’ll see the result as a chart or table. To save it:
- Click Save to Dashboard below the chart.
- Give the chart a name (e.g., “Pipeline by Stage — Live”).
- The chart is added to your CRM dashboard and refreshes automatically with live data every time you view it.
Reports
Saving to Reports
For analytics you want to revisit regularly without pinning to the dashboard:
- After running a query, click Save to Reports.
- Give the report a name and optional description.
- Access saved reports from AI → Reports at any time.
Advanced Queries
Combining Filters with Natural Language
AI analytics run against your live CRM data. Deleted records are not included in query results. If a chart looks off, verify that the underlying data (e.g., close dates, stage values) is accurate in the CRM.
Tips
Tips for Better Queries
- Be specific about time ranges — “last 30 days” or “Q1 2025” produces better results than “recently.”
- Specify groupings — “by rep,” “by stage,” “by source” tells the AI how to slice the data.
- Ask for comparisons — “compared to last month” or “vs. the same period last year” triggers trend analysis.
- Use CRM terminology — Terms like “closed won,” “lead source,” and “pipeline stage” are understood natively.
Pipeline Health Queries
Ask about pipeline movement, not just snapshots. Behind the scenes the analytics engine reads theOpportunityStageHistory ledger — one row per stage transition — so it can answer about drift over time.
“What’s our average cycle time from Prospecting to Closed Won in the last 90 days?” “Which stage do we drop the most opportunities from?” “How many opportunities sat in Negotiation longer than 14 days last quarter?”The chart shows drop-off bars per stage, an average-cycle-time line, or a velocity-by-stage breakdown depending on what you asked. Save it as a Pipeline Health widget on a report to track it over time.
Automation Queue Queries
The analytics engine knows about automation-spawned tasks too (via theautomation_action field on Task). So you can answer:
“Which automation rule has fired the most this month?” “How many automation send_email actions failed in the last week?” “Show me the time-to-complete distribution for create_task actions.”Useful for tuning automations — if one rule is doing 80% of the firing, it might be configured too aggressively; if half its actions are failing, something’s broken with the rule’s email settings.
