View: shopify_sales_report

Fields

Sales Report: shopify_sales_report
Filters, Dimensions and Measures Category Description
Shopify Sales Report: Business Channel dimension The Business Channel for this Store from the Daasity App UI
Shopify Sales Report: Business Unit dimension The Business Unit for this Store from the Daasity App UI
Shopify Sales Report: Converted Currency Code dimension The currency code of all sales metrics that were converted
Shopify Sales Report: Currency Conversion Rate dimension The daily rate for the currency conversion
Shopify Sales Report: Email Address dimension Email Address of the Customer placing the Order
Shopify Sales Report: Item Quantity dimension The quantity of an item purchased or refunded
Shopify Sales Report: Order Code dimension The customer facing Order Number in Shopify
Shopify Sales Report: Order ID dimension The internal ID of the order from the source system
Shopify Sales Report: Order Line ID dimension The internal ID of the order line from the source system
Shopify Sales Report: Original Currency Code dimension The currency from the store (non-converted currency code)
Shopify Sales Report: Price dimension The product price at time of purchase
Shopify Sales Report: Product ID dimension The internal ID of the product from the source system
Shopify Sales Report: Product Name dimension The name of the product from Shopify
Shopify Sales Report: SKU dimension The SKU of the item purchased or refunded. May also contain a description of a refund discrepancy
Shopify Sales Report: Shop ID dimension The Shopify identifier in the Daasity App (shop_id.shopify.com)
Shopify Sales Report: Store Country dimension The country of the store as set in the Daasity App
Shopify Sales Report: Store Integration Name dimension The name of the integration as set in the Daasity App
Shopify Sales Report: Store Name dimension The friendly name of the Store based on the location logic in the Daasity App
Shopify Sales Report: Store Type dimension Type of store (ecommerce, retail, marketplace, wholesale) as set in the Daasity App
Shopify Sales Report: Transaction Date dimension Date of when the transaction (order or refund) was processed
Shopify Sales Report: Transaction Day of Week dimension Date of when the transaction (order or refund) was processed
Shopify Sales Report: Transaction Day of Week Index dimension Date of when the transaction (order or refund) was processed
Shopify Sales Report: Transaction Detail Type dimension Indicates if at the Order or Item level for the Purchase or Refund
Shopify Sales Report: Transaction Month dimension Date of when the transaction (order or refund) was processed
Shopify Sales Report: Transaction Month Name dimension Date of when the transaction (order or refund) was processed
Shopify Sales Report: Transaction Month Num dimension Date of when the transaction (order or refund) was processed
Shopify Sales Report: Transaction Quarter dimension Date of when the transaction (order or refund) was processed
Shopify Sales Report: Transaction Week dimension Date of when the transaction (order or refund) was processed
Shopify Sales Report: Transaction Year dimension Date of when the transaction (order or refund) was processed
Shopify Sales Report: Transcation Type dimension Indicates if a Purchase or Refund transaction
Shopify Sales Report: Discounts measure Sum of all discounts
Shopify Sales Report: Gross Sales measure Sum of all gross sales
Shopify Sales Report: Gross Sales - Original Currency measure Sum of all gross sales in the Original Currency
Shopify Sales Report: Net Sales measure Sum of all net sales
Shopify Sales Report: Orders measure Total Number of Orders
Shopify Sales Report: Returns measure Sum of all refunds and returns
Shopify Sales Report: Shipping measure Sum of all net shipping charges
Shopify Sales Report: Tax measure Sum of all net tax charges
Shopify Sales Report: Total Sales measure Gross Sales + Discount + Returns + Shipping + Tax


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