ThinkUpLLC / ThinkUp

ThinkUp gives you insights into your social networking activity on Twitter, Facebook, Instagram, and beyond.
http://thinkup.com
GNU General Public License v3.0
3.3k stars 676 forks source link

New Insight: Distance Shared. #1953

Open gbrady92 opened 10 years ago

gbrady92 commented 10 years ago

One-liner

Shows users the distance they travelled based off automated posts from fitness applications.

Full explainer

The distance shared insight is designed for users who have an interest in the social side of running and use a fitness tracking application such as Nike+. This insight will use the distances displayed on posts originating from a range of fitness applications. Using a line graph the insight will then display a comparison of the total distance shared the previous two weeks/months.

Audience for the insight

This insight will work should work on all social networks that allow ThinkUp to store the text content of a post and that support automatic posts from fitness applications.

This insight works best when a user's who use fitness applications and share their workouts on social network sites.

The insight can run on first run as long as they're posts from fitness applications stored within two weeks prior of the first run of ThinkUp.

How often this insight runs

distance

Criteria and logic

This insight will use the tu_posts table and the post_text, pub_date, source columns. The like keyword in MySQL will be used to recognise fitness application posts. The string representation of the distance will be treated like an int using the php function intval The insight’s data will displayed using Google Charts.

Included elements

gbrady92 commented 10 years ago

Just some updates on this insight: