Product feed health checker

The score starts at 100 and loses points for each problem in proportion to its share of the feed. Every point of disapproved products costs 1.2, every point of price mismatch costs 1.0, every point of missing GTINs costs 0.6 and every point of weak titles costs 0.4. With 5 percent disapproved, 3 percent mismatched, 10 percent missing GTINs and 30 percent weak titles, the deductions are 6, 3, 6 and 12, leaving a score of 73. The score cannot go below zero. Eligible products is the feed size minus the disapproved share, because a disapproved product cannot serve no matter how good its title is.

The third output is a simple rule. If the disapproved share is at least as large as the missing GTIN share, it shows 1 and you should clear the disapprovals first, because each one is a product that is invisible today. Otherwise it shows 2 and the GTIN gap is the larger problem, since products without a required identifier get limited or no exposure and may be disapproved later. Price mismatches are not in the rule because they should be fixed the day they appear regardless of scale. Each one is a live risk to the account, not just to the product, and the fix is usually a feed refresh schedule or a currency and tax setting rather than a product edit.

The feed is the raw material for every Shopping and Performance Max impression, so its condition sets the ceiling on the visitors lever from paid search. Disapprovals and mismatches remove products from the auction. Missing GTINs reduce how often the remaining products are matched to searches. Weak titles let products serve but for the wrong queries, which spends budget on clicks that do not convert. A feed at 73 is leaving a quarter of its potential on the table before a single bid is set. Fix the feed and the same budget buys more relevant clicks, which also lifts the conversion rate of the traffic that arrives.