Retained-order worksheetA Netherlands retailer’s retained-order worksheet
Specify the basket version: Save the item, bundle, euro price and delivery conditions the customer saw. Preserve earlier terms when the shop changes a promotion, so each cohort retains its own economics.
Check the commercial allowance: Suppose a retained order leaves €25 after the retailer’s stated product and routine fulfilment costs. Reserving €7 for the business leaves €18 available for acquisition. These hypothetical amounts are a transparent seller calculation, not FroggyAds pricing or a Netherlands industry benchmark.
Verify the euro reference: The European Commission identifies the Netherlands as a euro-area member. It supports our currency terminology, not a shop’s tax treatment, an advertising exchange rate or an acquisition allowance.
Read the publisher proposition accurately: DPG describes its own digital formats and Trusted Web. This illustrates a publisher-media brief without establishing FroggyAds access to those titles, audience figures or branded-content services.
Keep language and service aligned: Dutch creative needs a destination that continues the conversation accurately. Check descriptions, checkout instructions and support. Language choice does not establish an eligible delivery address.
Reconcile retained contribution: Follow each media cohort’s order identifiers to their final store status. Apply consistent stated costs. Identify unmatched sales instead of forcing them into campaigns to make totals agree.
Inspect the return reason: Check whether the image, bundle description or specification differed from the delivered item. Use your actual customer evidence to decide which creative or destination correction matters.
Protect the affiliate comparison: Use the merchant’s approved terms and reported conversion definitions. If reporting ends at an initial approved event, state that limit without claiming knowledge of retained orders you cannot observe.
Check the next allocation: Confirm stock and service capacity before increasing spend. Keep new customers and unresolved orders identifiable until they reach the same review stage as the previous cohort.
Choose a useful repair: Correct the documented constraint, such as a misleading delivery threshold. Preserve its date and destination version so the next test can reveal whether that correction improves the economics.
| Order stage | Required evidence | Buying interpretation |
|---|
| Checkout started | Basket and source identifier | The visitor began the purchase process. |
| Paid order | Store-confirmed payment | Payment occurred; final retention is unresolved. |
| Retained order | Final order under the stated review rule | Use it for retained acquisition cost. |
A worked euro calculation after returns
Hypothetical retailer calculation: €420 of media spend generates 35 paid orders, giving €12 per paid order. Seven of those orders are later cancelled or returned, leaving 28 retained orders and €15 media cost per retained order. If €56 of additional recorded handling is outside the routine costs already included, specified media and handling cost is €476 divided by 28, or €17 each. That is a different measure from the original €12.
Why choose FroggyAds for this Netherlands offer?
We give advertisers and media buyers a practical way to control traffic allocation, inspect source delivery and test an accurate retail proposition. Connect those campaign controls to your own retained-order records and you can make a buying decision grounded in the offer’s economics. Create your free FroggyAds account with one product or bundle ready to test.