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.
| Decision | Strong | Acceptable | Weak |
|---|---|---|---|
| --- | --- | --- | --- |
| Feed health analysis | Every product audited against all required and recommended attributes with specific errors listed per product | Category-level attribute compliance checked with sample products reviewed | Only checking disapproval count without diagnosing root causes |
| Title optimization | Keyword-enriched titles following category-specific templates with search volume data informing priority | Titles reviewed for completeness and basic keyword inclusion | Generic title advice without category-specific guidance or keyword research |
| Bidding strategy | Segment-specific ROAS targets with bid adjustments by device, audience, and product group | Portfolio-level ROAS target with basic campaign structure | Single ROAS target across all products with no segmentation |
| Query analysis | Search term report mined for negatives, query-product match quality scored, and converting queries identified | Top wasted spend queries identified and negated | No search term analysis or only reviewing top-level campaign metrics |
| Product grouping | Multi-level product groups by performance tier, margin, and category with differentiated bids | Product groups by category or brand with some bid differentiation | All products in a single ad group with uniform bids |
| Competitive analysis | Benchmark pricing, impression share, and click share against category competitors with positioning recommendations | Impression share reviewed with general competitive observations | No 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):
| Before | After |
|---|---|
| --- | --- |
| "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:
| Campaign | Products | ROAS Target | Daily Budget |
|---|---|---|---|
| --- | --- | --- | --- |
| Shopping — Top Performers | 25 SKUs (top 20% by profit) | 400% | $600 |
| Shopping — Core Catalog | 60 SKUs (middle tier) | 600% | $700 |
| Shopping — Long Tail | 35 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:
| Label | Values | Purpose |
|---|---|---|
| --- | --- | --- |
| custom_label_0 | margin_high / margin_mid / margin_low | Differentiate ROAS targets by profitability |
| custom_label_1 | perf_star / perf_core / perf_tail / perf_drain | Segment by historical performance |
| custom_label_2 | seasonal_spring / seasonal_summer / evergreen | Adjust bids for seasonal relevance |
| custom_label_3 | promo_active / promo_none | Boost bids during active promotions |
| custom_label_4 | new_launch / established | Different 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%.
共 2 个版本