I’ve been dreaming lately, of the time when I would have too many accounts to manage, of the time I would need to automate my client management. Today I searched for “adword scripts” and ‘discovered’ that other people think about this too. Here’s the entire post that appeared at the top of the organic search.
My first thought is that if I can get my scripts controlled in one Google Sheet, I can probably put all kinds of control data in one as well.
Use GDrive To Load A Single AdWords Script Into Multiple Accounts
Well in this post, I put together a simple way to keep a single copy of your script and load it into any number of AdWords accounts. Then, if you ever have a change to make, you can update a single version of the script and all the accounts will instantly start using the new code.
The code for this consists of two parts. The first snippet of code is the generic code that you need to place in each one of your accounts. This code references a single Google Spreadsheet (here is a sample one for you to copy: http://goo.gl/y6hPfy) that it uses to know what scripts it is supposed to run. The spreadsheet has only 3 columns: A description which is just used for logging, the location of the script in Google Drive, and the Object Name in the script. Don’t worry about that right now, I will describe it better in the next section. Finally, it loads the script file and executes the main function.
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
|
/************************************ * Generic Script Runner * Version 1.0 * Created By: Russ Savage * FreeAdWordsScripts.com ***********************************/function main() { //See http://goo.gl/KvINmD for an example spreadsheet. var scriptConfigId = 'Your Spreadsheet Id Goes Here'; var sheet = SpreadsheetApp.openById(scriptConfigId).getActiveSheet(); var data = sheet.getRange('A:C').getValues(); for(var i in data) { if(i == 0) { continue; } var [description, location, classname] = data[i]; if(!location) { continue; } Logger.log('Running "'+description+'" from location: '+location); var scriptFile = getFile(location); var scriptText = scriptFile.getBlob().getDataAsString(); eval(scriptText); var script = eval('new '+classname+'();'); script.main(); }} //This function gets the file from GDrivefunction getFile(loc) { var locArray = loc.split('/'); var folder = getFolder(loc); if(folder.getFilesByName(locArray[locArray.length-1]).hasNext()) { return folder.getFilesByName(locArray[locArray.length-1]).next(); } else { return null; }} //This function finds the folder for the file and creates folders if neededfunction getFolder(folderPath) { var folder = DriveApp.getRootFolder(); if(folderPath) { var pathArray = folderPath.split('/'); for(var i in pathArray) { if(i == pathArray.length - 1) { break; } var folderName = pathArray[i]; if(folder.getFoldersByName(folderName).hasNext()) { folder = folder.getFoldersByName(folderName).next(); } } } return folder;} |
Now that we have a generic piece of code that reads the description, location, and object name from a spreadsheet and executes code, we need to make some slight modifications to some of our existing scripts to get it to work.
One of my favorite scripts is the one about Finding Anomalies in Your Account. In order for the script to be run from another script, we need to convert it into an object with a single public function. This same technique should work on almost all of the scripts fromFreeAdWordsScripts.com.
First, surround the entire script in a function call and give it whatever name you like.
|
1
2
3
4
|
Next, you need to update the main function to be a public method so that we can call it from our generic script.
|
1
2
3
|
this.main = function() { // Don't make any changes to the body of the main method} |
A full version of the updated code can be found here: Find Anomalies in Your Account Object Version.
Now you can save this new script somewhere in your GDrive and update the Location and Object Name (Anomalies in this case) in your config spreadsheet.
Now you should be good to go. You can add as many scripts as you like to the config spreadsheet but keep in mind that the 30 minute limit still applies.
Thanks,
Russ
