AdTracker Database System
The core DPS AdTracker™ product tracks all text, graphic, and logo components of each display ad, and then follows the ad through stages of composition, to proofing, to page layout and finally to archiving and purging. It provides real-time element status and management functions from either PC or Mac platforms. Interfaces are available for accepting insertion order data from an external order entry system or for accepting page layout information from an external ad reservation system. The product is implemented using the industry standard Microsoft SQL® database running on Windows networks. This allows user extensions to DPS AdTracker™ through standard, off-the-shelf software packages, such as inexpensive report writers or any ODBC compliant MS SQL® application.
Business System Interface / Page Layout Interface
DPS can provide an interface between an existing order entry system and DPS AdTracker™ to eliminate re-keying insertion order data. The business system data then drives automatic creation of the database record, insertion of pertinent information about the ad and its sub-elements, as well as run date information. The interface can be configured to a specific business system, or the user can provide data in a format specified by DPS. It’s also possible to feed DPS AdTracker™ with page layout information. If this interface is possible, managers in both ad production and editorial can take advantage of a graphical page status view of the ads running in the current edition of the paper. This feature provides a real time check of ads that are scheduled to run, are in house, and are ready to be placed on a page.
The entire pickup process can be automated. No more searching for old ads or old artwork. The pickup information is entered into the order entry system and processed by the DPS AdTracker™ business system interface. The old pickup ad is located, copied to the new ad number, and all the artwork is linked to the new ad. The old ad remains in its original form. If no changes are required, an EPS or PDF of the ad could be created and sent off to the pagination system without anyone having to be involved in the process.
Team Configuration and Management
DPS AdTracker™ can be configured to allow team ad production. Ads can be assigned to specific ad designers based on team concepts. This is an automatic process built into the order entry interface. Ads can be assigned, tracked, and managed by team. Automatic Proof Faxing Module Ad-Fax is designed to significantly reduce the labor involved in producing and delivering ad proofs to your advertisers. Each newspaper can create proof templates containing their branding logos and specific proofing information. When your ad is ready to go to an advertiser as a proof, DPS AdTracker™:Online will take over and simplify your workflow. DPS AdTracker™ and DPS AdTracker™:Online combine to automate the creation of the proof template and then deliver the proof to your advertisers.
The EPS/PDF Router
The DPS AdTracker™:EPS/PDF Router will provide a simple solution to a host of production problems. If you have multiple production sites and multiple ad delivery requirements this is your answer. The EPS/PDF Router will sort out all the issues associated with color ads and B&W ads going to different paths, or the need for file extensions or elimination of file extensions. If you need to deliver an EPS/PDF of the final ad to more than one print facility because the ad has been cross-sold, this is no problem for the EPS\PDF Router. Have a WAN bandwidth issue; the answer is The EPS\PDF Router. Cross-selling and regional ad production adds a significant level of complexity and labor to the ad production workflow. In this case Ads can be built and modified in multiple locations and final EPS/PDF files need to be routed to multiple production facilities. The DPS AdTracker™ Remote Production module allows users to initiate ad production at one location and easily complete production at another location. Only one copy of the ad exists and DPS AdTracker™ manages the delivery of this ad to the correct location. Both manual and automated pickups are implemented across all of the newspaper locations. Once the ad is finalized, one EPS/PDF is created and the EPS/PDF Router module takes care of making copies and delivering them to the correct production facility. The EPS/PDF Router module can route EPS files to one location and PDF files to others. It can also manage the adding or removing file extensions of the final ad file type. This module provides significant productivity and reliability to these complex multi newspaper environments.
Automatic EPS/PDF Generation
AdTracker can be configured to schedule the automatic generation of EPS/PDF versions of ads and send them to the appropriate pagination queues. It can detect color ads and EPS/PDF them separately from the B&W ads and can send ads to various pagination queues based on ad type (Class/ROP) or by publication.
DPS AdTracker™:AutoEPS application can be configured to automatically provide PDF versions of ads as an ad production member places them into a “Proof Out” status. The system can detect that an ad has entered a proofing status and trigger a process, which produces a PDF of the ad. Sales reps for viewing or proofing can pull up the PDF, or it can be electronically sent to a customer for proofing. The PDF versions of the ad are linked to and kept with the ad at all times. This process requires an EPS to PDF conversion application such as Adobe Acrobat®.
Integrated Report Generator
One of the most important features of ad tracking database products is their ability to extract and report information stored in the database. DPS AdTracker™ comes with its own built in report generator. The DPS AdTracker™ Browser Reports application has a simple to use database query interface. The Browser Reports application provides access to two types of reports, real-time ad hoc information and historical productivity information. The real-time ad hoc function provides access to daily management information such as current “Proof Out” status, status of ads for tomorrow’s paper, ads sent to pagination queues, ads by sales rep, spec ad information, deadline information, and many other on the fly ad hoc queries. The historical productivity reports allow managers to get access to production information by user, by team, or as an organization. The reports detail the amount of time per ad, the number of ads, and the amount of column inches.
Real-time Ad Production Management
DPS AdTracker™:AdAlert is designed to significantly improve the management of every aspect of ad production. This DPS plug in module runs in the background and monitors every database event. Specific database queries and reports can be scheduled to trigger at key times in the daily production cycle. The results of these database queries or reports can be sent via email to sales reps, specific advertisers, the production staff or to designated team members. The results can also be in html format. DPS AdTracker™:AdAlert is on the job all day every day making sure nothing in ad production falls through the cracks. It will ensure that everyone is always aware of any problems in ad production.
Online Ad Management
DPS provides complete Ad Management on the web. DPS AdTracker™:Online is a web enabled SQL database driven ad management tool. DPS AdTracker™:Online is designed to simplify the flow of ever increasing electronic ads to and from your customers. It provides the customer with a simple, convenient and consistent interface for all electronic ads. Newspapers can finally take control of incoming electronic ads. Customers need only a web browser to send in new ads, proof existing ads, check on the status of ads in production and place orders for new ads.
Simple Remote Site Integration
AdTracker Remote is specifically designed for sites, which have limited communication bandwidth between the main AdTracker site and the remote sites. This solution provides a mechanism where only specific ads and their artwork are moved between the main and remote site in a manual on demand mode. A site control menu is added to the main DPS AdTracker™ spreadsheet view. Within this site control menu are options for a designer to either move an ad and it’s Jacket to its site or to send an ad from its site to another site. Ads in any status of the workflow can be sent or pulled. Unlike the normal remote site workflow, in this option, once an ad is sent or pulled it is under the control of the receiving site and cannot be accessed from the other sites. Sites are specified by the sales rep code assigned to the ad. All ads whose sales rep codes are “undefined” will initially have undefined site codes. The first site to open an ad with an undefined site code will take control of the ad. The site code will become the site where the ad is first opened. Manual and automated pickups are “remote site aware” in this option, which allows the pickup process to operate even if the ad being picked up does not exist at the site where the new ad will be built.