Reports
Download report data as CSV or view raw data in the browser.
Available reports
Click "View data" to see raw results; use the download icon to export CSV.
| Name | Description | Query | Actions |
|---|---|---|---|
| Chat Sessions | Chat sessions created. Base: mtg_ai_chat_session_v2. Joins: client (salesforce.accounts), opportunity (salesforce.opportunities), asana project, Vulcan Group/Fit, feedback, prompt, user. | -- ============================================================================= -- Report: How many chat sessions created -- Base table: public.mtg_ai_chat_session_v2 -- Column prefixes: client__ (sa… | |
| Asana Projects with Custom Fields | All Asana projects with custom fields as columns. One row per project; each custom field is its own column (by field_gid). | -- ============================================================================= -- Report: All Asana projects with custom fields as columns -- One row per project; each custom field is its own column… | |
| Users Login Activity | All users with login tracking (v2) and login history counts by portal. Vulcan/Bridge. Date ranges: today, last 7/15/30 days. Active users only. | -- ============================================================================= -- Report: All users with login tracking (v2) and login history counts by portal -- Base: public.mtg_authentication_use… |