This article applies only to Reach Target Monthly Spend (Version 2) which supports managing multiple campaigns and shared budgets using a single spreadsheet. This makes it the recommended option when you want to control several budgets efficiently.
The Reach Target Monthly Spend (Version 2) script automatically adjusts daily budgets to help you reach a specified monthly spend target as closely as possible (aiming for ~100%).
This version supports two configuration approaches:
1. Individual Settings (No Spreadsheet)
One Optmyzr setting controls one campaign or one shared budget
Best suited for managing a small number of budgets
2. Spreadsheet-Based Management (Recommended for Multiple Budgets)
One Optmyzr setting reads instructions from a Google Sheets spreadsheet
The spreadsheet can define multiple campaigns and shared budgets
The same spreadsheet can be used across multiple accounts
This spreadsheet-based approach is the recommended and most efficient method when managing several budgets.
Configuring the Script
Basic Settings
Setting Name: Provide a name for your setting.
Spreadsheet Option: Indicate if you want to read the settings from a spreadsheet.
Budget Name: Select the campaign or shared budget you want to manage automatically.
Target Monthly Spend: Enter the amount you would like the campaign or shared budget to reach by the end of the month. If the budget amount has decimals, you need to use a period (.) as a decimal separator.
Note: Only numerical figures can be used, and no special characters, for instance, currency symbols.
Methodology
Budget Calculation Method:
Evenly with Increases for High Potential Days: Distributes the budget evenly but increases on high-potential days based on historical data by setting a higher budget if today is a day of the week that has typically seen higher click volume.
Based on Day of Week Potential: The budget is allocated on the basis of the potential to spend on every day of the week.
Evenly: Spreads the budget evenly across the month.
Front-Loaded: Allocates the majority of the budget at the beginning of the month.
Back-Loaded: Spends most of the budget towards the end of the month.
Note: We recommend the “Evenly with Increases For High Potential Days of the Week" reallocation method because this method sets a budget no lower than based on even distribution but increases it when it believes the day has extra potential based on day-of-week patterns. So it's more likely to help you spend your budget.
You can read more about how different reallocation methods work here.
Action when budget has been exceeded: Decide if the script should keep the last assigned daily budget (Keep Last Budget) or set it to $1 to prevent drastic overspending (Set Budget to 1).
Number of weeks of data to calculate day-of-week patterns: Choose the number of past weeks to calculate day-of-week patterns, with the default being eight weeks.
Highest allowed daily budget: Set the maximum daily budget as a percentage of the total monthly target.
Notifications
Enter email addresses to receive notifications when the script runs.
Advanced Settings
Roll over unused budget from previous month: Option to roll over unused budgets from the previous month to the next month's target.
Roll over if budget had cost in first days of month: Specify the number of days to consider cost accumulation for rolling over the budget.
Debug Data and Verbose Data Logs: For troubleshooting purposes by the support and engineering team.
Using the Script with a Spreadsheet
When you want to use the script with a spreadsheet, configure the Basic Settings and enable the spreadsheet option. You’ll be asked to enter the spreadsheet details:
Spreadsheet Configuration
Spreadsheet Template:
Make a copy of the provided spreadsheet template, which contains five columns:
Account ID: This allows you to include target budget settings for one or multiple accounts in one sheet.
Campaign or Shared Budget Name: This field is case-sensitive, so ensure the name here is an exact match with the campaign or shared budget names in Google Ads.
Target Monthly Spend: Enter the target monthly budget for each campaign or shared budget.
Budget Type: Indicate whether it is a campaign-level budget or a shared budget.
Max Daily Budget Percentage: Define the maximum percentage of the monthly target that can be allocated for the daily budget.
Spreadsheet URL and Tab Name:
Provide the URL of the Google Sheets spreadsheet where your target monthly budget settings are stored.
Specify the tab name within the spreadsheet where these settings are located.
A single spreadsheet can be used for multiple accounts.
However: Each account must still have its own Optmyzr script setting installed even if all accounts reference the same spreadsheet. The script only runs in accounts where a setting exists.
A single spreadsheet can be used for multiple accounts.
However: Each account must still have its own Optmyzr script setting installed even if all accounts reference the same spreadsheet. The script only runs in accounts where a setting exists.
Benefits of Using a Spreadsheet
Centralized Management:
Managing multiple accounts or several campaigns and shared budgets becomes more efficient by centralizing all settings in one spreadsheet.
Ease of Updates:
Whenever you need to update the target budgets or any other settings, you only need to modify the spreadsheet.
Flexibility:
This approach is especially useful when you manage multiple accounts. You can configure all settings once and update them in a single location, ensuring consistency and saving time.
Working with Shared Budgets
The Shared Budget option is available when you use the same budget across multiple campaigns in Google Ads. Ensure this setting is unselected if you are using individual campaign-level budgets. The shared budget setting helps the script distinguish between campaigns and shared budgets that may have similar names.
Important Note: When a shared budget is created after the month has started, Google Ads doesn't transfer the spend from individual campaigns to the new shared budget. Optmyzr can only consider the spend from the shared budget from the creation date, which may cause discrepancies initially.
Installing the Script
After configuring your settings:
Click Save Settings.
Download the script for either a single account or MCC level.
Proceed to install the script in your Google Ads account.
Schedule the script to run ‘Daily’.
If you would like to read the full instructions on installing Optmyzr Google Ads scripts, you can refer to this help article.