Objects
FROM takes one of these objects. Objects marked Combinable can be mixed in one report, for example FROM contacts SHOW deals.count, orders.total. The others are reported on their own.
| Object | What it holds | Combinable | Main metrics |
|---|---|---|---|
deals |
Sales opportunities, their value and stages | Yes | count, value, avg_value, min_value, max_value, won_count, … |
accounts |
Companies you sell to | Yes | count, new, unique_industries, unique_countries, unique_owners |
contacts |
People, leads and where they came from | Yes | count, new, active_leads, new_leads, contacted_leads, hot_leads, … |
activities |
Calls, meetings, tasks, emails and notes | Yes | count, calls, meetings, tasks, emails, notes, … |
price_offers |
Quotes sent to customers | Yes | count, value, avg_value, min_value, max_value, pending, … |
invoices |
Billing, payments and balances | Yes | count, total, avg_value, min_value, max_value, collected, … |
tickets |
Support requests and their status | Yes | count, open, resolved, closed, pending, unique_requesters, … |
projects |
Delivery projects and their progress | Yes | count, not_started, in_progress, completed, on_hold, unique_owners, … |
milestones |
Project milestones | No | count, in_progress, completed, pending_approval, avg_progress, unique_projects |
project_jobs |
Jobs inside projects | No | count, pending, in_progress, completed, blocked, estimated_hours, … |
appointments |
Bookings, check-ins and durations | Yes | count, booked, confirmed, completed, avg_duration, total_duration, … |
requests |
Internal requests and approvals | Yes | count, submitted, approved, rejected, pending, completed, … |
orders |
Orders, sales, payments and fulfillment | Yes | count, total, avg_value, subtotal, tax_total, shipping_total, … |
carts |
Carts and whether they became orders | Yes | count, total, avg_value, converted_count, open_count, unique_customers |
line_items |
Products on orders, carts and subscriptions | No | count, quantity, amount, avg_unit_price, discount, tax, … |
products |
Your catalog: prices, costs and categories | No | count, active, avg_price, avg_cost, unique_suppliers |
product_variants |
Product variants and stock | No | count, inventory, avg_price |
subscriptions |
Recurring billing, MRR and churn | Yes | count, live, mrr, live_mrr, arr, avg_mrr, … |
listings |
Property listings, prices and sales | Yes | count, total_value, avg_price, sold_count, sold_value, avg_sold_price, … |
campaigns |
Marketing campaigns, budget and spend | Yes | count, active, completed, budget, spent, budget_used, … |
articles |
Content hub articles | No | count, published, draft, avg_word_count, avg_reading_time |
forms |
Forms and their submissions | No | count, published, submissions, avg_submissions |
suppliers |
Suppliers and payment terms | No | count, active, on_hold, avg_payment_terms |
widget_events |
Website widget visits and clicks | No | count, unique_visitors, unique_channels, opens, prompt_views, prompt_clicks, … |
inbox_conversations |
Customer conversations, response and resolution times | No | count, open, pending, snoozed, resolved, closed, … |
inbox_messages |
Messages sent and received in the inbox | No | count, inbound, outbound, agent_replies, bot_replies, notes, … |
agent_runs |
AI agent runs, tokens and cost | No | count, completed, failed, handoffs, waiting_for_approval, cancelled, … |
goals |
Goal targets and progress | No | current, target, attainment, targets_count, achieved_count |
Each object’s fields come from Properties, including custom properties. In the query editor, the book icon lists every metric and field of the selected object; click a name to add it to the query.
Access
Section titled “Access”Every object’s data visibility applies, so you only count the records you’re allowed to see. Reports on orders, carts, line items, products, product variants, suppliers, subscriptions, listings, campaigns, articles, forms, and goals also need that object’s view permission and a plan that includes its module. A report that combines objects needs the view permission of each one.