Get staff insights data in structured JSON format

What are Staff Insights? Staff Insights provides detailed analysis of employee time tracking data, showing how team members allocate their working hours across projects, task types, and value categories. This helps managers understand workload distribution, identify productivity patterns, and track employee performance against goals.

What data is returned: The response includes two “sheets” of data in JSON format (matching the Excel export structure):

• Summary sheet:
  • For COMPARISON model: Wide format (pivot table style) with periods/staff as rows and breakdown categories as columns
  • For TOTAL model: Categories with hours and percentage distribution
• Detailed sheet:
  • For COMPARISON model: Long format (normalized) with one row per period/staff/breakdown combination
  • For TOTAL model: Same structure as summary (aggregated totals)

Supported analysis options:

• Staff selection: Analyze single employee or compare multiple team members
• Date range: Auto-calculated from time log data if not provided, or specify custom range
• Model selection:
  • COMPARISON: Time-series analysis showing trends over time periods
  • TOTAL: Aggregated totals across entire period (distribution analysis)
• Period granularity: Required for COMPARISON model - group by months or weeks
• Breakdown options:
  • byProject: Hours allocated per project
  • byTaskType: Hours by task category
  • byChargeableTime: Billable vs non-billable hours with target hours comparison
  • byValueGroups: Hours categorized by value groups (A, B, C, D)

Special features:

• Chargeable time breakdown: Includes target hours column based on employee goals and working time patterns, allowing comparison of actual vs target billable hours
• Goal integration: When using chargeable time breakdown, compares actual hours against employee goals
• Localized output: Headers and titles are fully localized based on user’s language preference
• Human-readable data: All entity names (employees, projects, task types) are human-readable (never UUIDs)

Use cases:

• Track individual employee productivity and time allocation
• Compare team member workloads across projects
• Analyze billable vs non-billable time distribution
• Monitor employee performance against goals and targets
• Export to Excel for detailed reporting and analysis

curl -X GET "https://leadtime.app/api/public/insights/staff-chart?staffIds=7acff2df-a904-4323-adcc-c2f24a769bde&model=comparison&period=months&breakdown=byProject" \
  -H "Authorization: Bearer YOUR_ACCESS_TOKEN"

const response = await fetch("https://leadtime.app/api/public/insights/staff-chart?staffIds=7acff2df-a904-4323-adcc-c2f24a769bde&model=comparison&period=months&breakdown=byProject", {
  method: "GET",
  headers: {
    "Authorization": "Bearer YOUR_ACCESS_TOKEN"
  }
});

import requests

response = requests.get(
    "https://leadtime.app/api/public/insights/staff-chart?staffIds=7acff2df-a904-4323-adcc-c2f24a769bde&model=comparison&period=months&breakdown=byProject",
    headers={
        "Authorization": "Bearer YOUR_ACCESS_TOKEN"
    },
)

{
  "detailed": {
    "headers": [
      "Period",
      "Period Label",
      "Employee",
      "Hours"
    ],
    "rows": [
      {
        "Employee": "John Doe",
        "Hours": 160,
        "Period": "2024-01",
        "Period Label": "Jan 2024"
      },
      {
        "Employee": "John Doe",
        "Hours": 175,
        "Period": "2024-02",
        "Period Label": "Feb 2024"
      }
    ],
    "title": {
      "main": "Staff Insights: John Doe",
      "subtitle": "Comparison, Breakdown by Project, Jan 2024 - Dec 2024, By Months"
    }
  },
  "metadata": {
    "hasMoreData": false,
    "periodsGenerated": 12,
    "queryExecutionTime": 234,
    "totalTimeLogsProcessed": 480
  },
  "summary": {
    "headers": [
      "Period",
      "Period Label",
      "Employee",
      "Hours"
    ],
    "rows": [
      {
        "Employee": "John Doe",
        "Hours": 160,
        "Period": "2024-01",
        "Period Label": "Jan 2024"
      },
      {
        "Employee": "John Doe",
        "Hours": 175,
        "Period": "2024-02",
        "Period Label": "Feb 2024"
      }
    ],
    "title": {
      "main": "Staff Insights: John Doe",
      "subtitle": "Comparison, Breakdown by Project, Jan 2024 - Dec 2024, By Months"
    }
  }
}