How to Build OOH Inventory Reports and Analytics

An OOH inventory report assembled from a collection of market spreadsheets, each updated by a different market manager on a different schedule, is a report of what the inventory looked like at different points in time for different markets — not a picture of what it looks like right now.

Outdoor advertising operators are asked regularly to report on portfolio performance — to management, to investors, to agency partners, to permit authorities. The standard response is a report assembled from individual market files, which takes time to produce, requires reconciling inconsistencies between market formats, and becomes outdated before it reaches the meeting where it's presented. When the actual data — structure counts, available inventory, format mix, occupancy rates, permit status — lives in a unified live database rather than scattered market files, reporting is a filter and an export rather than a data assembly project.

Atlas generates OOH inventory reports and analytics as a byproduct of maintaining a live, unified portfolio map — every structure status update, every availability change, every permit renewal contributes to the reporting dataset without anyone maintaining a separate reporting spreadsheet.

Here's how to build the reports your portfolio requires.

Why Unified Inventory Data Is the Foundation of Credible OOH Reporting

A report assembled from different sources has different accuracy levels in different rows — and no one knows which rows those are.

OOH inventory reports built from a unified live database are reports stakeholders can trust — because the data didn't come from a spreadsheet that someone updated before the meeting.

Step 1: Define the Metrics Your Portfolio Reports Will Track

Before building any report, define what you'll measure:

Structure count and active inventory — total structures by market, format, and ownership classification; the baseline portfolio composition metric that everything else is calculated against
Availability rate — the percentage of structure faces currently available for sale, by market and by format; the sales pipeline health metric that sales management watches most closely
Occupancy rate — the inverse of availability; percentage of available inventory currently sold; the revenue utilization metric that finance and leadership track
Permit compliance rate — the percentage of structures with current, non-expired permits; the regulatory health metric that risk management requires
Average revenue per face per period — the revenue efficiency metric that compares performance across markets and formats when expressed per-unit rather than in aggregate
Format mix — the breakdown of portfolio faces by format category (bulletins, posters, digital, transit) by market; the strategic composition metric that capital allocation decisions use

Each metric needs a precise definition — what counts as "available," what the revenue period is, whether acquired structures in integration are included in the active inventory count — before it's calculated, so the metric is consistent across reporting periods.

Step 2: Verify Data Completeness Before Reporting

A metric is only trustworthy if the underlying data is complete:

Audit availability status completeness — are all structures in the database carrying a current availability status, or are some showing a status that hasn't been updated in weeks? Availability metrics calculated from stale status fields are not reliable
Verify permit record completeness — do all active structures have a current permit record with an expiration date? Permit compliance rates calculated against a database with missing permit records undercount compliance risk
Check market record consistency — do all structures in each market follow the same format classification conventions? A market that uses "14×48" and another that uses "Bulletin" for the same format type produce inaccurate format mix metrics when aggregated
Confirm new structure additions — have structures built in the last reporting period been added to the database? Inventory counts that exclude recently developed structures understate the portfolio
Validate removal records — have structures demolished or darkened in the last reporting period been appropriately reclassified? Active inventory counts that include removed structures overstate the portfolio

Data quality problems found before a report is sent to leadership or investors are correctable. Data quality problems found by the recipient are credibility problems.

Step 3: Build Standard Report Templates for Each Audience

Different stakeholders need different cuts of the same data:

Sales management report — available inventory by market and format, upcoming availability (structures coming off current campaigns), aging inventory (available structures that have been unsold for more than a defined threshold)
Operations report — structures with open maintenance work orders by market, permit expiration calendar for the next 90 days, structures with compliance issues requiring resolution
Finance and executive report — occupancy rate and revenue per face by market, format mix comparison across markets, period-over-period trend for key portfolio metrics
Investor report — total portfolio structure count, geographic distribution map, occupancy and revenue trend, development pipeline status
Agency and advertiser report — available inventory in a specific market and format category, with map view showing geographic distribution of available structures for campaign planning

Build each template once against the live database and update it with current data on the report cadence — not from scratch each reporting period.

Step 4: Map Portfolio Metrics Geographically

Tabular metrics without geographic context miss the most important dimension of an OOH portfolio:

Map availability by structure showing available inventory as colored points on the map — a sales manager looking for available inventory near a specific advertiser location gets the answer from the map immediately, not from filtering a table
Visualize occupancy rates by market territory using color-coded market boundary polygons — a market with below-average occupancy is visible on the portfolio map at a glance
Show format distribution geographically to identify markets where format mix doesn't match the traffic pattern — a market with heavy digital inventory on roads where analog bulletins would generate more revenue is a strategic insight that appears on the map

Also read: Share a Billboard Inventory Map with Advertisers

Step 5: Establish Reporting Cadence and Distribution

Reports only drive decisions when they're delivered consistently:

Weekly sales reports for sales teams showing current availability, posting changes, and upcoming availabilities — the operational data that drives daily sales activity
Monthly portfolio reports for management and operations covering occupancy trends, permit status, and maintenance activity
Quarterly investor or board reports with portfolio composition, geographic distribution, and period-over-period performance against key metrics
On-demand reports for investor inquiries, agency RFPs, and acquisition due diligence that require specific data cuts not covered by standard templates
Alert-based reports triggered by threshold crossings — occupancy falling below a target level in a specific market, permits expiring without a renewal initiated, structures with extended open maintenance work orders

