Case Study: Clear Channel Outdoor achieves cheaper, faster, automated congressional reporting with Alteryx

Revamped Report Cheaper, Faster, Fancier, and Happier

Clear Channel Outdoor needed per-member-of-Congress reports for its lobbying team but was paying a vendor $20,000/year for quarterly updates that lacked maps and flexibility. The company asked its GIS Manager to replicate and extend the vendor’s output — first adding OOH counts, then determining which radio stations could be heard in each district, and finally recreating the entire report in-house.

Using Alteryx Designer and Server Scheduler, John Hollingsworth built an automated workflow that ingests radio coverage polygons, station locations, Congressional district boundaries, OOH inventory and contact lists, performs spatial joins and analysis, and outputs a PDF report per Member with maps, counts, and leadership contacts. The result: vendor contract canceled (saving $20K/year), monthly automated reports with richer features (maps, contact info, employee and asset counts), and a much happier lobbying team.

Clear Channel Outdoor

John Hollingsworth

GIS Manager