Here are some simple steps I used to map the Foursquare check-ins:
1) Doing simple Foursquare search using the venue explore API, I selected coffee shop check-ins, using coordinates for The Loop within a 5000 meter distance. These are the response results Apigee Snapshot: Foursquare The Loop Coffee Shop Check-Ins.
2) In order to geolocate these check-ins in QGIS, I had to import the JSON into Excel, filter and parse the information to show, name of coffee shop, latitude, and longitude.
3) Import the CSV file to QGIS
These maps are showing coffee shop check-ins in The Loop with purple dots.