MCC All Tabs Explained

Understanding the MCC sheet structure and how it organizes data across multiple client accounts.

MCC Sheet Structure

The MCC (My Client Center) sheet is the master control sheet that manages all your client accounts in one place. Unlike individual account sheets, the MCC sheet focuses on account management and scheduling rather than detailed performance analysis.

Master Settings Tab

The Master Settings tab is where you configure which accounts the script should process and when.

• Account list with names and IDs
• “Run at” column to schedule when each account updates
• Enable/disable toggle for each account
• Global settings that apply to all accounts
• Links to individual client sheets

How the MCC Script Works

1. Script runs on your MCC schedule (hourly recommended)
2. Checks the Master Settings tab to see which accounts need updates
3. For each account, checks if it's time to run (based on “Run at” column)
4. If yes, creates or updates that account's individual sheet
5. Logs the results and moves to the next account

Individual Account Sheets

The MCC script creates separate sheets for each client account. These individual sheets contain all the analysis tabs you'd see in a single-account implementation:

• Account tab
• Campaign tab
• Categories tab
• Title tab
• nGram tab
• Pages tab
• Assets tab
• And all other analysis tabs

Scheduling Strategy

Recommended approach: Stagger account updates throughout the day to avoid Google API limits and script timeout issues.

For example, if you have 20 accounts:

• Accounts 1-5: Update at 2 AM
• Accounts 6-10: Update at 6 AM
• Accounts 11-15: Update at 10 AM
• Accounts 16-20: Update at 2 PM

This spreads the load and ensures all accounts get updated daily without overwhelming the script execution limits.