daily budget calculator

Yesterday, we talked about how Google Ads’ daily budget settings are anything but intuitive.

Here’s a link to the story, for your convenience: https://nilsrooijmans.com/daily/your-daily-budget-is-not-really-your-daily-budget

The moral of the story is that calculating new daily budget settings when managing monthly budgets is far from trivial.

Fellow member of the list Tim Moorhead (name shared with permission) agreed, and he created a calculator you can use for adjusting daily budgets when making mid-month changes.

This tool calculates the correct daily budget by entering your month-to-date spend and your new or updated monthly budget. 

Here’s what that looks like:

(click image to enlarge)

Here’s a link to the Google Sheet (make a copy first): https://docs.google.com/spreadsheets/d/155yRUSdlBS8ESfKb34PeETzedKpGl9tvYkxQ3YWhIqI/copy

Thanks for sharing, Tim!

– Nils

Author: Nils Rooijmans

Google Ads Performance Architect with a passion for PPC Automation & AI, in particular via Google Ads Scripts.