Google Merchant Center Framework

v1.0.0

Google Merchant Center analysis and optimization framework. Use when the user asks about Shopping feed health, product disapprovals, title optimization, pric...

0· 106·0 current·0 all-time
byLuis Calderon@lac5q

Install

OpenClaw Prompt Flow

Install with OpenClaw

Best for remote or guided setup. Copy the exact prompt, then paste it into OpenClaw for lac5q/google-merchant-center-framework.

Previewing Install & Setup.
Prompt PreviewInstall & Setup
Install the skill "Google Merchant Center Framework" (lac5q/google-merchant-center-framework) from ClawHub.
Skill page: https://clawhub.ai/lac5q/google-merchant-center-framework
Keep the work scoped to this skill only.
After install, inspect the skill metadata and help me finish setup.
Use only the metadata you can verify from ClawHub; do not invent missing requirements.
Ask before making any broader environment changes.

Command Line

CLI Commands

Use the direct CLI path if you want to install manually and keep every step visible.

OpenClaw CLI

Bare skill slug

openclaw skills install google-merchant-center-framework

ClawHub CLI

Package manager switcher

npx clawhub@latest install google-merchant-center-framework
Security Scan
VirusTotalVirusTotal
Benign
View report →
OpenClawOpenClaw
Benign
high confidence
Purpose & Capability
The name/description (GMC analysis & optimization) matches the SKILL.md content: questions to collect context, diagnostic frameworks, scoring, and optimization guidance. There are no unrelated requested binaries, env vars, or config paths.
Instruction Scope
Runtime instructions are limited to collecting user-provided context, asking follow-ups, applying diagnostic frameworks, and recommending fixes. The doc notes optional live access via a Google Merchant Center connection but does not instruct the agent to read local files, environment variables, or send data to unexpected endpoints.
Install Mechanism
No install spec and no code files — this is instruction-only, so nothing is downloaded, written to disk, or executed by the skill itself.
Credentials
The skill declares no required environment variables, no primary credential, and no config paths. The Integration Note reasonably references using a Merchant Center connection for live data; that implies credentials would be supplied by whatever MCP integration the platform provides, but the skill itself does not request unrelated secrets.
Persistence & Privilege
always is false and there is no install behavior that modifies agent config or requests persistent presence. Normal autonomous invocation is allowed by platform defaults but the skill does not escalate privileges.
Assessment
This skill is an offline decision framework for Google Merchant Center and appears coherent. Before using it with live data, connect to your Merchant Center only via the platform's official OAuth/connector (do not paste long account credentials into chat). Prefer least-privilege access scopes, and avoid pasting full feeds or customer PII in chat; instead provide redacted exports or allow the platform connector to fetch data. If you intend the agent to act on your GMC account, verify which scopes/actions it will be granted and revoke access when finished.

Like a lobster shell, security has layers — review code before you run it.

latestvk977m0dat064gjcagb71e8bn5h83veqz
106downloads
0stars
1versions
Updated 1mo ago
v1.0.0
MIT-0

Google Merchant Center Framework

Diagnose feed health, optimize product listings, resolve disapprovals, analyze price competitiveness, and assess Shopping campaign readiness. A decision-framework for agents working with Google Merchant Center accounts of any size.

How This Skill Works

Step 1: Collect context from the user's message — merchant category, product count, known issues, goals (fix disapprovals, improve performance, launch Shopping ads, etc.).

Step 2: Ask one follow-up with all remaining questions using multiple-choice format. Key questions:

  • a) Account size: (1) <500 SKUs, (2) 500-10K, (3) 10K-100K, (4) 100K+
  • b) Primary goal: (1) Fix disapprovals, (2) Improve feed quality, (3) Boost Shopping performance, (4) Launch new campaign, (5) General audit
  • c) Feed method: (1) Direct API, (2) Scheduled fetch (XML/CSV), (3) Shopify/WooCommerce plugin, (4) Supplemental feeds, (5) Not sure
  • d) Current disapproval rate: (1) <2%, (2) 2-10%, (3) 10-25%, (4) >25%, (5) Unknown

Allow shorthand answers (e.g., "1a 2c 3b 4e").

Step 3: Analyze using the frameworks below. Prioritize by impact: disapprovals first (products not showing), then data quality (products showing poorly), then performance (products showing but underperforming).

Step 4: Deliver structured output with specific fixes, benchmarks, and priority order.

Integration Note

This skill works best when paired with a Google Merchant Center MCP for live data access. Without live data, the agent applies frameworks to data the user provides (exports, screenshots, descriptions of issues). With live data, the agent can pull product statuses, diagnostics, and price insights directly.


1. Feed Health Analysis

Health Score Framework

Calculate a feed health score from these weighted components:

