Performance Max Brand Cannibalisation & Search Theme Auditor
Google conceals granular search queries inside Performance Max. By default, the algorithm frequently bids aggressively on your existing brand terms, inflating cosmetic ROAS while cannibalising traffic that would have converted for free organically.
What this script does
- Queries Google’s
campaign_search_term_insightresource across all active PMax campaigns via GAQL. - Classifies search term categories against your brand and competitor tokens.
- Calculates your Brand Click Share and Brand Conversion Value Share in PMax.
- Automatically generates a formatted Google Sheet with an executive risk summary and exclusion tokens.
- Requires zero external software or paid subscriptions — runs 100% inside your Google Ads account scripts.
How to install in 2 minutes
- Log in to your Google Ads account.
- Navigate to Tools & Settings → Bulk Actions → Scripts.
- Click the blue + (New Script) button.
- Paste the script code into the editor, replacing existing template code.
- Update
CONFIG.BRAND_TERMSwith your brand name tokens in lowercase. - Click Authorize to grant the script permission to query insights and create a Google Sheet.
- Click Preview or Run, then check the logs for your generated Google Sheet URL.
The Conversion Lag & Real tROAS Calibrator
PMax cannibalisation is only one half of algorithmic distortion. The other is Conversion Lag. If your sales cycle takes 7 to 30 days, your recent 7-day ROAS in Google Ads is mathematically deflated. Marketers who lower bids on lagging campaigns choke off profitable impression volume.
Calibrated ROAS = Reported Value / (Cost × Cohort Maturity Factor)Rule of thumb: never adjust Target ROAS or Target CPA on data inside your 85% maturity window. For high-ticket eCommerce, that means evaluating bid performance on 30-day trailing cohorts, not yesterday’s numbers.
Want me to audit your account structure personally?
Get a comprehensive 30+ point teardown of your Google Ads account, including broad match leakage, conversion-tracking gaps, and a prioritised 90-day action plan. Delivered as a custom 15–25 min Loom.
