> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dqlabs.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Use Cases

> Real-world Standalone Query metric examples in Prizm — Daily Active Users KPI tracking and cross-source revenue reconciliation.

<script type="application/ld+json">
  {`{
            "@context": "https://schema.org",
            "@type": "TechArticle",
            "headline": "Standalone Query Metric Use Cases",
            "description": "Real-world Standalone Query metric examples in Prizm - Daily Active Users KPI tracking and cross-source revenue reconciliation.",
            "url": "https://docs.dqlabs.ai/architecture/metrics/standalone/usecases",
            "publisher": {
              "@type": "Organization",
              "name": "DQLabs Inc",
              "logo": "https://media.brand.dev/332adc35-5bc4-4d2b-bf78-256aa4a5e414.svg"
            }
            }`}
</script>

## Example use cases

**Daily Active Users KPI:** Track DAU as a standalone business metric, monitored independently of any specific events table asset. Alerts when DAU drops more than 15% below the rolling 7-day average.

```sql theme={null}
SELECT COUNT(DISTINCT user_id)
FROM events
WHERE event_date = CURRENT_DATE - 1
  AND event_type = 'session_start'
```

**Cross-source revenue reconciliation:** Compute the gap between the transactional warehouse and the reporting layer daily. Fires if the discrepancy exceeds 0.5% — a global check that does not belong to either source system individually.

```sql theme={null}
SELECT ABS(a.total - b.total) / b.total AS discrepancy_rate
FROM (
  SELECT SUM(amount) AS total
  FROM warehouse.transactions
  WHERE date = CURRENT_DATE - 1
) a,
(
  SELECT SUM(revenue) AS total
  FROM reporting.daily_revenue
  WHERE date = CURRENT_DATE - 1
) b
```

<Note>
  Standalone Query metrics require at least one configured data source connection. They are designed for metrics that span multiple tables or have no natural home on a single asset page. For single-table checks, use a Query metric instead.
</Note>