Analyze Google Merchant Center product data, diagnose feed quality issues, optimize bidding strategies, and generate actionable plans that increase impressions, clicks, and conversions while reducing wasted ad spend. This skill transforms raw Merchant Center diagnostics, Shopping campaign reports, and product feed exports into a structured optimization plan covering feed health, product data quality, competitive positioning, bidding efficiency, and campaign structure. It identifies the specific issues suppressing performance — disapprovals, missing attributes, poor titles, inefficient bids, wasted spend on non-converting queries — and produces prioritized fixes with projected impact estimates.
DecisionStrongAcceptableWeakFeed health analysisEvery product audited against all required and recommended attributes with specific errors listed per productCategory-level attribute compliance checked with sample products reviewedOnly checking disapproval count without diagnosing root causesTitle optimizationKeyword-enriched titles following category-specific templates with search volume data informing priorityTitles reviewed for completeness and basic keyword inclusionGeneric title advice without category-specific guidance or keyword researchBidding strategySegment-specific ROAS targets with bid adjustments by device, audience, and product groupPortfolio-level ROAS target with basic campaign structureSingle ROAS target across all products with no segmentationQuery analysisSearch term report mined for negatives, query-product match quality scored, and converting queries identifiedTop wasted spend queries identified and negatedNo search term analysis or only reviewing top-level campaign metricsProduct groupingMulti-level product groups by performance tier, margin, and category with differentiated bidsProduct groups by category or brand with some bid differentiationAll products in a single ad group with uniform bidsCompetitive analysisBenchmark pricing, impression share, and click share against category competitors with positioning recommendationsImpression share reviewed with general competitive observationsNo competitive data analyzed
Export the full product feed from Merchant Center or your feed management tool. For each product, verify all required attributes are present and correctly formatted: id, title, description, link, image_link, availability, price, brand, gtin/mpn, condition, and product_type. Check recommended attributes: additional_image_link, sale_price, google_product_category, custom_labels, shipping, and tax. Flag every disapproved or warned product with the specific error code and root cause. Categorize issues by type: policy violations, data quality errors (missing attributes, incorrect formatting), image issues, pricing mismatches between feed and landing page, and availability mismatches.
Analyze current titles against category-specific best practices. Effective Shopping titles front-load the most important attributes in order: brand + product type + key attributes (size, color, material, model). Research top-performing search queries in the category using Search Terms reports and keyword tools. Rewrite titles to include high-volume, relevant search terms while staying within the 150-character limit (first 70 characters are most critical as they display in ads). For descriptions, ensure the first 160 characters contain the primary value proposition and key specifications since this portion may display in free listings.
Pull the Search Terms report for the past 30–90 days. Identify wasted spend: queries with significant spend but zero conversions, queries with ROAS below the break-even threshold, and queries that are irrelevant to the products being shown. Build negative keyword lists at the campaign and ad group level. Identify high-performing converting queries and ensure the matching products have optimized titles and competitive pricing. Calculate the query-to-product match quality — are the right products showing for the right searches?
Evaluate the current campaign structure against best practices. Recommend a tiered structure: (1) High-priority campaign with higher bids for top-performing products (high margin, high conversion rate, strong ROAS). (2) Medium-priority campaign for products with moderate performance. (3) Catch-all campaign with lower bids for remaining products and new/untested items. Within each campaign, create product groups segmented by category, brand, or custom label to enable granular bid management. Set up custom labels in the feed to tag products by margin tier, performance tier, seasonality, and promotion status.
For Smart Shopping / Performance Max campaigns: set segment-specific ROAS targets based on product margin and conversion data — high-margin products can accept lower ROAS, low-margin products need higher ROAS to remain profitable. For manual CPC or Enhanced CPC: set bids based on the value-per-click calculation (average order value × conversion rate × target margin). Apply bid adjustments by device (mobile vs. desktop conversion rate differences), audience (remarketing lists, customer match), and time of day/day of week based on conversion pattern data. Calculate the breakeven CPC for each product group.
Pull the Merchant Center competitive visibility report and the Auction Insights (if available through linked Google Ads). Identify products where you have low impression share despite competitive pricing — these likely have feed quality issues. Identify products where competitors consistently win on price — evaluate whether to compete on price, differentiate on other attributes, or reduce bids to maintain profitability. For products with strong reviews and ratings, ensure seller ratings and product ratings extensions are enabled to improve click-through rates.
Prioritize all identified improvements by projected impact and implementation effort. Create a phased execution plan: Phase 1 (Week 1) — Fix all disapprovals and critical feed errors. Phase 2 (Weeks 2–3) — Implement title optimizations and negative keyword lists. Phase 3 (Weeks 3–4) — Restructure campaigns and adjust bids. Phase 4 (Ongoing) — Monitor performance, refine bids, and iterate on feed quality. Define KPIs and tracking cadence: daily (spend, ROAS), weekly (impression share, CTR, conversion rate, disapproval count), monthly (revenue, profit, feed score).
Input data: Google Merchant Center export with 120 active products, Shopping campaign reports for 90 days, Search Terms report, and competitive visibility data.
Feed audit findings:
google_product_category — defaulting to algorithm classification (lower match quality)additional_image_link — missing lifestyle images that improve CTRTitle optimization (sample):
BeforeAfter"Cedar Planter Box""Cedar Raised Garden Planter Box - Outdoor Elevated Wood Bed 4x2ft""Solar Path Lights""Solar Pathway Lights Outdoor LED - Waterproof Garden Walkway 8-Pack""Patio Umbrella""9ft Patio Umbrella with Tilt & Crank - Outdoor Market Table Umbrella Navy"
Search query analysis (90 days):
Campaign restructure:
CampaignProductsROAS TargetDaily BudgetShopping — Top Performers25 SKUs (top 20% by profit)400%$600Shopping — Core Catalog60 SKUs (middle tier)600%$700Shopping — Long Tail35 SKUs (new + low volume)300%$200
Projected impact: Fixing disapprovals restores $3,800/mo in lost revenue. Title optimization projects +15–25% CTR improvement. Negative keyword cleanup saves $4,200/mo in wasted spend. Campaign restructure projects +18% overall ROAS improvement. Combined 90-day projection: +$28,000 incremental revenue, ROAS improvement from 380% to 520%.
Input data: Merchant Center feed with 450 products across 6 apparel categories, Performance Max campaign data for 60 days, supplemental feed for promotions, and Google Ads auction insights.
Feed audit findings:
color attribute — critical for apparel discovery and filteringsize attribute — prevents showing in size-filtered searchesproduct_type taxonomy inconsistent — 14 different naming conventions for the same categoryproduct_highlight or product_detail attributes — missing structured specification dataBidding analysis:
Custom label strategy:
LabelValuesPurposecustom_label_0margin_high / margin_mid / margin_lowDifferentiate ROAS targets by profitabilitycustom_label_1perf_star / perf_core / perf_tail / perf_drainSegment by historical performancecustom_label_2seasonal_spring / seasonal_summer / evergreenAdjust bids for seasonal relevancecustom_label_3promo_active / promo_noneBoost bids during active promotionscustom_label_4new_launch / establishedDifferent bidding strategy for new vs. proven products
Projected impact: Fixing disapprovals restores $12,500/mo in lost revenue. Attribute completeness improvements project +20% impression share. Bidding restructure with performance tiering projects ROAS improvement from 320% to 485%. Eliminating spend on bottom-tier drains saves $33,600/mo in wasted budget. Combined 90-day projection: +$95,000 incremental revenue, blended ROAS improvement from 320% to 510%.
Ignoring feed quality and focusing only on bids: No amount of bid optimization can fix a feed with missing attributes, disapproved products, and thin titles. Feed quality is the foundation — without it, products either don't show at all or show for the wrong queries. Always fix feed issues before touching bids.
Writing titles for humans instead of algorithms: Shopping ad titles serve double duty — they're the primary signal Google uses for query matching AND the text shoppers see. Front-load high-volume search keywords rather than writing creative marketing copy. "Cedar Raised Garden Planter Box - Outdoor Elevated Bed 4x2ft" outperforms "The Beautiful Cedar Box for Your Garden" because it matches more purchase-intent queries.
Bidding uniformly across all products: A single ROAS target treats a $100 product with 60% margins the same as a $15 product with 20% margins. Segment products by margin and performance to set appropriate targets — high-margin winners deserve more aggressive bids while low-margin, low-conversion products should be bid down or excluded.
Never reviewing the Search Terms report: The Search Terms report reveals exactly which queries trigger your ads and how they perform. Without regular review, you accumulate wasted spend on irrelevant queries (informational searches, competitor brand names you can't compete on, wrong product matches) that silently erode ROAS.
Using only required attributes and skipping recommended ones: Required attributes get your products listed; recommended attributes make them competitive. Products with complete attributes — additional images, sale prices, product highlights, shipping details — receive higher quality scores and better ad placement than bare-minimum listings.
Not setting up custom labels: Without custom labels, you can't segment product groups by business-relevant dimensions like margin tier or performance category. This forces uniform bidding and prevents the granular campaign structure that separates high-ROAS advertisers from average ones.
Ignoring mobile performance differences: Mobile and desktop Shopping campaigns often have dramatically different conversion rates and ROAS. If mobile converts at half the rate of desktop but you bid identically, you're overspending on mobile clicks. Apply device bid adjustments or create device-specific campaigns.
Setting and forgetting Performance Max campaigns: Performance Max automates many decisions but still requires active management — audience signals, asset groups, feed quality, and ROAS targets all need regular review. "Automated" doesn't mean "unmanaged."