maiven gateway · online··
manifest · 1d ago
Sign in
Back to catalog
MAIVENmodelmarts

mart_payments_daily

certified
mart incremental

Money in / money back per day, by transaction type and status.

Lineage Builds
Definition

Daily payment-funnel rollup. Naively summing `amount` across `transaction_type` double-counts (auth and capture both carry the order total). Revenue = `captured_amount = sumIf(amount, is_final_capture)`. Refunds and failed auths are tracked separately for funnel diagnostics.

What it means
Watch out for
  • highSumming `gross_amount` across transaction types

    Double-counts revenue — `auth` and `capture` rows both carry the order total. Use `captured_amount` for true revenue.

  • mediumTreating `failure_count` as lost-revenue total

    `failure_count` is a row count, not a dollar figure. Use `failed_amount` for the exposure side; not all failures represent lost revenue (auto-retry recovers many).

Questions this answers
  • “What was captured revenue last month, broken down by transaction status?”
  • “Payment failure rate this week.”
Related metrics
  • revenue

    `captured_amount` reconciles with `revenue` over the same window.

  • customer_health

    Customer-level payment failure influences retention.

References
Reconciles with
  • revenue metric (mart_orders_daily)
    last verified · 2026-05-20drift · 0.00%
14 of 14
Column
Type
Description
Tests · PII
processed_day
Date
Calendar date the vendor processed the transaction. Sort + partition key.
1 test
transaction_type
String
`auth` / `capture` / `refund` / `void`.
1 test
status
String
`succeeded` / `failed` / `pending`.
1 test
payment_count
UInt64
Row count in the bucket. Includes auth + capture; not a deduped order count.
2 tests
unique_orders
UInt64
Distinct order_id count in the bucket.
1 test
unique_customers
UInt64
Distinct customer_id count in the bucket.
1 test
gross_amount
Decimal(14, 2)
Sum of `amount` across all rows. NOT a revenue figure (double-counts auth+capture).
2 tests
captured_amount
Decimal(14, 2)
Sum of `amount` where transaction_type='capture' AND status='succeeded'. THE revenue figure.
2 tests
refunded_amount
Decimal(14, 2)
Sum of refund-row amounts. Subtract from captured for net revenue.
1 test
failed_amount
Decimal(14, 2)
Sum of failed-auth amounts. Exposure-to-failure measure.
capture_count
UInt64
Count of `is_final_capture` rows.
refund_count
UInt64
Count of `is_refund` rows.
failed_auth_count
UInt64
Count of `is_failed_auth` rows.
failure_count
UInt64
Count of `status='failed'` rows (any transaction_type).