
Performance Max Channel Dashboard
Problem It Solves
PMax campaigns give you almost no visibility into where your budget is actually going. The Google Ads interface keeps channel, product and asset group data buried across separate reports, so you end up pulling things manually just to understand what's working. This script fixes that.
What It Does
RS-PMAX-COLLECT pulls performance data from your PMax campaigns daily and writes everything into a Google Sheet. It collects five separate data sets: campaign totals, channel breakdown, product performance, asset group performance and asset inventory. It then builds formatted dashboards from that data every time it runs. No formulas to maintain, no manual exports, no separate reporting tool.
Key Features
- Breaks your PMax spend, conversions and conversion value down by channel (Search, Shopping, YouTube, Display) so you can see where your budget is going
- Product dashboard shows top 50s by clicks, conversions, conversion value, ROAS and cost, each sorted independently so you can spot winners and underperformers quickly
- Campaign and asset group tables colour-code ROAS green, amber or red based on your own thresholds, with Ad Strength colour-coded across asset groups
- Sends an email summary after every run confirming what was written and flagging any errors
- Runs on a daily schedule so the sheet updates itself overnight
Why It's Valuable
PMax is a black box by default. This script gives you a consistent view of performance across every dimension Google exposes, without building a single formula or touching the data yourself. You get a sheet you can share with a client or use to make decisions, not a raw export that needs hours of work before it tells you anything useful.
How It Works
- Paste the script into Google Ads Scripts and add your Sheet URL and email address to the config block.
- Set a daily schedule. 01:00 to 02:00 works well.
- The script runs overnight, pulls fresh data from the Google Ads API and overwrites the sheet with the latest figures.
- The five raw data tabs and five formatted dashboard tabs rebuild on every run.
- You get an email confirmation when it's done.
Output
A Google Sheet with ten tabs: five raw data tabs (campaigns, channels, products, asset groups, assets) and five formatted dashboards (OVERVIEW, CAMPAIGNS, CHANNELS, PRODUCTS, ASSET GROUPS), rebuilt automatically every day.
Everything in this script
- Paste it in once. Comes with a plain English setup guide, takes about 10 minutes, no developer needed.
- Runs automatically. Set the schedule once and it does the checking for you.
- No third-party access. The script runs inside your own Google Ads account. We never touch your data.
- One-time price. Buy it, own it. No subscription and no retainer.
From checkout to running in minutes
Purchase your product
Choose your digital product and complete the secure checkout.
Get instant access
Receive your download link instantly after successful payment.
Start using it
Download the file and start using it right away with easy instructions.
Before you buy
How do I install it?
Every script comes with a step-by-step setup guide. You paste the script into your own Google Ads account under Tools, then Scripts, set the schedule, and it runs from there. About 10 minutes, no technical background needed. If you'd rather not do it yourself, we offer an installation service.
Do you need access to my account?
No. The script runs entirely inside your own Google Ads account. Nothing is sent to us and we never see your data.
Will this change anything in my account?
No. This script is read-only. It reads your account data, builds your report and sends your alert. It never edits campaigns, changes bids, pauses ads or touches any settings. The only thing that changes is how much you know about your own account.
How do I get the script after buying?
Instant digital delivery. You'll get a download link straight after checkout and a copy by email.
What if Google changes something and it breaks?
Every script is covered by our 12-month update guarantee. If a platform change affects your script within a year of purchase, we send you the updated version free.
Do you offer refunds?
As a digital product delivered instantly, refunds are covered by our Refund Policy, which you can read before buying. If something doesn't work as described, contact us and we'll put it right.
How do I get the script after buying?
Instant digital delivery. You'll get a download link straight after checkout and a copy by email.