Back to Help

Quick Start Guide

10 minutes setup
Last updated: December 5, 2025

Get your MCC PMax script up and running in just 10 minutes. This guide walks you through the essential setup steps to start getting data from all your accounts.

Before You Start

  • Google Ads MCC account with editor access
  • At least one account with Performance Max campaigns running
  • Google account with Google Sheets access
  • Chrome browser (recommended)
Step 1

Copy the Template Sheet

  1. Click this link to copy the template: Make a copy
  2. Name it: MCC PMax Data - [Your MCC Name]
  3. Copy the URL from your browser's address bar - you'll need this in the next step
Step 2

Set Up the Script

  1. In Google Ads, go to Tools & Settings → Bulk Actions → Scripts
  2. Click the + (New script) button
  3. Name your script: MCC PMax Insights v92
  4. Get the script code from your purchase confirmation email or scripts page
  5. Paste the code into the script editor
  6. Find line 39: const MASTER_SHEET_URL = ''
  7. Paste your sheet URL between the single quotes:
    const MASTER_SHEET_URL = 'https://docs.google.com/spreadsheets/d/YOUR_SHEET_ID/edit'
  8. Click Save
Step 3

Run the Script for the First Time

  1. Click the Run button in the script editor
  2. When prompted, click Authorize and grant the requested permissions
  3. Wait ~1-2 minutes for the initial setup to complete
  4. Check the logs (bottom panel) - you should see "Initial Setup Complete!"
  5. Wait another ~10-15 minutes for the first 3 accounts to be processed
What's happening: The script is populating the 'all' tab with all your accounts, then auto-populating the 'settings' tab with accounts that have PMax spend. Finally, it processes the first 3 accounts to give you immediate data.
Step 4

Verify Setup

  1. Open your Google Sheet
  2. Check the 'all' tab - it should have all your MCC accounts listed
  3. Check the 'settings' tab - it should show accounts with PMax spend
  4. Look at column O (Initialized) - the first 3 rows should show TRUE
  5. Click the sheet URLs in column F to view individual account data
Step 5

Schedule Hourly Runs

  1. In the script editor, click the Triggers icon (clock symbol)
  2. Click + Add Trigger
  3. Configure the trigger:
    • Function to run: main
    • Event source: Time-driven
    • Type of time-based trigger: Hour timer
    • Hour interval: Every hour
  4. Click Save

What Happens Next?

Every hour, the script will initialize 3 more accounts. You can track progress in the 'Initialized' column (O) in the settings tab.

If you have 37 accounts (like in the example), all accounts will be initialized in approximately 12 hours (37 accounts ÷ 3 per hour).

Once an account is initialized, its data will refresh hourly according to the 'Run At' time in column C.

Next Steps

Learn about the data in each tab →Read the detailed setup guide →Customize run times and settings →
Back to HelpDetailed Setup Guide→