Data
The Intelligence Data section: the nine data sets and their columns, the controls that filter them, choosing columns, and export.
The Data section of the Intelligence portal shows the records behind the Reports as a spreadsheet. Where reports present visual summaries, Data lists each record, such as each task session or each user, so you can look at the detail, choose the columns you need, and export it.
The sessions data set in the Data section
Choosing a Data Set
Open Intelligence and click Data, then choose a data set from Report. The controls at the top of the page set what the table shows:
| Control | Description |
|---|---|
| Group | Limits the data to one user group, or shows All groups. See User Groups. |
| Report | The data set to show. See Data Sets. |
| Fields | The columns to show. See Choosing Columns. |
| Export | Exports the data set. |
| Time range | The period the data covers, from 1 week to all time. |
| Show Tests | Includes test sessions. |
| product | Limits the data to a copilot. Not shown for every data set. |
Data Sets
| Data set | Contents | Columns include |
|---|---|---|
| account_account | Account-level activity, one row per date. | date, users, new_users, customers, new_customers, suppliers, new_suppliers, products, new_products |
| account_products | The account's copilots over time. | date, product_name, tasks, new_tasks, resources, new_resources, sessions, new_sessions, steps, new_steps, users, new_users |
| users | The account's users. | user, email, active, last_login_ts, created_ts |
| customers | The account's customers. | user, users, email, active, last_login_ts, created_ts |
| products | The account's copilots. | product_id, product, status, created_ts |
| sessions | Task sessions. | user, product, session_id, session_date, session_end, status, users, task, solution, escalated, testing, source, language, step_count, duration, skills, parts, parts_used, asset |
| customer_sessions | Customers' task sessions. | session_date, session_end, session_id, status, product, asset, users, task, solution, escalated, duration, skills, parts, parts_used, source, step_count |
| resources | Resource usage. | product, user, timestamp, resource, usage |
| customer_resources | Customers' resource usage. | product, user |
Choosing Columns
Click Fields to choose the columns. Select a field's check box to show its column, or clear it to hide the column. Unselect All clears every field. Some fields, such as product_id and task_id on the sessions data set, are hidden until you select them.
The Fields list for choosing columns
To export the data set, click Export.
Updated about 3 hours ago