I want to use Looker to forecast total monthly spend in Google Ads, based on how much has been spent so far in the month. So, any day of the month, the report would estimate the total spend for the current month.
I'd be happy to calculate this at the account-level, but campaign-level would be even cooler.
Also, if it could compare forecasted spend to the budgeted spend, that would be a home run. But, baby steps.
I have a Google sheet that has all the dates of the year, along with how many days are left in the month, and a numerical factor to multiply by spend to date, to get the forecasted spend for the whole month. i.e. on the 20th of a month with 30 days, the multiplication factor would be 1.5.
I haven't found a free Looker Studio that already does this, so I planned to create one myself.
Any ideas how to use a Google Sheet along with a Google Ads account to forecast spend?
LinkedIn
Twitter
