Interactive demo · PayQuery

Skip to content

Acme StudioSample data

Query Dashboards Query library Connections Workspace health

customers

Provider-specific customer records. The same person at two providers remains two rows. country is the provider-reported customer address country as an uppercase ISO 3166-1 alpha-2 code when available, not a country name; it may differ from transactions.country.

idtext
providertext
external_idtext
emailtext
nametext
countrytext
currencytext
created_attimestamp
metadatajsonb

subscriptions

Current subscription snapshots with normalized status and a legacy source list-price estimate in mrr_minor. For current MRR using workspace rules, query subscription_mrr instead. These legacy amounts are in provider minor units. Paddle values are before discounts and retain source tax treatment (internal prices may include tax); unresolved item currency, country overrides, tax basis or incomplete recurring prices make mrr_minor NULL. Never replace a missing estimate with a catalog-price sum or zero. Never project these amounts backwards as recorded history or describe them as Paddle-reported MRR.

idtext
providertext
customer_idtext
statustext
currencytext
mrr_minorbigint
started_attimestamp
current_period_endtimestamp
canceled_attimestamp
ended_attimestamp
trial_endtimestamp
connection_iduuid

subscription_mrr

Current subscription MRR under the workspace's saved discount and subscriber-start rules. One row per subscription, including excluded rows. Use eligible for included/excluded counts: false contributes zero; an eligible row with missing mrr_minor or currency makes its monetary aggregate unknown, never a partial sum. Permanent recurring discounts are always deducted; recurring and one-time discount switches select the other deductions. first_paid_at is the first qualifying payment found in imported data, not proof of complete payment history. reason explains excluded or unresolved inputs. settings_version identifies the rules used. These current values are not cash, recognized revenue, Paddle-reported MRR or reconstructed historical balances. subscriptions.mrr_minor and historical views retain their separate source/list-price basis.

idtext
subscription_idtext
providertext
connection_iduuid
external_idtext
customer_idtext
statustext
currencytext
mrr_minorbigint
eligibleboolean
first_paid_attimestamp
reasontext
settings_versionint
started_attimestamp
current_period_starttimestamp
current_period_endtimestamp
canceled_attimestamp
ended_attimestamp
trial_endtimestamp
metadatajsonb

mrr_observation_totals

Configured balances for every complete captured snapshot, by provider/connection/currency. Use this for monthly queries with partial-period cutoffs: filter observed_at to the requested UTC interval FIRST, then choose the latest snapshot_id per month by observed_at and snapshot_id descending. Join all rows of that chosen snapshot before narrowing provider/currency; do not choose different dates for missing groups or carry them forward. mrr_monthly_configured instead selects the latest point for the whole month before caller filters. Values use current workspace settings. NULL amount and unknown-currency evidence must be preserved. source_checked_at is source freshness, distinct from observed_at capture time; no pre-capture backfill is available.

snapshot_idbigint
observed_attimestamp
source_checked_attimestamp
providertext
connection_iduuid
currencytext
mrr_minornumeric
included_subscriptionsbigint
missing_amountsbigint
unknown_currency_subscriptionsnumeric
settings_versionint

mrr_daily_configured

Configured MRR from the latest complete captured snapshot in each UTC day, per provider/connection/currency. observed_at is capture time; source_checked_at is the oldest active connection completed source sync, not the capture timestamp. Coverage starts when capture begins: absent days and pre-baseline dates are unknown, never zero-filled. mrr_minor is NULL if an eligible amount is unknown or any eligible currency in that connection snapshot is unknown; missing_amounts and unknown_currency_subscriptions disclose this. Values are recalculated using current workspace settings_version. Never sum daily MRR balances as revenue or monthly MRR; use mrr_monthly_configured for monthly observations. Multi-connection sums must remain NULL when any component is unknown.

daydate
observed_attimestamp
source_checked_attimestamp
providertext
connection_iduuid
currencytext
mrr_minorbigint
included_subscriptionsbigint
missing_amountsbigint
unknown_currency_subscriptionsbigint
settings_versionint

mrr_monthly_configured

Latest actual complete captured MRR observation within each UTC month, per provider/connection/currency, under current workspace settings. month labels the month; observed_at is the actual measurement time, not necessarily month end. source_checked_at separately reports source freshness. Current month is partial. For a cutoff inside a month, use mrr_observation_totals and filter before selecting each monthly snapshot; filtering this view afterwards can hide valid earlier observations. Coverage, NULL totals and unknown currency rules match mrr_daily_configured. Never sum daily balances to construct monthly MRR, fill absent history with zero or claim a month-end observation without one.

monthdate
observed_attimestamp
source_checked_attimestamp
providertext
connection_iduuid
currencytext
mrr_minorbigint
included_subscriptionsbigint
missing_amountsbigint
unknown_currency_subscriptionsbigint
settings_versionint

mrr_movements

Per-subscription net changes between adjacent captured daily snapshots, with both snapshots calculated under the same CURRENT workspace settings. No movement for the baseline; settings changes alone are not growth. This is a comparison of observed balances, not an exact provider-event ledger or intraday chronology. movement is new, reactivation, expansion, contraction, churn, pause, eligibility_change, currency_change, coverage_change, unknown or unchanged. A late import of an old subscription is coverage_change, never new; disappearance alone is not churn. currency_change, coverage_change and unknown have NULL change_minor; do not coalesce them into measured growth. Comparable changes retain signed change_minor and same-currency units. reason explains the classification. previous_observed_at/observed_at disclose the actual interval and any missing days. Keep provider/connection/currency separate and expose unknown comparisons when aggregating.

