Digital and Social Media

How to create a heat map of your Foursquare check-ins using Google Fusion Tables

Do you want to create a cool heat map of your Foursquare check-ins? Of course you do! Who doesn’t like cool maps?! With Google Maps no longer supporting KML imports (which by the way makes no sense to me), Google Fusion Tables provides an alternative method for us map geeks to visualize our check-in data. Here are 3 steps to make it happen.

  1. Go to www.foursquare.com/feeds and click the KML link which will download a KML file of your check-ins.
  2. Log in to your Google Drive account which is where you’ll now find Fusion Tables under “Drive apps”.  Click create and upload your KML file.Fusion Tables
  3. Once uploaded, click on “Map of geometry” where you can toggle back in forth between a point map and a heat map.4SQ Feature Map

(more…)

The One Thing You Must Do On Social Networks

By Billy Burle

There is certainly no shortage of social media advice out there saying you must have a strategy, calculate an ROI, get more followers, schedule or don’t schedule posts, be human, be awesome and on and on and on. While these are good discussions to have, I won’t be having them here, not today anyway. Instead, I want to to talk to you about one thing that will have the greatest impact – reply. Reply to posts. For the love of all that is good and holy in this world – reply to posts. Sounds easy doesn’t it? Yet so few do it! I’m completely baffled when I hear that anywhere from 60%-90% of social media posts to companies go unanswered or ignored. This summer I attended an event put on by Google, where they said 95% of posts to brands on Google+ go unanswered. That’s the equivalent of : (more…)