The Discounts by Billing Country metric shows the total amount of discounts applied to orders based on the country where the customer's billing address is located.
With Databox you can track all your metrics from various data sources in one place.
Used to show comparisons between values.
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 Discounts by Billing Country 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 Gross Sales - Discounts - Returns + Taxes + Shipping Charges during specified Date Range. Total Sales will be a positive number for a Sale on the date that an order was placed, and a negative number for a return on the date that an order was Refunded.
Equates to product Selling Price x Ordered Quantity during the specified Date Range. Gross Sales does not include Discounts, Returns, Taxes, or Shipping.
Equates to product Selling Price x Ordered Quantity during the specified Date Range split up by Billing Country.
Net Sales by Billing Country metric represents the total revenue generated from sales transactions based on the billing country of the customer.
The Net Sales by Product Vendor metric shows the total sales revenue generated by each vendor that contributed to the sale of products on the Shopify store.
This metric allows Shopify store owners to track the effectiveness of their discount campaigns based on the location of the customer's billing city. It provides insights on which cities are responding well to discounts and can aid in targeting future promotions.
The Returns by Billing City metric calculates the number of items returned to the store, grouped by the billing city of the customer who made the purchase. It helps in analyzing the areas with a high return rate and in improving customer satisfaction.
The Quantity by Product Vendor metric indicates the total number of units sold for each product vendor in a given time period. It helps determine which vendors are most successful and which products are driving sales.