Archive: Google Ad Script

Budget 169$ per month

Posted: 5 years ago

Closed

Description: I need a Google Ad Script that reads a Google Drive Sheet DAILY and adjusts the Budget of the Campaigns that are referred in the data: (with help of a second sheet with monthly budgets)

Sheet 1: Event Dates
Rows:
Event-Date Event Location AdCampaign_ID Startdate_High Enddate_High Budget_High Budget_Low

The Logic of the script is:

Step 1:

If today’s date is between Startdate_High and Enddate_High then set the Campaign budget (ID comes with row AdCampaign_ID) to Budget_High
else set to Budget_Low

Step 2: Send Confirmation Mail with “Campaign Name Budget was set to xxxx “

Step 3: “Shut Dow”n Campaoign if the MONTHLY COSTS of current month (until now) exceed the
monthly Budget (see Sheet 2) then set all Campaign Bugets (referred in the List) to ZERO (means a shutdown) until next month
Send confirmation Email “Shut Down of Campigns, budget xxx reached

Step3: Send Daily confirmation mail with

“Monthly costs until now are xxxxx , cost yesterday was yyyyy, estimated (budget of current month / costs of yesterday) days left of campaign until shutdown

Sheet 2: Budgets

Rows:
Month, Budget

Data:
1, 2000
2, 1000
3, 2000
etc.
Skills:
campaign,google advertisement (google ads),google adwords,google drive,script reading,search engine marketing (sem)