google-ads-pmax-retail-optimizer

PMax Retail Optimizer

Specific optimizations for Performance Max campaigns with product feeds (PMax Retail). Focused on e-commerce accounts using Merchant Center feeds.

Quick Diagnostic

PMAX RETAIL HEALTH CHECK
==========================

1. Zombie Products?
   -> >20% products without impressions (30d) --> ACTION NEEDED

2. Listing Group Filters set?
   -> Only UNIT_INCLUDED (all) --> SUBOPTIMAL

3. Custom Labels active in feed?
   -> No custom labels --> OPPORTUNITY MISSED

4. Asset group spend distribution?
   -> >60% budget to 1 asset group --> REBALANCE

5. Product ROAS spread?
   -> Top 20% products = 80% revenue --> SEGMENT

1. Zombie Inventory Detection

Data Retrieval

Zombie products = products with 0 impressions in the last 30 days.

-- Products WITH impressions (active products)
SELECT segments.product_title, segments.product_brand,
    segments.product_type_l1, segments.product_item_id,
    metrics.impressions, metrics.clicks,
    metrics.cost_micros, metrics.conversions
FROM shopping_performance_view
WHERE segments.date DURING LAST_30_DAYS
ORDER BY metrics.impressions ASC
LIMIT 100

-- Total shopping performance (for zombie % calculation)
SELECT segments.product_title, metrics.impressions,
    metrics.clicks, metrics.cost_micros
FROM shopping_performance_view
WHERE segments.date DURING LAST_30_DAYS
AND metrics.impressions = 0
LIMIT 200

Zombie Analysis Framework

ZOMBIE PRODUCT CLASSIFICATION
==============================

TYPE 1: Feed Quality Zombies
+-- Cause: Disapprovals, poor data quality
+-- Detection: Products with warnings/disapprovals in MC
+-- Solution: Fix feed issues (title, image, price)
+-- Impact: High -- these products CANNOT run

TYPE 2: Competition Zombies
+-- Cause: Too much competition, bids too low
+-- Detection: Product exists in feed, no disapprovals, 0 impressions
+-- Solution: Higher bids OR separate asset group with more budget
+-- Impact: Medium -- bid increase can help

TYPE 3: Low Demand Zombies
+-- Cause: Little search volume for this product
+-- Detection: Niche product, few search terms
+-- Solution: Accept OR improve titles with more popular terms
+-- Impact: Low -- sometimes there's just no demand

TYPE 4: Structural Zombies
+-- Cause: Product not in active listing group filter
+-- Detection: Product in feed but outside asset group scope
+-- Solution: Expand listing group filters
+-- Impact: High -- configuration error