I recently ran into this problem when I was looking at someones Adwords account and wanted to get an idea about all the unique keywords that they were using. I used the following formula to get an array of all unique keywords: =UNIQUE(SPLIT(CONCATENATE(‘Keyword Report’!B2:B),” “)) But then I encountered a problem: “Error Result was not automatically …
How To Add Multiple Columns to Google Spreadsheets Read More »
You know what’s cooler than calling API’s and services with Google Apps Script? Making your own API with Google Apps Script. After playing around with my first REST API with Python and Bottle, I wondered how this could be done even cheaper and quicker; without worrying about the complexities of databases and hosting. When it’s simple …
How to Make a Google Apps Script RESTful API or Service Read More »
“Report automation” is my favorite two-word combo besides “free pizza.” And because of the nature of the testing and optimization game, and the speed it happens (in comparison to something like SEO), reporting can can pile up rather quickly. This is why I was as happy as [see picture below] when Optimizely recently released a …
Automate Optimizely Reports With the Results API Read More »
Update: This script now allows you to copy multiple sheets within one spreadsheet to either the same spreadsheet or a different one. If you want to copy the sheet to the same spreadsheet, just input your current spreadsheet’s ID when prompted. The spreadsheet id can be found in the Spreadsheet’s URL eg: docs.google.com/spreadsheets/d/SPREADSHEETID/edit#gid=0 If you are looking …
Bulk Hide, Show, Delete & Copy Multiple Sheets in Google Spreadsheets Read More »
I made it! I am finally a nerd. At the top of the MailChimp API there is a clear disclaimer: “Woah, Nerds Only!” Undeterred, I scrolled on to test my nerdy medal. The following is my account of navigating the well-charted waters of the MailChimp API and a tutorial on how to automate a “BARF” …
Automate MailChimp Reporting with Google Spreadsheets Read More »
