Gross Sales Report Definitions

Gross Sales Report Definitions

This report is for orders placed in the date range. It shows information for debit items regardless of their processed status.

Gross Sales Report Column Definitions
# Ords / Ord IDNumber of orders for the specific grouping level, order id on the detail level
Ext Ord IDExternal order number of the order
# ItemsNumber of items for the specific grouping level
CountQuantity * Unit Count of the items for the grouping level
RevenueQuantity * Unit Price of the items for the grouping level
ShippingShipping amount of the items for the grouping level
RushIf an item is a rush item then the additional rush fee of the product offers for items for the grouping level
TaxTax amount of the items for the grouping level
Total RevQuantity * Unit Price + Shipping + Tax for items for the grouping level
 
FILTERS
Date RangeThe date range of the order
Order TypeRegular Order: An order with an external order number that does not start with 'WEB' Web Imported Order: An order with an external order number that does start with 'WEB'        
ClientClient of the source of the order
ScriptScript of the order
CampaignCampaign of the source of the order
Media BuyerMedia buyer of the source of the order
Media TypeMedia type of the source of the order
Product GroupProduct group of the item
TeamTeam of the employee who placed the order
EmployeeEmployee who placed the order
LocationLocation of the order
CountryShip to country of the order
Item TypeItem type of the item
Do Not Show Cancelled ItemsIf checked do not include items in 'Item Cancelled' status in the results.
Do Not Show Ship Cancelled ItemsIf checked do not include items in 'Item Shipment Cancelled' status in the results.
Do Not Show Batch OrdersIf checked do not include data entry batch orders in the results.
Include Autoship OrdersIf checked include autoship generated orders in the results.
Do Not Show Items w/an RMAIf checked do not include debit items that have an RMA item attached to them (open or closed).
 
GROUPING                                            
CampaignCampaign of the source of the order
ClientClient of the source of the order
CountryShip to country of the order
DateThe date of the order
DNISThe DNIS of the source of the order
EmployeeEmployee who placed the order
Fiscal WeekFiscal week of the order date
Item TypeItem type of the item
Media TypeMedia type of the source of the order
Payment MethodPayment method of the order
Product GroupProduct group of the item
Product NameProduct offer of the item
ScriptThe script of the source of the order
Promo CodePromo code of the order (if available, 'None' otherwise)
StateShip to state of the order
TeamTeam of the employee who placed the order
    • Related Articles

    • Gross Sales Summary Report Definitions

      This report is based on calls that are created when an agent enters the new order screen (not call collector calls). Gross Sales Summary Report Column Definitions ANS # The number of calls in the date range VALID # The number of calls with ...
    • 5.1.179 - Gross Sales Report Fix

      Version: 5.1 Patch: 179 Title: Gross Sales Report Fix Application Category: Other Patch Type: Bug Description: Fixed: GrossSales report was not working for specific layout named 'Product Offer/Campaign/Client' Main SQL view named 'vwGrossSalesReport' ...
    • Gross Royalty Report Definitions

      This report shows items on orders in the date range and the gross royalty amount associated with those orders. It includes credit and debit items. The credit items are shown as a positive amount. Gross Royalty Report Column Definitions Product ...
    • Gross Margin Report Definitions

      This report is for successfully processed debit and credit items in the specific date range (order date, payment date or shipment date). It includes product cost, commission and royalty amounts and shows returned revenue information to determine the ...
    • Sales Agent Commission Detail Report Definitions

      This report is run by commission batches that are created and breaks out the commission batch by employee/item status/item. Each employee is on a separate page. Sales Agent Commission Detail Report Column Definitions Employee Grouping level for ...