Dynamic Campaign Creation: Basic Framework
Wed Feb 21 2024 17:49:54 GMT+0000 (Coordinated Universal Time)
Saved by
@tchives
#javascript
function main() {
// 1. Data Source: Google Sheet
var spreadsheetUrl = "https://docs.google.com/spreadsheets/d/..."; // Replace with your spreadsheet URL
var dataSheet = SpreadsheetApp.openByUrl(spreadsheetUrl).getSheetByName("CampaignData");
// 2. Campaign Template Settings
var campaignNameTemplate = "Dynamic Campaign - {Product Category}";
var budget = 100; // Daily budget
// ... other desired campaign settings ...
// 3. Iterate through Spreadsheet Data
var dataRange = dataSheet.getDataRange().getValues();
dataRange.shift(); // Remove header row
for (var i = 0; i < dataRange.length; i++) {
var productCategory = dataRange[i][0];
// ... extract other data from the row ...
// 4. Create New Campaign (Simplified)
var campaignBuilder = AdsApp.newCampaignBuilder();
var campaign = campaignBuilder
.withName(campaignNameTemplate.replace("{Product Category}", productCategory))
.withBudget({ amount: budget, currencyCode: "USD" })
.build()
.getResult();
// 5. (Optional) Create Ad Groups, Keywords, Ads based on Spreadsheet Data
}
}
content_copyCOPY
Comments