Ian Lurie // Sep 23 2011
I was sure I’d get crushed by a falling NASA satellite today. It didn’t happen, but it was very motivating. I completed my legacy to the marketing world: A Google Spreadsheet that automatically grabs everything from Linkscape data to Google Analytics numbers to Twitter follower counts. It’s purty:
If you want to see how it all works, you can look at the Utilities tab in the spreadsheet, and look at the code in Tools >> Script Editor.
This sheet uses triggers to run every night, while I sleep peacefully (or thrashing around like a lunatic, which is apparently more the norm for me). At night, the sheet:
If it’s the end of the month, then it also collects and records:
You have to add the Google link and page counts on your own, sorry.
I coded most of this at 2 AM during my 45 minutes of free time each day. Do you think I have any idea how it works?
If you want to see how it works, check out the code and the sheet tab labeled ‘utilities’. It’s safer than me trying to explain it.
If you want to rip off my work and be a lazy bum, feel free. Just save a copy.
You’ll need to create triggers for:
All I ask is that you send me any changes/improvements you make, so I can share them.
Oh, and you can’t get all snotty if you find and correct my mistakes. Be nice.
No way in hell I could’ve written this without help from:
Tom Critchlow from Distilled helped me figure out how to connect to LinkScape without going completely insane.
Ian Lurie is founder and CEO of Portent Inc., an internet marketing agency that has provided internet marketing, including PPC, SEO, social and analytics services, since 1995. Read More