Solver/Linear ProgrammingLinear Optimization, Dynamic Programming, Operations Research, Solver

Overview

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.

Have a software development project?

Talk To Bot
Powered by Laitkor