How-to Accumulate Historical Facebook and Twitter data on your PC

One of the cool things about Facebook is that there’s lots of publicly available data and you don’t need Admin access to get it.
For example, our Competitive / Comparative Analysis Worksheet shows lots of valuable data:

With this simple Excel dashboard you can the following information about anybody’s page.

The number of Facebook Fans
The number of Facebook [...]

Learn to prevent Google Analytics Fast Access Mode–Use Offline data!

If you have a busy site, you know the pain Fast Access Mode is causing you. Have sympathy for Google though. It is, after all, a free service, and you are making their servers work exponentially (factorially?) harder than most other businesses.
Some of you might be asking — What’s “Fast Access” mode. This mode alters your [...]

Get historical Twitter data on friends, followers, competitors, peers

The Twitter API is wide open.  You can get data not just on yourself, not just on your friends and followers, but also your competitors and peers.
Most Twitter tools give you stats as-of-the-moment.  Very few if any let you build history for longer term analysis of trends and outliers, patterns, and correlation.  Maybe some do, [...]