background preloader

Tools - Extracting

Facebook Twitter

Google. Search, plus Your World. The Fine Art of Reverse Searching on Images - Being Social Us.

Tips & Tricks

YouTube. Get More Into YouTube. Add a YouTube widget to any web site with jQuery : Digging My Blog. Another new addition to the home page of my blog is the “Latest Videos” widget.

Add a YouTube widget to any web site with jQuery : Digging My Blog

It pulls in the 6 most recent videos that I have tagged as favorites on YouTube. It also has the option to pull in only videos that I have uploaded, but since I rarely upload videos I decided to spotlight any videos that I favorite for the time being. Like the Twitter widget and the Flickr widget that I wrote about recently, the YouTube widget is also a JavaScript only widget. It uses jQuery to make an AJAX request to get a YouTube feed formatted as json and and a little bit more JavaScript to output the images, titles and author info to the page.

The code that I used is based on the YouTube Channel Playlist plugin (demo) but I modified it quite a bit. To use the YouTube plugin you just need to add a script reference to the jQuery library and the file. Google Demo Slam. Vimeo.


Expert Q+A. ImportFeed - Google Docs Help. Google Spreadsheets supports cell formulas typically found in most desktop spreadsheet packages.

ImportFeed - Google Docs Help

These formulas can be used to create functions that manipulate data and calculate strings and numbers. Here's a list of all the functions available in each category. When using them, don't forget to add quotation marks around all function components made of alphabetic characters that aren't referring to cells or columns. The new Google Sheets includes a number of additional functions. These functions include ARRAY_CONSTRAIN, ARRAY_LITERAL, ARRAY_ROW, CELL, CLEAN, DELTA, ISEMAIL, ISURL, TIMEVALUE, LOOKUP, PERCENTRANK.EXC, PERCENTRANK.INC, RANK.AVG, RANK.EQ, TYPE, WEEKNUM, SUMIFS, COUNTIFS, AVERAGEIF, AVERAGEIFS, NETWORKDAYS.INTL, WORKDAY.INTL, SEARCHB, FINDB, and TDIST.

Transforming Text Into Knowledge. AlchemyAPI is helping pioneer a computer’s ability to understand human language and vision.

Transforming Text Into Knowledge

Our web services for real-time text analysis and computer vision give you the intelligence needed to transform vast amounts of unstructured data into actions that drive your business. Now you can easily perform sentiment analysis, keyword extraction, entity extraction, image tagging and much more on the massive volumes of web pages, documents, tweets and photos produced every second. Turning Google+ Search results into a RSS feed (for Google Reader) Google Spreadsheet: Auto-Update via RSS (and keep history) I have a google spreadsheet that fetches some data via RSS.

Google Spreadsheet: Auto-Update via RSS (and keep history)

The RSS feed is updated once a day, everyday. Is it possible for me to keep archive of all the new & historic data in the google spreadsheet? The data itself is not a lot, i.e. one new entry is added into the RSS feed per day. ImportFeed in Google Docs Tutorial - Use Google Docs as an RSS Reader. Learn how to use any Google Docs spreadsheet as an RSS Feed reader.

ImportFeed in Google Docs Tutorial - Use Google Docs as an RSS Reader

You can also use the technique to embed RSS feeds into web pages. How to get RSS into Excel: Google docs for analysing online buzz. HOW TO: Search Twitter from Google Spreadsheets and Excel. Twitter search is the only usable (and useful!)

HOW TO: Search Twitter from Google Spreadsheets and Excel

Social media search tool I’ve been using since it was Summize. It has turned invaluable for many essential tasks: Track your brand mentions: Be sure to check out these cool ideas on various ways to search Twitter to effectively track your brand mentions.Monitor new link building opportunities (e.g. guest post invites or citation requests).Monitor any twitter hashtag (e.g. your company Twitter chat or conference): collect and visualize Tweets around a conference hashtag and easily publish it to the web! Add Images to your Google Docs Spreadsheet Cells. You can now add images and icons to individual cells of a Google Docs spreadsheet using the IMAGE formula.

Add Images to your Google Docs Spreadsheet Cells

While it has always been possible to add images to any inside of your Google Docs spreadsheets, you can now insert images and icons inside individual spreadsheet cells as well. To add an image to a cell, highlight the cell, click F2 to enter the formula mode and then type =image(“URL”) where URL is the public web address of that image. Google Docs, by default, will scale the image to fit inside the area of the selected cell but you may change the default settings by adding another parameter to the image function. For instance, a formula like =image(“URL”, 2) will stretch the image to fit inside the selected cell while =image(“URL”, 3) will insert the image into the cell at its original size.

If you are getting parsing errors, you are either using a non-existent image or you may have missing adding quotes around the image URL inside the image() formula. Fetching tweets to Excel/Word/PPT/Google Docs. Update: due to changes made by Twitter, this script does not work at the moment.

Fetching tweets to Excel/Word/PPT/Google Docs

We have published a new version that is now included in our Supermetrics Functions product. Our project of the day: creating a solution for fetching a list of tweets by keyword from Twitter to Excel. There are lots of Twitter statistics apps out there, but it's quite nice being able to fetch tweets to Excel, as there you can conveniently do all kinds of additional analysis like sentiment scoring, either manually or with automation, and control all the steps in the analysis process yourself. There you can also merge the results with data from other sources, for instance into a web analytics dashboard created with my Google Analytics functions. There's an example workbook where the getTweets function is used available for download here. The functions work in Windows Excel 2003 and later - macros need to be allowed in Excel's security settings (after changing the setting, you may need to restart Excel).