Specific Use Cases

Here’s a list of specific ways users have used us, and how you can do them:

Finance and Revenue Reporting

Removing gifts and seeded products from sales reports

You can remove orders from your sales reports such as those tagged as a gift, from a specific sales channel, purchased with order value 0, or purchased with a special discount code.

To do this, run the Order Export Hop and filter out the types of orders you want removed.

Separate one-off sales from subscriptions

You can separate one-off sales from subscription sales to analyze them independently and understand your revenue streams better. Subscription sales are typically identified as coming from a different sales channel.

To do this, run the Product Variant Sales by Date and Sales Channel Hop and filter your results by product and sales channel.

Adjust for refunds in sales reports

You can adjust your sales reports to accurately reflect refunds, returns, and exchanges based on the original order date. Airboxr ties refunds to the order date, not the date of the refund.

To do this, run the Variant Sales Performance over Time Hop and view the refunds column.

Create wholesale sales reports with ease

If you handle wholesale orders and DTC orders on the same Shopify storefront, you can use Airboxr to separate wholesale reports from DTC, and better understand margin profiles.

To do this, run the Order Export Hop and filter for bulk orders using Draft Orders, discount codes, or buyer details.

Get an accurate view of your inventory value

You can get a view of your inventory value by tracking how much cash is tied up in your inventory at any given time.

To do this, run the Active Inventory Snapshot Hop and view the inventory value column.

Operational Analytics

Measure 3PL partner performance

You can measure the performance of your 3PL partners to identify cost-saving opportunities and improve customer satisfaction.

To do this, run the Shipper performance Hop and compare delivery times across your logistic partners

Take monthly inventory snapshots

Shopify doesn’t store historical inventory data, but you can. Use Airboxr to take monthly inventory snapshots, track stock levels over time, and plan more effectively for upcoming quarters.

To do this, run the Active Inventory Snapshot Hop to capture end-of-month inventory data.

Marketing Insights

Identify which products drive repeat purchases to optimize acquisition targeting

Analyze customer purchase patterns to identify products that lead to repeat purchases. Use this insight to refine acquisition campaigns—target customers more likely to convert into high-LTV buyers by promoting products with strong repeat purchase behavior.

To do this, run the Customer Acquisition and Retention by Product Hop.

Understand your new and returning customer behavior

Go beyond just a single retention rate metric, and delve into the split of sales between each customer type, including discounts, returns, refunds, and more.

To do this, run the Sales by Customer Type over Time Hop.

Design effective product bundles

Analyze what products are frequently purchased together to create bundles that increase average order value (AOV). Use data-driven insights to recommend complementary products, driving higher conversion rates and customer satisfaction.

To do this, run the Frequently Bought Together Hop.

Identify Products to Cross-Sell

Uncover products commonly bought by repeat customers after their initial purchase. Use this insight to set up personalized cross-sell offers that increase customer lifetime value (LTV) and drive incremental revenue.

To do this, run the Cross Sell Analysis Hop or the Category Cross Sell Analysis Hop.

Accurately identify funnel dropoff points from your ad campaigns

You can categorize your campaigns by TOFU, MOFU, BOFU or any funnel structure you use to discover your conversion rates and dropoff points across funnel steps.

Identify Funnel Drop-Off Points from Ad Campaigns

Track customer journeys from ad click to purchase to pinpoint where potential buyers abandon the funnel. Use this insight to optimize landing pages, product pages, or checkout flows and improve conversion rates.

To do this, run the User Purchase Journey over Time Hop (Google Analytics), or the E-Commerce Funnel Performance Hop (Meta Ads).

Understand profitability by product collection

Create filters for specific products in a collection so you can track which product releases performed best, and double down on what worked.

To do this, run the Profit by Product Variant over Time Hop and filter for the products you want.

Airboxr for Agencies

Agencies can provide all the above analytics for their clients via a whitelabeled analytics service, automate their own existing reporting models, or simply refer us to a client for a fee. If you’re an agency looking for intelligent data support, let’s chat.