Thread by @paidsearchwkly

Automate your #GoogleAds budget pacing for FREE.

To get started, you’ll need:

🖥️ Your #GoogleAds account
📄 #GoogleSheets
➕ The #GoogleAds Add-on for #GoogleSheets
💸 Campaign budgets
📅 Campaign end dates

Here’s what you need to do...🧵👇

Using the Google Ads Add-on, create a report that pulls cost data per campaign, per account, for the current month.

Set it to automatically refresh daily.

Columns you need from the Add-on report:

- Customer ID
- Account
- Campaign
- Campaign ID
- Cost.

You'll need to manually add new columns at the end:

- Budget
- Budget Type
- Today’s Date
- End Date
- Total Campaign Budget
- Action

Budget will be automatically calculated using this formula.

= (Total Campaign Budget - Cost) / (End Date - Today’s Date)

Budget Type will be “Daily” for all campaigns.

Today’s Date will be the same for all campaigns, and it’s just the =TODAY() formula in every cell.

End Date will be the end date of that particular campaign. This will have to be manually updated every time a new campaign is launched.

Total Campaign Budget is the budget that you provided.

Action will be “Edit” for all campaigns.

At this point, you should have had the add-on pull your Google Ads cost data for the month for all of your campaigns.

The columns we manually created should be filled with data.

There’s one more thing we have to do:

Build a new Google Sheet.

See, the sheet we just built has a lot of crap that Google Ads doesn’t need. So what we’re going to do is build another sheet that essentially copies and pastes the info from the sheet we built.

We can do this by using the =IMPORTRANGE formula.

Use this formula and take just the info we need (Action, Customer ID, Account, Campaign, Campaign ID, Budget, Budget Type)

You've now:

- Automated Google Ads cost data collection into Google Sheets
- Used formulas to calculate what each campaign's new daily budget should be

Now you can schedule an automated fetch of these daily budget edits in Google Ads.

Happy automating!

I'll be writing a more detailed guide on how to build this soon and I'll publish it on my site.

Please be careful when doing anything automated. I am NOT responsible for any account mishaps!

That's a wrap!

If you enjoyed this thread:

1. Follow me @paidsearchwkly for more of these
2. RT the tweet below to share this thread with your audience

https://twitter.com/paidsearchwkly/status/1511124596963131395

BONUS: Did you know that I send out a newsletter every Tuesday (aka today)?

I share #paidsearch tips, strategies, news, and tools.

Consider subscribing 😬

Paidsearchweekly.com