On this page

A campaign forecast assumes 1,000 orders averaging $100 and a 10% reward. The expected reward value is $10,000. If a small number of legitimate customers place much larger orders, the total can rise materially even though the order count remains exactly 1,000.

A percentage reward follows eligible value, so the upper end of the purchase-size distribution matters. This worksheet stress-tests the forecast against larger purchases without treating them as abuse or redesigning the reward cap.

Build a purchase-size distribution assumption

Use a fictional ordinary order value of $100 and a large order value of $1,000. At the approved illustrative 10% rate, the rewards are $10 and $100 respectively. Assume both purchase types are legitimate, eligible and uncapped under the proposed design.

Keep the total count fixed at 1,000 orders and vary the number of large purchases. This isolates the effect of basket mix from a change in order volume. A live model should use plausible values grounded in the merchant’s business rather than arbitrary extreme amounts.

Do not rely only on the average observed during a short quiet period. A campaign may include product combinations or buyers capable of placing larger legitimate purchases. The forecast should show what happens if those purchases make up a greater share of the eligible population.

The RebateCardX campaign overview can frame a discussion of the proposed percentage offer. The model here assumes an uncapped formula for analysis; it does not establish an actual program limit or available funding arrangement.

Calculate exposure under ordinary and large-order scenarios

Use four purchase mixes and show the full reward total.

Large orders among 1,000 Ordinary orders at $100 Large orders at $1,000 Total eligible merchandise Reward value at 10% Increase over ordinary-only forecast
0 1,000 0 $100,000 $10,000 $0
10 990 10 $109,000 $10,900 $900
50 950 50 $145,000 $14,500 $4,500
100 900 100 $190,000 $19,000 $9,000

Each large order replaces an ordinary one in this fixed-count comparison. It therefore adds $900 of eligible value and $90 of reward exposure, not a full extra $100 of reward on top of an unchanged 1,000 ordinary orders.

At 50 large orders, only 5% of purchases are in the larger group, yet total reward value rises by 45% relative to the ordinary-only forecast. That is a result of the example’s tenfold basket-size difference, not a general statistic about Shopify stores.

Add other campaign costs separately. If the model assumes $1 of other variable reward cost per order and $500 fixed cost, the totals become $11,500, $12,400, $16,000 and $20,500. Because the order count is fixed, the $1,000 variable event cost remains unchanged across these scenarios. The face-value component drives the difference.

A difficult case is a fee linked to reward value rather than order count. In that arrangement, larger orders could increase both face value and program charges. The model should use the documented fee basis rather than retaining the $1 assumption simply because it is convenient.

Another case involves larger orders with different fulfillment economics. The table shows funding exposure, not final campaign profitability. The additional merchandise may generate more contribution, but it can also carry different product, shipping or service costs. The larger-basket contribution worksheet addresses those economics separately.

Decide whether the approved budget has enough headroom

Suppose the merchant has approved a $15,000 campaign cost budget under the stated $1 event cost and $500 fixed cost assumptions. The ordinary-only scenario leaves $3,500 of headroom. The 50-large-order scenario requires $16,000 and exceeds the budget by $1,000. The same number of orders can therefore cross the budget because their values change.

The planning question is whether the merchant can support a plausible larger-order mix under the proposed promise. It should not assume that high-value legitimate purchases can be rejected after the fact merely because the initial forecast used smaller baskets.

If the scope or formula needs revision, do that prospectively through the approved design process. This worksheet does not choose the mathematical cap; the reward-cap comparison handles that separate decision. A stress test identifies exposure so the merchant can decide whether a change is necessary.

Review the source of the large-order assumption. It might come from historical wholesale-like baskets that are actually outside the consumer offer, or from normal customer orders that genuinely belong in scope. The model should include the relevant population and avoid mixing unrelated purchase types simply to create an alarming number.

Also test a larger count without a larger value. If ordinary order volume rises, that is a separate dimension from the mix shown here. A full planning model may need both, but keeping them separate initially helps the merchant see which assumption creates the funding requirement.

For the fictional campaign, a useful decision note is: “The $15,000 budget covers the ordinary-only scenario but not a mix containing 50 eligible $1,000 orders among 1,000 total purchases. Validate the plausible purchase distribution and approve sufficient exposure or revise the offer before publication.”

The practical deliverable is a tail-exposure table with ordinary and large purchases shown explicitly. It turns a hidden average-order assumption into a visible budget dependency without treating valuable customers as suspicious or confusing funding exposure with measured campaign success.

Review the effect of larger eligible orders on your proposed campaign budget. Discuss program fit.

Source references

Back to contents

General information only

This guide is general information, not financial, legal, tax or regulatory advice. Eligibility, card availability, permitted use and responsibilities depend on the applicable offer and card terms.