{"id":994,"date":"2012-01-02T11:48:08","date_gmt":"2012-01-02T01:48:08","guid":{"rendered":"http:\/\/www.mappingonlinepublics.net\/dev\/2012\/01\/02\/taking-twitter-metrics-to-a-new-level-part-3\/"},"modified":"2012-04-24T13:36:47","modified_gmt":"2012-04-24T03:36:47","slug":"taking-twitter-metrics-to-a-new-level-part-3","status":"publish","type":"post","link":"https:\/\/mappingonlinepublics.net\/dev\/2012\/01\/02\/taking-twitter-metrics-to-a-new-level-part-3\/","title":{"rendered":"Taking Twitter Metrics to a New Level (Part 3)"},"content":{"rendered":"<p><font color=\"#ff0000\"><strong>Update:<\/strong> revision 1.2 of metrify.awk is now available (still at the link below), and introduces some further functionality, <\/font><a href=\"http:\/\/www.mappingonlinepublics.net\/dev\/2012\/01\/31\/more-twitter-metrics-metrify-revisited\/\"><font color=\"#ff0000\">which is outlined here<\/font><\/a><font color=\"#ff0000\">.<\/font><\/p>\n<p>Over <a href=\"http:\/\/www.mappingonlinepublics.net\/dev\/2012\/01\/02\/taking-twitter-metrics-to-a-new-level-part-2\/\">the past couple of posts<\/a>, I&#8217;ve introduced our new <a href=\"http:\/\/www.mappingonlinepublics.net\/dev\/wp-content\/uploads\/2012\/01\/metrify.zip\">metrify.awk<\/a> <em>Twitter<\/em> metrics script, and looked at the first of the three metrics tables produced by the script. Let&#8217;s move on now to the second table, where I&#8217;ll use a snapshot of Australian political discussion on <em>Twitter<\/em> under the #auspol hashtag between February and August 2011, instead of #qldfloods &#8211; the overall metrics for the different user percentiles in the #qldfloods dataset turn out not to be particularly interesting&#8230; As before, we&#8217;re dividing the total userbase according to the 1\/9\/90 rule into the 1% of most active users, the next 9% of moderately active users, and the final 90% of least active users. (In the case of #auspol, that first percentile contains 142, the second percentile contains 1291, and the final percentile contains 12700 of a total of 14133 users.)<\/p>\n<\/p>\n<h2>Percentile Metrics<\/h2>\n<p>The second table generated by metrify.awk provides us with detailed metrics on these three percentiles, on an overall basis rather than per specific time period.<\/p>\n<p>This table contains the following columns:<\/p>\n<ul>\n<li><strong>percentile: <\/strong>the various percentiles making up the userbase, as well as total metrics for the entire userbase <\/li>\n<li><strong>various stats on tweets of these different types:<\/strong> the types match those we&#8217;ve already encountered in the previous blog post, and stats on these tweet types are provided in each case as total numbers, and as a percentage of the number of tweets posted by the user percentile in question\n<ul>\n<li>original tweets <\/li>\n<li>@replies <\/li>\n<li>genuine @replies <\/li>\n<li>retweets <\/li>\n<li>unedited retweets <\/li>\n<li>edited retweets <\/li>\n<li>tweets containing URLs <\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&#160; <br \/>Again, too, these figures will add up to the total:<\/p>\n<ul>\n<li>edited retweets + unedited retweets = retweets <\/li>\n<li>retweets + genuine @replies = @replies <\/li>\n<li>original tweets + genuine @replies + retweets = total number of tweets <\/li>\n<\/ul>\n<p>&#160; <br \/>and<\/p>\n<ul>\n<li>% edited retweets + % unedited retweets = % retweets <\/li>\n<li>% original tweets + % genuine @replies + % retweets = 100% <\/li>\n<\/ul>\n<p>&#160; <br \/>(with tweets containing URLs again constituting a separate category, since any type of tweet may also contain URLs).<\/p>\n<h2>Some Results<\/h2>\n<p>Applying this to our <strike>#royalwedding<\/strike> #auspol dataset, here&#8217;s what the activities of the different user percentiles look like:<\/p>\n<p><a href=\"http:\/\/www.mappingonlinepublics.net\/dev\/wp-content\/uploads\/2012\/01\/image.png\"><img loading=\"lazy\" decoding=\"async\" title=\"image\" style=\"border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px\" height=\"295\" alt=\"image\" src=\"http:\/\/www.mappingonlinepublics.net\/dev\/wp-content\/uploads\/2012\/01\/image_thumb.png\" width=\"487\" border=\"0\" \/><\/a><\/p>\n<p>We&#8217;re clearly seeing some very significant differences between the various percentile groups here. Interaction amongst the top 1% of most active users is especially discursive, with more than 55% of all of their tweets constituting genuine @replies: these people are very actively talking to (or at) one another.<\/p>\n<p>The next lower group of active users, by contrast, doesn&#8217;t engage as much: only one third of their tweets are genuine @replies, but nearly 39% are original tweets. They&#8217;re more active at posting their own views and comments, rather than responding to others &#8211; or at least (and this is important to keep in mind with any such metrics), they&#8217;re less in the habit of also marking their @replies with the #auspol hashtag. By contrast, the top group are much more overtly <em>performing<\/em> their conversations, making them visible to all followers of #auspol; the second group may well send their own @replies, but if those @replies don&#8217;t contain the hashtag #auspol, they&#8217;re less visible to others and not included in our hashtag dataset.<\/p>\n<p>Finally, too, the least active 90% of users are participating differently again: some 52% of their tweets are retweets, so (given that they&#8217;re not posting to #auspol that often in the first place) they&#8217;re probably more likely to be present here simply as &#8216;drive-by&#8217; retweeters who occasionally pass along an interesting #auspol-tagged message that shows up in their <em>Twitter<\/em> feeds, but don&#8217;t deliberately follow the continuing #auspol conversation itself.<\/p>\n<p><a href=\"http:\/\/www.mappingonlinepublics.net\/dev\/wp-content\/uploads\/2012\/01\/image1.png\"><img loading=\"lazy\" decoding=\"async\" title=\"image\" style=\"border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px\" height=\"300\" alt=\"image\" src=\"http:\/\/www.mappingonlinepublics.net\/dev\/wp-content\/uploads\/2012\/01\/image_thumb1.png\" width=\"487\" border=\"0\" \/><\/a><\/p>\n<p>There are two more useful statistics to examine for #auspol, and I&#8217;ve combined them in the graph above: first, the percentage of the total volume of #auspol tweets that each group is responsible for (shown here in blue): the one percent of most active users &#8211; a total of 142 <em>Twitter<\/em> users, for the period we&#8217;re looking at &#8211; accounts for a staggering <em>62%<\/em> of all #auspol tweets. In other words, Australian political discussion on <em>Twitter<\/em>, under the #auspol banner, is dominated by a vanishingly small group of users whose output is massively disproportional to the size of the group. Compare this with the least active 90%: those more than 12,000 users contribute less than 9% of all #auspol posts. Quite a difference &#8211; #auspol shows a very strong long-tail distribution amongst its active participants, then. (This is very different for many of the crisis-related hashtags we&#8217;ve looked at, by the way: the top 1% of most active users in #qldfloods, for example, are responsible for less than 17% of all tweets; the least active 90% of #qldfloods users for nearly 57%.)<\/p>\n<p>Second, the distribution of tweets containing URLs is also interesting here. We already know that the lowest 90% are more likely to retweet than post their own commentary or @replies &#8211; and it looks like many of those retweets are of posts containing URLs: some 37% of all tweets by the bottom 90% include links. By contrast, the discursive few at the top of the activity scale include URLs in only 18% of their tweets.<\/p>\n<h2>Percentile Metrics, Compared<\/h2>\n<p>But beyond these metrics for the various user percentiles in individual hashtags, we can also compare these findings <em>across<\/em> different hashtag datasets &#8211; and that&#8217;s where things get <em>really<\/em> interesting. There are very many possible comparisons here: how do the individual percentiles of users compare across the different hashtags (something I&#8217;ve already hinted at above, comparing the relative contribution of the top 1% in #auspol and #qldfloods, for example), which hashtags contain more @replies, retweets, URLs, etc.?<\/p>\n<p>We&#8217;ve only scratched the surface on these broader comparisons, but one very interesting pattern which has already emerged is shown in the graph below (which remains preliminary; one of my plans for the next month or so is to develop this further):<\/p>\n<p><a href=\"http:\/\/www.mappingonlinepublics.net\/dev\/wp-content\/uploads\/2012\/01\/image2.png\"><img loading=\"lazy\" decoding=\"async\" title=\"image\" style=\"border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px\" height=\"451\" alt=\"image\" src=\"http:\/\/www.mappingonlinepublics.net\/dev\/wp-content\/uploads\/2012\/01\/image_thumb3.png\" width=\"441\" border=\"0\" \/><\/a><\/p>\n<p>Here, we&#8217;re comparing the <em>total<\/em> metrics (for all users, rather than for specific percentiles) across a range of different hashtags: #qldfloods, #eqnz, the Japanese #tsunami, #libya, the #londonriots, #ukriots, and #riotcleanup, the #royalwedding, election nights in Australia and Ireland (#ausvotes and #ge11), the Tour de France (#tdf), #eurovision, and #wikileaks. The size of each point on the graph shows the total size of the userbase for each hashtag &#8211; so, the #royalwedding and the #tsunami attracted a vastly larger <em>Twitter<\/em> userbase (of around half a million unique users each) than the Irish election or Queensland floods, for example.<\/p>\n<p>But what the graph shows is that independent of the size of the userbase, there are some very obvious patterns here. All of the crisis events are characterised by a large number of both (unedited) retweets and tweets sharing links; people are actively finding and disseminating information. All of the widely televised events, on the other hand, have very few URLs, and only marginally more retweets: <em>Twitter<\/em> may be used as a backchannel for the television, in a shared experience of audiencing, but there&#8217;s not much additional information sharing going on here. #wikileaks, in turn, is a different story altogether &#8211; but perhaps we&#8217;ll come across more hashtags with similar metrics, and it&#8217;s the first sign of a third major category.<\/p>\n<p>I&#8217;m reluctant to read too much more into these patterns as yet &#8211; first, I&#8217;ll need to do some more work cleaning up the datasets which the graph above is based on (working out which exact periods of time to use for each hashtag, and trying comparisons of a few more different combinations of metrics. I do think there&#8217;s a first sign in this of much more fundamental patterns in how <em>Twitter<\/em> hashtags are used for specific purposes. But that&#8217;s a longer discussion for another time.<\/p>\n<p>And we haven&#8217;t yet exhausted all the possibilities which metrify.awk itself offers. In addition to the time- and\/or percentile-based metrics which we&#8217;ve discussed over these last couple of posts, it also calculates metrics for each individual user in the dataset. And that&#8217;s what we&#8217;ll look at <a href=\"http:\/\/www.mappingonlinepublics.net\/dev\/2012\/01\/02\/taking-twitter-metrics-to-a-new-level-part-4\/\">in the final instalment in this series<\/a>.<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Update: revision 1.2 of metrify.awk is now available (still at the link below), and introduces some further functionality, which is outlined here. Over the past couple of posts, I&#8217;ve introduced our new metrify.awk Twitter metrics script, and looked at the first of the three metrics tables produced by the script. Let&#8217;s move on now to &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/mappingonlinepublics.net\/dev\/2012\/01\/02\/taking-twitter-metrics-to-a-new-level-part-3\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Taking Twitter Metrics to a New Level (Part 3)&#8221;<\/span><\/a><\/p>\n<p><!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":2,"featured_media":1315,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[172,5,173,176,113,8,177],"tags":[147,7,82,297,50,298],"class_list":["post-994","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-crisis-2","category-methods","category-politics-2","category-processing","category-tools-2","category-twitter","category-visualisation","tag-auspol","tag-gawk","tag-hashtags","tag-methods","tag-metrics","tag-twitter","entry"],"_links":{"self":[{"href":"https:\/\/mappingonlinepublics.net\/dev\/wp-json\/wp\/v2\/posts\/994","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mappingonlinepublics.net\/dev\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mappingonlinepublics.net\/dev\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mappingonlinepublics.net\/dev\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mappingonlinepublics.net\/dev\/wp-json\/wp\/v2\/comments?post=994"}],"version-history":[{"count":0,"href":"https:\/\/mappingonlinepublics.net\/dev\/wp-json\/wp\/v2\/posts\/994\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mappingonlinepublics.net\/dev\/wp-json\/wp\/v2\/media\/1315"}],"wp:attachment":[{"href":"https:\/\/mappingonlinepublics.net\/dev\/wp-json\/wp\/v2\/media?parent=994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mappingonlinepublics.net\/dev\/wp-json\/wp\/v2\/categories?post=994"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mappingonlinepublics.net\/dev\/wp-json\/wp\/v2\/tags?post=994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}