ComponentWeightHow to Score
Approval rate30%100% approved = 100 pts. Deduct 2 pts per % disapproved
Required attribute completeness25%% of products with all required attrs filled
Recommended attribute completeness15%% of products with 8+ of 12 recommended attrs
Data freshness15%Updated <24h = 100, 24-48h = 70, 48-72h = 40, >72h = 0
Image quality15%% of products with compliant images (no watermarks, no placeholders, >100x100px)

Score interpretation:

  • 90-100: Excellent. Focus on performance optimization.
  • 75-89: Good. Fix remaining disapprovals and fill attribute gaps.
  • 50-74: Needs work. Systematic issues present. Prioritize disapprovals, then required attributes.
  • <50: Critical. Feed is substantially broken. Triage disapprovals by volume.

Required vs Recommended Attributes

Always required (all products):

  • id, title, description, link, image_link, availability, price

Required for most categories:

  • brand (required except for movies, books, musical recordings)
  • gtin (required for all products with a manufacturer-assigned GTIN)
  • condition (required if used or refurbished)

Conditionally required:

  • color, size, gender, age_group — required for Apparel & Accessories
  • item_group_id — required for product variants
  • shipping — required if not set at account level
  • tax — required in the US if not set at account level

High-impact recommended attributes:

  • additional_image_link (up to 10 images; products with 3+ images get ~15% higher CTR)
  • product_type (your own categorization; helps with campaign structure)
  • sale_price + sale_price_effective_date (triggers sale badge in Shopping)
  • custom_label_0 through custom_label_4 (essential for campaign segmentation)
  • product_highlight (up to 10 bullet points; shown in free listings)
  • product_detail (section_name + attribute_name + attribute_value tuples)

Diagnostic Priority Order

  1. Account-level suspensions — nothing shows until resolved
  2. Item-level disapprovals — products removed from serving
  3. Item-level warnings — products serve but with reduced visibility
  4. Missing required attributes — will become disapprovals
  5. Missing recommended attributes — reduces competitiveness
  6. Data quality issues — poor titles, descriptions, categorization

2. Product Optimization

Title Optimization

Titles are the single highest-impact attribute for Shopping performance. Google uses titles for query matching more heavily than descriptions.

Structure formula by category:

CategoryTitle FormulaExample
ApparelBrand + Gender + Product Type + Attributes (Color, Size, Material)"Nike Women's Air Max 270 Running Shoes - Black/White, Size 8"
ElectronicsBrand + Product Line + Model + Key Specs"Samsung Galaxy S24 Ultra 256GB Titanium Black Unlocked"
Home & GardenBrand + Product Type + Material + Key Dimensions + Color"KitchenAid Classic 4.5-Quart Tilt-Head Stand Mixer Onyx Black"
BeautyBrand + Product Line + Product Type + Size/Count + Variant"CeraVe Moisturizing Cream Face and Body 19oz Fragrance-Free"
GroceryBrand + Product Name + Flavor/Variant + Size/Count + Pack"KIND Bars Dark Chocolate Nuts & Sea Salt 12-Count Box"

Title rules:

  • Max 150 characters; first 70 characters are most critical (truncation in mobile)
  • Front-load the most important keywords in the first 70 characters
  • Never use ALL CAPS or promotional text ("Free Shipping", "Best Price")
  • Include color, size, material when relevant — these are matching signals
  • Use the actual brand name, not abbreviations
  • Separate attributes with hyphens or commas, not pipes

Title quality scoring:

SignalPoints
Brand name present and correct+20
Product type keyword included+20
Key differentiating attribute (color/size/material)+15 each, max +30
Within 70-character sweet spot+15
No promotional language+15
Total possible100

Description Optimization

  • 1,000-5,000 characters optimal (minimum 500)
  • First 150-200 characters most critical (may be shown in free listings)
  • Include keywords naturally — Google does use descriptions for matching, but less than titles
  • Include specifications, materials, dimensions, use cases
  • No HTML tags (stripped by Google), no promotional language, no links

Image Requirements

RequirementStandardNotes
Minimum resolution100x100px (250x250 for apparel)800x800+ recommended for zoom
Max file size16MB
FormatJPEG, PNG, GIF, BMP, TIFF, WebP
BackgroundWhite or transparent preferredNon-white OK but clean background required
WatermarksNot allowedAutomatic disapproval
Text overlayNot allowed on main imageOK on additional images
Promotional overlayNot allowed"Sale", "Free shipping" overlays = disapproval
Product visibilityProduct must fill 75-90% of frameNo tiny product in large frame

Image optimization checklist:

  • Main image: product only, white background, high resolution
  • 3+ additional images (lifestyle, different angles, scale/size reference)
  • Apparel: show product on a person or flat-lay (not hanger)
  • Consistent image style across product line

