Return On Investment Report Definitions

Return On Investment Report Definitions

This report returns media schedules with a start time between the date range start and end date and time.

Return On Investment Report Column Definitions
# ANS# Calls sourced to the Media Schedule (could be multiple Media Schedules based on grouping)
# ORDS# Orders sourced to the Media Schedule (could be multiple Media Schedules based on grouping)
% CLOSE# ORDS / # ANS
$ SPEND AMTSpend amount of the Media Schedule (could be multiple Media Schedules based on grouping)
# CALLS PER K($ SPEND AMT / 1000) * # ANS
$ COST PER ORD$ SPEND AMT / # ORDS
$ PRD REVQuantity * UnitPrice of the items on the order
$ AVG TKT$ PRD REV / # ORDS
$ TOT REV(Quantity * UnitPrice) + Shipping of items on the order
$ TOT AVG TICKET$ TOT REV / # ORDS
$ REV PER CALL$ TOT REV / # ANS
ROI PROD RATIO$ PRD REV / $ SPEND AMT : 1
ROI TOT RATIO$ TOT REV / $ SPEND AMT : 1
 
FILTERS
Media Schedule Start Date RangeThe start date of the media schedule
Media Schedule Start Time RangeThe start time of the media schedule
ClientThe client of the campaign of the ad copy the media schedule belongs to and also of the product group            
CampaignThe campaign of the ad copy the media schedule belongs to
Product GroupThe product group of any items on orders
StationThe station of the media schedule
 
GROUPING                                             
Ad CopyThe ad copy the media schedule belongs to
CallOrder DateThe call/order date
CampaignThe campaign of the ad copy the media schedule belongs to
ClientThe client of the campaign of the ad copy the media schedule belongs to and also of the product group
DateThe media schedule start date
Day Of WeekThe day of week of the media schedule start date
DNISThe DNIS of the calls/orders
Fiscal WeekThe fiscal week of the media schedule start date
Media ScheduleThe start date and time, end date and time, and DNIS of the media schedule
StationThe station of the media schedule

    • Related Articles

    • Warehouse Report Definitions

      This report displays all locations for all warehouses and the inventory items in them. Definitions Warehouse Report Column Definitions Warehouse The warehouse name Location The floor/aisle/section/shelf in the warehouse Is Multi? Whether or not the ...

    • Supplier Item Report Definitions

      This report display supplier item information. Definitions Supplier Item Report Column Definitions Supplier The supplier name Item The inventory item Sku Supplier Sku The supplier Sku for the inventory item Unit Of Measure The unit of measure for the ...

    • Client List Report Definitions

      This report lists clients entered in OLX. Client List Report Column Definitions Client ID The ID of the client Client Name The name of the client Contact Name The contact name for the client Address The address of the client Phone Number The phone ...

    • Payroll Batch Report Definitions

      This report is run by payroll batches that are created and displays time worked and payroll info. Payroll Batch Report Column Definitions Employee Name Name of the employee Department The department the employee punched in to Shift The shift name the ...

    • Item List Report Definitions

      You can use the (product) Item list report to view product items by Client, Product Group, or Active status.   The report shows the (product) Item Name, Description, Product Group, External SKU, Client, Active Status, and number of product offers for ...