Overview

Report Management lets you create and maintain the charts and stat cards that appear on the five report pages (Users, Questions, Communications, Interactions, Customer Support). Each report is a named configuration that links a data source to a chart type and assigns it a position on a page.

Changes to reports affect all admin users on your brand. Adding a report with Active on makes it visible on the target page immediately; turning it off hides it without deleting it.

To reach Report Management, open any report page and look for the Management link, or navigate directly from the main menu.

Report list

The list groups reports in a tree by page then group (a label that clusters charts together on the report page). Expand a page or group to see individual reports.

ColumnMeaning
Name Internal identifier for the report — visible only in Admin, not on the chart itself.
Label The title shown to admins above the chart on the report page.
Order Position within the group. Click the cell to edit the number inline; lower numbers appear first.
Active Toggle the report on or off. Inactive reports are hidden from the report page but their configuration is preserved.

Click Add New Report to open the editor for a new report.

Click any report row to open its editor.

Report editor

The editor is divided into sections in a left navigation bar. Move between them to fill in the report configuration.

Basic information

FieldWhat to enter
Name An internal reference name (not shown to non-admin users). Use something descriptive, e.g. "users_by_age_pie".
Label The chart title displayed on the report page to admins.
Type Chart type — see Chart types below.
Page Which report page this chart belongs to (Users, Questions, Communications, Interactions, or Customer Support).
Group An optional label that clusters related charts together on the page. Charts with the same group appear in a shared panel.
Order Display position within the group. Lower numbers appear first.
Size How wide the chart panel is. Larger values take up more horizontal space on the report page.
Source Where the data is read from — see Data sources below.
Active Whether the chart is shown on the live report page. Turn off to hide without deleting.

Series configuration

For charts with multiple data series (for example grouped bar charts), the Series section lets you define each series: its label, color, and which field in the query result it maps to.

Custom SQL

Enter a raw SQL query that returns the data for this chart. The column names in the result must match what the Series configuration expects. Use the Generate SQL feature to create an initial query from a plain-language prompt.

Custom settings (JSON)

An optional JSON block for advanced chart options not covered by the standard fields (for example axis labels, color overrides, or chart-library-specific settings). Leave empty unless your team has specific guidance.

Chart types

Choose the type that best represents your data in the Type field on the Basic information section.

TypeWhat it showsWhen to use
Pie A circular chart divided into slices showing proportional breakdown. Use when showing how a total is distributed across categories (for example status breakdown of open tickets).
List A tabular list of data rows. Use when showing ranked or labeled records rather than visual proportions.
Bars Vertical bar chart comparing values across categories. Use when comparing totals side by side (for example users per status per month).
Horizontal Bar Bar chart with horizontal orientation. Use when category labels are long or there are many categories.
Time A line chart plotting a metric over time. Use for trends: registrations, introductions, or ticket volume over weeks or months.
Ticket A colored stat card showing a single number prominently. Use for key performance indicators shown in the stat-card row at the top of a report page.
Ticket Delta A stat card showing a number and its change (delta) compared to the previous period. Use when the direction of change is as important as the value itself (for example open tickets this week vs last week).
Custom A fully custom chart driven by your SQL query and Custom Settings JSON. Use for charts that don't fit the standard types or need advanced chart-library configuration.

Data sources

SourceWhat it queriesWhen to use
Main DB The live operational database — the same data the rest of Admin reads. Results reflect the current state of the platform. Use for current-state snapshots: active users, open tickets, pending introductions. Keep queries simple to avoid slowing down the live system.
BigQuery The analytics data warehouse — historical event data aggregated from member-app and server activity. Use for trends, event counts, and long-look-back analytics (for example signups per week over the past year). Queries run separately from the live database and do not affect app performance.

Generate SQL

The Generate SQL section lets you describe what you want to measure in plain language and have the system produce a starting SQL query automatically.

  1. Type a plain-language description of the data you need (for example "count of new users per week for the last 3 months").
  2. Click Generate. The system sends the prompt to an AI model which writes an SQL query based on the database schema.
  3. Review the generated query in the Raw query field. Edit it if needed before saving.
  4. Save the report. The Raw query field becomes the SQL used when the chart loads.

Always review the generated query before saving. The AI may not know your exact schema, custom columns, or brand-specific table names. Test with a small date range first if the query is complex.