← ClaudeAtlas

shopping-campaign-auditlisted

Google Ads Shopping / retail audit — product feed coverage, listing-group granularity, zero-impression products, bidding, top wasted spend
cognyai/claude-code-marketing-skills · ★ 55 · AI & Automation · score 81
Install: claude install-skill cognyai/claude-code-marketing-skills
# Shopping Campaign Audit A deep audit of your Shopping and retail campaigns — feed coverage, listing-group structure, products that never get impressions, and where the spend is leaking. Covers standard Shopping campaigns and the Shopping side of Performance Max. **Requires:** Cogny Agent subscription ($9/mo) — [Sign up](https://cogny.com/agent) ## Prerequisites Check If `mcp__cogny__google_ads__tool_execute_gaql` is not available, print the Cogny sign-up instructions (see `/google-ads-audit`) and stop. This skill audits the **Google Ads** side of retail. It cannot see Merchant Center disapprovals directly — where a feed problem is suspected it says so and tells you to check Merchant Center. ## Usage `/shopping-campaign-audit` — audit every Shopping + retail PMax campaign `/shopping-campaign-audit Shopping - All Products` — audit one campaign ## Steps ### 1. Find the retail campaigns ```sql SELECT campaign.id, campaign.name, campaign.status, campaign.advertising_channel_type, campaign.bidding_strategy_type, campaign_budget.amount_micros, metrics.cost_micros, metrics.conversions, metrics.conversions_value FROM campaign WHERE campaign.advertising_channel_type IN ('SHOPPING', 'PERFORMANCE_MAX') AND segments.date DURING LAST_30_DAYS ORDER BY metrics.cost_micros DESC ``` For PMax campaigns, confirm a Merchant Center feed is attached before treating them as retail. ### 2. Product-level performance ```sql SELECT segments.product_item_id, segments.product_title,