Consistent reporting cadence means management sees trends rather than snapshots — and can make adjustments before trends become problems.

Step 6: Use Reporting Data to Drive Portfolio Decisions

Reports that don't change decisions aren't worth producing:

Set performance targets for each key metric by market at the beginning of each year — occupancy target, permit compliance target, average revenue per face — and measure actual performance against targets monthly
Identify underperforming markets using comparative metrics and investigate the root cause — is a market with below-average occupancy suffering from weak demand, poor inventory mix, outdated rate card positioning, or inadequate sales coverage?
Prioritize capital investment in markets where the data shows the highest return on new structure development, format conversion, or major maintenance investment
Report improvement trends over time showing management that operational investments are producing measurable results in the metrics that matter

Use Cases

Building OOH inventory reports and analytics matters for:

Multi-market OOH operators who currently spend significant staff time assembling reports from individual market files every reporting cycle and want reporting that comes from the live database
Private equity-backed OOH companies whose investor reporting obligations require consistent, comparable portfolio metrics each quarter — metrics that require a unified inventory database, not a collection of market files
OOH companies preparing for sale or capital raise who need to produce credible historical portfolio performance data for a management presentation, and whose current reporting infrastructure produces data that varies in quality by market
Municipal outdoor advertising programs with public reporting requirements for city-owned advertising assets — permit compliance rates, occupancy, and revenue by market area are typical public reporting requirements
Agency holding companies managing OOH media plans across multiple operator partners who need a unified inventory view for campaign planning and post-campaign delivery reporting

It matters for any organization where inventory reporting currently requires assembling data from multiple sources before every reporting cycle — and where the time spent assembling data reduces the time available to act on it.

Tips

Report occupancy and availability separately — occupancy is sold as a percentage of available; availability is available as a percentage of total; they're different metrics with different denominators and different uses
Show the basis of every percentage metric — "72% occupancy" is incomplete; "72% occupancy (388 sold of 539 available faces)" is a complete metric that lets the reader evaluate what the percentage actually means
Separate organic performance from acquisition effects — a portfolio that shows improving occupancy because acquired structures were added to the numerator is performing differently from a portfolio with the same occupancy improvement from genuine sales improvement; report both
Archive every report with the data snapshot date — a portfolio metrics report from eight months ago that doesn't specify the data date is useless for comparing to current metrics
Don't optimize your report format for the tools you have — if the best report for your sales team is a map with a table, build that, not a spreadsheet just because spreadsheets are what your current reporting workflow produces

OOH inventory reporting built from Atlas's live database is reporting that leadership can rely on — because it comes from the same source everyone is already using to manage the portfolio.

OOH Analytics and Reporting with Atlas

Meaningful portfolio reporting requires a unified live database where every structure's status, availability, and permit record is current — not a collection of market files assembled before each reporting cycle. Atlas generates reporting as a natural byproduct of portfolio management rather than as a separate data assembly project.

From Market Files to Live Reports

With Atlas you can:

Generate availability, occupancy, and permit compliance metrics from the live inventory database at any time — without waiting for market managers to update their individual files
Build standard report templates for sales, operations, finance, and investors that draw from the same underlying data with different level-of-detail and formatting for each audience
Map portfolio metrics geographically to give spatial context to the tabular numbers — occupancy by market on a color-coded boundary map communicates more than an occupancy table sorted by market name

Also read: Manage OOH Assets Across Multiple Markets

Reporting That Drives Better Decisions

Atlas lets you:

Track occupancy and availability trends across reporting periods to identify whether portfolio performance is improving or deteriorating — and in which markets the trend diverges from the portfolio average
Export data in any format required for investor reporting, agency RFPs, acquisition due diligence, and regulatory compliance filings
Set performance targets and compare actual metrics against targets monthly, creating the accountability structure that makes reporting more than a backward-looking summary

That means portfolio reporting that stakeholders trust and that actually informs the decisions it was assembled to support.

Reporting at Any Scale

Whether you're reporting on 200 structures in a single market or 8,000 across a national portfolio, Atlas generates consistent, comparable metrics from the same live database without manual data assembly.

It's OOH inventory analytics built for the outdoor advertising operator — where the reporting comes from the portfolio management, not the other way around.

Build Your First Data-Driven OOH Portfolio Report Today

Portfolio reporting starts with unified inventory data. Atlas gives you the live database, standard report templates, and geographic visualization that turn OOH inventory metrics from a data assembly project into a management tool.

In this article, we covered how to build OOH inventory reports and analytics — from defining metrics and verifying data completeness to building audience-specific report templates, mapping portfolio metrics, establishing reporting cadence, and using reporting data for portfolio decisions.

From weekly sales availability reports through quarterly investor reporting and on-demand due diligence data, Atlas supports complete OOH inventory analytics without separate reporting infrastructure.

So whether you're replacing a collection of market files with unified portfolio metrics or building your first formal OOH reporting program, Atlas gives you the analytics foundation your portfolio management requires.