What is Sales Transaction?
The Sales Transaction report provides sales data on the most granular level and includes your shop’s entire sales history. This enables the flexibility to construct both detailed low-level analysis of specific order details, as well as getting a high-level overview of your products or customers.
All standard sales metrics that are available in Shopify’s UI reporting tool are also available in this report. These include:
Gross sales
Discounts
Returns
Net sales
Shipping
Taxes
Total sales
Duties
Tips
For a complete list of all available dimensions and metrics, see What data can I get from Shopify?
Sales Transaction report examples
Curious about what ways you can use the Sales Transaction report with your Shopify data? Here are some examples of how the report can be used for analysis:
Sales over time
Year-by-year overview of your sales, matching the Sales over time report in Shopify.
Sales Channel breakdown
Sales performance broken down by Sales Channel
Top selling products
Sales performance per product
First-time/Returning customer
Sales performance broken down by Customer Sale Type. This provides a sales performance comparison between New and Returning Customers.
How long does it take to download my data?
When you connect a Shopify Sales Transaction data source, transactions from the two most recent days will be downloaded first. This is to ensure that you have some data to work with while Funnel works on getting your entire history downloaded.
After loading your two most recent days, your Shopify data will be downloaded in chronological order, starting from the date when the shop’s first order was created. How long this takes completely depends on the number of orders your Shopify store has, scaling from around one hour to several days.