One of the topic that attracts good twitter traffic in India is movies. And if the movie is a much awaited Diwali release from Super star, then its a simple expectation to have a good twitter buzz. And on its release day Jab Tak Hai Jaan was a trending topic. I did collected the tweets related and in this blog will present some metrics. Some might call this Analysis but I prefer metrics/report because no Statistical or NLP algorithms involved to derive these results.
Data was from 11/12/2012 18:33 to 11/14/2012 12:15. Twitter Steaming API is used to collect the data and the keywords that were tracked are "JTHJ", "Jab Tak Hai Jaan" and "SRK". Not much of data cleaning applied as these keywords are not so common. Total tweets collected are 104,654 of these Retweets are 31177 (30%).
First lets see simple report, the tweet time line. The graph shows the tweets trending. The value on x-axis is dd/yy HH. Around 3'O Clock in afternoon of 13th Nov is the peak.
Below table shows top sources for traffic with re-tweet segregation. I expected percentage of re-tweets will be more for mobile devices. But my assumption seems to be wrong from below data. Surprisingly, twitter for Blackberry is more popular than iphone though the margin is less. This data also signifies the dominance or abundance of Android.
Most of the tweets with triple figure re-tweet count are from celebs. Of the top 10 3 are from Sharukh, 3 are from reviewers (like taran adarsh). One from Yash raj films also in top 10. Looks the movie team engaged themselves well in Social Media, which I feel is very important for successful social media marketing. Below are top 5 tweets with max re-tweets.
Below table shows top sources for traffic with re-tweet segregation. I expected percentage of re-tweets will be more for mobile devices. But my assumption seems to be wrong from below data. Surprisingly, twitter for Blackberry is more popular than iphone though the margin is less. This data also signifies the dominance or abundance of Android.
Source | Total tweets | Original | Original% | Retweets | Retweets% |
web | 38043 | 24635 | 64.76 | 13408 | 35.24 |
mobile web | 14813 | 10382 | 70.09 | 4431 | 29.91 |
twitter for android | 14359 | 9285 | 64.66 | 5074 | 35.34 |
twitter for blackberryâ® | 8828 | 6698 | 75.87 | 2130 | 24.13 |
twitter for iphone | 8035 | 5287 | 65.80 | 2748 | 34.20 |
4682 | 4658 | 99.49 | 24 | 0.51 | |
tweetdeck | 1490 | 1069 | 71.74 | 421 | 28.26 |
tweet button | 1429 | 1398 | 97.83 | 31 | 2.17 |
twitter for ipad | 1276 | 807 | 63.24 | 469 | 36.76 |
ubersocial for blackberry | 1114 | 935 | 83.93 | 179 | 16.07 |
tweetcaster for android | 1103 | 774 | 70.17 | 329 | 29.83 |
Most of the tweets with triple figure re-tweet count are from celebs. Of the top 10 3 are from Sharukh, 3 are from reviewers (like taran adarsh). One from Yash raj films also in top 10. Looks the movie team engaged themselves well in Social Media, which I feel is very important for successful social media marketing. Below are top 5 tweets with max re-tweets.
Tweet | Retweet Count | Author |
RT @iamsrk: Very touchng how all of u r buyng tckets for jthj and excted about t. It makes me feel very wanted & postvely pro ... | 1221 | iamsrk |
RT @bipsluvurself: Jab Tak Hai Jaan mkes u wnt 2 find ur soulmate ur true love.Infuses romance in2 ur life.A must see!Saluting the King ... | 641 | bipsluvurself |
RT @priyankachopra: As everyone comes together to Celebrate Yashji tonight..I sit far away and thank him for touching all our lives..wis ... | 567 | priyankachopra |
RT @iamsrk: En route to Jalandhar for JTHJ...havent slept a wnk all nght...eyelds r feelng lke a mattress. Hope ts a long slow flt... | 561 | iamsrk |
RT @taran_adarsh: Those asking, yes, all three Khans - SRK, Aamir & Salman - were under one roof for #JTHJ premiere. Premiere and po ... | 493 | taran_adarsh |
In the next blog will try to interpret actual review of the film from Tag Cloud generated from these tweets.
1 comment:
Hello Maruti,
Can you please open source your code to get these data from Twitter.
Post a Comment