NetFore developed new custom applications for MDMC to help them quickly normalize non-standard and inaccurate programming data and export it for customer use.
Fast, efficient data cleaning and extraction
The programming data contained in the logs is often inaccurate and inconsistent, making data extraction difficult. To simplify this process, NetFore developed a custom web application for identifying and cleaning programming data faster and more efficiently.
The application allows users to create and refine Elasticsearch queries and filters to quickly pinpoint all records that correspond to a specific PSA campaign. Users can then assign a label to all of the matching log records. These labels can then be used for reporting and analytics purposes.
The application also allows users to generate a CSV file containing the cleaned programming log data along with the proprietary broadcaster data used to create airplay reports. Users can specify a client name, a time range, and a list of PSA campaign names.