shopping-campaign-auditlisted
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,