Equates to product Selling Price x Ordered Quantity during the specified Date Range split up by Billing City.
With Databox you can track all your metrics from various data sources in one place.
Databox is a business analytics software that allows you to track and visualize your most important metrics from any data source in one centralized platform.
To track Gross Sales by Billing City using Databox, follow these steps:
‘Gross Sales’ and ‘Discounts’ standard and dimensional metrics will be off by some cents on some days if ‘taxes included’ is checked in the connected Shopify account.
The reason for this, using the Discounts metric example, is that Databox has to calculate the actual discount from the values it gets from the API by subtracting the tax from it. This is done by calculating the tax with the tax rate and the discounted amount, which often yields decimal numbers, but Shopify has its own way of rounding these numbers in the User Interface. As a consequence, when observed with Daily granularity, some days may have discrepancies by a few cents due to rounding.
Affected metrics: Discounts ˪ by Billing City ˪ by Billing Country
Gross Sales ˪ by Billing City ˪ by Billing Country ˪ by Top Products ˪ by New vs Returning Customers ˪ by Product Vendor
Equates to Product Selling Price x Ordered Quantity on during specified Date Range. Gross Sales does not include Discounts, Returns, Taxes, or Shipping.
Net Sales (POS) is a metric that measures the total amount of revenue generated by a business through point-of-sale transactions, after accounting for returns and discounts.
Discounts (POS) metric measures the amount of money saved on purchases made using a discount code or promotion in Shopify's Point of Sale (POS) system. It helps track the success of sales promotions and evaluates the impact of discounts on revenue.
Unfulfilled orders is a metric that measures the number of orders that have not yet been shipped or delivered to the customer. It helps merchants keep track of outstanding orders and ensure timely fulfillment.
Equates to product Selling Price x Ordered Quantity during the specified Date Range split up by New vs Returning Customers.
Net sales is the total sales revenue generated by a business after accounting for returns, discounts, and other deductions. It is a key metric to measure a company's profitability.
Number of Taxes associated with a Sale or return during the specified Date Range split up by Billing City
Number of Shipping Charges associated with a Sale or return during the specified Date Range split up by Billing City