There are some minor tools like Twitter Search (http://www.alteryx.com/resources/blending-social-media-data-without-it) and Grazitti's Facebook Page crawler...
But we need tools for accessing and blending more of the existing semi-structure social data,
- no YouTube connector to search between videos and track impressions yet...
- no LinkedIn connector to crawl public and full profiles (with permission) to do HR analytics yet...
- no Instagram connector yet, to crawl marketing data and do trends and competition search
- no Flickr connector to grab pictures to do Image search and recognition...
Top social media sites Updated February 1, 2017;
1 | Facebook 1,100,000,000 - Estimated Unique Monthly Visitors
2 | YouTube 1,000,000,000
3 | Twitter 310,000,000
4 | LinkedIn 255,000,000
5 | Pinterest 250,000,000
6 | Google Plus+ 120,000,000
7 | Tumblr 110,000,000
8 | Instagram100,000,000
9 | Reddit 85,000,000
10 | VK 80,000,000
11 | Flickr 65,000,000
12 | Vine 42,000,000
13 | Meetup 40,000,000
14 | Ask.fm 37,000,000
15 | ClassMates 15,000,000