GTIN/MPN Completeness

  • GTIN is critical. Products with valid GTINs get ~20% more impressions than those without.
  • Google cross-references GTINs against the GS1 database. Invalid GTINs cause disapprovals.
  • If a product genuinely has no GTIN (custom, handmade, vintage, parts), set identifier_exists to no.
  • Never fabricate GTINs. Never reuse GTINs across different products.
  • MPN is required when GTIN is not available and the product has a manufacturer part number.

3. Price Competitiveness

Interpreting Price Benchmarks

Google provides price benchmarks in the Price Competitiveness report. Key metrics:

MetricWhat It MeansAction Threshold
benchmark_priceMedian price of the same product from other merchantsIf your price >15% above: expect significantly lower CTR
price_difference_percentageYour price vs benchmark>10% above: review pricing. >20% above: likely suppressed
country_codeMarket the benchmark applies toCompare only within same market

Competitive Visibility Score Framework

PositionYour Price vs BenchmarkExpected Impact
Strong>10% below benchmarkHigh impressions, high CTR. Verify margin is acceptable.
CompetitiveWithin +/-10% of benchmarkNormal serving. Optimize other signals.
Weak10-20% above benchmarkReduced impressions. Consider sale_price or promotions.
Uncompetitive>20% above benchmarkSeverely reduced serving. Re-evaluate pricing or exclude from Shopping.

Price Strategy Decisions

When price is too high vs benchmark:

  1. Can you lower the price? Do it.
  2. Can you add a promotion or sale_price? Triggers sale badge, improves CTR even if final price is still above benchmark.
  3. Can you differentiate on value (bundle, warranty, fast shipping)? Add to title and description.
  4. Is the product a loss leader for competitors? Consider excluding from Shopping.
  5. Use custom_label to segment high-priced items into separate campaigns with different ROAS targets.

Price-Landing Page Match — #1 cause of avoidable disapprovals:

  • Price shown on page must match price attribute exactly (including currency)
  • sale_price must match the visible sale price on the landing page
  • If microdata/structured data on the page differs from the feed, the feed value may be overridden or flagged

4. Performance Analysis

Shopping Performance Benchmarks by Category

CategoryMedian CTRGood CTRMedian CPC (Shopping Ads)Median Conv. Rate
Apparel & Accessories1.2%>2.0%$0.40-0.701.5-2.5%
Electronics0.8%>1.5%$0.50-1.001.0-2.0%
Home & Garden1.0%>1.8%$0.35-0.651.5-3.0%
Health & Beauty1.5%>2.5%$0.30-0.552.0-3.5%
Grocery & Food1.8%>3.0%$0.20-0.402.5-4.0%
Toys & Games1.3%>2.2%$0.25-0.502.0-3.5%
Sports & Outdoors1.0%>1.7%$0.35-0.651.5-2.5%
Auto Parts0.7%>1.2%$0.40-0.801.0-2.0%

Performance Diagnostic Tree

Low impressions:

  1. Check disapprovals — products not serving at all?
  2. Check price competitiveness — priced out of auctions?
  3. Check title relevance — titles match search queries?
  4. Check bid/budget (paid) — budget exhausting before end of day?
  5. Check product ratings — competitors with ratings outranking you?

Low CTR (impressions OK):

  1. Image quality — compelling vs generic?
  2. Title quality — informative vs vague?
  3. Price position — higher than competitors in same carousel?
  4. Sale badge — competitors showing sales, you are not?
  5. Shipping speed/cost — competitors showing "Free delivery" and you are not?

Low conversion rate (clicks OK):

  1. Landing page match — does the page show what the listing promised?
  2. Landing page speed — >3 seconds load time loses ~50% of mobile users
  3. Price on landing page — any surprise fees or shipping costs?
  4. Mobile experience — is the landing page mobile-optimized?
  5. Availability — "Add to cart" immediately visible?

Key Metrics to Track Weekly

MetricRed Flag
Disapproval rate>5% or increasing trend
Impression share (paid)<50% in target categories
CTRBelow category median
Click-to-conversion rate<1% for most categories
Price competitiveness %>30% of products uncompetitive

5. Disapproval Workflows

Top 10 Disapproval Reasons and Fix Paths

