View: order_line_revenue

Fields


Order & Order Line Revenue: order_line_revenue
Filters, Dimensions and Measures Category Description
Order Line Revenue: Converted Currency dimension The Currency Code the amount was convererted to
Order Line Revenue: Currency Conversion Rate dimension The daily rate of the currency conversion
Order Line Revenue: Gift Card Flag (Yes / No) dimension If the Item is a Gift Card
Order Line Revenue: Listing SKU dimension The SKU of the product from the Source System
Order Line Revenue: Original Currency dimension The Currency Code the amount was convererted from
Order Line Revenue: Product Name dimension The name of the product when purchased
Order Line Revenue: Product Type dimension The type of product from the Source System
Order Line Revenue: SKU dimension The mapped SKU (if applicable) based on the BSD SKU Mapping table
Order Line Revenue: SKU Cost dimension The cost of the item (1 unit)
Order Line Revenue: Store Customer ID dimension The Customer ID from the Source System
Order Line Revenue: Store Order ID dimension The Order ID from the Source System
Order Line Revenue: Store Order Line ID dimension The Order Line ID from the Source System
Order Line Revenue: Variant Name dimension The name of the Item (Product Variant) when purchased
Order Line Revenue: Variant Price dimension The price of the item when purchased
Order Line Revenue: Attribution Contribution Margin measure Total contribution margin of orders: Net Margin less attribution marketing cost and fulfillment/shipping cost
Order Line Revenue: Attribution Marketing Cost measure Total Attribution Marketing cost of orders
Order Line Revenue: Average Order Attribution Marketing Cost measure Average Attribution Marketing Cost per valid order
Order Line Revenue: Average Order Discount Amount measure Average discount per order -- Total Discount Amount divided by Valid orders
Order Line Revenue: Average Order First Click Marketing Cost measure Average First Click Marketing Cost per valid order
Order Line Revenue: Average Order Gross Sales measure Average order value using gross sales -- Total Gross Sales divided by Valid orders
Order Line Revenue: Average Order Last Click Marketing Cost measure Average Last Click Marketing Cost per valid order
Order Line Revenue: Average Order Net Sales measure Average order value using net sales -- Total Net Sales divided by Valid orders
Order Line Revenue: Average Order Product Cost measure Average Product Cost per order
Order Line Revenue: Average Order Product Sales measure Average product sales per order -- Total Product Sales divided by Valid orders
Order Line Revenue: Average Unit Attribution Marketing Cost measure Average Attribution Marketing Cost per valid unit
Order Line Revenue: Average Unit Discount Amount measure Average discount per order line item -- Total Discount Amount divided by Valid order items
Order Line Revenue: Average Unit First Click Marketing Cost measure Average First Click Marketing Cost per valid unit
Order Line Revenue: Average Unit Gross Sales measure Average gross Sales unit -- Total gross Sales divided by Valid order items
Order Line Revenue: Average Unit Last Click Marketing Cost measure Average Last Click Marketing Cost per valid unit
Order Line Revenue: Average Unit Net Sales measure Average net Sales per unit -- Total Net Sales divided by Valid order items
Order Line Revenue: Average Unit Product Cost measure Average Product Cost per valid unit
Order Line Revenue: Average Unit Product Sales measure Average product sales per unit -- Total Product Sales divided by Valid order items
Order Line Revenue: Cart Discount Amount measure Total discount applied at the cart level (order)
Order Line Revenue: Count - Customers measure Count the number of householded customers
Order Line Revenue: Count - Feature Items measure Count the number of line order items
Order Line Revenue: Count - Free Items measure Count the number of free items (price is zero)
Order Line Revenue: Count - Invalid Feature Items measure Count the number of invalid feature items
Order Line Revenue: Count - Invalid Free Items measure Count the number of invalid free items (price is zero)
Order Line Revenue: Count - Invalid Items measure Count the number of invalid feature + invalid free items
Order Line Revenue: Count - Invalid Orders measure Count the number of invalid orders
Order Line Revenue: Count - Items measure Count the number of feature + free items
Order Line Revenue: Count - Orders measure Count the number of orders
Order Line Revenue: Count - Valid Feature Items measure Count the number of valid feature items
Order Line Revenue: Count - Valid Free Items measure Count the number of valid free items (price is zero)
Order Line Revenue: Count - Valid Items measure Count the number of valid feature + valid free items
Order Line Revenue: Count - Valid Orders measure Count the number of valid orders
Order Line Revenue: Discount Amount measure Total discount amount a customer be charged
Order Line Revenue: Feature Product Amount measure Total product sales including product discounts
Order Line Revenue: First Click Contribution Margin measure Total contribution margin of orders: Net Margin less first click marketing cost and fulfillment/shipping cost
Order Line Revenue: First Click Marketing Cost measure Total First Click Marketing cost of orders
Order Line Revenue: Gift Card Sales Amount measure Total Gift Card amount purchased
Order Line Revenue: Gross Margin measure Total Gross Margin of orders: Gross Sales less sku cost
Order Line Revenue: Gross Sales measure Total Gross sales of orders: Quantity * product price
Order Line Revenue: Last Click Contribution Margin measure Total contribution margin of orders: Net Margin less last click marketing cost and fulfillment/shipping cost
Order Line Revenue: Last Click Marketing Cost measure Total Last Click Marketing cost of orders
Order Line Revenue: Net Sales measure Total Net sales of orders: Amount Charged - Tax - Refund
Order Line Revenue: Percent - Discount of Potential Sales measure Percentage of discount amount on the full amount
Order Line Revenue: Percent - Refund of Gross measure Percentage of refund amount on total gross sales
Order Line Revenue: Potential Sales measure Potential Sales is the full amount a customer could be charged - i.e. Non-Discounted Product Amount + Shipping Amount
Order Line Revenue: Product Cost measure Total Product cost of orders
Order Line Revenue: Product Discount Amount measure Total discount applied to the product (line level)
Order Line Revenue: Refund Amount measure Total refund amount allocated based on Product Sales
Order Line Revenue: Shipping Amount Charged measure Total shipping amount of orders
Order Line Revenue: Tax Amount measure Tax amount allocated based on Product Sales
Order Line Revenue: Unit Per Order measure Units per order -- Total feature items divided by valid orders


All content © Daasity 2021. Do not copy, share or distribute.