Troubleshooting Guide

Solutions for common issues with the MCC PMax script.

Setup Issues

No MASTER_SHEET_URL found

Cause: The sheet URL hasn't been added to the script.

Fix: Open the script, find line 39, and paste your sheet URL between the single quotes: const MASTER_SHEET_URL = 'YOUR_URL_HERE'

Script can't access my sheet

Cause: Permission or sharing issues with the Google Sheet.

Fix: Ensure you created your own copy of the template. The sheet must be in your Google Drive. Check sharing settings - the script needs access.

'all' tab is empty after first run

Cause: MCC access issues or no accounts found.

Fix: Verify you have Editor access to the MCC. Check that client accounts are linked to the MCC. Try running the script again.

'settings' tab shows no accounts

Cause: No accounts with PMax spend in last 30 days.

Fix: Check the 'all' tab to see which accounts have data. You can manually add accounts from 'all' to 'settings' following the format.

Processing Issues

Accounts stuck not initialized

Cause: Account failed to process or hasn't been reached yet.

Fix: Check column N (error column) for error messages. If blank, the account is pending and will process on a future hourly run. Check column O to see current status.

Account shows initialized but no data

Cause: Sheet URL issue or processing error.

Fix: Check column F for the sheet URL. Click it to verify the sheet exists. Check column N for errors. Set Initialized back to FALSE to retry.

Not a valid Account ID error

Cause: Account ID format is incorrect.

Fix: Account IDs must be in format: 123-456-7890 (digits with dashes). Check the 'all' tab for the correct format. Copy/paste from there.

Data is out of date

Cause: Account hasn't run at its scheduled time yet.

Fix: Check column L (Last Successful Run). Check column C (Run At) matches current hour. Verify the hourly trigger is active.

Data Issues

Numbers don't match Google Ads UI

Cause: Timezone differences or date range mismatch.

Fix: The script uses your MCC timezone and last 30 days. UI might show different timezone or date range. Check for removed campaigns.

Missing campaigns in totals tab

Cause: Campaign status or type filtering.

Fix: Only PMax, Shopping, and Demand Gen campaigns with cost > 0 are included. Removed campaigns are excluded.

Placement data incomplete

Cause: 50,000 row limit reached.

Fix: The script fetches top 50,000 placements by impressions. Increase PLACEMENT_LIMIT in the script if needed (may cause timeouts).

Trigger Issues

Script not running hourly

Cause: Trigger not set up or disabled.

Fix: Go to Triggers in the script editor. Verify a trigger exists for 'main' function, Hour timer, Every hour. Re-create if missing.

Authorization required emails

Cause: Script permissions expired or changed.

Fix: Click the link in the email to re-authorize. Select your Google account and grant permissions again.

Script runs but does nothing

Cause: Wrong hour or all accounts already processed.

Fix: Check logs to see what the script is doing. Verify it's not the maintenance hour (23:00). Check if any accounts match the current run time.

Still Need Help?

If your issue isn't covered here:

Check the FAQ for quick answers

Ask in the Ads to AI Community

Email support at mike@mikerhodes.com.au

Back to Help FAQ→