The difference between an operator who scouts every campaign from scratch and one who draws on a mature location database is the difference between a vendor and a strategic partner. A location database is how an outdoor advertising operator converts the work of past campaigns into a durable competitive asset that improves every future campaign in the markets it covers.
Our team at American Guerrilla Marketing has built a location database across 50+ U.S. markets through years of wheat paste poster campaign execution. That database is one of our most significant operational assets. It allows us to build precise campaign briefs faster, identify high-performing surfaces with confidence, and draw on campaign history that makes each successive activation in a familiar market more accurate than the last.
Building that kind of database does not happen all at once. It is built incrementally, campaign by campaign, with consistent data capture disciplines that convert each scouting session and each installation report into a lasting record. This guide covers how to structure that database, what data to capture, and how to maintain it so it becomes more valuable with every campaign that runs through it.
The Core Database Structure
A location database for outdoor poster campaigns needs a structure that supports three primary use cases: campaign planning (finding suitable locations in a target market), installation navigation (directing crews to precise surface locations), and performance analysis (evaluating which locations produce the best campaign outcomes). These use cases define the data fields the database must contain.
Primary Record: The Location Entry
Each location in the database has a primary record with the following core fields: location ID (a unique identifier for cross-referencing), GPS coordinates (latitude and longitude), street address, surface description, surface dimensions (height and width in feet), surface material type, surface condition rating at time of last inspection, market name and neighborhood classification, property owner contact name and status, access agreement reference, and date of last record update.
These core fields make each location record usable for campaign planning without requiring additional research for standard campaigns in known markets. A planner pulling a list of available surfaces in a specific neighborhood can use the core fields to evaluate suitability, check access status, and confirm dimensions without leaving the database.
Campaign History Records
Each location entry should be linked to campaign history records documenting every campaign that has run at that location. Campaign history records include the campaign name and client, installation date, removal date or observed duration, poster format and size, GPS-tagged installation photo links, and any post-campaign condition notes. This history allows planners to assess how a surface has performed over time: whether poster durability is consistent, whether access agreements have been honored reliably, and whether the location has generated positive client feedback in past reporting.
Property Owner Relationship Records
Property owner relationship data is sensitive and should be maintained with appropriate access controls in shared database systems. The property owner record for each location includes the owner or manager name, contact information, relationship status (new prospect, active relationship, dormant, unavailable), compensation arrangement if any, agreement reference and expiration date, and relationship history notes documenting the evolution of the operator’s access to the surface. This record is the most operationally valuable element of the database for markets where property relationships determine surface access.
Tools for Building and Maintaining the Database
The right tool for a location database depends on the scale of the operation and the number of markets it covers. Operations with a smaller number of locations in a limited number of markets can function well with structured spreadsheets. Operations covering hundreds of locations across dozens of markets benefit from purpose-built geographic database tools.
Spreadsheets for Smaller Operations
Google Sheets or Microsoft Excel are the most accessible database tools for smaller outdoor advertising operations. A well-structured spreadsheet with consistent column definitions, filter capabilities, and linked photo files functions as an effective location database for operations covering 50 to 200 locations across a limited number of markets. The primary limitations of spreadsheets are their weak geographic querying capabilities and their reliance on manual organization rather than automated geographic visualization.
GIS Applications for Geographic Visualization
Geographic information system applications like ArcGIS Online or QGIS allow location databases to be presented and queried as geographic visualizations rather than spreadsheet rows. A GIS-based database allows planners to identify all database locations within a specific radius of a target neighborhood, assess the geographic distribution of available surfaces across a market, and produce map-based reports that present location selections to clients in a visually intuitive format. The learning curve for GIS tools is higher than for spreadsheets, but the geographic querying capabilities are significantly more powerful for campaign planning applications.
Purpose-Built Campaign Management Platforms
Larger outdoor advertising operations use purpose-built campaign management platforms that integrate location databases with scheduling, crew management, documentation, and client reporting functions. These platforms are more expensive and require more setup investment than general-purpose tools, but they create the operational integration between database, planning, and execution that large-scale operations require.
Capturing Database Data During Scouting
A location database is only as good as the data capture discipline applied in the field. The most common failure in location database development is inconsistent data capture: some scouting sessions producing complete, well-documented records and others producing partial records that require subsequent correction or supplementation. Consistent data capture starts with a standardized field protocol that defines what must be captured at every location, regardless of campaign context or time pressure.
Standardized Field Data Entry
A standardized field data entry form, accessed on a mobile device, guides scouts through the required data fields for each location without relying on memory to ensure completeness. The form should match the database structure exactly, with one field per database column, in an order that matches the natural flow of an on-site assessment. GPS coordinates should be captured automatically by the form application where possible, eliminating the manual entry step that introduces coordinate recording errors.
Photo Capture Standards
Photo capture standards for database records follow the same protocol as campaign scouting photography: wide-angle environmental context, medium shot from approach angle, and close-up surface condition. Database photos should be organized in a consistent file naming structure that links them to the location ID without requiring manual matching during database update.
Database Maintenance and Update Cadence
A location database that is not regularly maintained degrades in reliability as conditions on the ground diverge from the records. Maintenance is not a periodic project. It is an ongoing process integrated into every campaign operation that uses the database.
Post-Campaign Update Protocol
After every campaign that uses a database location, the location record should be updated with post-campaign condition notes, durability observation, any changes in property owner relationship status, and links to the campaign documentation photos. This update takes approximately five to ten minutes per location and ensures that the next campaign to use the same location starts with current, validated intelligence rather than potentially outdated records.
Proactive Market Surveys
For high-value markets where multiple campaigns run per year, periodic proactive market surveys, independent of any specific campaign, keep the database current between campaigns. A brief pass through key neighborhoods every six months, updating surface condition records and confirming property owner relationship status, prevents the database degradation that accumulates in active markets between campaign-triggered updates.
Frequently Asked Questions
What is a location scouting database for poster campaigns?
A location scouting database is a structured, searchable record of all surfaces that have been assessed, photographed, and documented for potential use in outdoor poster campaigns. It stores GPS coordinates, surface data, access information, campaign history, and property owner contact details for each location.
What information should be stored for each location in the database?
Each location record should include GPS coordinates, surface address and description, surface dimensions, surface condition rating, property owner contact information and access agreement status, campaign history, poster durability observations, and any known regulatory or access constraints. Photos of the surface should be linked or attached to each record.
What tools are best for building a location database?
The most widely used tools are structured spreadsheets like Google Sheets or Excel for smaller operations, and GIS applications like ArcGIS or QGIS for operations requiring map-based visualization and geographic querying. Purpose-built campaign management platforms are used by larger operations requiring integrated database and execution workflow management.
How does a location database improve campaign efficiency over time?
A mature location database eliminates the need to scout from zero in markets where campaigns have previously run. Campaign planners can pull a list of verified, high-performing locations from the database, confirm current access status, and build a location brief in hours rather than days. Each successive campaign in the same market becomes more precise and less expensive to plan.
How often should a location database be updated?
Location records should be updated after every campaign that uses the location. Post-campaign updates should include current surface condition, poster durability observation, any changes in property owner access status, and any enforcement activity observed at the location.
Can a location database be shared across multiple campaign teams?
Yes. A shared location database allows multiple campaign planners, scouts, and installation crews to access, contribute to, and benefit from the same cumulative location intelligence. Cloud-based tools support multi-user access with permission controls that protect sensitive property owner data.
What’s the minimum viable starting point for a location database?
The minimum viable starting point is a structured spreadsheet with consistent column definitions for GPS coordinates, surface address, dimensions, condition, access status, and photo links. Even a simple spreadsheet, maintained consistently after every campaign, builds into a meaningful operational asset within a year of active use. The structure matters more than the tool at the outset.
