OOH Data Extraction & Decision Support Tool

A desktop app that extracts billboard and location data from PPTX, PDF, and image files, then generates detailed, chart-filled PPTX reports with location maps.

This Windows desktop application was developed to assist a media company in analyzing Out-Of-Home (OOH) advertising data. The application allows users to import PPTX, PDF, or image files containing OOH campaign details. Using OCR (Tesseract), it intelligently extracts billboard images, GPS coordinates, location details, and other structured data.

Once extracted, the app reorganizes and compiles the content into a well-structured PPTX file. This report includes charts, tables, and a map with location pins, enabling marketing teams to easily analyze campaign coverage, identify underperforming areas, and plan future placements.

The app dramatically reduces the manual effort required to parse media plans, while ensuring accuracy and enabling location-based decision-making using visual and data insights.

Client Benifits

This app replaced a highly manual, error-prone process with a streamlined solution that automatically extracts, transforms, and visualizes OOH campaign data. It enabled the client to make faster and smarter advertising decisions based on visualized insights and geolocation data.