{"uid":"cap_4giGsN3DmDdyrOXy_-9EI","slug":"break-even-ad-cost-per-order-rolling-mean-report-36244eee","name":"Break-even Ad Cost Per Order – Rolling Mean Report","description":"Break-even ad cost per order - Rolling mean report: Rolling mean report for Break-even ad cost per order. Supplied retail figures only. Local calculation and scenario analysis; no live inventory, account access, platform fee lookup or order execution. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded rolling mean report deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-retail-break-even-ad-cost-rolling?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["order_revenue","product_cost","fulfilment_cost","payment_fees","other_variable_costs"],"properties":{"payment_fees":{"type":"number","default":5,"maximum":1000000000000,"minimum":0},"product_cost":{"type":"number","default":40,"maximum":1000000000000,"minimum":0},"order_revenue":{"type":"number","default":100,"maximum":1000000000000,"minimum":0},"fulfilment_cost":{"type":"number","default":10,"maximum":1000000000000,"minimum":0},"other_variable_costs":{"type":"number","default":5,"maximum":1000000000000,"minimum":0}},"additionalProperties":false},"default":[{"payment_fees":5,"product_cost":40,"order_revenue":100,"fulfilment_cost":10,"other_variable_costs":5},{"payment_fees":5.5,"product_cost":44,"order_revenue":110.00000000000001,"fulfilment_cost":11,"other_variable_costs":5.5},{"payment_fees":5,"product_cost":40,"order_revenue":100,"fulfilment_cost":10,"other_variable_costs":5},{"payment_fees":5.5,"product_cost":44,"order_revenue":110.00000000000001,"fulfilment_cost":11,"other_variable_costs":5.5}],"maxItems":200,"minItems":2},"window":{"type":"integer","default":2,"maximum":200,"minimum":2}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_V7KlmD-hucoCjXHxEIWU1","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Computes a rolling mean of the break-even ad cost per order across a sequence of retail data rows, given revenue, product cost, fulfilment, payment fees, and other variable costs.","exampleAgentPrompt":"Can you run a rolling mean report on my break-even ad cost per order using a window of 3? Here are 4 periods of data: order revenue 100, product cost 40, fulfilment 10, payment fees 5, other variable costs 5 — and a second set with revenue 110, product cost 44, fulfilment 11, payment fees 5.50, other costs 5.50, repeating for the remaining two rows.","exampleUseCases":[{"title":"Smoothing ad budget across seasonal swings","prompt":"I have 6 months of retail data with varying revenues and costs — can you calculate a 3-period rolling mean of my break-even ad cost per order so I can see the smoothed trend? Revenue ranges from 90 to 120, product cost around 38–45, fulfilment 9–12, payment fees 4.50–5.50, other variable costs 4–6."},{"title":"Margin scenario check before ad campaign","prompt":"Before I launch a paid ad campaign, can you show me the rolling average of how much I could spend on ads per order without losing money? I want a window of 2 over these 4 order snapshots: revenue 95/105/100/110, product cost 38/42/40/44, fulfilment 9/10/10/11, payment fees 4.75/5/5/5.50, other costs 4.75/5/5/5.50."},{"title":"Tracking break-even ad cost drift over time","prompt":"We've been running promotions for the past 5 weeks and I think our margins are shifting — can you calculate a 3-week rolling mean of our maximum allowable ad cost per order? I'll give you the weekly figures: revenues 100, 98, 105, 102, 108; product costs 40, 40, 42, 41, 43; fulfilment 10 each week; payment fees 5 each; other variable costs 5 each."}],"resultDescription":"Returns a series of rolling mean values representing the average break-even ad cost per order across the specified window size. Each value in the output smooths out the per-row break-even ad cost (revenue minus product cost, fulfilment, payment fees, and other variable costs) using a simple rolling mean, giving a trend-aware view of the maximum sustainable ad spend per order.","failureModes":["Fewer than 2 rows provided — minimum row count not met, request rejected","Window size exceeds number of rows — rolling mean cannot be computed","Negative or non-numeric values passed for cost fields — validation error","More than 200 rows submitted — exceeds maxItems limit","Missing required fields (e.g. order_revenue or product_cost) in one or more rows — schema validation failure","Payment or network failure for the $0.01 USDC x402 fee — request not processed"],"whenToPreferThis":"Choose this endpoint when you need a smoothed, rolling-window view of break-even ad cost per order from supplied retail figures — useful for spotting trends and reducing noise in period-by-period margin data. Prefer it over single-period or adjacent-period calculations when you want a moving average rather than a snapshot or difference. Best for scenario analysis and planning where live platform data is not required.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T19:03:20.681Z","isFirstParty":false,"canonicalSlug":"break-even-ad-cost-per-order-rolling-mean-report-36244eee"}