How do I set up asset tracking software to centralize specs and photos for OOH inventory?

To set up asset tracking software for OOH inventory so it centralizes specs, photos, and location data, treat it like building a single source of truth for every face/site.

1) Define the asset record structure

Start by deciding what each inventory item must contain. Typical fields:

Core identification

• Asset ID / Face ID
• Inventory type: billboard, poster panel, digital screen, transit shelter, etc.
• Site name
• Address / GPS coordinates
• Market / region
• Owner / operator
• Status: available, sold, booked, under maintenance, inactive

Physical specs

• Dimensions
• Orientation: portrait / landscape
• Illumination: yes/no
• Static vs digital
• Format / panel type
• Visibility / read direction
• Road type / traffic count if relevant
• Installation date
• Material / construction notes

Photo management

• Primary current photo
• Additional angles
• Close-up of face/spec plate
• Date captured
• Photographer / uploader
• “Before/after” or historical versions
• Photo tags: daytime, nighttime, winter, street-level, aerial

Commercial fields

• Rate card
• CPM or other pricing attributes
• Product eligibility
• Minimum booking duration
• Availability calendar
• Client restrictions

Operational fields

• Inspection date
• Maintenance history
• Permit / compliance status
• Lease expiration
• Safety notes

---

2) Choose software that supports flexible asset records

Look for a system that can do these things well:

• Custom fields and templates
• Bulk import/export via CSV or API
• Photo/file attachments
• Search and filtering
• Role-based permissions
• Mobile upload from field teams
• Version history / audit trail
• Integration with CRM, ERP, or booking systems

If your current software is generic asset management, configure it like a database for OOH rather than a simple equipment tracker.

---

3) Build a standardized naming convention

Consistency is what makes centralized tracking usable.

Example:

• MKT-SITE-FACE-01
• NYC-045-A
• CHI-DOWNTOWN-BILL-12

For photos:

• AssetID_Date_View_Seq
• Example: NYC-045-A_2026-07-01_StreetView_01.jpg

This helps prevent duplicate records and makes searching easier.

---

4) Create templates for each inventory type

Don’t use one generic form for everything if you have multiple OOH formats.

Example templates:

• Static billboard template
• Digital billboard template
• Street furniture template
• Transit template
• Wallscape template

Each template should include only the relevant fields, so teams enter data faster and more accurately.

---

5) Set up photo capture rules

Centralized photos are most useful when they are standardized.

Recommended rules

• Take one primary street-level image
• Add left/right angle photos
• Include a close-up of the structure or face when needed
• Capture timestamp and GPS if possible
• Use the same orientation and distance standards across sites
• Require “current” status photos after changes or maintenance

If possible, use a mobile app with:

• Auto-geotagging
• Auto timestamping
• Direct upload to the asset record
• Offline capture for remote locations

---

6) Migrate existing data carefully

Before upload:

• Clean duplicate records
• Normalize addresses and site names
• Standardize dimensions and units
• Verify GPS coordinates
• Map old photo folders to asset IDs

Then:

• Import a small test batch first
• Check whether fields map correctly
• Confirm photos attach to the right asset
• Fix any broken links or inconsistent formats

---

7) Define roles and permissions

Typical roles:

• Admin: manages templates, fields, integrations
• Operations: edits specs and maintenance info
• Field team: uploads photos and inspection notes
• Sales team: views inventory and availability
• Management: dashboards and reports only

This prevents accidental overwrites and keeps the data clean.

---

8) Connect inventory to workflow

Asset tracking works best when it’s tied to daily operations:

• New site added → inspection and photos required
• Maintenance completed → update status and upload after photos
• Site booked → availability changes automatically
• Permit expiring → alert sent to operations
• Photo older than X months → renewal task created

Automations keep records current without relying on manual follow-up.

---

9) Add search and reporting views

Build views for common questions such as:

• All available assets by market
• Assets missing photos
• Sites with outdated inspections
• Digital inventory by spec
• Assets expiring in the next 90 days
• Premium locations by traffic or visibility

Dashboards should help sales and ops find data quickly.

---

10) Establish data governance

Centralization only works if people trust the data.

Set policies for:

• Who can edit specs
• How often photos must be refreshed
• Required fields before an asset can go live
• Naming conventions
• Review cycles for stale or incomplete records
• Audit checks for accuracy

A monthly data cleanup process is usually worth it.

---

Simple rollout plan

Phase 1: Foundation

• Define fields and templates
• Set naming conventions
• Import a small inventory set

Phase 2: Photos and field workflow

• Add mobile photo upload
• Standardize inspection processes
• Train field staff

Phase 3: Automation and reporting

• Add alerts, expirations, availability sync
• Build dashboards and views
• Connect to CRM/booking tools

---

Best practice recommendation

If you’re starting from scratch, make Asset ID the primary key and use that ID everywhere:

• In the asset software
• In photo file names
• In booking records
• In inspection logs
• In finance and permit docs

That makes it much easier to centralize everything around one record.

If you want, I can also give you:

1. a sample OOH asset data schema,
2. a recommended software feature checklist, or
3. a step-by-step setup guide in Airtable/Smartsheet/Monday.com.