Description
Measure signed refund lag and flag a refund before purchase.
Business metrics depend on event definitions, time windows, revenue and cost bases, and reporting scope. Observed sales during stockout do not by themselves verify latent demand, while a return contribution depends on which costs were already recognized. Local flags and signed balances are not a complete profitability or causal analysis.
Measure signed refund lag and flag a refund before purchase.
When to use this tool
Use Refund Lag Signed Duration when you already have purchaseTimestampSeconds, refundTimestampSeconds and need to measure signed refund lag and flag a refund before purchase.
How to use the tool and how it works
- Enter purchaseTimestampSeconds, refundTimestampSeconds. Use the units and conventions below.
- Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
- Read lagSeconds, refundPredatesPurchase. Inspect refundPredatesPurchase before interpreting the associated values.
Return refundTimestamp-purchaseTimestamp and refundPredatesPurchase=refund<purchase.1
| Input field | Meaning and units | Accepted input |
|---|---|---|
| purchaseTimestampSeconds | Purchase Timestamp Seconds | Required. Finite number. |
| refundTimestampSeconds | Refund Timestamp Seconds | Required. Finite number. |
| Output field | Interpretation | Returned shape |
|---|---|---|
| lagSeconds | Lag Seconds | Required. Finite number. |
| refundPredatesPurchase | Refund Predates Purchase | Required. Boolean. |
{
"input": {
"purchaseTimestampSeconds": 1000,
"refundTimestampSeconds": 4600
},
"output": {
"lagSeconds": 3600,
"refundPredatesPurchase": false
}
}Limitations and assumptions
- Equality is not before. No transaction identity, clock, refund, legal entitlement or actual chronology is verified.
- Inputs must satisfy both the field types and the cross-field conditions above. Invalid input causes an error; a successful false flag or documented placeholder is a different result.
- Numeric calculations use binary floating point unless exact decimal-integer arithmetic is explicitly stated. No hidden measurement tolerance or decimal rounding is added; nonfinite or out-of-contract results are rejected. Numeric signed-zero results are exported as zero.
Alternative or Complementary methods
Reconcile source transactions, inventory and cohort records with the full metric definitions. Use complete forecasts, accounting and study designs where needed; individual contributions and supplied scenarios do not establish performance or causal effects.
References
Similar or alternative tools
- Time To First Value Event Delta
Measure supplied first-value-event time relative to activation.
- Reservation No Show Net Revenue
Calculate supplied no-show retained amounts minus a refund.