MCC Performance Scorecard
One KPI table for the whole portfolio — cost, clicks, CTR, conversions, CPA and budget-lost impression share per client account — the Monday-morning answer to 'which account needs me today?'
by Google (Kratu concept), chiliad (rewrite)·web.archive.org/web/20220124020710/https://developers.google.com/google-ads/scripts/docs/solutions/adsmanagerapp-kratu
Overview
MCC Performance Scorecard runs inside the manager account and builds one KPI table across all client accounts for the chosen window: cost, clicks, CTR, conversions, CPA and average budget-lost impression share, sorted by spend. It's the portfolio triage view — scan one email, spot the outlier CPA or the budget-capped account, and start the week where it matters. (Concept in the spirit of Google's retired Kratu report, rebuilt minimal.)
Setup
- 1Open your MANAGER (MCC) account and go to Tools → Bulk Actions → Scripts.
- 2Click the + button to create a new script and paste the code below.
- 3Adjust DATE_RANGE (LAST_7_DAYS for weekly triage, LAST_30_DAYS for monthly reviews).
- 4Set EMAIL_ADDRESS and schedule weekly (Monday morning).
Configuration Variables
| Variable | Default |
|---|---|
DATE_RANGE | LAST_7_DAYS |
MAX_ACCOUNTS | 50 |
LABEL_FILTER | (empty) |
EMAIL_ADDRESS | (empty) |
Expected Output
=== MCC Performance Scorecard (LAST_7_DAYS, 23 accounts) === Client A (123-456-7890, EUR) cost: 3120.40 clicks: 2411 CTR: 4.2% conv: 84.0 CPA: 37.15 budget lost IS: 2.1% Client B (234-567-8901, USD) cost: 1840.20 clicks: 1650 CTR: 3.1% conv: 18.0 CPA: 102.23 budget lost IS: 24.8% Client C (345-678-9012, EUR) cost: 890.15 clicks: 720 CTR: 5.0% conv: 31.0 CPA: 28.71 budget lost IS: 0.0% Email sent to you@example.com
Notes
Costs are in each account's own currency — don't sum the column across mixed-currency portfolios. Budget-lost impression share is averaged over the account's Search campaigns that lost anything; 0% means no campaign was budget-capped.