daydate
observed_attimestamp
previous_observed_attimestamp
providertext
connection_iduuid
subscription_idtext
currencytext
previous_currencytext
previous_mrr_minorbigint
mrr_minorbigint
change_minorbigint
movementtext
reasontext
settings_versionint

mrr_settings

One row of workspace-wide current MRR rules. Owners change these through workspace settings, not SQL. Defaults subtract recurring discounts, do not deduct one-time discounts, and start subscriber eligibility at subscription_start. Permanent recurring discounts are always subtracted. subscriber_start is subscription_start or first_payment; version increases on saved rule changes. Settings apply when subscription_mrr is next queried and do not rewrite historical list-price data.

subtract_recurring_discountsboolean
subtract_one_time_discountsboolean
subscriber_starttext
versionint

subscription_items

Price and quantity lines on a subscription.

idtext
subscription_idtext
price_idtext
quantityint

transactions

Stripe charges and Paddle transactions. Collected statuses: succeeded, partially_refunded, refunded. Stripe authorized amounts are not collections. Money is in charge/transaction currency; fee/net are NULL when settlement currency differs or details are unknown. paid_at can be NULL (Stripe charge snapshots do not provide capture time); created_at is only a documented fallback, not an exact settlement date. country is an uppercase provider-reported ISO 3166-1 alpha-2 code, not a country name: Stripe card country with billing-address fallback, or Paddle transaction address country. It is not necessarily the customer's address country.

idtext
providertext
customer_idtext
subscription_idtext
statustext
currencytext
amount_minorbigint
fee_minorbigint
tax_minorbigint
net_minorbigint
payment_method_typetext
countrytext
created_attimestamp
paid_attimestamp
failure_codetext

invoices

Invoices (Stripe) and billed transactions (Paddle).

idtext
providertext
customer_idtext
subscription_idtext
statustext
currencytext
total_minorbigint
tax_minorbigint
created_attimestamp
paid_attimestamp
due_attimestamp

refunds

Stripe refunds and Paddle adjustments with action=refund, not credits or chargebacks. Original provider status is retained: currently completed cash means (provider='stripe' AND status='succeeded') OR (provider='paddle' AND status='approved'). Completed cash totals exclude pending_approval, pending, rejected and authorization_released; those rows remain queryable for questions about their states. created_at is request creation, not approval/completion or bank settlement time. Current status plus created_at is a creation-time proxy and cannot prove a refund was completed by a past cutoff. Some legacy Stripe capture releases cannot be distinguished without linked history.

idtext
providertext
transaction_idtext
currencytext
amount_minorbigint
reasontext
statustext
created_attimestamp

disputes

Stripe disputes and Paddle chargebacks, with provider-specific lifecycle statuses.

idtext
providertext
transaction_idtext
currencytext
amount_minorbigint
reasontext
statustext
created_attimestamp

payouts

Stripe payout records, including pending and failed payouts. Filter status to paid for completed payouts.

idtext
providertext
currencytext
amount_minorbigint
statustext
arrival_datedate
created_attimestamp

products

Canonical products records.

idtext
providertext
nametext
activeboolean
created_attimestamp

prices

Canonical prices records.

idtext
providertext
product_idtext
currencytext
unit_amount_minorbigint
billing_intervaltext
interval_countint
usage_typetext
activeboolean

discounts

Canonical discounts records.

idtext
providertext
codetext
percent_offnumeric
amount_off_minorbigint
currencytext
activeboolean

paddle_subscription_history

Paddle subscription change records. Entries in a single request share group_id; do not count each entry as a separate state. Paddle began recording history on June 29, 2026; older inferred records and source unknown are not complete history. Scheduled changes are not completed cancellation events.

idtext
providertext
connection_iduuid
subscription_idtext
group_idtext
occurred_attimestamp
sourcetext
actiontext
datajsonb

subscription_history_coverage

Per-subscription Paddle history import coverage. Use only status completed and checked_at at or after the requested as-of time. Pending, missing, or older coverage makes that subscription unknown, not zero. Coverage is an observed import horizon, not an atomic provider snapshot.

idtext
providertext
connection_iduuid
subscription_idtext
source_updated_attimestamp
checked_attimestamp
statustext

subscription_mrr_history

Paddle grouped recurring list-price state timeline. mrr_minor is monthly-normalized recurring list value before discounts, with source-price tax treatment preserved; internal tax-mode prices may include VAT. This is not Paddle tax-exclusive MRR. Select the latest state before each as-of boundary per connection/subscription, never sum changes or today's prices. quality recorded is usable; inferred/unknown, missing amounts or missing coverage mean unknown, not zero. Active/past_due states contribute recurring value; known trialing/paused/canceled states contribute zero.

idtext
providertext
connection_iduuid
subscription_idtext
occurred_attimestamp
statustext
currencytext
mrr_minorbigint
qualitytext
reasontext

subscription_events

Estimated starts and ends reconstructed from current subscription snapshots. Historical plan changes are not captured.

subscription_idtext
customer_idtext
occurred_attimestamp
kindtext
delta_mrr_minorbigint
currencytext

mrr_daily

Estimated daily MRR from current subscription snapshots, by provider and currency; not a complete historical ledger.

daydate
providertext
currencytext
mrr_minorbigint
active_subscriptionsint

raw_objects

Latest synced provider objects in JSON. Coverage depends on connector endpoints and granted permissions.

providertext
object_typetext
idtext
updated_attimestamp
datajsonb

Connect your data

Acme StudioSample data

Loading SQL editor…

Results

Your results will appear here

Run the query when you’re ready.

Interactive demo · PayQuery