Home›Learn›Analytics

What are eCommerce alerts?

Q: What are the most important eCommerce metrics to alert on?

For Amazon: return rate by ASIN (spike detection), buy box percentage (loss detection), daily revenue vs 7-day average (revenue anomaly), inventory days remaining (stockout prevention). For Shopify: refund rate by product, daily revenue, cart abandonment rate. For any business: any metric with a known normal range that, when violated, requires action.

Q: How do I set a meaningful threshold vs one that causes alert fatigue?

Base thresholds on your historical normal range. If your Amazon return rate averages 6% with a standard deviation of 2%, set your alert at 10% (mean + 2 standard deviations). This catches genuine anomalies while filtering out normal variation. Review and adjust thresholds quarterly as your business evolves.

Q: How does Taptic Data handle eCommerce alerts?

Taptic evaluates alert conditions after every data refresh. You define the metric (using a SQL query or pre-built metric), the threshold, and the notification channel (email). When the condition is met, Taptic sends an alert with the current value, the threshold, and a link to the relevant report.

Q: Can alerts be set on custom SQL queries in Taptic?

Yes. Because Taptic gives you SQL access to your data, you can write any query as the basis for an alert — including multi-table joins, custom calculations, or cross-platform conditions. An alert can, for example, fire when Amazon return rate exceeds Shopify refund rate for the same product category.

Threshold-based monitoring for Amazon and Shopify — what to alert on and how it works

Definition

What it is

eCommerce alerts are automated notifications triggered when a business metric crosses a defined threshold. Examples include: return rate on an ASIN exceeding 15%, buy box percentage dropping below 80%, daily revenue falling more than 30% below the 7-day average, or inventory reaching a reorder point. Alerts replace manual monitoring — instead of checking dashboards daily, the system notifies you when something needs attention.

Formula

Alert Condition Formula

Formula

Alert fires when: metric_value [operator] threshold Examples: return_rate > 0.15, buybox_pct < 0.80, daily_revenue < (7_day_avg × 0.70)

Good alerts have three components: a metric (what to measure), an operator (greater than, less than, percentage change), and a threshold (the trigger value). Thresholds should be set based on your normal operating range — too sensitive creates alert fatigue; too loose misses real problems.

Business impact

Why it matters

The cost of discovering a problem late compounds quickly. A buy box loss that goes undetected for a week can mean thousands of lost sales. A return rate spike that isn't caught for a month may indicate a quality defect that has already shipped hundreds of units. Alerts give you the earliest possible warning signal — evaluated every time data refreshes — so you can act before impact compounds.

The challenge

How most teams track this today

Amazon Seller Central has limited built-in alerting (low inventory, account health). Shopify has no native threshold alerting on business metrics. Most sellers discover problems reactively — noticing a revenue drop in a weekly review rather than being alerted in real time.

Run it on your data

Calculate this automatically with Taptic Data

Connect your Amazon Seller Central account and Taptic generates this calculation from plain English against your actual data — no Excel exports, no manual joins. The SQL runs against your real schema, your real tables, your real numbers.

SQL query for Amazon return rate by SKU — a common alert trigger →Connect Amazon Seller Central →Try Free — $29.99/mo

FAQ

Common questions

What are the most important eCommerce metrics to alert on?

For Amazon: return rate by ASIN (spike detection), buy box percentage (loss detection), daily revenue vs 7-day average (revenue anomaly), inventory days remaining (stockout prevention). For Shopify: refund rate by product, daily revenue, cart abandonment rate. For any business: any metric with a known normal range that, when violated, requires action.

How do I set a meaningful threshold vs one that causes alert fatigue?

Base thresholds on your historical normal range. If your Amazon return rate averages 6% with a standard deviation of 2%, set your alert at 10% (mean + 2 standard deviations). This catches genuine anomalies while filtering out normal variation. Review and adjust thresholds quarterly as your business evolves.

How does Taptic Data handle eCommerce alerts?

Taptic evaluates alert conditions after every data refresh. You define the metric (using a SQL query or pre-built metric), the threshold, and the notification channel (email). When the condition is met, Taptic sends an alert with the current value, the threshold, and a link to the relevant report.

Can alerts be set on custom SQL queries in Taptic?

Yes. Because Taptic gives you SQL access to your data, you can write any query as the basis for an alert — including multi-table joins, custom calculations, or cross-platform conditions. An alert can, for example, fire when Amazon return rate exceeds Shopify refund rate for the same product category.

Analytics hub

All Analytics queries, use cases, and SQL examples in one place.

Amazon Analytics hub — queries, use cases, and SQL examples →

Stop calculating this in spreadsheets

Connect Amazon Seller Central to Taptic Data and run this calculation automatically from plain English — against your real data, on a schedule, delivered to your team.

Start Free — $29.99/mo Try the Live Demo