Get project insights data in structured JSON format

What are Project Insights? Project Insights provides detailed analysis of working hours spent on company projects over time. This endpoint returns data that can be visualized as charts or exported to Excel, showing how time is allocated across projects, team members, task types, and individual tasks.

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

• Summary sheet: Wide format (pivot table style) with periods as rows and breakdown categories as columns. Perfect for quick overview and visual chart generation.
• Detailed sheet: Long format (normalized/tidy data) with one row per period/breakdown combination. Ideal for further analysis, pivot tables, and BI tools.

Supported analysis options:

• Project selection: Analyze single project or compare multiple projects side-by-side
• Date range: Auto-calculated from time log data if not provided, or specify custom range
• Model selection:
  • timeSeries: Shows data over time periods (trends and comparisons)
  • total: Shows aggregated totals across entire period (distribution analysis)
• Period granularity: Group data by months or weeks
• Breakdown options:
  • none: No breakdown (total hours only)
  • byUser: Breakdown by team member
  • byTaskType: Breakdown by task category
  • byTask: Breakdown by individual task
  • byProject: Breakdown by project (only for multiple projects)
• View style (single project time series only):
  • trend: Cumulative values showing progress over time (ladder-style bars)
  • periodComparison: Period-by-period values (non-cumulative bars)
• Display style (multiple projects time series only):
  • groups: Separate lines/bars for each project (comparison view)
  • stacks: Stacked bars showing combined effort (aggregate view)

Data structure:

• Headers and titles are fully localized based on user’s language preference
• All entity names (users, projects, tasks) are human-readable (never UUIDs)
• Numeric values include proper formatting (2 decimal places)
• Metadata includes query execution time and data processing statistics

Use cases:

• Generate visual charts showing project time allocation trends
• Export to Excel for detailed analysis and reporting
• Track team member contributions over time
• Analyze task type distribution across projects
• Monitor project progress against budgets and estimates

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

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

import requests

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

{
  "detailed": {
    "headers": [
      "Period",
      "Period Label",
      "Value",
      "Cumulative Total"
    ],
    "rows": [
      {
        "Cumulative Total": 120.5,
        "Period": "2024-01",
        "Period Label": "Jan 2024",
        "Value": 120.5
      },
      {
        "Cumulative Total": 255.7,
        "Period": "2024-02",
        "Period Label": "Feb 2024",
        "Value": 135.2
      }
    ],
    "title": {
      "main": "Project Insights: Project Name",
      "subtitle": "Jan 2024 - Dec 2024, Time Series, By User, Months, Trend"
    }
  },
  "metadata": {
    "hasMoreData": false,
    "periodsGenerated": 12,
    "queryExecutionTime": 234,
    "totalTimeLogsProcessed": 1000
  },
  "summary": {
    "headers": [
      "Period",
      "Period Label",
      "Value",
      "Cumulative Total"
    ],
    "rows": [
      {
        "Cumulative Total": 120.5,
        "Period": "2024-01",
        "Period Label": "Jan 2024",
        "Value": 120.5
      },
      {
        "Cumulative Total": 255.7,
        "Period": "2024-02",
        "Period Label": "Feb 2024",
        "Value": 135.2
      }
    ],
    "title": {
      "main": "Project Insights: Project Name",
      "subtitle": "Jan 2024 - Dec 2024, Time Series, By User, Months, Trend"
    }
  }
}