Shopping Duplicate Product Targets
Finds products served by multiple Shopping campaigns at the same priority — the internal competition that silently breaks brand/non-brand splits and hands control of bids to Ad Rank instead of you.
by Frederick Vallaeys (concept), chiliad (rewrite)·chiliad.io
Overview
Shopping Duplicate Product Targets scans the shopping performance data for the chosen window and flags every product that actually served impressions from two or more Shopping campaigns set to the same campaign priority. Same-priority overlap means Google decides which campaign serves by Ad Rank — your intended split of budgets, bids and negatives no longer applies to that product. Intentional waterfall setups (same product in high/medium/low priority campaigns) are not flagged.
Setup
- 1Open your Google Ads account and go to Tools → Bulk Actions → Scripts.
- 2Click the + button to create a new script and paste the code below.
- 3Set MIN_COST to skip trivial overlaps; raise TOP_N if you want the full list.
- 4Set EMAIL_ADDRESS to receive the report; leave blank for logs only.
- 5Preview once to verify, then schedule weekly.
Configuration Variables
| Variable | Default |
|---|---|
DATE_RANGE | LAST_30_DAYS |
MIN_COST | 1 |
TOP_N | 50 |
EMAIL_ADDRESS | (empty) |
Expected Output
Scanned 8412 product/campaign rows (LAST_30_DAYS). === Products served by multiple same-priority Shopping campaigns === Products analyzed: 1240 With overlap: 2 Item 8712345 total cost: 84.10 clicks: 112 - Shopping — Bestsellers (priority 1) cost: 61.20 - Shopping — All Products (priority 1) cost: 22.90 Item 8767890 total cost: 42.75 clicks: 58 - Shopping — Brand (priority 0) cost: 30.15 - Shopping — All Products (priority 0) cost: 12.60 Email sent to you@example.com
Notes
Detection is based on products that actually served, so a structural overlap with zero traffic in the window won't appear — run monthly with LAST_90_DAYS for a deeper sweep. Performance Max campaigns don't have priorities and are outside this check (PMax always outranks standard Shopping for the same product).