---
search:
  tags:
    - insights
    - GET
seo:
  description: >-
    What are Turnover Insights? Turnover Insights provides detailed… Reference
    for the GET /insights/turnover-chart endpoint in the Leadtime Public API
    API.
sidebar:
  badge: GET
  label: Get turnover insights data in structured JSON format
title: Get turnover insights data in structured JSON format
type: openapi-operation
---
**What are Turnover Insights?**
Turnover Insights provides detailed revenue analysis across projects, showing income from various revenue streams over time. This helps businesses understand revenue patterns, forecast future income, and analyze which projects or revenue types contribute most to the bottom line.

**What data is returned:**
The response includes two or three "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. Structure varies by model and breakdown selection.
- **Detailed sheet**: Long format (normalized) with one row per period/project/revenue type combination. Perfect for pivot tables and further analysis.
- **Forecast sheet** (optional): Only included when includeTrend=true and forecast data exists. Contains 6-month revenue forecast based on subscription billing cycles and project deadlines.

**Supported analysis options:**
- **Project selection**: Analyze single project or compare multiple projects
- **Date range**: Auto-calculated from invoice data if not provided, or specify custom range
- **Model selection**: 
  - COMPARISON: Compare revenue across multiple projects side-by-side
  - TOTAL: Aggregate revenue view showing combined totals
- **Breakdown options** (both work with **COMPARISON** and **TOTAL**):
  - **byProject**: In **COMPARISON**, each period shows one bar per project (project total for that month). In **TOTAL**, periods show stacked contributions by project toward the combined total.
  - **byRevenueType**: In **COMPARISON**, each project’s bar is stacked by revenue type. In **TOTAL**, stacked layers are revenue types on the workspace aggregate.
- **Forecast option**: includeTrend (only available for **TOTAL** model) — enables 6-month revenue forecast

**Revenue types included:**
The analysis includes all revenue types from invoices:
- Support (hourly billing)
- Fixed Subscriptions (recurring fixed amounts)
- Variable Subscriptions (recurring variable amounts)
- Express Quotations (quick quotes)
- Products (one-time product sales)
- Components (product components)
- Manual Positions (custom invoice line items)

**Important validation rules:**
- **includeTrend** is only available for **TOTAL** model (forecast uses the aggregate series)
- At least one project must be selected

**Forecast calculation:**
When includeTrend=true, the forecast sheet includes:
- 6-month forward-looking revenue projection
- Based on active subscription billing cycles
- Includes upcoming project deadlines and milestones
- Helps with cash flow planning and revenue forecasting

**Use cases:**
- Track revenue trends over time
- Compare revenue performance across projects
- Analyze revenue distribution by type (subscriptions vs one-time)
- Forecast future revenue based on active subscriptions
- Export to Excel for financial reporting and analysis

<Operation source="api-reference" id="insightscontroller-getturnoverchart" />