Comparing shopping spend with product-level margin

Compare Shopping spend with the contribution from orders attributed to that advertising, using a consistent reporting period and cost basis. Revenue divided by ad spend cannot show whether sales covered product and fulfilment costs. First match products to orders, then distinguish the product advertised from the products sold.

Use Google Shopping reporting filters to review performance at product, brand or product group level. Put available ad cost and conversion value or ROAS (return on ad spend) beside reconciled product and basket contribution for the same view.

Define the margin available for advertising

For each sold item, take realised selling price after discounts and subtract product cost on the business's chosen accounting basis. For an acquisition decision, also weigh variable costs that figure may omit, such as delivery subsidy, payment fees and expected returns. Treat GST consistently across revenue and cost records.

An internal measure is attributed order contribution minus ad cost. If an order contains several products, allocate discounts and order-level costs consistently. Mark missing item costs as unknown; do not treat them as zero. Ask finance to agree the definition before comparing products or campaigns.

For a gross-margin-only check, break-even ROAS is 1 ÷ gross margin; at 40% margin, that is 2.5x. Treat this as a break-even floor, not proof of commercial profit, because variable costs excluded from that margin still need covering.

Use the right product view

Google Ads Help names “About conversions with cart data” and “Step 2: Provide cost of goods sold (COGS) feed attribute to report on profit margins”. These address different questions: cart data relates to products in attributed orders, while the COGS feed attribute supports profit-margin reporting.

Keep advertising cost aligned with the advertised product or campaign that incurred it; never subtract the same cost separately from every sold item. Do not assign the full value of a mixed basket to each item in it.

If spend is available only at product-group level, compare that group's total attributed contribution with its cost. Do not present a grouped cost as a product-level result or split it across items without an agreed allocation; keep the product verdict provisional if no defensible split is available.

Conversions with cart data depend on correctly supplied cart data, and a cost of goods sold (COGS) feed attribute supports reporting on profit margins.

Check purchase counts, discounts and returns against commerce records. Attributed sales also do not establish that every reported order was incremental.

Pros and Cons of Using Cart Data vs. COGS Feed for Margin Reporting

Decide with comparable records

Place ad cost beside attributed orders, realised revenue, product cost and the additional variable costs in the agreed definition. Use a consistent date and attribution basis in advertising and commerce records, and record the basis actually used. Allow for conversion delay and later returns, and note stockouts and promotions that changed the offer during the period.

Use break-even as a minimum: spend that falls below it is not covered by the stated margin. Expand only when reconciled contribution after ad cost clears the business's agreed commercial hurdle; ROAS above break-even alone does not establish that outcome if other costs remain uncovered.

If revenue is strong but contribution is weak, investigate price, discounts, fulfilment and basket mix before expanding spend. If what is advertised and what is sold tell different stories, examine which products attract buyers and which are purchased. Where tracking or costs are incomplete, keep the decision provisional until the gap is resolved.

Steps to Accurately Compare Shopping Spend with Product-Level Margin