From metaflow-marketing-skills
Optimizes Google Merchant Center product feeds for Shopping and Performance Max campaigns, from resolving disapprovals to building custom label strategies for profitability-based bidding.
How this skill is triggered — by the user, by Claude, or both
Slash command
/metaflow-marketing-skills:google-merchant-centerThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
**For feed audits:**
For feed audits:
For new feed setup:
Fix in this order — each level has decreasing marginal impact:
| Priority | Attribute | Impact on Performance | Why |
|---|---|---|---|
| 1 | Title | Highest | Determines which queries match your products. Title = your keyword strategy for Shopping |
| 2 | Image | Very High | Primary visual in Shopping results. White background, high resolution, no watermarks |
| 3 | Price | High | Competitive pricing directly affects CTR and conversion rate |
| 4 | Description | Medium | Supports query matching and product understanding |
| 5 | GTIN/MPN/Brand | Medium | Required for unique product identification. Missing = limited serving |
| 6 | Product type / Category | Medium | Helps Google classify correctly. Use detailed paths |
| 7 | Availability | Foundational | Must be accurate — mismatches cause disapprovals |
| 8 | Custom labels | Strategic | Enables performance-based bidding tiers |
Titles are the single most impactful feed attribute. They function as keywords for Shopping ads.
Formula: Brand + Product Type + Key Attributes (material, size, color, gender, model)
By vertical:
| Vertical | Title Formula | Example |
|---|---|---|
| Apparel | Brand + Gender + Product Type + Color + Size + Material | "Nike Men's Running Shoes Black Size 11 Flyknit" |
| Electronics | Brand + Product + Model + Key Spec + Variant | "Samsung Galaxy S24 Ultra 256GB Titanium Black" |
| Home & Garden | Brand + Product Type + Material + Dimensions + Color | "KitchenAid Stand Mixer 5-Quart Stainless Steel Red" |
| Beauty | Brand + Product Line + Product Type + Size + Variant | "CeraVe Moisturizing Cream 19oz Fragrance-Free" |
| B2B / Industrial | Brand + Product Type + Specification + Application | "3M Safety Glasses Anti-Fog ANSI Z87.1 Construction" |
Title rules:
| Disapproval | Cause | Fix |
|---|---|---|
| Missing GTIN | No GTIN for manufactured products | Add valid UPC/EAN/JAN. If custom/handmade, set identifier_exists: no |
| Price mismatch | Feed price ≠ landing page price | Sync feed update frequency. Use real-time API for dynamic pricing |
| Availability mismatch | Feed says "in stock" but page shows "out of stock" | Increase feed refresh frequency (minimum daily, ideally every 6 hours) |
| Missing shipping info | No shipping configured | Set up shipping in Merchant Center settings or at product level |
| Image quality | Watermarks, promotional text, too small | Use clean product images, minimum 800x800px, no overlays |
| Landing page not crawlable | Googlebot can't access the page | Check robots.txt, ensure no noindex on product pages |
| Misrepresentation | Unrealistic claims, unclear business info | Review product descriptions and business identity settings |
| Adult content | Products flagged for adult classification | Add adult: yes attribute or appeal if incorrectly flagged |
Priority Fixes tab workflow:
Custom labels (0-4) let you segment products for bidding strategies in Shopping and PMax. Five labels available.
Recommended label assignment:
| Label | Dimension | Values | Purpose |
|---|---|---|---|
| Custom Label 0 | Margin tier | high_margin, medium_margin, low_margin | Bid more aggressively on high-margin products |
| Custom Label 1 | Performance tier | best_seller, rising, standard, underperformer | Based on last 30-90 day ROAS/conversion data |
| Custom Label 2 | Seasonality | evergreen, spring, summer, fall, winter, holiday | Adjust bids and budgets by season |
| Custom Label 3 | Price range | premium (>$200), mid ($50-200), budget (<$50) | Different bid strategies by price point |
| Custom Label 4 | Inventory status | full_stock, low_stock, clearance, new_arrival | Promote clearance, protect low stock |
How to use custom labels in campaigns:
underperformer + low_margin combinationsbest_seller + high_margin products with higher budgetsProfitability-based bidding (POAS > ROAS):
Supplemental feeds enrich your primary feed without replacing it. Changes in the supplemental feed override matching attributes in the primary feed.
| Use Case | What to Add | Method |
|---|---|---|
| Custom label assignment | Custom labels 0-4 | Google Sheets supplemental feed (easiest) |
| Title testing | Optimized titles overriding primary feed titles | Google Sheets → update titles → measure impact |
| Promotional data | sale_price, sale_price_effective_date | Scheduled feed or Sheets |
| Missing attributes | GTINs, product types, additional descriptions | Sheets or file feed |
| Seasonal adjustments | Update custom labels for seasonal products | Sheets updated monthly/quarterly |
Setup: Merchant Center → Products → Feeds → Supplemental feeds → Add. Match on id attribute. Google Sheets is the fastest method for non-technical teams.
Feed rules transform data during processing without changing the source feed.
Common feed rules:
| Rule | What It Does | Example |
|---|---|---|
| Set to | Override an attribute with a fixed value | Set shipping_weight to "2 lb" for all products |
| Extract | Pull data from one attribute into another | Extract brand name from title → brand field |
| Prepend/Append | Add text to existing values | Prepend brand name to all titles |
| Find & Replace | Modify specific text within attributes | Replace "cm" with "inches" in descriptions |
| Calculate | Compute values from other fields | sale_price = price × 0.8 |
| Conditional | Apply rules only when conditions are met | If brand = "Nike", set custom_label_0 = "premium" |
For feed audits:
## Merchant Center Feed Audit
### Feed Health Summary
- Total products: [X]
- Active: [X] ([%])
- Disapproved: [X] ([%])
- Pending: [X] ([%])
### Priority Fixes (by click uplift potential)
| Issue | Products Affected | Est. Click Uplift | Fix |
|-------|------------------|-------------------|-----|
| [issue] | [N] | [+X%] | [specific fix] |
### Title Optimization Opportunities
| Current Title | Optimized Title | Changes Made |
|--------------|----------------|--------------|
| [before] | [after] | [added brand, reordered attributes] |
### Custom Label Strategy
| Label | Dimension | Values | Products per Value |
|-------|-----------|--------|--------------------|
| 0 | Margin tier | high/medium/low | [X] / [X] / [X] |
### Feed Maintenance Plan
- Feed refresh frequency: [recommendation]
- Supplemental feed setup: [yes/no, what for]
- Review cadence: [weekly/monthly]
Input: "I have 2,400 products in Merchant Center. 180 are disapproved and my Shopping campaigns are underperforming. Help me fix the feed and set up a smart bidding structure."
Output:
| Issue | Products Affected | Est. Click Uplift | Fix |
|---|---|---|---|
| Missing GTIN | 95 products | +12-18% clicks | Add valid UPCs. For handmade/custom items, set identifier_exists: no |
| Price mismatch | 42 products | +8-12% clicks | Increase feed refresh to every 6 hours (currently daily) |
| Image quality (watermarks) | 28 products | +5-8% clicks | Replace with clean product photos, no text overlays |
| Missing shipping | 15 products | +3-5% clicks | Configure shipping in MC settings for all products |
| Current Title | Optimized Title | Changes |
|---|---|---|
| "Blue Running Shoes" | "Nike Air Zoom Pegasus 41 Men's Running Shoes Blue Size 11" | Added brand, model, gender, size |
| "Wireless Earbuds" | "Sony WF-1000XM5 Wireless Earbuds Noise Cancelling Black" | Added brand, model, key feature, color |
| "Coffee Maker" | "Breville Barista Express Espresso Machine Stainless Steel" | Added brand, product line, material |
| Label | Dimension | Values | Products | Bid Strategy |
|---|---|---|---|---|
| 0 | Margin | high (>60%), medium (30-60%), low (<30%) | 480 / 1,200 / 720 | tROAS 300% / 500% / 800% |
| 1 | Performance | best_seller, rising, standard, underperformer | 240 / 360 / 1,200 / 600 | Max budget / Growing budget / Standard / Reduced |
| 2 | Seasonality | evergreen, seasonal | 1,800 / 600 | Stable year-round / Ramp up in season |
| 3 | Price range | premium (>$200), mid ($50-200), budget (<$50) | 300 / 1,100 / 1,000 | Lower tROAS OK / Balanced / Needs volume |
| 4 | Inventory | full_stock, low_stock, clearance | 1,800 / 400 / 200 | Standard / Cap spend / Promote aggressively |
npx claudepluginhub narayan-metaflow/metaflow-marketing-skills --plugin metaflow-marketing-skillsCreates, edits, and optimizes skills for Claude Code, including drafting, evaluating with test prompts, iterating on performance, and improving skill descriptions for better triggering accuracy.