Archive for August, 2010

Has there been a population shift for the AFL on Dreamwidth Studios since June?

Posted by Laura on Monday, 23 August, 2010

I wanted to feel a bit productive this afternoon so I thought I would go back and look at one of the easily measurable populations that I have. In this case, I chose Dreamwidth Studios. Was there a population shift since June when I last recorded how many people listed a team as an interest? Nope. Data below.

Service League Team Interest Date checked Communities People 23-Aug-10 23-Aug-10 Difference Difference
Dreamwidth AFL Collingwood Magpies Collingwood Magpies 7-Jun-10 0 0 0 0 0 0
Dreamwidth AFL Carlton Blues Carlton Blues 7-Jun-10 0 0 0 0 0 0
Dreamwidth AFL West Coast Eagles West Coast Eagles 7-Jun-10 0 0 0 0 0 0
Dreamwidth AFL Essendon Bombers Essendon Bombers 7-Jun-10 0 0 0 0 0 0
Dreamwidth AFL Adelaide Crows Adelaide Crows 7-Jun-10 0 4 0 4 0 0
Dreamwidth AFL St. Kilda Saints St. Kilda Saints 7-Jun-10 0 0 0 0 0 0
Dreamwidth AFL Sydney Swans Sydney Swans 7-Jun-10 0 1 0 1 0 0
Dreamwidth AFL Fremantle Dockers Fremantle Dockers 7-Jun-10 0 1 0 1 0 0
Dreamwidth AFL Richmond Tigers Richmond Tigers 7-Jun-10 0 0 0 0 0 0
Dreamwidth AFL Brisbane Lions Brisbane Lions 7-Jun-10 0 1 0 1 0 0
Dreamwidth AFL Geelong Cats Geelong Cats 7-Jun-10 0 0 0 0 0 0
Dreamwidth AFL North Melbourne Kangaroos North Melbourne Kangaroos 7-Jun-10 0 1 0 1 0 0
Dreamwidth AFL Melbourne Demons Melbourne Demons 7-Jun-10 0 0 0 0 0 0
Dreamwidth AFL Port Adelaide Power Port Adelaide Power 7-Jun-10 0 0 0 0 0 0
Dreamwidth AFL Hawthorn Hawks Hawthorn Hawks 7-Jun-10 0 0 0 0 0 0
Dreamwidth AFL Western Bulldogs Western Bulldogs 7-Jun-10 0 0 0 0 0 0
Dreamwidth AFL Gold Coast Football Club Gold Coast Football Club 7-Jun-10 0 0 0 0 0 0
Dreamwidth AFL Greater Western Sydney Greater Western Sydney 7-Jun-10 0 0 0 0 0 0
Dreamwidth AFL St Kilda Saints St Kilda Saints 7-Jun-10 0 1 0 1 0 0
Dreamwidth AFL Gold Coast Football Club Israel Folau 17-Jun-10 0 0 0 0 0 0
Dreamwidth AFL Western Bulldogs jason akermanis 17-Jun-10 0 0 0 0 0 0
Dreamwidth AFL Western Bulldogs Western Bulldogs 24-Jun-10 0 0 0 0 0 0
Dreamwidth AFL Western Bulldogs Julia Gillard 24-Jun-10 0 0 0 0 0 0
Dreamwidth AFL Western Bulldogs jason akermanis 24-Jun-10 0 0 0 0 0 0
Dreamwidth AFL Collingwood Magpies Collingwood Magpies 23-Aug-10 0 0
Dreamwidth AFL Carlton Blues Carlton Blues 23-Aug-10 0 0
Dreamwidth AFL West Coast Eagles West Coast Eagles 23-Aug-10 0 0
Dreamwidth AFL Essendon Bombers Essendon Bombers 23-Aug-10 0 0
Dreamwidth AFL Adelaide Crows Adelaide Crows 23-Aug-10 0 4
Dreamwidth AFL St. Kilda Saints St. Kilda Saints 23-Aug-10 0 0
Dreamwidth AFL Sydney Swans Sydney Swans 23-Aug-10 0 1
Dreamwidth AFL Fremantle Dockers Fremantle Dockers 23-Aug-10 0 1
Dreamwidth AFL Richmond Tigers Richmond Tigers 23-Aug-10 0 0
Dreamwidth AFL Brisbane Lions Brisbane Lions 23-Aug-10 0 1
Dreamwidth AFL Geelong Cats Geelong Cats 23-Aug-10 0 0
Dreamwidth AFL North Melbourne Kangaroos North Melbourne Kangaroos 23-Aug-10 0 1
Dreamwidth AFL Melbourne Demons Melbourne Demons 23-Aug-10 0 0
Dreamwidth AFL Port Adelaide Power Port Adelaide Power 23-Aug-10 0 0
Dreamwidth AFL Hawthorn Hawks Hawthorn Hawks 23-Aug-10 0 0
Dreamwidth AFL Western Bulldogs Western Bulldogs 23-Aug-10 0 0
Dreamwidth AFL Gold Coast Football Club Gold Coast Football Club 23-Aug-10 0 0
Dreamwidth AFL Greater Western Sydney Greater Western Sydney 23-Aug-10 0 0
Dreamwidth AFL St Kilda Saints St Kilda Saints 23-Aug-10 0 1
Dreamwidth AFL Gold Coast Football Club Gold Coast Suns 23-Aug-10 0 0
Dreamwidth AFL Gold Coast Football Club Israel Folau 23-Aug-10 0 0
Dreamwidth AFL Western Bulldogs jason akermanis 23-Aug-10 0 0
Dreamwidth AFL Western Bulldogs Julia Gillard 23-Aug-10 0 0

Related Posts:

Twitter Weekly Updates for 2010-08-22

Posted by Laura on Sunday, 22 August, 2010
  • For Perth based teams on bebo, bloggger, 43things, #wce most popular, #freo is 2, #waforce is 3, PerthGlory is 4, PerthHeat is 5 #
  • Gridiron Australia is based in the ACT! E-mailed them to ask if we could meet and discuss developing fan base for my research. *fingers xed* #
  • Off task. Totally off task. Not sure what on task is. Should do that. #
  • My new fave hobby in sports stores? Talking to workers about official club merchandise and frustrations as a consumer. #
  • Finished reading "The Rale Rasic Story". Really interesting read about Australian soccer. #
  • Is there a tool to batch convert shortened urls to longer versions? I have a list of 1000 bit.ly urls I want lengthened. :/ #
  • Looks like #afl fans on Twitter are not big into citing Wikipedia… #
  • Sample of 665 urls (from 2,942 urls from 6313 unique AFL tweets), most popular domains? twitpic.com, afl.com.au, facebook.com, youtube.com #
  • Found a URL extender this morning. Why couldn't I find it last night? #
  • Full list of urls referenced in AFL tweets: Most popular domains? afl.com.au, foxsports.com.au, heraldsun.com.au, au.sport.yahoo.com #
  • These results are very different than #afl related RTs with #hashtags . #
  • What domains in #afl related tweets get the most RT @ ReTweets? : bit.ly/cJfNBY #
  • Twitter #hashtags and the Australian election : bit.ly/aJdX1M #ausvotes #
  • One last #ausvotes Twitter election related map : Labor vs. Liberal : bit.ly/bU8r8B Where do #libs and #lab dominate on Twitter? #
  • #ausvotes Tweet totals by electorates : bit.ly/dkaiPQ #
  • Post #ausvotes analysis and commentary : bit.ly/93BJxx #
  • Give me a few days and I will get back to AFL analysis. :) Maybe. Need to avoid Twitter content analysis. It is useless. #

