Solver/Linear ProgrammingLinear Optimization, Dynamic Programming, Operations Research, Solver
A client wanted a Google App Script-based workflow, which would leverage Linear Optimation, Solver, and API.
Google Ads campaign budget data from the prior month is exported to Google Sheets via the Adwords API and consumed by the Google Sheets API
Created a Solver using the Google OR tools https://developers.google.com/optimization
Google Sheets Solver calculates optimal campaign budget allocations for the next month.
The new campaign budget allocations determined in the Google Sheets Solver are exported from Google Sheets back into Google Ads and assigned to the proper campaigns.