The Google News RSS Feed / Google Reader Mashup

The Google Information RSS Feed / Google Reader Mashup

My present employer is an government search agency recruiting candidates for the actual property growth and building industries. I lead their web advertising and marketing efforts; I additionally am in command of market analysis. If I can ship aggressive trade intelligence to the recruiters in our workplace, they’ll put it to use to match government job candidates with employers who want them however can´t discover them on their very own.The ChallengeThere are a really giant variety of firms worthy of being tracked by my firm. ENR (Engineering Information & Report) creates totally different authoritative topic-specific lists containing names of the most important business building companies. Builder On-line lists the most important residential homebuilding companies. Between these two sources, I´ve recognized about 1,700 firms the place it could be helpful to trace every & each information story about them. Luckily, on any given day, solely a small share of those firms will make noteworthy information…nonetheless, in an effort to make sure that I catch all the precious info, I would like to observe all of them.Most logically, I must implement some type of RSS answer in an effort to monitor 1,700 firms. Guide entry of 1,700 feeds right into a feedreader isn´t an possibility; I don´t have any programming expertise; and I don´t have a funds to search out somebody to program an answer.So what did I do?The Answer: Half 1When I examined a typical Google Information RSS URL, I can decide that the one variable info inside every prolonged URL is the time period being searched:,GGLJ:2006-37,GGLJ:en&oe=UTF-8&tab=wn&q=builder+magazine&output=rssFrom this info, I can shortly and easily reproduce a Google Information RSS URL for every merchandise in my listing shortly and simply in Excel.I then do the next (which is extra clearly illustrated within the hooked up spreadsheet that I strongly encourage you to obtain by clicking this hyperlink):1) As soon as I open Excel, I place my total listing of related firms into Column B.2) In Column A, I place the primary portion of the Google RSS URL (from http:// as much as the variable portion).3) In Column C, I place the ultimate portion of the URL (&output=rss).4) I additionally know from expertise that in an effort to make my feed as related as attainable, I need to use actual match wherever I can. “%22” is the image used for “quote”. I append “%22” because the final characters in Column A and the primary characters in Column C.5) I make it possible for the code in Columns A & C is copied onto each row containing a related firm in Column B.I additionally have to carry out the next world steps in Column B:1) Exchange “space” and “&” with “+”2) Exchange “++” with “+”3) Delete all situations of “apostrophe”.Right here comes the enjoyable half:1) I widen the columns so that there’s loads of white house to the fitting of the textual content in every column.2) I save the doc as a Formatted Textual content House Delimited (.prn) doc.3) I reopen the doc, select “Delimited”, click on “Next”, after which click on “Finish”.4) I then globally exchange “space” with nothing, producing the listing of lengthy RSS URL´s.The Answer: Half 2(…catches breath…)In every of the feed readers I´ve used, I´ve seen that one can bulk import feeds into them if they’re in OPML, one thing I admit to not understanding too effectively. I noticed that if I might convert my URL´s into OPML, I can then get my total listing of firm information RSS feeds right into a feedreader. I discovered Feedshow Goodies ( by Google, dropped my URL´s into the shape situated on this web page, and clicked “Create OPML” (observe that it’s going to course of as much as about 200 URL´s directly). I then saved every OPML file to my exhausting drive.I then made the error of considering that my trusty Feedreader 3.07 would cleanly settle for 1,700 new feeds. The primary OPML import of 200 feeds ate up all my web bandwidth and slowed my laptop to a crawl. Google Reader was the one different feedreader that I´ve used, so I signed into it and uploaded 9 giant OPML information.It labored. Google Reader allowed me to seamlessly (if considerably slowly) import 1,700 feeds and skim all of them collectively, permitting me to get an actual time information replace of all of the business & residential building firms that I desired to trace.My Public Feed ( (Be aware I configured it considerably otherwise than within the pattern above).Suggestions1) Though the Google Reader is doing all of the “heavy lifting”, having it open monitoring 1,700 feeds will hog your reminiscence, particularly in IE. I discovered that opening Google Reader in Firefox or Opera as a substitute lower considerably the quantity of reminiscence used.2) The one disadvantage to this course of is that the “title” of every feed is the lengthy ugly Google RSS URL as a substitute of one thing extra descriptive.3) When you have lots of tales in your Google Reader, go to Preferences and test “In Expanded View, Mark Items as Read as You Scroll Past Them”. This function is an incredible assist in wading by voluminous quantities of information.4) I discovered that creating Google Information feeds for all information created “in the past week” gave me the most effective outcomes. A Google Information feed for all firm information for every firm led to an excessive amount of info and information feed protecting simply the previous day´s information appeared to overlook tales. On this instance, I used Information RSS URL´s for all firm information as a result of they’re essentially the most user-friendly. To make use of this mashup with “time-restricted” Google Information, you have to to click on on “Advanced News Search”, do a pattern search with an outlined time interval, generate the Information RSS URL and replica the primary portion of it into Column A of your spreadsheet earlier than following the proscribed course of.I now can monitor information from all 1,700 firms in my Google Reader. Kudos to these good of us on the ´Plex.