Analytics

Nine support and cost numbers over one date range, and the explorer for any other question.

Every role can open Analytics, cost tiles included. The explorer’s Activity log dataset needs an owner or admin. See Roles.

Pick a range

The menu at the top right sets one range for every tile and chart on the page.

• The range starts at midnight on your device’s clock. Each day ends at your midnight.
• Today counts while it is still going. Chart tooltips call it Today so far.
• The header spells out the dates, like “Aug 28 to Sep 26”.

The tiles

Nine tiles sit in a grid. Press one to draw it as the large chart under the grid. The page opens on Conversations.

Resolved by agent and Satisfaction draw a row of pills filled to their share. The other seven tiles draw a sparkline of their days. Press the table icon at the top right of the chart to see the same numbers as rows, one per day.

Plans, prices and what a credit buys are on Billing.

Caps

Each tile reads a limited number of rows per range.

Past a cap, the oldest days lose rows first. The header names every cap the range hit, like “counting the latest 2,000 conversations and the latest 2,000 ratings”. The note is hidden on narrow screens.

Explore

The explorer answers one question at a time over anything the workspace records. It opens as a dialog.

The range menu in the dialog offers Today, Last 7 days, Last 30 days, Last 90 days and All time. From Logs, the handed-over dates lead the menu. Each time the dialog opens it takes the page’s range again. The query stays until you leave the page.

Ask in words

Type into Ask a question about your data and press Enter or the arrow button. Three sample questions sit under the box until you ask one. Press a sample to ask it.

• Questions take up to 500 characters.
• While it works, the chart area reads Reading the question, Choosing the data, then Writing the query.
• The answer fills the query column, picks a chart and names it. A line under the box says what it did.
• A question that names a range, like “last week”, sets the range menu to the nearest preset.
• A follow-up changes the query on screen instead of starting over, like “now split it by channel” or “only email”.
• Edit any step afterward. The chart updates live.
• Asking needs Standard or Pro. See Plans. On the Explore plan the box is disabled and reads “Available on Standard and Pro.” Owners and admins get a View plans link. Members see “Ask an owner or admin to upgrade.” Building a query by hand works on every plan.
• Each question is charged as AI usage. It shows in Logs as an Analytics question.

Build a query

The query is a row of pills under the ask box, read left to right. A pill shows its setting’s name and value. Press it to change the value. Pills for a setting that does not apply yet, like the field to measure beside Count, stay hidden. On a phone the row scrolls sideways.

The chart takes the full width under the query and grows to fill the dialog’s height.

Filter comparisons are is, is not, is any of, is none of, is more than, is at least, is less than, is at most, contains, does not contain, is set and is not set. Each field offers the ones that fit it.

• A field with named values, like Channel, lists them with checkboxes. Tick one or more, pick is or is not, then Apply. Two or more read as is any of or is none of.
• For typed values, is any of and is none of take a list split by commas.
• Duration filters take minutes. Over the API they take milliseconds.
• Between two filters sits and. Press it to switch every join to or, so a row needs to pass only one filter. Press or to switch back.
• Hours and weekdays follow your device’s clock.

With Largest first or Smallest first, groups rank by what they measure, and the ranking decides which keep their names. Top 5 with Largest first on Conversations split by Page shows the five busiest pages. Other takes one of the places. Hide leaves the other groups off the chart, and the headline covers only the groups shown.

Previous period puts a line beside the headline number, like “12% vs previous period”, with an arrow for the way it moved. Hover it for the earlier number. Table and Download CSV gain a Previous period column when the chart has no axis.

Datasets

Every dataset also has Hour of day and Day of week.

When a query stops at its cap, a note under the chart reads like “Counting the latest 5,000 usage events”. Members do not see Activity log in the menu. A query for it from a member returns “Only admins and owners can view audit logs.”

Chart kinds

The row of chart icons sits beside the headline number. A kind that does not fit the query stays dimmed and says why on hover.

Records and CSV

Chart and Records switch the result.

• Records lists the rows the query matched. Filters, date and range apply. Measure, split and axis do not.
• The menu over the list sorts it: Newest first, Oldest first, or any number field highest or lowest first, like Duration, highest first for the slowest tool runs. Rows with no value sort last. A sorted field shows first on each row.
• It loads 50 rows. Show more adds 50, up to 200. The footer reads like “Latest 50 of 1,240 conversations”, or “First 50” when sorted another way.
• A row opens its page in the app and closes the dialog. Tasks and Usage rows have no page to open.
• Download CSV saves the numbers behind the chart, the same rows Table shows. The file is named after the chart’s title. Log entries themselves export from Logs.

Over the API, CLI and MCP

The same numbers are on the management API. The API returns more than the page draws, like conversations by hour, top pages, sentiment and the knowledge base’s shape.

A query takes the same steps as the builder:

Money in /billing is in microcredits, 1,000,000 to the dollar.

median analytics explore --days 90 \
  --query '{"dataset":"conversations","measure":{"op":"count"},"groupBy":"channel","bucket":"week"}'

# The handoff rate by channel, against the 30 days before
median analytics explore --days 30 \
  --query '{"dataset":"conversations","measure":{"op":"percent","where":{"field":"handedOff","op":"is","value":true}},"groupBy":"channel","compare":true}'

curl https://api.median.sh/v1/analytics/explore \
  -H "Authorization: Bearer $MEDIAN_KEY" \
  -H "content-type: application/json" \
  -d '{"days":90,"query":{"dataset":"conversations","measure":{"op":"count"},"groupBy":"channel","bucket":"week"}}'

return await median.analytics.explore({
  days: 90,
  query: { dataset: "conversations", measure: { op: "count" }, groupBy: "channel", bucket: "week" },
});

Queries take field ids rather than labels, like channel for Channel. median_docs with topic analytics lists every dataset’s field ids. Every command and flag is in the CLI reference. The MCP server is on MCP.