Gross Revenue Definition
At Conjura, we define Gross Revenue as the total value of your orders, i.e. the money your customers actually parted with.
This accounts for any discounts the customer received, but does not account for refunds.
Formula: Product Revenue Including Tax + Shipping Revenue Including Tax
Your revenue is calculated from the orders present in your connected ERP and eCommerce systems.
This article details how to get the gross revenue figure from your Conjura dashboards matching to what you see on the Shopify UI.
Shopify Reconciliation
To reconcile your Conjura Revenue with a Shopify store, go to Analytics > Reports > New Exploration
Then paste the following into the query box:
FROM sales
SHOW orders, total_sales, gift_card_net_sales
WHERE is_return_related = false AND is_canceled_order = false
GROUP BY day WITH TOTALS, PERCENT_CHANGE
TIMESERIES day
SINCE 2025-04-01 UNTIL 2025-04-30
COMPARE TO previous_period
ORDER BY day ASC
LIMIT 1000
VISUALIZE total_sales TYPE line
Note that this example is looking at the month of April 2025. You can change the date range to whatever you like.
Click Run
Now select the same date range within a Conjura dashboard (we're using the Performance Overview). If you have more than one store connected to Conjura, make sure to filter the dashboard to relevant store as well:
The Gross Revenue KPI in Conjura will match Total Sales + Gift Card Net Sales within Shopify
Example
Conjura shows £38.3K
When we hover over this metric we see the un-rounded figure is £38,287
Shopify shows £38,187.35 in total sales, and £100 in gift card sales. This makes £38,287.35, matching the Conjura UI.
Notes:
Remember to hover over the Gross Revenue metric in Conjura to see the full figure. The KPI card shows a rounded version by default.
You may see a small discrepancy between Conjura and Shopify if you have made manual edits to historic orders.