How To Create An Automatic Monthly Google Ads Pacing Sheet

In this video tutorial, you will learn how to create a monthly Google ads budget pacing sheet that connects to your MCC account and updates automatically

First Step To Make a Monthly Google ads Pacing Sheet

Make a copy of this spreadsheet and edit it as suited to your needs.

Monthly Budget Pacing Sheet

Copy The Code & Paste it Into Your Google Ads Scripts

					function main() {

  // Select the accounts to be processed (all of them).
  var accountIterator = MccApp.accounts()
  // Set the Spreadsheet that you want to add data to.
  var SHEET_NAME = 'Monthly Spend';
  // Open sheet in spreadsheet
  var ss = SpreadsheetApp.openById(SPREADSHEET_ID);
  var sheet = ss.getSheetByName(SHEET_NAME);
  // Clear yesterdays contents
  // Add heading rows
  sheet.appendRow(['Name', 'Account ID', 'Cost']);
  // First we take the accountIterator variable from before
  while (accountIterator.hasNext()) {
    // And, for each account, we save the data into another variable
    var account =;
    // Switch to the account you want to process.;
    // Now we can do something
    // Generate account level query
    var report =
      'SELECT ExternalCustomerId, Clicks, Impressions, Cost, Ctr ' +
    // Get the results and save them into a variable
    var rows = report.rows();
    while (rows.hasNext()) {
      var row =;
      var cost = row['Cost'];
      var id = row['ExternalCustomerId'];
    Logger.log(account.getName() + ", " + id + ", :" + cost);
    sheet.appendRow([account.getName(), id, cost]);



Adjust Your Monthly Budgets

Insert your monthly budget for each account under the “total budget” column.

Creating a Pacing Sheet for More Than 30 Accounts?

If you have more than 30 accounts under your MCC you can copy and paste the values from one cell under each column into new rows.

Repeat these steps for all the columns on the spreadsheet. You can manage as many accounts on this spreadsheet as you like.

Table of Contents

2 Responses

  1. Hi,

    I am getting this error:
    ReferenceError: MccApp is not defined
    at main (Code:4:25)
    at Object. (adsapp_compiled:20157:54)

    1. Hi George unfortunately this code only works on MCC level which is Google ads Manager account.
      I will modify this script to run on individual accounts and upload it here in a few days.

Leave a Reply

Your email address will not be published. Required fields are marked *