Description
Add eligibleSpend and pendingSpend for projectedSpend.
Marketing rates compare a counted outcome with a declared cohort or exposure base. Reentries, exclusions, and distinct funnel stages can change the denominator substantially.
Add eligibleSpend and pendingSpend for projectedSpend.
When to use this tool
Use Loyalty Tier Spend Progress Margin when you need a transparent cohort or exposure ratio.
How to use the tool and how it works
- Enter eligibleSpend, pendingSpend, threshold. Use the units and conventions below.
- Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
- Read projectedSpend, remainingSpend, reached. Inspect reached before interpreting the associated values.
Add eligibleSpend and pendingSpend for projectedSpend. Return zero-floored threshold shortfall and reached on the inclusive threshold comparison.1
| Input field | Meaning and units | Accepted input |
|---|---|---|
| eligibleSpend | Eligible Spend | Required. Finite number; minimum 0. |
| pendingSpend | Pending Spend | Required. Finite number; minimum 0. |
| threshold | Threshold | Required. Finite number; minimum 0. |
| Output field | Interpretation | Returned shape |
|---|---|---|
| projectedSpend | Projected Spend | Required. Finite number. |
| remainingSpend | Remaining Spend | Required. Finite number. |
| reached | Reached | Required. Boolean. |
{
"input": {
"eligibleSpend": 70,
"pendingSpend": 20,
"threshold": 100
},
"output": {
"projectedSpend": 90,
"remainingSpend": 10,
"reached": false
}
}Limitations and assumptions
- Use one currency and eligibility basis; pending spend is treated as fully qualifying and actual loyalty rules are not inferred.
- 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 event definitions, attribution windows, and deduplication against the source analytics before comparing rates.
References
Similar or alternative tools
- Coupon Gift Qualifying Base Flag
Add giftValue to purchasedValue only when includeGift is true.
- Promotion Price Uplift Factor
Divide nonnegative promotionPrice by positive referencePrice for priceFactor and return that ratio minus one as signedUplift.