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.
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 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
Number of taxes associated with a sale or return during specified date range.
The Net Sales by Billing City metric shows the total revenue earned by a store based on the location of the customer's billing address, providing insights into the store's geographical revenue distribution.
Equates to Gross Sales - Discounts - Returns + Taxes + Shipping Charges during the specified Date Range split up by Billing Country.
The Orders by Billing City metric shows the total number of orders placed by customers from different billing cities. It helps identify which cities have the highest sales and can be used to focus marketing efforts and targeted promotions to those areas.
Number of Shipping Charges associated with a Sale or return during the specified Date Range.
Number of Shipping Charges associated with a Sale or return during the specified Date Range split up by Billing City
Total number of Customers gained.
This metric shows the number of units sold per specific variation (e.g. color, size) of a product. It helps measure the popularity of each variant and informs inventory management decisions.