#ReasonCauseFixTimeline
1MisrepresentationMisleading claims, missing business infoRemove superlatives, add return policy, add About Us page3-7 days, may need manual review
2Price MismatchFeed price ≠ landing page priceSync feed price to page exactly; check currency24-72h re-crawl
3Availability MismatchFeed says in stock, page says out of stockSync inventory feed; increase update frequencyNext crawl
4Missing GTINHas manufacturer GTIN but not in feedAdd GTIN or set identifier_exists: noImmediate on next processing
5Image OverlayWatermarks, promo text on main imageReplace with clean product image24-72h re-crawl
6Landing Page Error404/500 errors, geo-blocking GooglebotFix URLs; unblock GooglebotNext crawl
7Insufficient Product DataTitle/description too short or genericTitle >30 chars with brand+type; description >500 charsImmediate
8Missing Shipping WeightCarrier-calculated rates but no weight in feedAdd shipping_weight or switch to flat-rateImmediate
9Restricted ProductRegulated category without verificationVerify compliance; apply for merchant verification if requiredVaries
10Duplicate Item IDSame ID reused for different productsAssign unique, stable IDs per variantImmediate

Disapproval Triage Matrix

VolumeSame Reason?Action
>100 productsYesSystematic root cause — fix feed template or feed rule, not individual items
>100 productsNoGroup by reason, fix highest-volume first
10-100 productsFix in bulk via supplemental feed or feed rules
<10 productsFix individually; watch for pattern

Appeal Process

  1. Fix the issue first. Never appeal without fixing.
  2. Wait 24-72 hours for automatic re-crawl.
  3. If not resolved: Request manual review (Diagnostics > Item Issues > Request Review).
  4. One appeal at a time. 7-day cooldown applies for repeated policy violations.

6. Feed Management

Feed Method Decision Tree

Platform has native GMC integration (Shopify, WooCommerce)?
  YES → Use platform plugin as primary feed
        Need to override attributes the plugin doesn't support?
          YES → Add supplemental feed for overrides
          NO  → Plugin-only is sufficient
  NO  → Have developer resources?
        YES → Content API (real-time; best for >10K SKUs or fast inventory)
        NO  → Scheduled fetch (XML/CSV hosted on your server; update at least daily)

Feed Types

Feed TypeUse CaseUpdate Frequency
Primary feedAll products, all required attributesDaily minimum; every 6h for fast-moving inventory
Supplemental feedOverride/add attributes without touching primaryAs needed
Feed rulesTransform data at processing time (regex, lookups)Applied every processing run
Content APIReal-time individual product updatesReal-time; 100K requests/day limit
Automated feedsGoogle crawls your siteGoogle's schedule (not your control)

Supplemental Feed Strategy

Use supplemental feeds for:

  • Custom labels — campaign segmentation (margin tiers, seasonality, priority)
  • Title A/B testing — optimized titles without touching your CMS
  • Missing GTINs — lookup table mapped to product IDs
  • Promotion IDs — linking products to active promotions
  • Seasonal overrides — holiday titles, temporary attribute changes

Supplemental feeds match on id — must exactly match the primary feed id.


7. Shopping Campaign Readiness

Pre-Launch Checklist

CheckRequirement
Feed health score>80 (Section 1 framework)
Disapproval rate<5% of active products
Price competitiveness>60% of products within +10% of benchmark
Landing page speed<3 seconds, mobile-friendly
Conversion trackingGoogle Ads tag firing, revenue tracking verified
Shipping infoAccurate in feed or account settings

Standard Shopping vs Performance Max

FactorStandard ShoppingPerformance Max
Query controlHigh (negatives, search term reports)Low (limited insights)
BiddingManual CPC or Target ROASAutomated only
Best forTight ROAS targets, query-level strategyBroad reach, new advertisers, >30 conv/month
Min daily budget$5-10/day viable$50-100/day recommended
Ramp-upImmediate2-4 week learning phase

Custom Label Strategy

SlotUseExample Values
custom_label_0Margin tierhigh_margin, medium_margin, low_margin
custom_label_1Product priorityhero, standard, long_tail
custom_label_2Seasonalityevergreen, summer, holiday, clearance
custom_label_3Price rangeunder_25, 25_to_100, over_100
custom_label_4Performance tiertop_seller, average, underperformer, new

ROAS Targets by Category (Starting Points)

CategoryConservative ROASAggressive ROAS
Apparel400-600%200-300%
Electronics600-800%300-500%
Home & Garden400-600%200-400%
Health & Beauty300-500%150-300%
Grocery200-400%100-200%

Output Format

  • Start with a Feed Health Score (0-100) and top-line summary
  • Group findings into: Critical (disapprovals, policy) → High (data quality, price) → Medium (optimization) → Low (nice-to-have)
  • Include specific product counts and percentages per issue
  • Provide exact fix instructions, not general advice
  • Mark estimates with ⚠️ when based on incomplete data
  • End with a prioritized action plan (numbered, with effort: 5min / 30min / 2hrs / half-day)
  • Include a 7-day and 30-day check-in plan

Comments

Loading comments...