Skip to main content

Filters, Groupings, and Example Views

M
Written by Mike Ilin

Both the Markets and Products pages have a collapsible filter panel at the top of the page. Filters narrow your data to a specific subset before the chart and table render.

How filters work:

  1. Click Filters to expand the panel

  2. Select values in one or more filter fields

  3. Click Apply filters to update the view

  4. Click Clear filters to reset everything

Filters are combinable - you can set multiple filters at once to create precise views. All active filters apply simultaneously (AND logic).

Markets page filters

Filter

What it does

Example

Market

Limit to specific Swap markets

"Swap US" to see only US cross-border orders

Country

Limit to destination countries

"Germany" to see all German orders

Region

Limit to geographic regions

"Europe" to see all European orders

Order Tags

Filter by Shopify order tags

"wholesale" to see only wholesale orders

Product Tags

Filter by product tags

"new-arrival" to see new arrivals only

SKU

Filter to specific SKUs

Paste a list of SKUs to focus on specific items

Products page filters

Filter

What it does

Example

Country

Limit to destination countries

"United States" to see US demand

Market

Limit to Swap markets

"Swap DE" to see German cross-border orders

Product Name

Search for specific products

Search by product title

SKU

Filter to specific SKUs

Paste a list of SKUs

Product Tags

Filter by product tags

"seasonal" to see seasonal items

Order Tags

Filter by order tags

"vip" to see VIP customer orders

Vendor

Filter by product vendor

"Nike" to see one brand

Collection

Filter by Shopify collection

"Summer 2026" to see one collection


Groupings overview

Groupings determine how your data is aggregated in the chart and table. Changing the grouping doesn't filter data out - it restructures how data is presented.

Markets page groupings

Grouping

What you see

Best for

Market

One row per Swap market configuration

Understanding performance by selling channel

Country

One row per destination country

Geographic demand analysis

Region

One row per geographic region

High-level regional trends

Products page groupings

Grouping

What you see

Best for

Master Product

One row per product (all variants combined)

Overall product performance

Product Variant

One row per variant (e.g., size/colour)

Identifying best and worst variants

Individual Variant

One row per unique SKU

Granular inventory and fulfilment analysis

Collection

One row per Shopify collection

Collection-level performance review

Vendor

One row per vendor/brand

Comparing supplier or brand performance


Example views

1. Top products by sales in a specific country

Goal: See which products sell best in Germany.

Steps:

  1. Go to Products page

  2. Open Filters, set Country = "Germany"

  3. Click Apply filters

  4. In the table, click the Sales column header to sort descending

  5. Group by Master Product (default)

What you'll see: All products ordered by customers in Germany, ranked by revenue. Use this to understand which products resonate in specific markets.

2. Market performance comparison

Goal: Compare order volume and revenue across all your markets.

Steps:

  1. Go to Markets page

  2. Set Primary metric to Orders, Secondary to Sales

  3. Keep grouping on Market (default)

What you'll see: A bar chart with solid bars for order count and hatched bars for revenue for each market. The table below shows the full numeric breakdown. Look for markets with high orders but low AOV (potential for upselling) or high AOV but low volume (growth opportunity).

3. Country-level AOV analysis

Goal: Find which countries have the highest average order value.

Steps:

  1. Go to Markets page

  2. Switch grouping to Country

  3. In the table, click the Avg Order Value column header to sort descending

What you'll see: Every country ranked by AOV. High-AOV countries may be good candidates for targeted marketing. Countries with unusually high AOV might also indicate bulk ordering or wholesale activity worth investigating.

4. Collection performance across markets

Goal: See how a specific collection performs internationally vs domestically.

Steps:

  1. Go to Products page

  2. Open Filters, set Collection = "Winter 2026"

  3. Click Apply filters

  4. Switch grouping to Master Product

  5. Compare Units Ordered vs Global Units Ordered columns

What you'll see: Each product in the collection, with total units and international units side-by-side. Products where Global Units Ordered is close to Units Ordered are primarily international sellers. Products where there's a big gap sell mostly domestically.

5. Vendor comparison

Goal: Compare performance across your product vendors or brands.

Steps:

  1. Go to Products page

  2. Switch grouping to Vendor

  3. Set Primary metric to Sales, Secondary to Units Ordered

What you'll see: Each vendor's total sales and units in the chart, with full details in the table. Compare vendors to understand which brands drive revenue vs. volume. High sales with low units means high-value products; high units with low sales means high-volume, low-price items.

6. International product demand

Goal: Identify products with the highest international demand.

Steps:

  1. Go to Products page

  2. Group by Master Product

  3. Click the Global Units Ordered column header to sort descending

What you'll see: Products ranked by international order volume. These are your top cross-border sellers. Compare with the Global Sales column to understand both volume and revenue from international channels.

7. Shipping and duty impact by market

Goal: Understand how much of each market's order value goes to shipping and duties.

Steps:

  1. Go to Markets page

  2. Group by Market (default)

  3. Compare the Taxes & Duties and Shipping Revenue columns against Sales

What you'll see: For each market, the total shipping charges and taxes/duties alongside revenue. Markets with high Taxes & Duties relative to Sales have a significant duty burden that may affect customer conversion. This is especially useful for evaluating whether Swap Clear is delivering savings.

8. SKU-level deep dive

Goal: Investigate specific SKUs that are underperforming or flagged by your operations team.

Steps:

  1. Go to Products page

  2. Open Filters, paste your SKU list into the SKU field

  3. Click Apply filters

  4. Switch grouping to Individual Variant

What you'll see: Each SKU with its full performance data. Use this for investigating specific items flagged in operations reviews, quality checks, or return spike investigations.


Tips

Export and combine.

Use the Export to CSV button on any table to download data for further analysis in a spreadsheet. This is useful when you want to combine Markets and Products data or create custom calculations.

Sort before exporting.

The CSV export respects your current sort order, so sort the table how you want it before downloading.

Filters persist while you navigate.

If you apply filters on the Markets page, switch to Products, and come back, your Markets filters will still be active.

Start broad, then narrow.

Begin with the default ungrouped view to spot patterns, then use filters and groupings to investigate what's driving the numbers.

POS and pickup orders are not included.

CI only includes orders with a shipping address. If you notice lower totals than Shopify, this (along with cancelled order exclusion) is likely the reason. See the Metrics Glossary page for details.

Did this answer your question?