CUSTOM FORMULAS · SHARED EVERYWHERE

Advanced calculated metrics: build the numbers your reports are missing

Create custom metrics from your own formulas — profit margin, contribution, blended ROAS, cost ratios — and use them anywhere in PayHelm, across every store and marketplace.

Out-of-the-box dashboards give you revenue and orders. But the metrics that actually run your business — true margin after fees, contribution per order, blended ad ROI, cost as a percentage of sales — usually live in a spreadsheet you rebuild by hand every month. PayHelm's calculated metrics let you define those formulas once and reuse them everywhere: in reports, charts, scheduled exports, and dashboard widgets. Set it up in minutes, and your custom numbers update automatically.

Build your first calculated metric
FORMULAREUSEREFRESH
01 — START WITH THE NUMBERS

What are calculated metrics?

A calculated metric is a number you define from other numbers — a formula that PayHelm computes for you across every order, product, and channel. Instead of exporting raw data and building formulas in a spreadsheet, you create the metric once inside PayHelm and it's available everywhere.

Common calculated metrics merchants build

01

Net profit

Sales − cost of goods − fees − shipping
02

Profit margin %

(Profit ÷ sales) × 100
03

Contribution per order

Profit ÷ orders
04

Blended ROAS

Total sales ÷ total ad spend
05

Fee ratio %

(Marketplace fees ÷ sales) × 100
06

Average discount %

(Discounts ÷ gross sales) × 100

Define the formula, name it, and use it like any built-in metric.

02 — BEYOND A BASIC RATIO

Advanced calculated metrics for the numbers that matter

Go beyond simple ratios. PayHelm's advanced calculated metrics let you combine fields across data sources — sales, costs, fees, shipping, ad spend, refunds — into exactly the KPI your business runs on:

  • Reference any PayHelm field — store, marketplace, and ad metrics in one formula
  • Blend channels — combine Amazon, eBay, Shopify, and more into a single number
  • Mix in ad spend — build blended ROAS and true per-channel profitability
  • Reuse everywhere — the same metric powers reports, charts, and dashboard widgets
  • Always current — metrics recalculate automatically as new data syncs

If you can write the formula, PayHelm can track it — automatically, across your whole business.

03 — ONE METRIC, EVERYWHERE

Use your calculated metrics everywhere in PayHelm

A calculated metric isn't locked to one screen. Once you've defined it, drop it into:

  • Custom reports — add your metric as a column alongside any other field
  • Scheduled reports — have your KPI delivered to email or Google Drive automatically
  • Charts & dashboards — visualize your custom metric over time or by channel
  • Exports — push it to Google Sheets, Looker Studio, or BigQuery

One formula, used across your entire reporting workflow.

Start building custom metrics free
PART OF THE WHOLE TOOLKIT

Part of PayHelm's full analytics toolkit

Calculated metrics are one piece of PayHelm's reporting platform — alongside custom reports, scheduled delivery, and analytics for every store and marketplace you sell on.

Explore all PayHelm analytics & reporting features
GOOD TO KNOW

Calculated metrics FAQs

What is a calculated metric?+

It's a custom metric you define with your own formula — like profit margin or blended ROAS — that PayHelm computes automatically from your store and marketplace data.

Can I build a profit margin or ROI metric?+

Yes. Create formulas for net profit, margin %, contribution per order, blended ROAS, fee ratios, and more, then use them in any report.

Can calculated metrics combine data from multiple channels?+

Yes. Advanced calculated metrics can blend sales, costs, fees, and ad spend across Amazon, eBay, Shopify, and your other channels into one number.

Where can I use my calculated metrics?+

Anywhere in PayHelm — custom reports, scheduled reports, charts, dashboard widgets, and exports to Google Sheets, Looker Studio, or BigQuery.

Do calculated metrics update automatically?+

Yes. They recalculate as new data syncs, so your custom KPIs are always current without manual work.

THE NUMBERS THAT MATTER

Track the metrics your business actually runs on

Build advanced calculated metrics in PayHelm — custom formulas for profit, margin, and ROI across every channel, updated automatically. Get started free.

Build a calculated metric free