Marketing & Advertising
Shopping Campaign Performance Calculator
Model eligible-product impression supply, shopping clicks, placed orders, returns, retained revenue, COGS, ad spend, feed cost, ROAS, and break-even retained orders.
Shopping ad impressions-
Shopping ad clicks-
Orders placed from shopping clicks-
Orders retained after cancellations and returns-
Revenue from retained orders-
Cost of goods sold-
Retained revenue less COGS-
Gross profit less ad and feed costs-
Retained revenue divided by ad spend-
Ad spend per retained order-
Retained ROAS minus target-
Retained orders needed to cover ad and feed cost-
Decision view
Shopping feed inventory and retained-order economics
Shopping feed inventory and retained-order economicsEligible products create auction impressions and clicks; cancellations, returns, COGS, ad spend, and feed cost bridge gross orders to campaign contribution.
Exact scenario comparisonShopping ad click-through rate (%) changes while all other entered assumptions remain constant.
| Shopping ad click-through rate (%) | Shopping ad impressions | Shopping ad clicks | Orders placed from shopping clicks | Orders retained after cancellations and returns | Revenue from retained orders | Cost of goods sold | Retained revenue less COGS | Gross profit less ad and feed costs | Retained revenue divided by ad spend | Ad spend per retained order | Retained ROAS minus target | Retained orders needed to cover ad and feed cost |
|---|
How to use Shopping Campaign Performance Calculator
- Enter only products currently eligible to serve.
- Use shopping-specific CTR, click-to-order rate, and return rate.
- Reconcile retained revenue with COGS and both media and feed-platform costs.
Calculator guide
Understanding Shopping Campaign Performance Calculator
Shopping campaigns begin with feed eligibility and end with retained order margin. This calculator connects those operational and financial layers without treating placed orders as final revenue.
Detailed calculation process
Detailed shopping-campaign calculation process
The default example connects feed eligibility to retained order contribution.
General formula: I = PqC = I(r_c/100)O_g = C(r_o/100)O = O_g(1-r_r/100)R = OvG = R(1-r_g/100)K = G-A-F Eligible products create impressions, clicks create orders, returns reduce the order base, and retained gross profit is reduced by ad and feed cost.
What each symbol means
Worked substitution with the default inputs
Contribution plus ad spend, feed cost, and COGS must reconcile to retained revenue.
Worked situations
Practical examples
- A feed cleanup can increase eligible products while holding per-product impressions constant.
- A high-return apparel campaign can test whether retained ROAS still clears the target after returns.
Better inputs
Useful tips
- Use retained revenue after cancellations and returns.
- Keep feed or merchandising tooling outside ad spend.
- Compare product groups separately when margin and return rates differ materially.
Before relying on the result
Limitations and common mistakes
- Auction mix, bids, shipping, taxes, promotions, stockouts, and repeat value are excluded.
- One average impression count, order value, COGS rate, and return rate are applied across eligible products.
- Attribution settings can change reported order counts.
Reference
Key terms
- Eligible product
- A feed item approved and able to participate in the shopping auction.
- Retained ROAS
- Revenue remaining after cancellations and returns divided by ad spend.
- COGS
- Cost of goods sold assigned to retained revenue.
Important note
For mixed catalogs, run separate calculations for product groups with materially different order values, margins, or return rates.
Frequently asked questions
Why include feed cost?
Feed tooling and merchandising can be required to create and maintain eligible inventory.
Is ROAS based on gross orders?
No. This page uses retained order revenue.
Does break-even include COGS?
Yes. It divides ad and feed cost by retained gross profit per order.