Powered by Twitter Tools

Related Posts:

Post #ausvotes analysis and commentary

Posted by Laura on Sunday, 22 August, 2010

The last post? It leads me to believe that you cannot use tweet volume by electorate to predict the outcome of that electorate’s voting. In most cases, the sample sizes were just too small: 1 to 10 tweets. There might have been more tweets coming out from that electorate but they weren’t using party names, acronyms or the names of the major party leaders. An already small sample of say 50 tweets from an electorate could be whittled down to 5. (I could go back and redo that, try to get more tweets, include post election tweets and see if the results changed… but I’m not certain the point. If some one gives me an incentive to do that though, it will be done.) Twitter doesn’t appear to have any meaningful predictive value on that level… or even on a broader level (where Labor was mentioned almost twice as often as the Liberals. The best suggestion could be that the overall trend is that Labor and Green supporters engage in the usage of social media more than their Liberal, National and Family First counterparts.)

That said, I still want to analyze these patterns. I generally avoid content analysis but this is interesting and some what relevant to an important topic. (Will Tony Abbott win and adversely effect my desire to stay in the country post graduation? How will the elections impact the country’s spending and the value of the USD, which I rely on to pay my bills in Australia?) I asked an acquaintance what analysis she would like and she suggested sentiment analysis post election results. (Are people on Twitter happy with the results?) I’m not a fan of sentiment analysis for a variety of reasons… It isn’t easy to do and is rarely accurate. The easiest way to do that would probably involve letting people judge the attitude of Twitter folks towards the election based on the most popular #ausvotes related hashtags.

