Competitor hiring intelligence board for strategy meetings

Build me a competitor hiring intelligence board I can open before strategy and pipeline meetings. It runs on a watchlist of companies I maintain myself, and the data comes from Coresignal. This is an interactive board rather than a scheduled report: I browse it, drill into it, and compare companies inside it.

The landing view is a grid of watchlist cards, one card per company. Each card shows the company name, its current headcount, a headcount trend indicator comparing the latest figure against the previous stored snapshot, the number of currently open job postings, and the top three hiring departments by posting volume. Company details come from Coresignal Collect Company by ID (Multi-source). The open job count and the department breakdown come from Coresignal Search Jobs (Filter) scoped to that company.

Adding a company is a single paste-the-website box at the top of the board. When I paste a URL, resolve it with Coresignal Enrich Company by Website (Multi-source), show me the matched company so I can confirm it is the right one, and save its Coresignal company ID to the watchlist. If the website does not resolve to a company, say so plainly and let me try another URL. Removing a company is an action on the card itself with a confirmation step. Persist the watchlist server side and share it across the whole team, so anyone who opens the board sees the same companies.

Clicking a card opens a company view. The main element there is a job postings table backed by Coresignal Search Jobs (Filter), with filters for department, seniority, location and posted date that I can combine. Each row shows title, department, seniority, location and posted date. Expanding a row fetches the full posting description with Coresignal Collect Job by ID (Multi-source), and only when I expand that row rather than for every row in the table. Above the table, show a headcount trend chart drawn from the headcount history on the stored company record.

A compare mode lets me select two to five watchlist companies and put them side by side on hiring velocity by function, so I can see who is staffing up sales versus engineering versus support. Group each company's open postings by function, show the counts next to each other, and include how each function has moved since the previous refresh. Keep the layout readable at five companies.

Every table view needs an Export this view button. It takes the rows currently visible after my filters, creates a spreadsheet with Google Sheets Create Spreadsheet named for the company or comparison plus the date, writes a header row, and appends the rows with Google Sheets Append Values. Then show me a link to the new spreadsheet so I can drop the numbers into a board deck. Export what is on screen with my active filters applied, not the unfiltered dataset.

One important constraint: Coresignal deducts a credit for every search and collect response, so cache the watchlist company records and job counts server side instead of re-collecting them on every page load. Show a last refreshed timestamp on the board, and give me a refresh control both on each card and for the whole watchlist, so I decide when to spend credits. Every refresh should store the headcount figure it saw, so the trend indicator and the headcount chart have history to draw on.