Open the CSV in Excel, or import it into Google Sheets and choose comma-separated values. Save your working copy in a controlled location. The CSV contains the rows below and space for your notes; it has no macros, formulas or live account connection. The separate Excel workbook contains editable example inputs and formulas that update the forecast.
How to use the template
Export the two reports
Download the PMax search terms report for one campaign and 30 days, and note the same campaign's total cost and conversion value from the Campaigns view.
List your brand
Type every spelling of your brand on the Settings tab, including the spaced version and common typos. The workbook marks any search term that contains one as brand.
Read the split
The Summary tab shows brand share of cost and value, the ROAS PMax reports, the ROAS without brand searches and your break-even ROAS, with a verdict.
Fix and verify
If a funded brand Search campaign covers your name, add a brand list exclusion to PMax and decide on the Shopping option. Re-run the sheet in 14 to 30 days and judge on total sales, not PMax's ROAS.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Check | Where in Google Ads | What to record |
|---|---|---|
| Pull the PMax search terms | Campaigns > Insights and reports > Search terms > Search terms and landing pages for Performance Max | Last 30 days: term, impressions, clicks, cost, conversions, value |
| Pull campaign totals | Campaigns view, same dates | Total cost and conversion value |
| List brand spellings | Workbook Settings tab | Brand name, spaced version, misspellings, domain |
| Compare ROAS | Workbook Summary tab | Reported ROAS, ROAS without brand, break-even ROAS |
| Brand Search campaign | Campaigns: a Search campaign on your brand terms | Status, budget, 'Limited by budget' |
| Create a brand list | Tools > Shared library > Brand lists > + | List name; request your brand if missing |
| Apply the exclusion | PMax campaign > Settings > Additional settings > Brand exclusions | Date applied |
| Decide on Shopping | Same setting: 'Allow Shopping ads on searches that mention excluded brands' | Ticked or not, and why |
| Cover misspellings | Brand Search keywords, or PMax negative keywords | Misspellings added |
| Re-check in 14 to 30 days | Re-run the workbook; compare total sales | Brand share, brand campaign conversions, total revenue |
Worked review example
Fictional candle brand: one PMax campaign spent $11,500 in 30 days and reported $40,500 in conversion value, a ROAS of 3.52 against a 2.50 break-even.
Seven brand search terms took 19.6% of the cost ($2,250) and 58.8% of the value ($23,820). Without them the campaign spent $9,250 for $16,680: a ROAS of 1.80, below break-even. The verdict: high brand share; add a brand exclusion and make sure the brand Search campaign is funded.
What this template does and does not establish
Brand matching is plain text, so check the flagged rows. The search terms report omits low-volume searches and non-search channels. The audit shows how much of PMax's reported result comes from brand searches, not how much was incremental; only a controlled test can show that. The 30% 'high' line is our starting point, not a Google figure. Example data is fictional.
Primary references
- Optmyzr: Is Performance Max cannibalizing your Search campaigns?
- Google Ads Help: How Performance Max interacts with other campaigns in your account
- PPC Land: Performance Max may stop serving brand searches
- Google Ads Help: About the search terms report in Performance Max
- Google Ads Help: About brand settings for Search and Performance Max
- Google Ads Help: Apply brand exclusions to Performance Max or Search campaigns
- Google Ads Help: Manage a brand list
- Google Ads Help: Negative keywords in Performance Max campaigns