To do this, I went to searchtastic and searched and searched like I did before (using the following searches: #ausvotes, #asuvotes, gillard, abbott, greens house, greens senate, #sexparty, #familyfirst, #nbn, #campaignbender, ranga julia, #vote9, #hungparliament, hung oz, #auslabor, Australian sex party, #9votes, #laborfail, #myliberal, Joe Hockey, tony julia, Maxine McKew, Wyatt Roy, wilson tuckey, Stephen Fielding, Steven Conroy, bob brown) . I found over 10,000 total tweets using these searches. I then removed all tweets that were posted before Aug 21 2010, 0:00 UTC. This time would be 21 August 2010, 10:00 AM Canberra time. People had started voting by then and most of the election vote getting had been done. That done, I had 7,985 total tweets. The next step was to remove all duplicate tweets. The tweet total is 3,372, which looks like a pretty decent sample size.

After that, I extracted all the #hashtags from these tweets. These 3,372 tweets had 4,354 #hashtags used in them. There were 420 unique #hashtags. The table below is a count of the most popular #hashtags used after Aug 21 2010, 0:00 UTC where the tag was used at least twice:

#tcot 5
#84 4
#Adelaide 4
#alp 4
#ausvote 4
#conroy 4
#hunglikeaparliament 4
#ope 4
#politics 4
#Quote 4
#ReTweetThisIf 4
#sausagesizzle 4
#votelabor 4
#VoteLiberal 4
#win 4
#wisdom 4
#zing 4
#60 3
#aflhawksfreo 3
#australia 3
#Australian 3
#australianlabor 3
#ausvoted 3
#climate 3
#disability 3
#dontfriskabbott 3
#dontriskRabbit 3
#electiondrinkinggames 3
#electionWire 3
#F1 3
#grayndler 3
#greensaresocialists 3
#hungover 3
#music 3
#nocleanfeed 3
#nowbuggeroff 3
#topend 3
#unintentionallyironic 3
#6RAR 2
#Abbottalypse 2
#abc1 2
#Amnesty 2
#antonygreenfacts 2
#auseats 2
#auselectoralfraud 2
#ausvotes 2
#awunion 2
#Breaking 2
#ChangeTheGovernment 2
#dawson 2
#dontbothertrying 2
#electionnightcocktail 2
#EPICFAIL 2
#fraser 2
#hescute 2
#ifabbotwins 2
#juliagillard 2
#keysinthefishbowl 2
#LA 2
#labour 2
#lol 2
#losers 2
#masterchef 2
#Melbourne 2
#NBNfail 2
#Note2Females 2
#ozelection 2
#ozlog 2
#p2 2
#Perth 2
#qanda 2
#Qld 2
#rejectedpartynames 2
#retweet 2
#rippedoff 2
#sadbuttrue 2
#SausageSizzles 2
#sbspoll 2
#senate 2
#tallyroom 2
#TeamAmerica 2
#Tehran 2
#travel 2
#truly 2
#TT 2
#twexitpoll 2
#uc 2
#UN 2
#votingpetpeeves 2
#VXToronto 2
#WAfirst 2
#waystoresolvehungparliament 2
#wellhung 2
#wellhungparliament 2
#westwing 2
#wewannaknow 2
#whitsundays 2
#whoneedsdrugs 2
#winwithgodwin 2
#workforitabbott 2
#WorldChampsPosse 2
#WTF 2
#Wyatt2035 2
#xxx 2
#youhaveapotatoforachin 2
#YouKnowYoureInAustralia 2
#zow 2

Is there any sentiment being expressed by people interested in the Australian elections that you could take away from this? Probably not. The extent to which I’d say any attitude is being expressed is that people do not want Abbott to come out on top and that they blame Labor for this failure of having a clear victor and functional government. It could also possibly be read that people are concerned about the impact of the elections on Internet censorship and infrastructure in Australia. (Though #nocleanfeed could refer to the Wikileaks story. People often use that #hashtag to discuss the site.) Marriage equality and civil rights are viewed as being a post election concern. And I suppose you could also conclude that Australians are keeping their sense of humor about themselves with their use of various puns and sexual references.

Rather than do another post, I’ve decided to tack on a list of URLs that were mentioned. From that same list of 3,372 tweets, there were 516 total urls included in the tweet. 297 of them were “unique.” (I haven’t lengthened all of the URLs so there may be a few repeats using url shorteners that I can’t easily lengthen.) The following URLs were the ones that were all mentioned five or more times:

Tweets Count
https://www.youtube.com/watch?v=RQ_s6V1Kv6A&feature=player_embedded 48
http://youtu.be/RQ_s6V1Kv6A 29
https://www.youtube.com/watch?v=RQ_s6V1Kv6A 26
https://www.youtube.com/watch?v=RQ_s6V1Kv6A& 11
hotfile.com/dl/63200434/385dec4/Inception.DIVX.DVD.QUALITY.wmv.html 8
LATENIGHTLOCALS.TK 8
https://www.facebook.com/photo.php?pid=6908926&fbid=462135946202&op=1&o=global&view=global&subj=106582159380758&id=540506202 8
http://www.abc.net.au/news/abcnews24/ 7
http://au.news.yahoo.com/a/-/latest/7799523/candidate-may-become-youngest-pollie/ 6
http://alp.org.au/special-pages/compare-julia-gillard-tony-abbott-policies/ 5
http://twitpic.com/2gsip7 5
http://yfrog.com/f1p53hj 5

It is an interesting selection of links: YouTube, Facebook, ABC news, Yahoo News, Labor’s website, TwitPic, and YFrog (a picture). The only really official content is that from Labor. Despite the #hashtag popularity of the Sex Party, people weren’t linking to them. People also weren’t linking to Get!Up content on their site. They weren’t linking to other official party content. The message in this case is clearly in control of voters and the media, not the parties.

Anyone have any more suggestions for what to write about in terms of the Australian elections before I go back to sport?

Related Posts:

#ausvotes Tweet totals by electorates

Posted by Laura on Saturday, 21 August, 2010

The Twitter collection I had and I’ve been posting about? I spent an hour or two getting Tweets. I stopped getting Tweets around the time the polls opened. (See this post and this for a more detailed methodology used for data gathering.) After that, I sorted the Tweets out to get rid of the duplicate Tweets. Then I get rid of the obviously not about Australian politics tweets based on the following keywords: glennbeck, #palin, #gop, #teaparty. The next step was to figure out from the location field where a tweet originated from. If the Tweet was not from Australia and I couldn’t figure out which city in Australia it was from, it was discarded from counting. This left 17,802 tweets total. After that, I sorted tweets based on party: Labor, Liberals/Nationals, Greens, Sex Party, Family First. For each party, I used that word, the name of the leader, prominent members of the party and the acronym they go by to get a more complete list of tweets. (Hockey = Joe Hockey = Liberal. Julia = Julia Gillard = Labor. Etc.) Then I tallied up the total of tweets from each city. I sorted the cities by electorate… and I got the following table. If you don’t see an electorate, no Tweets were identified as having come from it.

State Electorate Liberal Labor Green Family First Sex Party
Australian Capital Territory Canberra 1 1 1 0 0
Australian Capital Territory Fraser 85 84 34 0 0
New South Wales Banks 1 1 0 0 0
New South Wales Barton 1 1 0 0 0
New South Wales Bennelong 0 1 0 0 0
New South Wales Bennelong 0 0 0 0 1
New South Wales Berowra 1 1 0 0 0
New South Wales Bradfield 0 1 0 0 0
New South Wales Calare 2 4 1 0 0
New South Wales Chifley 66 121 7 0 0
New South Wales Cowper 1 1 4 0 0
New South Wales Cunningham 6 6 1 0 0
New South Wales Dobell 1 1 0 0 0
New South Wales Eden-Monaro 1 1 0 0 0
New South Wales Gilmore 7 2 0 0 0
New South Wales Grayndler 7 3 1 0 0
New South Wales Greenway 2 0 0 0 0
New South Wales Hume 1 2 2 0 1
New South Wales Hunter 1 0 0 0 0
New South Wales Kingsford Smith 0 1 1 0 1
New South Wales Lindsay 2 1 3 0 0
New South Wales Lyne 6 17 3 0 0
New South Wales Mackellar 27 85 4 0 0
New South Wales Macquarie 2 1 0 0 0
New South Wales Mitchell 1 1 0 0 0
New South Wales New England 5 6 4 0 2
New South Wales Newcastle 60 124 27 1 1
New South Wales North Sydney 13 47 1 0 0
New South Wales Paterson 17 36 2 0 0
New South Wales Reid 3 3 3 0 0
New South Wales Richmond 3 0 2 0 0
New South Wales Riverina 0 0 1 0 0
New South Wales Robertson 3 10 1 0 0
New South Wales Sydney 343 405 75 4 6
New South Wales Throsby 1 2 0 0 0
New South Wales Wannon 3 2 0 0 0
New South Wales Wentworth 2 4 0 0 0
New South Wales Wills 1 1 0 0 0
Northern Territory Lingiari 1 1 1 0 0
Northern Territory Solomon 1 4 0 0 0
Queensland Blair 0 1 0 0 0
Queensland Brisbane 97 115 20 1 5
Queensland Capricornia 1 1 0 0 0
Queensland Dawson 3 9 2 0 0
Queensland Fairfax 1 1 0 0 0
Queensland Flynn 1 1 0 0 0
Queensland Griffith 1 1 0 0 0
Queensland Herbert 1 2 1 0 0
Queensland Hinkler 0 0 1 0 0
Queensland Kennedy 1 3 0 0 0
Queensland Leichhardt 4 4 2 0 0
Queensland Lilley 0 0 1 0 0
Queensland McPherson 0 1 0 0 0
Queensland Moncrieff 74 231 2 0 0
Queensland Moreton 1 1 1 0 0
Queensland Petrie 1 1 0 0 0
Queensland Ryan 1 2 0 0 0
Queensland Wide Bay 4 2 0 0 0
South Australia Adelaide 85 132 8 3 1
South Australia Barker 0 0 1 0 0
South Australia Bass 2 0 0 0 0
South Australia Boothby 0 1 0 0 0
South Australia Denison 13 1 0 0 0
South Australia Mayo 28 169 3 0 0
South Australia Wakefield 0 1 0 0 0
Tasmania Bass 2 1 0 0 0
Tasmania Denison 13 9 8 0 0
Victoria Ballarat 2 2 1 0 0
Victoria Barton 20 27 23 1 2
Victoria Batman 0 1 0 0 0
Victoria Bendigo 0 0 1 0 0
Victoria Calwell 3 5 1 1 0
Victoria Canning 1 1 0 0 0
Victoria Corangamite 2 1 0 0 0
Victoria Corio 4 3 2 0 0
Victoria Dunkley 1 0 0 0 0
Victoria Flinders 4 31 0 0 0
Victoria Forrest 1 0 0 0 0
Victoria Gellibrand 1 2 0 0 0
Victoria Gorton 1 2 0 0 0
Victoria Higgins 2 1 0 0 0
Victoria Holt 4 1 0 0 0
Victoria Indi 1 2 1 0 0
Victoria Isaacs 2 7 0 0 0
Victoria Jagajaga 0 1 0 0 0
Victoria Kooyong 0 0 1 0 0
Victoria La Trobe 2 2 0 0 0
Victoria Lalor 2 1 1 0 0
Victoria McEwen 0 1 0 0 0
Victoria McMillan 1 0 0 0 0
Victoria Melbourne 244 302 65 8 13
Victoria Melbourne Ports 2 4 1 0 0
Victoria Menzies 3 4 1 0 0
Victoria Murray 0 1 0 0 0
Victoria Scullin 278 367 0 0 0
Western Australia Curtin 88 393 22 3 6
Western Australia Forrest 8 12 1 0 0
Western Australia Fremantle 2 5 2 0 0
Western Australia Hasluck 2 1 0 0 0
Western Australia Moore 1 0 0 0 0
Western Australia Perth 2 1 0 0 0
Western Australia Swan 0 1 0 0 0

Some of the results surprised me as I thought that the seats leaned Liberal or Labor and the tweets mentioned the other party more. After the results are in, I’m going to have to revisit this to see if there is any correlation between tweet volume by party in an electorate and the results for that electorate.

If anyone could make this into a map, that would be extremely awesome. A copy of the Excel file used to build these totals can be found here. Warning: it is 13 meg. If you want to see all the raw tweets and the keywords they were found under, AusVotes.csv. Warning: this file is 14 meg.

Related Posts:

One last #ausvotes Twitter election related map : Labor vs. Liberal

Posted by Laura on Friday, 20 August, 2010

Before I went to bed, I wanted one last Australian related election post. This post draws on the data and methodology from my other posts and maps.

At around 6pm, I did four additional keyword searches on Searchtastic beyond the ones in my most recent post. These were: #ausvotes, #donttrustabbott, #nocleanfeeds, #electionwire. I added them to my complete list of Tweets, then filtered the tweets based on username, location and tweet to remove duplicate tweets. This brought the total of 60,0084 Tweets down to 54,962. I then added three columns: City, State, Country. For the next few hours, I endeavored to fill in as many city fields as I could. The focus was on identifying Australian cities. Thus, for countries not Australia, I just listed the country or unknown. This was so I knew to ignore those. At 8pm, I stopped completing the fields. I just don’t have time to label everything…

Of those 54,962 tweets, some form of identification was completed for 34,213 tweets or 62% of all tweets. (Not a bad sample size from the whole.) Of these tweets, 19,165 came from Australia. Of these, 15,629 have Australian cities identified for the location of the Tweet. That I can play with.

The next step is to identify noise of Liberal, Labor and the Greens by city. The following CONTAINS filters were created on Excel to find tweets to get location data: Labor OR Gillard, Abbott OR Liberal, Brown or Greens. There were 1207, 977 and 302 tweet locations respectively. After this, the total number of Tweets per city for those terms was counted. There were 61 cities with Labor tweets, 62 cities with Liberal tweets, 38 cities with Green tweets.

After this was done, city locations were geocoded for mapping. I like to use BatchGeo. This gives me Latitude and Longitude which make the dots on the map locate more accurately. The tables were then ported over to Geocommons Maker and the following map was generated.

View full map

In table form, this map looks like:

City States Country Labor Count Liberal Count Green Count
Adelaide South Australia Australia 56 66 6
Alice Springs Northern Territory Australia 1 1 1
Ballarat Victoria Australia 2 1 1
Bathurst New South Wales Australia 1
Bayside Victoria Australia 4 2
Beechworth Victoria Australia 1 1 1
Bellingen New South Wales Australia 1
Blacktown New South Wales Australia 47 54 6
Blue Mountains New South Wales Australia 3
Boroondara Victoria Australia 1
Bowen Hills Queensland Australia 1
Brisbane Queensland Australia 71 69 16
Brunswick West New South Wales Australia 1 1
Bunbury Western Australia Australia 11 8 1
Bundaberg Queensland Australia 1
Burwood New South Wales Australia 3
Cairns Queensland Australia 2 3
Canberra Australian Capital Territory Australia 62 63 33
Carlton Victoria Australia 21 11 21
Chittaway Bay New South Wales Australia 1
Clay Wells South Australia Australia 1
Clovelly New South Wales Australia 1 1
Coffs Harbour New South Wales Australia 1 1
Cremorne New South Wales Australia 1
Darwin Northern Territory Australia 2 1
Enmore New South Wales Australia 2 4
Footscray Victoria Australia 1 1
Fremantle Western Australia Australia 2 2
Geelong Victoria Australia 1 2 2
Gold Coast Queensland Australia 107 37 2
Gordon New South Wales Australia 1
Gosford New South Wales Australia 7 1
Goulburn New South Wales Australia 1 1
Hastings Victoria Australia 7 1
Hobart Tasmania Australia 8 10 7
Illawarra New South Wales Australia 1 1
Indooroopilly Queensland Australia 1
Ipswich Queensland Australia 1
Joondalup Western Australia Australia 1
Katoomba New South Wales Australia 1
Kellyville Ridge New South Wales Australia 2
Kuranda Queensland Australia 1 1 1
Launceston Tasmania Australia 1 2
Lithgow New South Wales Australia 1
Mackay Queensland Australia 5 3 2
Macleod Victoria Australia 1
Mallala South Australia Australia 1
Matraville New South Wales Australia 1
Melbourne Victoria Australia 195 188 63
Mitt New South Wales Australia 1 1
Moe Victoria Australia 1
Mount Druitt New South Wales Australia 3 3
Mt. Isa Queensland Australia 1
Newcastle New South Wales Australia 33 20 9
Newtown New South Wales Australia 1 1 1
North Melbourne Victoria Australia 2 3 1
North Sydney New South Wales Australia 10 4 1
Northcote Victoria Australia 1
Orange New South Wales Australia 2
Parkville Victoria Australia 1 1
Perth Western Australia Australia 157 70 12
Point Cook Victoria Australia 1
Port Macquarie New South Wales Australia 13 5 3
Prahran Victoria Australia 1
Quakers Hill New South Wales Australia 1
Randwick New South Wales Australia 1
Redcliffe Queensland Australia 1 1
Ringwood Victoria Australia 2 1
Robina Queensland Australia 1
Rockhampton Queensland Australia 2 2
Sassafras Victoria Australia 1
Shellharbour New South Wales Australia 1
Shoalhaven New South Wales Australia 3
South Morang Victoria Australia 1
Spence Australian Capital Territory Australia 1
St Leonards Victoria Australia 1
St. Kilda Victoria Australia 1
Strathfield New South Wales Australia 1 3
Sunshine Coast Queensland Australia 4
Surry Hills New South Wales Australia 1
Sydney New South Wales Australia 336 298 87
Torquay Victoria Australia 1
Townsville Queensland Australia 1 1 1
Vermont Victoria Australia 1 1
Wagga Wagga New South Wales Australia 1
Windsor Queensland Australia 1
Wolli Creek New South Wales Australia 1 1
Wollongong New South Wales Australia 4 3 1
Woodside South Australia Australia 3

Related Posts:

Twitter #hashtags and the Australian election

Posted by Laura on Thursday, 19 August, 2010

Can you learn about an election by its Twitter #hashtags ? I’m curious to see if the #hashtag use on Twitter matches with what people see as the major issues that the newspapers and news media covered. (I’m also interested in seeing what #hashtags they ReTweeted but that will likely have to wait for another post.) There are a couple of challenges when doing something like this… and be wary of anyone not spelling out their methodology because if you don’t know their methods, you can’t fairly evaluate their results and subsequent conclusions. Social media research is very much creative research that takes place in the moment. While you may not ever be able to get the exact same results, when you repeat a person’s methodology, deviations should be explainable. Anyway, the challenges and assumptions with doing a #hashtag analysis of the Australian elections include:

  • Incomplete tweet set for keywords: I only get what is available from Searchtastic.
  • Incomplete tweet set based on keyword limitations: Even supposing I could get all the tweets related to a keyword, I can’t find every reference to the Australian elections as there are too many possible words that could reference the elections and all the candidates running nation wide.
  • Incomplete tweet set because of time: Some keywords were searched for earlier and some later. Not all keywords were looked at over the same period.
  • Irrelevant tweets: Keywords like #greens may refer to the Green Party in the United States. Liberals may refer to American or British liberals. Unless every tweet is examined, irrelevant tweets will remain in the data set.

To offset some of these problems, a large data set was acquired. (Because a lot of people are tweeting about the elections. I see way more election tweets than footy tweets.) These tweets were acquired using Searchtastic and the following keyword set: #Abbott, #alp, #alp vote, #arbib, #aus2010, #AusLabor, #ausvotes, #ausvotes abbott, #ausvotes gillard, #boatphone, #GILLARDTINED, #greens, #laborfail, #masterchef abbott, #masterchef debate, #masterchef election, #masterchef gillard, #myliberal, #nocleanfeed , #NPC, #ozvote, #qanda, #spill, #tcot, #workchoices, @AustralianLabor, @LiberalAus, @TonyAbbottMHR , abbott math, Abbott-Gillard, asylum boat, australia vote, canberra election, debate abbott, debate gillard, debate winner, Following: @JuliaGillard, Following: @SenatorBobBrown, Following: @TonyAbbottMHR, Gillard, greens brown, Greens Canberra, greens election, Gruen Report, Gruen transfer, hockey liberals, immigration australia, Julia Gillard, JuliaGillard, Krudd Labor, KRudd Liberals, Labor darwin, labor leaks, Labor Liberals, Labor Tasmania, Liberals Tasmania, libs abbott, libs darwin, Libs Howard, marginal electorate, marginal seats, NSWLabor, perth vote, preferences vote, Rudd Liberals, Sex Party, stimulus liberals, sydney elections, Tony Abbott, tony boat phone, tonyabbottmhr, Truss LNP, Truss nationals, Warren Truss, Work Choices Australia, WorkChoices .

These keywords represent the major parties and candidates, some of the major issues, #hashtags that I saw on my Twitter feed, and different geographic areas around the country. Searches were run between July 19 and August 19. A total of 57,977 tweets were collected. The elections were called on July 17. To make sure that the collection of tweets pertain to the elections, all tweets made before July 1 were removed from the data set. (Methodology: Sort tweets by date on Excel. Remove those tweets not between those dates.) By then, everyone knew the elections had to be called and conversation regarding them had started. This takes the total tweets in the data set down to 21,071. That’s still a fairly large collection of tweets to work from. The next step is to remove duplicate tweets from the data set. (On Excel, Data -> Filter -> Advanced Filter -> Unique records only.) This brings the total tweets down to 18,462. That’s still a lot of tweets.

The next step is to extract #hashtags. To do this, I copy and pasted all the tweets to Notepad. I ran a find and replace for [space]# and replaced with [tab]#. I copy and pasted these back, removed all cells that did not start with a #. After this was done, the data set was copy and pasted back to Notepad. Another find and replace was done, this time, [space] was replaced with [tab]. This was pasted back to excel and all cells that did not start with # were deleted. When this was done, 33,857 total hashtags were found. Symbols like , ! . – ? were removed from those #hashtags. This was done to make that #labor. and #labor were treated the same for counting purposes.

A list of unique hashtags was then attained of which there were 2,678. The following table includes all #hashtags that appeared 250 or more times on the list:

Tweet Count
#tcot 5157
#ausvotes 2449
#tlot 1816
#p2 1761
#teaparty 1704
#GOP 1172
#ocra 950
#Libertarian 920
#News 867
#ucot 705
#politics 687
#Israel 536
#sgp 536
#iamthemob 367
#jcot 308
#roft 304
#qanda 303
#cdnpoli 293
#Twisters 261
#USA 209
#Obama 194
#MyLiberal 187
#debate 183
#flotilla 171
#Gaza 155
#masterchef 154
#energy 149
#hhrs 147
#green 134
#rpn 121
#912 111
#aus2010 111
#NPC 108
#rootyq 101
#AUSlabor 95
#oilspill 94
#topprog 94
#nocleanfeed 92
#fb 88
#rightriot 80
#laborfail 79
#spill 76
#US 76
#jews 75
#ALP 74
#terrorism 74
#Greens 72
#cspj 70
#tpp 70
#BP 69
#antisemitism 68
#Gillard 67
#p21 67
#openinternet 66
#FF 65
#FollowFriday 65
#oil 65
#Muslim 64
#ireland 63
#Abbott 62
#UK 61
#Australia 58
#Iran 58
#Palin 57
#Blog 55
#Europe 54
#quote 54
#dnc 52
#fail 51
#iranelection 51
#jlot 51
#hcr 47
#MentalHealth 47
#justsayin 46
#rs 46
#eco 44
#boatphone 43
#glennbeck 43
#islam 42
#zionism 42
#NBN 41
#palestine 41
#jobs 40
#environment 39
#Autism 36
#Hamas 36
#Health 36
#military 36
#tiot 36
#dem 35
#AZ 34
#Lebanon 34
#vote2010 34
#dems 33
#ausdebate 32
#bonjovi 32
#climate 32
#judaism 32
#lateline 32
#MoFo 32
#videos 32
#foxnews 31
#theview 31
#730report 30
#hasbara 30
#nz 30
#travel 30
#tweetcongress 30
#YWC 30
#conservative 29
#Gulf 29
#patriottweets 29
#AFRICA 28
#ampat 28
#dublin 28
#property 28
#WORLDCUP 28
#beck 27
#Free 27
#IDF 27
#ronpaul 27
#acon 26
#jewish 26
#twibbon 26
#bds 25
#CNN 25
#Obamacare 25
#rush 25

Looking at this list, there are some phrases that are likely not Australian or not uniquely Australian. This includes #tcot, which stands for Top Conservatives On Twitter. The term was amongst those searched for because it appeared in a few tweets that also included the #ausvotes #hashtag. A google search for #tcot #ausvotes only brings up 8,120, which further supports the idea that this isn’t really an Australian election term. #tlot was not deliberately searched for in terms of trying to include it. If you put #tlot #ausvotes into a google search, you get 244,000 results which suggests heavy Australian usage. You could probably remove #teaparty, #GOP, #Libertarian, #Israel, #Twisters, #USA, #Obama, #flotilla, #Gaza, #912, #oilspill, #US, #jews, #BP, #antisemitism, #oil, #Muslim, #ireland, #UK, #Iran, #Palin, #Europe, #dnc, #cdnpoli, and #iranelection. They are unlikely to do with the Australian elections.

If that’s agreed upon, then it looks like top issues based on #hashtags … the internet and its openness? It doesn’t look like there was any large scale usage of #hashtags around issues. Instead, it appears that #hashtags were used to label tweets that discussed the election, were used to discuss specific candidates and to discuss specific parties. Issue based discussion may have been secondary to Twitter discussion.

And if that’s true, and going further with that idea, it could validate the messaging used by Labor and the Liberals to largely mount attacks on each other. People on Twitter are heavily engaged in discussing politics but not the issues. It may also justify the work of GetUp!, which strives to bring attention to specific issues in Australia.

If you want access to the Excel file with all the tweets, please comment or send me an e-mail. The file is about 24meg so I didn’t upload it.

Related Posts:

What domains in #afl related tweets get the most RT@ ReTweets?

Posted by Laura on Thursday, 19 August, 2010

This post is a follow up to What #afl related hashtags get the most RT @ ReTweets? and Want to be Retweeted? Add URLs to Your Tweets!. This post looks at the what domains get the most retweets in tweets related to the AFL. It borrows the methodology (and assumptions) from the previous post with two major differences. First, the tweet collection had 10,412 total tweets instead of 8,523 at the start. (More recent tweets and more tweets.) Second, a new tool was needed to lengthen short urls. The tool that was used was Long URL please, a FireFox extension. Short links were copy pasted from Excel to a draft document, urls were lengthened and then pasted back. (When URLs were not lengthened, they were manually visited to get the real url.)

That out of the way, there 10,412 total tweets that could be examined. The list of keywords used can be found at using my raw data. Duplicate Tweets were removed bringing the total to 6,313 unique tweets. Tweets that did not include a url were removed. This brought the Tweet total down to 2,892 tweets. (About 46% of AFL related Tweets include a URL. This compares to 52% of AFL related Tweets with #hashtags.) There were 2,941 urls in these Tweets, with 2,582 unique urls in these Tweets. Of these, there were 623 unique domains. For all AFL related Tweets with urls, the following domains were the most popular:

Domains Count
http://afl.com.au 248
http://foxsports.com.au 140
http://heraldsun.com.au 115
http://au.sport.yahoo.com 112
http://abc.net.au 101
http://aflfeeds.com 67
http://twitpic.com 67
http://sportal.com.au 65
http://couriermail.com.au 64
http://news.aflspace.com 60
http://news.google.com 51
http://twitter.com 49
http://facebook.com 47
http://youtube.com 41
http://feedproxy.google.com 37
http://portadelaidefc.com.au 36
http://theage.com.au 34
http://skynews.com.au 32
http://bigpondnews.com 27
http://essendonfc.com.au 26
http://sportsnewsodds.com 26
http://yfrog.com 25
http://askbiography.com 24
http://sydneyswans.com.au 23
http://tweetphoto.com 21
http://adelaidenow.com.au 19
http://news.smh.com.au 19
http://saints.com.au 19
http://twitlonger.com 19
http://footyheads.com.au 18
http://melbournefc.com.au 18
http://sports.espn.go.com 18
http://contestedfooty.com 17
http://hawthornfc.com.au 17
http://thebigtip.com.au 17
http://themonk.com.au 15
http://feeds.feedburner.com 14
http://feeds.theroar.com.au 14
http://https: 14
http://flickr.com 13
http://oohja.com 13
http://rttf.posterous.com 13
http://topikality.com 13
http://yoursupercoachcoach.com 13
http://foursquare.com 12
http://mashable.com 12
http://racingandsports.com.au 12
http://theaustralian.com.au 12
http://3aw.com.au 11
http://dailymail.co.uk 11
http://3ba.com.au 10
http://blog.aflcio.org 10
http://goldcoastfc.com.au 10
http://huffingtonpost.com 10
http://news.brisbanetimes.com.au 10

Of the Tweets with urls, only 342 of them were ReTweets. That means about 5% of AFL related ReTweets contain domains. (Compare that to ReTweets containing #hashtags: 8%.) There were 150 domains mentioned Amongst those, the following domains were the most popular:

Domains Count
http://twitpic.com 23
http://essendonfc.com.au 17
http://heraldsun.com.au 15
http://sydneyswans.com.au 13
http://hawthornfc.com.au 10
http://youtube.com 10
http://twitlonger.com 9
http://afl.com.au 8
http://twitter.com 8
http://feeds.feedburner.com 7
http://mashable.com 7
http://saints.com.au 7
http://feedproxy.google.com 6
http://tweetphoto.com 6
http://3aw.com.au 5
http://blog.aflcio.org 5
http://aflpablog.com.au 4
http://facebook.com 4
http://flickr.com 4
http://melbournefc.com.au 4
http://patdollard.com 4
http://portadelaidefc.com.au 4
http://thebigtip.com.au 4
http://yfrog.com 4
http://afc.com.au 3
http://dailymail.co.uk 3
http://geelongadvertiser.com.au 3
http://goldcoastfc.com.au 3
http://kangaroos.com.au 3
http://skynews.com.au 3
http://sportsnewsfirst.com.au 3
http://abc.net.au 2
http://bigfooty.com 2
http://community.thisisplymouth.co.uk 2
http://diamondkpartypeople.blogspot.com 2
http://dreamteam2010.org 2
http://images.slatterymedia.com 2
http://live.tech45.eu 2
http://mtv.com 2
http://myloc.me 2
http://rttf.posterous.com 2
http://theage.com.au 2
http://videos.onsmash.com 2
http://votesmart.com.au 2
http://watoday.com.au 2

The domains that are ReTweeted are interesting. It is really easy to link spam on Twitter and some people and organizations do. If you look at some accounts, they post view TwitterFeed. Beyond that, you can tell when looking at a URL list that automated link posting is happening because the account may be using a URL shortener that isn’t as popular and the URLs tend to follow a sequence. The AFL and various news services put out URLs and they just aren’t getting ReTweeted at the same rate that they are getting posted. What is getting ReTweeted? People’s pictures and club related links.

Looking at both the domain list and the Domain ReTweet list, one thing that stands out for me is the lack of Wikipedia links. Wikipedia ranks really high on Google and other search engines. The AFL related content is highly ranked. The AFL articles are often really, really, really good and they are updated frequently. They can be really useful when looking for historical information. Thus, I’m surprised that there were only 3 references to Wikipedia. What gives? Why isn’t Wikipedia being cited more?

Moving on, 488 accounts were mentioned in the 343 ReTweets with URLs. The following table gives an idea as to who the most popular mentions were:

Mentioned Count
@essendon_fc 22
@sydneyswans 20
@hawthornfc 12
@stkildafc 12
@AFL 11
@AFLPA 10
@AFLCIO 8
@superfooty 8
@Footyfree 7
@RTTF_AU 7
@mashable 6
@3AW693 5
@adelaide_fc 5
@blackpolitics 5
@Collingwood_FC 5
@StevenBaker10 5
@DJPANIIC 4
@GoldCoastFC 4
@heraldsun 4
@PAFCNews 4
@PatDollard 4
@watoday 4
@antonKart 3
@Carlton_FC 3
@DemonsHQ 3
@iamdiddy 3
@mydogateart 3
@myfabolouslife 3
@northkangaroos 3
@redcafesd 3
@reggie_bush 3
@ruanji 3
@Sportsnewsfirst 3
@TeamHippo 3

That Essendon and Sydney were amongst the most mentioned doesn’t come as a surprise: Their domains were highly ranked. What is a bit surprising that the Blues aren’t highly ranked; they ranked highly for mentions with #hashtags. St. Kilda ranked highly on both lists. I half want to attribute this to the idea that their audience may be more Twitter savvy than other clubs’s fans. I’d have thought players might have been higher on this list but they really don’t appear to be a factor. This may suggest that players are not Tweeting urls or that content isn’t what their fans are interested in.

The lesson of these two posts is that if you want your AFL related tweets reposted, be partisan in your support and link to official club content that the news services haven’t yet written about yet.

Related Posts:

Methodology: Draft/Free writing (part 2)

Posted by Laura on Wednesday, 18 August, 2010

This is an update of a draft of my methodology section. I finally got back to writing it as I took some time off from it and my literature review. This is very much a draft intended for me to explore concepts of what types of online research exist as it pertains to social media. After the major methods are spelled out, the intend is to go further into population studies, the why and how of them. This should be followed up with the methodology for what I’m actually doing. That last part will ultimately be the shortest as population studies aren’t that hard to do. The major methodology parts will actually be spelled out in the individual sections and will follow a format similar to ones that I’ve done for other posts here.

Methodology

When conducting social media research, there are ten general methods that can be used to gather and analyze data. These are:

1. Individual case studies for how a business uses social media and the web,
2. Search and traffic analytics analysis,
3. Sentiment analysis and reputation management,
4. Content analysis,
5. Usability studies,
6. Interaction and collaboration analysis,
7. Relationship analysis to try to determine how people interact and to identify key influencers, and
8. Population studies
9. Online target analysis of behavior and psychographics,
10. Predictive analysis.

Each of these methods offers insights into various aspects of the web and its population. The type of analysis used is often specific to the purpose of the research, involved blended approaches from traditional analysis types, and different methods are often used in conjunction with each other. These methods often blend quantitative and qualitative analysis. Choosing the correct method of gathering analyzing data can be one of the biggest hurdles for being able to measure ROI and understand how a community works.
This section will provide a brief summary of each type, explain how to conduct this type of research and give examples that used that methodology.

Online target analysis of behavior and psychographics

Online targeting of and marketing towards a specific audience because of their demographic characteristics is extremely common on the Internet. Psychographics is a term that includes targeting towards a specific demographic group except it includes the offline component.

Sutherland and Canwell (2004) define psychographics as “market research and market segmentation technique used to measure lifestyles and to develop lifestyle classifications.” (p. 247) Nicolas (2009) defines online behaviorial analysis as a series of steps: Collecting user data across several sites, organizing information about users based on the sites they visit and their behavior on those sites, “infer demographics and interest data”, and classifying new users based on the collected data in order to deliver relevant ads and content based their demographic profiles. Kinney, McDaniel, and DeGaris (2008) define psychographics as attitude towards something such as a brand or involvement with an organization.

Given the methodology involved, much of this type of research involves action research in that it is done in a specific content, based on internal models to address specific situations.

An example of this type of research was done by Kinney, McDaniel, and DeGaris (2008) who investigated the demographic characteristics of NASCAR fans and their attitudes towards NASCAR, its sponsors and sponsor involvement with NASCAR. The research found that age, gender and education were all important variables in determining sponsor recall: Younger, more educated males had the best brand recall amongst NASCAR fans.

This type of research can be viewed as a subcomponent of a population study in that demographic information is sought about the population. In an online context, it often works in conjunction with search and traffic analytics analysis, content analysis, and interaction and collaboration analysis.

Predictive analysis

A search on 13 July 2010 on SPORTDiscus had three results for “predictive analysis.” A search on the same date on Scopus had 605 results, 275 of which were in engineering, 132 in computer science and 102 in medicine. Predictive analysis is probably one of the least used analysis methods, especially in social media and fandom.

What is predictive analysis? At its simplest, it is identifying a future event or events, monitoring selection actions that precede the event and seeing if those events can be used to predict the outcome of similar events in the future. If a predictive value is found, an organization can monitor behaviors to help make more informed decisions.
An example of this type of research is “Predicting the Future With Social Media” by Asur and Huberman (2010). Their goal was to determine if tweet volume and sentiment on Twitter prior to a movie being released could be used to predict how well a movie performs at the box office. Their methodology involved identifying movie wider release dates that took place on a Friday, creating a list of keyword searches related to those movies, and using the Twitter API to collect all tweets and aggregate date that mention those keywords over a three month time period. The authors then compared the tweet volume to box office performance. They concluded that social media “can be used to build a powerful model for predicting movie box-office revenue.” (Asur & Huberman, 2010)

This type of research can be used in conjunction with other methods. It can be used along side a population study to see if certain actions will result in demographic changes.

References

Asur, S., & Huberman, B. A. (2010). Predicting the Future With Social Media. Social Computing Lab. Retrieved from http://www.hpl.hp.com/research/scl/papers/socialmedia/socialmedia.pdf

Kinney, L., McDaniel, S., & DeGaris, L. (2008). Demographic and psychographic variables predicting NASCAR sponsor brand recall. International Journal of Sports Marketing & Sponsorship, 9(3), 169-179. Retrieved from SPORTDiscus with Full Text database.

Nicolas, P. (2009, December 17). “Online audience behavior analysis and targeting.” Patrick Nicolas Official Home Page. Retrieved August 1, 2010, from http://www.pnexpert.com/Analytics.html

Sutherland, J., & Canwell, D. (204). Key Concepts in Marketing. Palgrave Key Concepts. Hampshire, England: Palgrave MacMillan.

Related Posts:

Perth sport fandom size

Posted by Laura on Monday, 16 August, 2010

I feel guilty as I’m kind of posting as I do with out any particular pattern. Anyway, I looked at Google.com.au and friendster (both of which have a load of garbage unrelated results) and recorded the totals for number of results for each team. I also did that bebo, care2 and blogger. (I also did ecademy and blackplanet but results were 0 the whole way through.) I’ll see if I feel like exploring and recording the size of the Perth sport fandom some more. The following table includes the results so far. If you have methodology questions, let me know.

43things.com Bebo – Groups Bebo – People Bebo – Videos Blogger Care2 – Blogs Care2 – Petitions Friendster – Groups Google Total Minus F & G Total
AFL West Coast Eagles 3 44 300 120 24 8 2 1006 273,000 501 274507
A-League Perth Glory FC 0 19 28 79 5 8 0 1072 325,000 139 326211
AFL Fremantle Dockers 5 17 85 18 10 1 0 12 116,000 136 116148
Super 14 Western Force 0 17 54 52 2 3 0 1005 196,000 128 197133
Claxton Shield Perth Heat 0 0 27 0 0 0 0 869 35,700 27 36596
WNBL West Coast Waves 0 2 5 18 0 0 0 1006 36,400 25 37431
Sheffield Shield Western Warriors 0 3 17 3 0 0 0 1004 20,700 23 21727
NBL Perth Wildcats 0 1 3 4 1 0 0 556 33,600 9 34165
WAFL Perth Demons Football Club 0 2 7 0 0 0 0 944 17,100 9 18053
S.G. Ball Cup Western Australia Reds Rugby League Club 0 0 4 2 0 0 0 371 19,600 6 19977
Australian Rugby Championship Perth Spirit 0 1 4 0 0 0 0 1078 10,300 5 11383
WNCL Western Fury 0 0 1 2 0 0 0 1010 85,700 3 86713
WAFL Claremont Tigers Football Club 0 0 3 0 0 0 0 297 13,200 3 13500
AHL WA Diamonds 0 0 1 2 0 0 0 345 7,560 3 7908
WNBL Perth Lynx 0 0 2 1 0 0 0 326 4,440 3 4769
Gridiron Australia Perth Blitz 0 0 0 3 0 0 0 484 2,110 3 2597
WAFL East Fremantle Sharks Football Club 0 0 2 0 0 0 0 1002 83,100 2 84104
WAFL West Perth Falcons Football Club 0 0 2 0 0 0 0 1069 32,700 2 33771
WAFL East Perth Royals Football Club 0 0 1 0 0 0 0 1071 95,300 1 96372
WAFL Subiaco Lions Football Club 0 0 0 0 1 0 0 333 3,660 1 3994
ANZ Championship West Coast Fever 0 0 0 0 0 0 0 1006 99,900 0 100906
WAFL South Fremantle Bulldogs Football Club 0 0 0 0 0 0 0 1003 88,300 0 89303
Western Australian Suburban Turf Cricket Association (WASTCA) Subiaco Marist Cricket Club 0 0 0 0 0 0 0 1002 17,400 0 18402
WAFL Peel Thunder Thunder Football Club 0 0 0 0 0 0 0 680 14,200 0 14880
State Basketball League (Western Australia) (SBL) Perth Redbacks 0 0 0 0 0 0 0 266 12,200 0 12466
State Basketball League (Western Australia) (SBL) Goldfields Giants 0 0 0 0 0 0 0 191 6,710 0 6901
WAFL Swan Districts Swans Football Club 0 0 0 0 0 0 0 614 2,440 0 3054
AHL SmokeFree WA Thundersticks 0 0 0 0 0 0 0 0 3,020 0 3020
Gridiron Australia Perth Broncos 0 0 0 0 0 0 0 277 670 0 947

Related Posts:

43things.com and Perth based sport clubs

Posted by Laura on Monday, 16 August, 2010

I haven’t done a real data dump day in a while and today appears to be the day. I want a distraction and trying to figure out the most popular sport teams in the Perth area fits the bill. The first is a list of goals for each time on 43things.com.

Service League Team Keyword Results Relevant goals Relevant goals + people Date checked
43things.com AFL Fremantle Dockers Fremantle Dockers 7 5 5 16-Aug-10
43things.com AFL West Coast Eagles West Coast Eagles 3035 2 3 16-Aug-10
43things.com AHL SmokeFree WA Thundersticks WA Thundersticks 1201 0 0 16-Aug-10
43things.com AHL SmokeFree WA Thundersticks thundersticks 0 0 0 16-Aug-10
43things.com AHL WA Diamonds WA Diamonds 281 0 0 16-Aug-10
43things.com A-League Perth Glory FC Perth Glory 202 0 0 16-Aug-10
43things.com ANZ Championship West Coast Fever West Coast Fever 3019 0 0 16-Aug-10
43things.com Australian Rugby Championship Perth Spirit Perth Spirit 112 0 0 16-Aug-10
43things.com Australian Rugby Championship Perth Spirit perth rugby 13 0 0 16-Aug-10
43things.com Claxton Shield Perth Heat Perth Heat 254 0 0 16-Aug-10
43things.com Gridiron Australia Perth Blitz Perth Blitz 10 0 0 16-Aug-10
43things.com Gridiron Australia Perth Broncos Perth Broncos 8 0 0 16-Aug-10
43things.com NBL Perth Wildcats Perth Wildcats 9 0 0 16-Aug-10
43things.com S.G. Ball Cup Western Australia Reds Rugby League Club red rugby 198 0 0 16-Aug-10
43things.com Sheffield Shield Western Warriors Western Warriors 483 0 0 16-Aug-10
43things.com State Basketball League (Western Australia) (SBL) Goldfields Giants Goldfields Giants 93 0 0 16-Aug-10
43things.com State Basketball League (Western Australia) (SBL) Perth Redbacks Perth Redbacks 99 0 0 16-Aug-10
43things.com Super 14 Western Force Western Force 919 0 0 16-Aug-10
43things.com WAFL Claremont Tigers Football Club Claremont Football Club 4545 0 0 16-Aug-10
43things.com WAFL East Fremantle Sharks Football Club East Fremantle Sharks 1356 0 0 16-Aug-10
43things.com WAFL East Perth Royals Football Club East Perth Royals 1102 0 0 16-Aug-10
43things.com WAFL Peel Thunder Thunder Football Club Peel Thunder Thunder 83 0 0 16-Aug-10
43things.com WAFL Perth Demons Football Club Perth Demons 98 0 0 16-Aug-10
43things.com WAFL South Fremantle Bulldogs Football Club South Fremantle Bulldogs 2808 0 0 16-Aug-10
43things.com WAFL Subiaco Lions Football Club Subiaco Lions 101 0 0 16-Aug-10
43things.com WAFL Swan Districts Swans Football Club Swan Districts Swans 120 0 0 16-Aug-10
43things.com WAFL West Perth Falcons Football Club West Perth Falcons 1618 0 0 16-Aug-10
43things.com Western Australian Suburban Turf Cricket Association (WASTCA) Subiaco Marist Cricket Club Subiaco Marist Cricket Club 179 0 0 16-Aug-10
43things.com Western Australian Suburban Turf Cricket Association (WASTCA) Subiaco Marist Cricket Club perth cricket 13 0 0 16-Aug-10
43things.com WNBL Perth Lynx Perth Lynx 6 0 0 16-Aug-10
43things.com WNBL West Coast Waves West Coast Waves 3104 0 0 16-Aug-10
43things.com WNCL Western Fury Western Fury 448 0 0 16-Aug-10

Related Posts: