Purchased vs Detected Report

Use the Purchased vs Detected Report to compare purchased schedules to spot detected data. Use of this option requires that the agency subscribe to a spot commercial detecting company. MediaBank is currently working with a third party audit company to receive this data. This report is similar to the Affidavit Matching Report but the results of the comparison are not saved. Therefore, each time the report is run, the latest detected data is compared to the current buy data. You may request either a printed report or a spreadsheet containing the report information.

Only stations monitored by the detecting company are included on this report. Tax amounts are not included and the spot cost shown is the ordered cost. The report compares client, product, station, band code, date, time and spot length.  ISCI is considered if ISCI is required on the estimate. Since there can be multiple estimates for the same time period for the same client, product and market, the estimate code is not considered unless your agency supplies the estimate code to the third party audit company and requests the report for that specific estimate.

To request the report, select EDI | Purchased vs Detected Report.

Purchased vs Detected Report Window

1. Key the Media and Client for the report.

2. Key a Product, Product Group, or select the All Products check box.

   • If you choose a Product Group or select the All Products check box, you may select the Combine Products check box to combine all products on a page.

3. If you have supplied an estimate code to a third party audit company, you may key a specific Estimate to limit the report to that estimate. Otherwise, key an Estimate Group or select the All Estimates check box.

   • If you choose an Estimate Group or select the  All Estimates check box, you may select the Combine Estimates check box to combine estimates for the same product.

4. Key a Market, Market Group, or select the All Markets check box. Alternatively, you can key in a Station/Band combination.

   If a client-specific market group code is keyed in the Market Group field, you must select the Client Specific check box.

    

5. Key Start and End Months or Start and End Dates if you did not key a specific estimate.

6. By default, the report shows ratings to one decimal place. To display ratings with three decimal places, select the Show 3-Decimal-Position Ratings check box.

7. To calculate an estimated rating when the actual book is not yet available, key one or two valid PVT books and a Share book.

8. To include program titles on the report, select the Print Program Titles check box.

9. To limit the report to unconfirmed items, select the Print Unconfirmed Items Only check box.

10. To print cost amounts on the report, select the Print Cost check box.

11. To print items in air date/time order and omit rotation checking, select the Print Date/Time Order check box. Leave the check box unchecked to print items in estimate/item order.

12. If you want a printed report:

    • Choose your preferred Report Formatting Options.

    • Click the <Submit> button.

    • Click the Reports icon in the MediaBank A|V toolbar to display the View Spool File window where you can access your report.

13. If you want to create a spreadsheet version of the report, click the Next icon and follow the instructions for Creating a Detected Spreadsheet.

Related Topics

• Affidavit Matching Report