How do I set up availability calendar software for booking billboard inventory by market and format?

To set up availability calendar software for booking billboard inventory by market and format, you want to model the inventory in a way that matches how sales teams actually sell it: by location/market, display format, time period, and status.

Here’s a practical setup approach.

---

1) Define your inventory structure

Start by deciding the core dimensions of each billboard asset.

Common fields for each board

• Board ID
• Market
  Example: Atlanta, Dallas, Phoenix
• Submarket / DMA / zone
• Format
  Example: static, digital, bullet, poster, spectacular, wallscape
• Size / specs
• Orientation
  Vertical / horizontal
• Location details
• Latitude / longitude
• Traffic / audience data
• Owner / vendor
• Rate card
• Production requirements
• Status
  Active, pending, hold, sold, offline, reserved

---

2) Set up the calendar logic

The software should track availability by date range and inventory unit.

Each booking should include:

• Board(s) or package
• Start date
• End date
• Reservation type
  • Hold
  • Tentative
  • Confirmed
  • Cancelled
• Client / agency
• Campaign name
• Market
• Format
• Notes / conflicts

Availability rules

• A board cannot be double-booked for the same time period.
• A tentative hold should block inventory unless you allow soft holds.
• Digital inventory may allow daypart or rotation-based scheduling, while static inventory is usually booked by continuous date range.
• Some inventory may be grouped into packages by market and format.

---

3) Organize inventory by market and format

You’ll want filters and groupings like:

• Market > Format > Board
• Format > Market > Board
• Map view + calendar view
• List view by availability

Example

Market: Chicago

• Digital
• Static
• Highway
• Urban
• Airport

Market: Houston

• Digital
• Bullet
• Wallscape

This makes it easy for reps to find what’s open in a given market and format.

---

4) Create inventory statuses

Use clear statuses so everyone knows what is truly available.

Suggested statuses

• Available
• On hold
• Tentative
• Booked
• Sold
• Offline / maintenance
• Expired

Recommended rules

• Available = open for booking
• On hold = temporarily reserved, may convert to booked
• Tentative = likely booked, but not final
• Booked = committed
• Offline = unavailable due to maintenance or owner issue

---

5) Use packages and rules for grouped inventory

If you sell by market and format, it may help to create packages.

Example packages

• “Dallas Digital Roadway Package”
• “Atlanta Static Urban Package”
• “Top 10 Airport Boards in NYC”

Package logic

• Package is tied to multiple boards
• Software should check all included boards for availability
• If one board is unavailable, package availability may be partial or blocked depending on your rule

---

6) Configure conflict detection

Your software should automatically detect:

• Overlapping date ranges
• Double bookings
• Conflicting holds
• Offline periods
• Production deadline conflicts

Example

If a board is booked from June 1–30, another hold on June 15–20 should be flagged unless overlapping holds are allowed.

---

7) Add permissions and workflow

Different users need different access.

Roles

• Sales rep: view availability, place holds
• Traffic manager: approve and finalize bookings
• Admin: edit inventory, pricing, rules
• Client-facing user: view limited availability

Workflow

1. Rep searches market and format
2. Places hold
3. Traffic approves
4. Booking confirmed
5. Production deadlines tracked

---

8) Integrate rate cards and pricing

Tie each market/format combination to pricing.

Examples

• Digital in top DMA = premium rate
• Static roadside in secondary market = lower rate
• Seasonal pricing
• Demand-based pricing
• CPM / impression-based pricing for digital

The calendar should ideally show:

• Availability
• Rate
• Package discount
• Minimum booking duration

---

9) Pick the right interface

The best setup usually includes:

Calendar views

• Month view for long-term planning
• Week/day view for near-term execution

Filtering

• Market
• Format
• Date range
• Status
• Owner/vendor

Map view

Useful for billboard sales because location matters as much as time.

Bulk actions

• Place holds on multiple boards
• Book a package
• Export availability
• Send proposal

---

10) Automate alerts and notifications

Helpful alerts include:

• Hold expiring soon
• Booking conflict detected
• Production due date approaching
• Inventory turned offline
• Rate change
• Booking confirmation sent

---

11) Build reporting

Useful reports:

• Available inventory by market/format
• Occupancy rate
• Revenue by market
• Holds-to-booked conversion
• Underperforming inventory
• Inventory expiring in next 30/60/90 days

---

12) If you’re configuring software, set up these tables

A simple data model might include:

Inventory table

• inventory_id
• market_id
• format_id
• board_name
• specs
• status

Calendar/availability table

• availability_id
• inventory_id
• start_date
• end_date
• status
• hold_type
• booked_by

Market table

• market_id
• market_name

Format table

• format_id
• format_name

Booking table

• booking_id
• client_id
• campaign_name
• date_range
• inventory list
• status

---

13) Best-practice setup summary

If you want this to work well, make sure the software:

• Stores inventory at the board level
• Lets users filter by market and format
• Tracks date ranges
• Supports holds, tentative, booked, offline
• Prevents conflicts automatically
• Supports packages
• Integrates pricing and reporting
• Offers calendar + map views

---

If you want, I can also give you:

1. a sample spreadsheet layout,
2. a database schema, or
3. a step-by-step setup for a specific tool like Airtable, Smartsheet, Monday, or a custom web app.