FATHOM

A deep-dive into all things ORCA.
From core concepts to advanced settings.

Global Tools

Reports

ORCA's reporting engine lets you pull structured data into clean, filterable summaries from any section in your account. Reports can be built manually or generated from a plain-English description. Once built, save them to run again any time.


Saved Reports

The top of the Reports page shows all your saved reports as cards. Click any card to re-run it instantly - the results load below. Each saved report stores your chosen section, columns, and filters so you don't have to rebuild from scratch.

Each card shows the report name, which section it runs against, when it was last run, and who created it. Saved reports are shared across the account, so a report one person builds is there for everyone.

To delete a saved report, use the bin icon on its card. You'll be asked to confirm first.

Saved totals

If your account has Totals, the totals you save from a section's list sit in the same Saved reports list, with that section's name on the card. Click one and it opens on the Totals page rather than running here, with the same grouping, figures, dates and filters it was saved with. Totals is a module the ORCA team switches on for your account, so you won't see these cards until it is.


Building a Report

1. Choose a section

Pick the data source you want to report on. Available sections include Companies, Contacts, Meetings, Communications, News, and any custom sections your account has set up.

Meetings reports cover logged meetings and calls. The option only appears if your account uses the Meetings module, and it takes whatever name the module has on your account, so you might see "Interactions" or similar instead. Available fields include Date, Type, Location, Notes, Follow-up Notes, Counterpart Companies, Counterpart Contacts, Attendees (Internal), Follow-up Date, Followed Up, and Needs Follow-up. Useful for tracking meeting cadence, pulling a list of calls needing follow-up, or auditing who's been in the room.

2. Choose columns

Click the column picker to choose which fields appear in the results. Tick or untick fields to add or remove them. Your selection is reflected in the results table immediately when you run.

For custom sections that link to contacts, the column picker also includes virtual contact detail fields: Contact Postcode, Contact Telephone, Contact Mobile, and Contact Email. Ticking any of these adds that detail as a standalone column in your results. The contact cell itself also shows mobile (or telephone as a fallback) and postcode inline below the contact name, so you may already have what you need without adding a separate column.

3. Add filters

Use the filter rows to narrow results. For each filter you can set:

  • Field - which field to filter on
  • Condition - equals, contains, before, after, between, last N days, etc.
  • Value - what to match against

Filters can be chained - add as many rows as you need. Each filter narrows the result set further.

Date fields get a date picker. For "between" conditions, both a start and end date are shown.

4. Run the report

Click Run report to execute. Results appear in the table below. Long text fields are capped at a short preview to keep the table readable. Click any row to open the full record.


AI Query Mode (Describe it)

The builder has two modes, Build and Describe it. Build is the manual picker described above. Switch to Describe it to skip it and say what you want in plain English instead.

For example:

  • "Companies added in the last 30 days"
  • "Communications with a follow-up due this week"
  • "News articles from this month mentioning climate"

ORCA's AI reads your description, works out which section and filters apply, and populates the builder automatically. You can review and adjust the generated config before running.


Saving a Report

After building or generating a report, give it a name and click Save. It appears as a card at the top of the Reports page and can be re-run any time.


Exporting

Once a report has results, two buttons appear above the table on the right: Export Excel and Export CSV. Either one downloads the report with the columns and filters you ran it with, named after the saved report (or just "report" if you haven't saved it).

The table on screen stops at 100 rows. The download doesn't: it has every matching row, up to 20,000. Past that, ORCA asks you to narrow the filters. If your role is limited to 20 records per report, the download is too.

Excel workbook

Export Excel gives you a proper .xlsx file rather than text that Excel has to guess at:

  • One sheet, named after the section
  • A bold header row, frozen so it stays put as you scroll
  • A filter on every column, and column widths that fit the content
  • Numbers arrive as numbers and dates as dates (dd/mm/yyyy, with the time where there is one), so you can sum or sort a column straight away

Anything that only looks like a number stays as text, so Excel can't mangle it:

  • A leading zero, such as a phone number starting 0141 or an id like 007
  • More than 11 digits before the decimal point, such as an international phone number or a long account reference. These would otherwise show up as 4.47701E+11.
  • More than 15 digits in all, which Excel can't hold precisely

Every cell is written with a fixed type, so a value that starts with = or + opens as plain text. Nothing typed into ORCA can run as a formula when someone opens the file.

Size limit for Excel

A workbook takes far more memory to build than a CSV, so Excel exports stop at 200,000 cells (rows multiplied by columns). That's 20,000 rows of 10 columns, or 10,000 rows of 20. A bigger report gets a message giving its size: export it as CSV instead, or narrow the filters or untick some columns.

CSV

Export CSV is the plain-text version. It has the 20,000-row ceiling but no cell limit, and opens in anything.


Totals

Reports list records. When you want them added up instead (profit by month, spend by client, hours by person), use Totals: open a section's list and click Totals. You group by one or two fields, pick what to total, average or find the lowest or highest of, and save it. Saved totals come back here under Saved reports.


Real-World Uses

  • Pipeline reviews for Monday meetings
  • Follow-up lists filtered by due date
  • News digests for a given topic or date range
  • Communications activity by company or method
  • Investor-ready overviews from custom section data
  • Profit, spend or hours added up by month, client or person, using Totals
Previous
Forward an Email to a Record