Analytics

May 20, 2026

Overview

The Analytics page helps you understand the relationship between your revenue and advertising spend. It calculates Return on Ad Spend (ROAS) automatically and visualizes daily trends so you can see which campaigns are driving results.

Summary Cards

Three metrics at the top of the page provide a quick overview for the selected period:

  • Total Revenue - Total net payments received from customers
  • Ads Spend - Total advertising expenses from all sources
  • ROAS - Return on Ad Spend: Revenue divided by Ads Spend

Date Filtering

Filter data by:

  • Today
  • This month (default)
  • Last month
  • All time
  • Custom range

The date filter applies to both orders (for revenue) and expenses (for ad spend).

Daily Items Sold Chart

Shows how many units customers bought each day in the selected period. Each bar is the total quantity sold (line item quantity minus refunds) for that day. A dashed orange line marks the period average per active day.

When the selected range supports it, the chart also compares against the previous comparable period so you can see whether sales are picking up or slowing down. The previous period is chosen automatically:

  • Today is compared with yesterday
  • This month is compared with the same days of last month
  • Last month is compared with two months ago
  • Custom range is compared with the same number of days immediately before the start of your range
  • All time has no comparison

When a comparison is active, each day’s bar is paired with a grey “Previous period” bar (drawn to the left), a thin dashed grey line marks the previous-period average, and a badge above the chart shows the change versus the previous period in both absolute units and percent.

Items per Order Chart

Shows how customers tend to buy: how many orders contained 1 item, 2 items, 3 items, and so on. Each bar represents the number of orders with that exact item count. Item count is the line-item quantity minus refunds, summed across the order. Orders that net out to zero items (fully refunded) are excluded.

Badges above the chart summarise the period: the total number of orders counted, the average items per order, and — when a comparison is available — the change in average items per order versus the previous comparable period.

When the selected range supports it, each bucket also shows a grey “Previous period” bar to the left of the current one, with a thin dashed grey line marking the previous-period average. The previous period is picked using the same rules as the Daily items sold chart (today vs. yesterday, this month vs. last month, etc.); all-time has no comparison.

Revenue vs Ad Spend Chart

An interactive chart shows daily revenue and ad spend side by side. Each advertising source (e.g. Google Ads, Meta Ads) appears as a separate series so you can see exactly where your budget is going.

How Revenue Is Calculated

Revenue is the sum of net payments across all active orders for each day. Net payment is the amount actually received after refunds and adjustments. Ignored orders are excluded from the calculation.

How Ad Spend Is Calculated

Ad spend is pulled from your expenses that are categorized as “Ads”. If an expense covers a date range (e.g. a monthly ad bill), the amount is spread evenly across each day in that range, clipped to the selected period.

For VAT-registered shops, the net (ex-VAT) amount is used, and linked VAT expenses are excluded to avoid double-counting.

Ads Breakdown Table

Below the chart, a table breaks down ad spend by expense name. Each row shows:

  • Expense Name - The name you gave the expense (e.g. “Google Ads”, “Meta Ads”)
  • Amount - Total spend for that source in the selected period
  • % of Total - What percentage of your total ad budget went to this source

This helps you compare spending across advertising channels at a glance.

Setting Up

To see data on the Analytics page:

  1. Create an “Ads” expense category in Settings > Expense Categories
  2. Add your advertising expenses with that category via the Expenses page
  3. Set a date range on each expense to spread costs across the billing period
  4. Revenue is calculated automatically from your synced Shopify orders

Auto-importing Meta Ads

If you’d rather not enter Facebook/Instagram ad spend by hand, connect your Meta ad account from Settings > Facebook Ads. Once connected, Panelque pulls your daily ad spend each morning and records it as expenses in the “Ads” category. The Analytics page picks them up automatically.

Best Sellers

Open Analytics > Best sellers to see what’s actually moving in your store. The page ranks items by units sold within the selected date range (today, this month, last month, all time, or a custom range) and offers three views:

  • Products - Top products by total units sold, with the most recent sale date.
  • Variants - The same ranking at the variant level, with SKU for quick reference.
  • By option - Sales grouped by variant option (e.g. by colour or size) so you can see which choices are pulling their weight.

Each row links to the product or variant detail page so you can drill in.