Skip to main content
All CollectionsEnhanced Scripts for Google AdsFlexible Budgets
Managing Bulk Budgets Through a Spreadsheet
Managing Bulk Budgets Through a Spreadsheet
Geetanjali Tyagi avatar
Written by Geetanjali Tyagi
Updated over a week ago

On this page:


Setting up the script

When you manage many items (accounts or campaigns) with frequently changing budgets, it may be more efficient to use a Google Spreadsheet to maintain settings. Make a copy of our sample spreadsheet into your own Google account and then enter the URL and tab name in the following settings:

Notes:

  • When you use a spreadsheet, its containing settings will override whatever values you have entered for the fields "Maximum Budget Amount," "Items To Check," "Budget Period," "Check Only Items With This Label," "Campaign Name Contains," "Ad Group Name Contains," and "Aggregate Costs."

  • Do not edit the columns headers of the spreadsheet as it might affect the correct performance of the script.

  • You shouldn't have empty cells in the spreadsheet.

Example: The screenshot below shows how you can input data in a spreadsheet to control the budgets for your campaigns, labels and ad groups. Use cases below correspond to each row in the screenshot:

  • 1st row: Checks monthly budget of 2000 at the account level.

  • 2nd row: Checks an ad group label named "adgroup test" for 200 monthly budget, which is an aggregate budget.

  • 3rd row: Checks an ad group label named "adgroup test" for 400 monthly budget.

  • 4th row: Checks an ad group "tools" for 200 monthly budget.

  • 5th row: Checks a campaign named "Optimization-New" for its specified monthly budget.

  • 6th row: Checks another campaign in the account named "Brand" for its specified budget.

You can leave whichever cell is not applicable, empty.

Using a Spreadsheet

Access the sample spreadsheet here. When using the spreadsheet, you need to enable access, otherwise, the script won't be able to retrieve the budgets' data.

Multiple Google Ads accounts in a spreadsheet

When you have several Google Ads accounts in the spreadsheet, you need to create a setting in each of the accounts where the script will make budget changes, otherwise, the script will run only on the account where a setting is created. To do this, you can copy the original setting (instead of creating one from scratch).

Did this answer your question?