Refine, reuse and request data | ScraperWiki. ImportXML Cookbook. ImportXML Cookbook (May 9, 2012) Added more here: More ImportXML Cookbooks Here’s a collection of ImportXML functions that I’ve collected over the past few months. Some of them I grabbed from other folks, others I’ve made myself. This post won’t introduce you to ImportXML. If you don’t know what ImportXML is go read this EPIC post by the guys at Distilled: “The ImportXML Guide for Google Docs”.
If you do know how to use ImportXML then this will be a fun Sunday afternoon project! Google Search Update 2/15/12: Google Scraper in Google Docs Update - Update to getting SERPs in Google Docs. Replace {KEYWORD} with the search term you’re looking for. =ImportXML(" Getting The Top 100 Search Result Links =ImportXML(" Getting the Top 100 Search Result Titles =ImportXML(" Google Products Replace {KEYWORD} with the keyword your looking for.
Getting All The Product Names =ImportXML("www.google.com/products? Twitter LinkedIn Alexa. Using Google Docs To Generate Hot Content Strategies [Tool] > Skip the chit chat, give me that tool now! It has been a little while now since my last blog post, but hopefully the wait has been worth it! I’m very excited to be writing this post and to be sharing this tool with you. Research for new content strategies takes time Every day in our industry we face the challenge of developing new strategies for attracting traffic to a website and staying ahead of the competition, whether this is through on or off site engagement. As marketers it’s our job to overcome these challenges to ultimately build ROI. But before you can jump to a strategy you need to do the research: What type of content is (and has been) working well – is it contextually relevant? – In a nut shell, what is hot right now? Our research doesn’t end there, once you have the above data you should be checking out similar topics too.
Check out our content generation tool For the purposes of this blog post here is a top level view of the on & off site strategy process: Content aggregators. Real-Time Keyword Research | GoFish v0.2.