Your CFO asks: “What's our span
of control by department?”
You spend two days in spreadsheets. Or you spend two minutes with the ChartPull API. It answers org structure questions in milliseconds.
Real-time
Headcount data via API
23
REST API endpoints for your dashboards
Historical
Trend analysis with org snapshots
Which managers are stretched too thin?
The ChartPull API returns descendant counts for every manager. Red flags show up in seconds, not days.
Span of Control Analysis
Sarah in Engineering has 14 direct reports. Amy has 15. They're burning out and you didn't know. Now you do.
GET /org-tree with descendant counts
One API call. Every manager, their direct report count, and total team size. Structured data, ready to analyze.
Flag anyone over 12 direct reports
Research says 7-10 is the sweet spot. Above 12, things start breaking. You want to know before it breaks.
Automate a weekly report
Set up a cron job. Every Monday, HR and leadership get a report showing who's stretched thin. No manual work.
Org Depth Metrics
Your org has 6 layers for 200 people. That's a lot of middle management. Is it intentional -- or did it just happen?
Calculate chain length per employee
The /org-tree endpoint computes how many levels separate each person from the CEO. The answer might surprise you.
Benchmark against your peers
Companies with 100-1,000 employees typically have 4-7 levels. Where do you land?
Watch for drift over time
Store monthly snapshots. Are you getting flatter or taller? If layers are creeping in, catch it early.
Department Growth Tracking
Engineering doubled in 6 months. Sales stayed flat. Was that the plan? If you're not tracking it, you don't know.
Pull department data weekly
Schedule a weekly API call to GET /departments. Department names and employee counts, every week, automatically.
Push it to your data warehouse
BigQuery, Snowflake, Redshift -- wherever your BI team lives. The data is structured and ready.
Build trend charts
Visualize department growth in Looker, Tableau, or Power BI. See the patterns over months and quarters.
Overlay revenue per employee
Which departments are efficient? Which are bloated? Combine headcount with revenue data and the answer is obvious.
Cost Center Mapping
Finance asks what each department costs. You need headcount by team. With ChartPull, that's one API call -- not a two-week project.
Map departments to cost centers
ChartPull department data becomes your source of truth. No more arguing about who belongs where.
Join with your finance data
Combine department headcount with your ERP or finance system. Per-unit cost attribution, automated.
Calculate revenue per employee
Sales generates $2M with 30 people. Marketing generates $500K with 25. Now you can have that conversation with data.
Build CFO-ready dashboards
Feed the combined data into your BI tools. The CFO gets a dashboard that updates itself. No more quarterly fire drills.
How many layers is too many?
Every company stage has a healthy range. ChartPull shows you where you land.
Startup
10-50 employees
2-3
recommended levels
Growth
50-200 employees
3-5
recommended levels
Scale-up
200-1000 employees
4-7
recommended levels
Enterprise
1000+ employees
5-8
recommended levels
Stop building org data from scratch
15 REST endpoints. Org hierarchy, departments, search, bulk export. Your BI tools get live org data from Google Workspace. See the full API documentation.