Google Ads script: Check Daily Budget

Warns if the budget today, yesterday or in the last x days exceeds a defined percentage of the daily budget. Also works with shared budgets across multiple campaigns.

Alert	Monitoring	Read-only
Sends an e-mail when something should be checked	The script monitors the Google Ads account (hourly or daily execution).	No changes are made in Google Ads, the Merchant Center or Google Analytics.

The percentage value of how far the budget may be exceeded can of course be set individually for each Google Ads account. The warning is issued per defined budget (shared budget or campaign budget). Several different checks can also be defined for each account.
For example, a warning should be issued if:

Spending today > 150% of the daily budget
Spending last 5 days divided by 5 > 130% of the daily budget
Spending last 14 days divided by 14 > 110% of the daily budget

Script developer: InBiz Online Marketing GmbH & CO. KG

The script was developed and provided for free use in the Ads Scripts Store by InBiz Online Marketing GmbH & CO. KG. Thank you very much!

Example alarm e-mail

This alert email lists the campaigns in which the average daily costs of the last 7 days have exceeded the defined 120% of the joint daily budget.

Google Ads Script Check Daily Budget Alarm Email

By clicking on the link in the "Delta" column, you will land directly in the config sheet and can configure a different threshold value instead of 120% – which changes the viewing period or ...
With a click on "Google Ads Account" you are immediately in the Google Ads account of Demo AG.

Example script configuration

Link to the demo configuration sheet for CheckDailyBudget.

Configuration parameters

Parameter	Description
#hours	Here you can restrict the execution to 4,5,6,7 (i.e. from 4 to 7 o'clock), for example, if the daily costs are not to be monitored.
#startDate	In the example email above, the budget was significantly exceeded over the last 7 days because the combined budget of the three shopping campaigns was reduced. To avoid receiving warning emails for the next 7 days, you can set a date in the future in the #startDate column from when the check should start again. Please always enter dates in the format 2024-05-10. In cells in which a date is expected, a calendar for date selection opens when you double-click in the cell.
#settingsExecutionMode	If the budget for the current day is to be monitored, the setting "completeWithIssuesOncePerDay" is useful. The script then checks every hour whether the limit value has been reached. If an alarm has been triggered ("with issue"), the AdsScriptsManager recognizes this when the script is run one hour later and does not carry out any checks at all, as the "completeWithIssuesOncePerDay" target has already been reached for this day. The "completeOncePerDay" setting is useful for monitoring past days. The check is then only carried out once a day. Further checks every hour make no sense and would be a waste of energy.
campaignLabelNames	If only certain campaigns are to be taken into account, you can define campaign labels here. This allows you to set different threshold values for different campaigns. However, it is important to ensure that all campaigns in a shared budget receive the same label.
alertCostGreaterThanPercentOfDailyBudget	100% is the default value, but this should be changed urgently. The shorter the observation period, the higher the percentage value should be.
numberOfDays	If there is more than one day, the costs are divided by the number of days and compared with the daily budget.
daysBack	If you want to monitor the costs of the current day, you should enter 0 here and 1 for numberOfDays. Otherwise, 1 for "from yesterday" makes sense.

Parameters that apply to all scripts

show

Download Google Ads script Check Daily Budget

Please log in or register in the Ads Scripts Store first to download the script (why is this necessary?).

E-mail address
Password: