↑↓ selectEnter openEsc close

    1. Elbuz
    2. Export and marketplaces
    3. Google Ads

    Google Ads product report: which products make money and which waste the budget

    4 min readUpdated

    Elbuz puts each product's Google Ads cost next to its purchase price and markup and calculates profit after ads. Segments: leaders, steady sellers, dead weight, no clicks.

    When you need this:

    • ROAS is 5, but the markup is 4% — profit after ads shows a loss, though Google Ads looks fine.
    • Where does the budget go? — “Dead weight” collects products with clicks but no sales.
    • Bids should depend on profit — the “Performance” label goes into the feed as a custom_label.
    • A manager checks a product — 30-day cost and profit are in the card and the product list.

    Where to start: the “Google Ads” window → “Products”.

    What the product report does

    • Profit after ads — for each product, with the purchase price taken into account.
    • Product table — search, segments, campaign, country, sorting by any figure, CSV export.
    • Segments — “Leaders”, “Steady”, “Dead weight”, “No clicks”, based on thresholds you set.
    • The “Performance” label in the feed — the same leaders and dead weight go into the custom_label of Google and Meta templates.
    • Product card and list — a 30-day Google Ads summary next to price and stock.

    How profit after ads is calculated

    Profit after ads = conversion value × (price − purchase price) / price − cost.

    Example: cost UAH 1,000, conversion value UAH 5,000 (ROAS 5), markup 4% of the price. Profit from sales is UAH 200; after ads it's minus UAH 800.

    • Without a purchase price, profit isn't calculated — the column shows “–”, and the product goes into the “No purchase price” recommendation.
    • Currency. Cost and value in the table are in the Google Ads account currency. Profit is in your main Elbuz currency: Google amounts are converted at the Elbuz exchange rate at the time of loading.
    • Price and purchase price are current. If you change the purchase price, profit in the window is recalculated right away; in the card and product list — after the nightly update.

    How to find loss-making products in the table

    The “Products” section shows every product that was advertised during the period. By default, products with the highest cost are on top.

    The Products section of the Google Ads window: search, segments, a totals row and a table with purchase cost, markup, ad cost and profit after ads
    1Search
    2Segments
    3Total
    4Profit
    5From selected
    6CSV
    1. By name, SKU or feed ID.
    2. Leaves one segment in the table.
    3. Cost, value, ROAS and profit for everything selected.
    4. Click the header to sort; loss-making products are red.
    5. A campaign from the selected products; the number in brackets is how many are selected.
    6. All products with the current filters, without the 500 limit.
    • Search — by name, SKU or feed ID.
    • Segment toggles — “All”, “Leaders”, “Steady”, “Dead weight”, “No clicks”.
    • Campaign and country — narrow the report to one campaign or one country where ads were shown.
    • Totals row — cost, conversion value, ROAS and profit after ads for everything filtered.
    • Column header — sorting: the first click sorts from highest, the second from lowest. Click “Profit after ads” twice to put loss-making products first.
    • Product name — opens the card, where you fix the price, purchase price or stock.

    The window shows up to 500 products; if there are more, you'll see “Showing 500 of N products — use “Export CSV” to get them all” above the table. “Export CSV” downloads all rows with the same filters.

    A “Product not found: <ID>” row means Google advertised a product that Elbuz doesn't have under that SKU or ID. Usually the feed's g:id contains something other than the SKU.

    Select products with checkboxes — the “Campaign from selected” button shows how many and opens the campaign form with these IDs. More: how to create a campaign.

    How Elbuz splits products into segments

    The segment is calculated for the selected period, and the rules are checked in order — the first one that matches is the segment.

    SegmentCondition (default)What to do
    No clicksno more than 2 clickscheck the price, photo and title: the product gets impressions, but shoppers aren't interested
    Leaders2 or more conversions and positive profit after ads; without a purchase price — conversions onlya separate campaign or a higher budget
    Dead weight20 or more clicks, and no conversions or a lossexclude from the campaign or lower the bid
    Steadyeverything elseleave as is

    The thresholds are in “Settings” → “Segments and recommendations”: “Leader: conversions from”, “Dead weight: clicks from”, “No clicks: clicks up to”. After editing, click “Save settings” at the bottom of the section — segments are recalculated the next time you open the report.

    The Segments and recommendations block in Google Ads settings: thresholds for leaders, dead weight, products without clicks, target ROAS and recommendation periods
    1Leader
    2Dead weight
    3No clicks
    4Recommendations
    1. How many conversions make a product a leader (if profit is positive).
    2. How many clicks without sales make a product dead weight.
    3. Products with this many clicks or fewer.
    4. How many recent days recommendations are calculated for.

    The “Dead weight: clicks from” threshold also applies to the “Clicks without sales” recommendation (recommendations).

    How to pass leaders and dead weight to the feed

    The “Performance” label in a Google or Meta export template is a custom_label with the values leader, ballast, no_impr, regular. In Google Ads, you use it to split products into groups with different bids.

    • There's Google Ads data for 30 days — the label is based on ads and profit:
      • leader — conversions at or above the threshold and positive profit (without a purchase price — conversions only);
      • ballast — clicks at or above the threshold, and no conversions or ads ate the profit;
      • no_impr — no impressions, regular — everything else.
    • No Google Ads data — the label is calculated from Merchant Center stats, as before.
    The Performance label in feeds block: export templates with ad labels, their thresholds and the button that writes thresholds to the selected templates
    1Template
    2Labels
    3Write
    1. A Google or Meta template; marked ones have thresholds different from the window.
    2. Whether ad labels are on in the template and whether Performance is among them.
    3. Copies the leader and dead-weight thresholds to the selected templates.

    Label thresholds are stored in each template separately. To make them match the window's thresholds, select the templates in the “Performance” label in feeds block and click “Write thresholds to selected templates”.

    Templates with different thresholds are already selected. Other label settings don't change.

    The button is available if you have access to the “Data export” window. How to turn on labels in a template: custom_label ad labels.

    Where else a product's ads are shown

    The product card has a “Google Ads · 30 days” block below “Prices and stock”: cost, conversions, conversion value, ROAS and profit after ads in green or red. The “Open Google Ads” button takes you to the window.

    The Google Ads · 30 days block in the product card: cost, conversions, conversion value, ROAS and profit after ads
    1Profit
    2Open
    3Date
    1. Green means ads paid off including purchase cost, red means they did not.
    2. Opens the Google Ads window.
    3. A 30-day total, updated after the nightly load.

    The product list has five columns: “Google Ads: cost, 30 d”, “…: conversions, 30 d”, “…: conv. value, 30 d”, “…: ROAS, 30 d”, “…: profit after ads, 30 d”. They're hidden: turn them on via “Set up grid” in the list menu, group “Prices and Availability”, then sort and filter by them.

    • The card and column figures are a summary for the last 30 days in your main Elbuz currency. It's recalculated after each nightly update.
    • No ads in 30 days — instead of figures the card says “This product was not advertised in Google Ads in the last 30 days (or is not matched to the feed yet).”
    • The block and columns are visible only to those with access to the “Google Ads” window, and only when at least one account is selected.

    Scenarios

    Ads lose money, but ROAS looks fine

    “Products” → click the “Profit after ads” header twice. Loss-making products are on top, usually with a low markup: they need a higher price, a lower bid or exclusion from the campaign.

    Different bids for leaders and dead weight

    Turn on the “Performance” label in the Google template and write the window's thresholds into it. In Google Ads, split the product group by this label: leader — higher bid, ballast — lower.

    Products with impressions but no clicks

    The “No clicks” segment → open the cards. Usually the price is higher than competitors', the photo is weak or the title has no model.

    FAQ

    Why isn't an advertised product in the table?

    It had no impressions in the selected period. Or it's there, but as a “Product not found” row — then compare g:id in the feed with the SKU.

    Are Search campaigns included in the report?

    No. Google reports by product only for Shopping and Performance Max; Search campaigns are shown in the “Campaigns” section.

    Which price is the markup based on?

    The product price in Elbuz, not the one in the feed: (price − purchase price) / price.

    Why are there no Google Ads columns in the product list?

    They're hidden by default — turn them on via “Set up grid”. If they aren't there either, you don't have access to the “Google Ads” window. If the columns are there but empty, no Google Ads account is selected in the window.

    Can I get the report in Excel?

    Yes, “Export CSV” downloads all products with the current filters, without the 500-row limit.

    Where to find it and who has access

    Menu
    Directories → Operations → Google Ads → “Products”
    Other entry points
    “Overview” → “Product segments”; product card → “Google Ads · 30 days”
    Access right
    the “Google Ads” window; to write thresholds to templates — also “Data export”
    Prepare
    product purchase prices, the SKU in the feed's g:id

    Related topics

    Was this article helpful?

    Missing a feature? Tell us.

    We will add it for free if other users need it too.

    If only you need it, we will agree on it separately.

    Article contents

    Suggest an improvement

    Try Elbuz free