Topic
Market series
Aggregate series across industries, countries and company size bands.
- Testing whether a job postings indicator adds to official statisticsTwo models forecast one official figure: its own past, then the same model with postings added. The design, the vintage tables it needs, and a worked example in which a lower error still fails its interval.
- Tracking entry-level and senior hiring as an economic indicatorThe seniority mix of the roles companies advertise shifts with their plans, and also with labels and company mix. How to measure it each week, set it beside official statistics and test a shift before you report it.
- How to seasonally adjust a job postings time seriesJob postings follow the calendar as well as demand. What the official seasonal adjustment methods ask of a series, what they cannot remove, and two comparisons that need no model, worked through on an illustrative weekly series.
- How to track wage growth using salary ranges in job postingsA median of advertised pay moves when the mix of roles moves. How the Employment Cost Index, average hourly earnings and the Atlanta Fed's tracker handle that, and how to build a posting-based index that holds the mix fixed.
- Job postings data and the BLS JOLTS job openings series comparedJOLTS asks sampled employers how many positions were open on one day; a postings index counts adverts. What each measures, why their levels and turns part, and how to compare the two on growth.
- How to build a sector hiring index from company job postingsOne large employer can decide a sector index built by summing its postings. Here is how to weight, cap and bound company-level hiring, with SQL on daily data and an illustrative example.
- Early indicators of an industry-wide hiring slowdownThree readings of job postings across an industry: the flow of new roles, how widely it falls and how long roles stay open. With the queries, what else moves each reading, and the official rates that report on the same months.
- How compensation teams keep sales pay benchmarks current during the yearOfficial occupational pay statistics arrive at most once a year, months after the date they describe. A weekly median of advertised sales pay on a control chart shows when the market has really moved, and when to act.
- Labour market data sources that arrive before official statisticsClaims, payroll counts and job postings arrive between the monthly jobs reports. Each is described here from its publisher's own methodology, with its week, delay and revision rule, and a worked example lines the weeks up.
- How to track enterprise technology spending with alternative datasetsAdoption and hiring data date the direction of enterprise technology demand, and payment, procurement and official figures carry the amounts. What each dataset observes, three queries and a worked example.
- How job postings are classified by occupation taxonomy and seniority levelA function or seniority label on a job posting rests on a taxonomy and a method. How public classifications and vendor taxonomies differ, what the Fokals fields hold, and how to grade fifty labels by hand before you trust a trend.
- How to measure hiring velocity from job postings: the formulaHiring velocity is postings opened per 100 employees per 30 days. The formula, three companion measures, a worked example and how to read one company against its industry and size band.
- Same-store cohorts: how the weekly market series stay comparableCoverage of a company index expands continuously, and a raw count would carry that expansion into every trend. Here is the cohort rule that keeps it out, and the arithmetic of every measure it feeds.
- Benchmarking pay and talent demand for workforce planningA workforce plan needs the pay employers advertise for a role and how many of them are competing for it. Here is how to build both from job postings.
- Benchmarking sales compensation from advertised payQuartiles of advertised base pay and on-target earnings for sales roles, by country and week. Here is how to place a plan against them and how to read the result.
- Measuring remote and hybrid work trends by industryThe share of new postings that state remote or hybrid work can be read every week by industry and country. Here is what it counts, how to pull it and how to read it.
- Producing market research from weekly aggregate seriesA weekly series is only as good as its footnote. Here is how research and media teams pull the Fokals Market Series, test a number before it is printed and cite it.
- Sector hiring trends for macro and thematic researchA thematic view is a claim about a sector, not one company. Here is how to read hiring series that hold their company cohort fixed, and how to test a theme across industries.
- A market dashboard on company signals in Data Studio (Looker Studio)How to shape the market series table for charting, build rate, index and growth charts with an industry filter, and avoid the aggregation and base-date traps that distort a weekly series.
- Power BI reports on company signalsA model for hiring and technology trends in Power BI: which tables are facts, which measures must not be summed, how refresh fits write-once tables and how row-level security keeps viewers in scope.
- Job functionA job function is the kind of work a role does, whatever its title. This entry shows how it differs from title and department, how it is queried and how a function share is read.
- Same-store cohortCompare only the companies present for the whole window, so wider coverage does not look like market growth. The method, a worked example and where it is used.
- Seniority levelSeniority level places a job on a ladder from intern to executive. How it is read from a posting, where titles mislead, and how it appears in Fokals hiring data.