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' ...

    • 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 ...

    • Sales Agent Commission Summary Report Definitions

      This report is run by commission batches that are created and breaks out the commission batch by team and employee. Sales Agent Commission Summary Report Column Definitions Team Team Name Emp. # Employee Number Employee Employee Name (Last, First) # ...

    • Coupon Details Report Definitions

      This report is for debit items with a coupon code attached to them on orders placed in the date range broken down to the order level. Coupon Detail Report Column Definitions Customer Name Last name and first name of the customer Order ID Order ID of ...