Affidavit Matching Report

The Affidavit Matching Report shows the results of matching purchased spots from buy entry with spots entered from affidavits, on a spot-by-spot basis within a specified broadcast month. The report details each spot on the buy line, showing successful matches, forced matches, spots which were ordered, but did not air and spots which aired, but were not ordered.

Poor vertical and horizontal rotations are flagged, based upon the settings defined in the Buying Unit Profile Definition.

The report also compares performance of purchased Gross Ratings Points (GRPs) to PVT x Share, estimated GRPs, and/or actual GRPs on a spot-by-spot basis. If the client requires entry of ISCIs, they are included on the report. A spot with an ISCI that ran before the release date or after the recall date will appear as unsuccessfully matched in the "Run But Not Purchased" section of the report. You may limit the report to discrepancies (non-matched spots) if necessary.

Keep in mind that if you are using Dual Costing, this option always uses the vendor cost.

To create this report, select Affidavits | Affidavit Matching Report.

Affidavit Matching Report Window

1. Key the Media and Client for the report.

2. Key a Product, a Product Group, or select the All Products check box. Select the Combine Products check box to combine products or clear the check box to report each product separately .

3. Key an Estimate, Estimate Group, or select the All Estimates check box.

   If you select the All Estimates check box, you can: Select the Combine Estimates check box in order to combine all the estimates on the report. Leave the Combine Estimates check box blank so that each estimate appears separately on the report.

    

   • Select the Est-Item Order check box to print the spots in estimate-item order or clear the check box to print the spots in date-time order.

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. To limit the report to a payee rep that was specified on the buy line, key the Payee Rep code. Do not key the payee rep if it was assigned on the station profile.

6. Key either Start and End Months or Start and End Dates for the date range to be included in the report.

7. For Pandora Users.  To report impression delivery supplied by Pandora on the electronic invoice, the Affidavit Matching Report can be run for the corresponding impression category provided it exists on the estimate.  For example, if Pandora supplies impression delivery for adults 18 to 49 on the electronic affidavit, then check the “Specify Demo” option and select the IP1849 demo category.

8. To show ratings to three decimal places, select the Show 3-Decimal-Position Ratings check box. To show ratings to one decimal place, clear the check box.

9. To calculate an estimated rating when the actual book is not yet available, key up to two PVT books and a Share book.

10. Select one or more of the available Report Options.

11. Choose your preferred Report Formatting Options.

12. Click the <Submit> button or to export information to a spreadsheet format, click the Next icon to display the Detail Window.

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

Related Topics

• Buying Unit Profile Definition