FAQ | Problem?

Tesco_2018-09-14_03-40-28.xlsx
Tesco_2018-09-14_03-40-28.xlsx
From:
NodeXLExcelAutomator
Uploaded on:
September 14, 2018
Short Description:
Tesco via NodeXL http://bit.ly/2Nfrwv1
@tesco
@bootstrapcook
@jamieoliver
@manyana47087653
@imajsaclaimant
@leyla_talbot
@madeinpoortaste
@sugarspotannie
@goldenoldiec
@that_bennett_96

Top hashtags:
#tesco
#win
#giveaway
#vegan
#bagsofhelp
#competition
#freebiefriday

Description:
Description
The graph represents a network of 5,747 Twitter users whose tweets in the requested range contained "Tesco", or who were replied to or mentioned in those tweets. The network was obtained from the NodeXL Graph Server on Friday, 14 September 2018 at 10:41 UTC.

The requested start date was Friday, 14 September 2018 at 00:01 UTC and the maximum number of days (going backward) was 14.

The maximum number of tweets collected was 5,000.

The tweets in the network were tweeted over the 1-day, 14-hour, 52-minute period from Wednesday, 12 September 2018 at 09:08 UTC to Friday, 14 September 2018 at 00:00 UTC.

Additional tweets that were mentioned in this data set were also collected from prior time periods. These tweets may expand the complete time period of the data.

There is an edge for each "replies-to" relationship in a tweet, an edge for each "mentions" relationship in a tweet, and a self-loop edge for each tweet that is not a "replies-to" or "mentions".

The graph is directed.

The graph's vertices were grouped by cluster using the Clauset-Newman-Moore cluster algorithm.

The graph was laid out using the Harel-Koren Fast Multiscale layout algorithm.


Author Description


Overall Graph Metrics
Vertices : 5747
Unique Edges : 6806
Edges With Duplicates : 2343
Total Edges : 9149
Number of Edge Types : 3
Mentions : 5706
Tweet : 1269
Replies to : 2174
Self-Loops : 1269
Reciprocated Vertex Pair Ratio : 0.061498200850507
Reciprocated Edge Ratio : 0.115870570107858
Connected Components : 1629
Single-Vertex Connected Components : 837
Maximum Vertices in a Connected Component : 2374
Maximum Edges in a Connected Component : 5942
Maximum Geodesic Distance (Diameter) : 11
Average Geodesic Distance : 3.396028
Graph Density : 0.000196534083582766
Modularity : 0.626337
NodeXL Version : 1.0.1.403

Top Influencers: Top 10 Vertices, Ranked by Betweenness Centrality
Top URLs
Top URLs in Tweet in Entire Graph:
[111] https://twitter.com/tesco/status/1039071558189371392
[92] https://twitter.com/login?redirect_after_login=/messages/compose?recipient_id=271986064
[65] https://twitter.com/tesco/status/1039531643365715968
[42] https://twitter.com/Tesco/status/1039531643365715968
[40] https://twitter.com/Tesco/status/1039071558189371392
[34] https://www.bbc.co.uk/news/business-45488402
[24] https://www.thedailymash.co.uk/news/business/tesco-launches-pre-binned-bagged-salad-20170601128641
[19] https://trib.al/ZhZUf3N
[16] https://www.marketingweek.com/2018/09/13/mark-ritson-tesco-jacks-aldi/
[13] https://www.tesco-baby.com/baby/baby-checklists/10-top-buys-to-help-you-live-a-little-more-sustainably/

Top URLs in Tweet in G1:
[92] https://twitter.com/login?redirect_after_login=/messages/compose?recipient_id=271986064
[13] https://www.tesco-baby.com/baby/baby-checklists/10-top-buys-to-help-you-live-a-little-more-sustainably/
[5] https://twitter.com/tesco/status/1039531643365715968
[4] https://www.tesco.com/groceries/en-GB/promotions/A32489902
[4] https://youtu.be/S5En8BdoJak
[4] https://www.plantbasednews.org/post/vegan-magnums-available-now-in-uk
[4] https://twitter.com/Tesco/status/1039531643365715968
[3] http://tes.co/HealthyMadeEasy
[3] https://po.st/scms/OrMCe04Lcp0lOFmbgkG-UGn1xaoFxb14cbhKewYi-TswOAp7/TescoAndJamie
[2] https://www.tescoplc.com/little-helps-plan/products-packaging/

Top URLs in Tweet in G2:
[42] https://twitter.com/tesco/status/1039531643365715968
[34] https://twitter.com/Tesco/status/1039531643365715968
[22] https://www.bbc.co.uk/news/business-45488402
[13] https://twitter.com/tesco/status/1039071558189371392
[4] https://www.bbc.com/news/business-45488402
[4] http://outlawsradio.airtime.pro/
[3] https://www.theguardian.com/business/2018/sep/11/tesco-launch-discount-chain-aldi-lidl-jacks?CMP=share_btn_tw
[3] https://twitter.com/Tesco/status/1039071558189371392
[3] https://www.dailymail.co.uk/sport/football/article-6159761/You-called-Gea-Sanchez-drops-huge-bag-Doritos-way-Tesco.html
[3] https://www.kentlive.news/whats-on/shopping/tesco-asda-lidl-sainsburys-urgently-1980319

Top URLs in Tweet in G3:
[4] https://secure.greenpeace.org.uk/page/content/shoppers-revolt
[2] http://northernfinancialreview.com/2018/09/13/morrisons-first-half-revenue-up-4-5-to-8-8bn/
[1] https://buff.ly/2Mo5CAf
[1] https://twitter.com/aplastic_planet/status/1039788809079189504
[1] https://www.theguardian.com/environment/2018/sep/10/plastic-waste-set-to-beat-price-as-uk-shoppers-top-concern-study?CMP=twt_a-environment_b-gdneco
[1] https://twitter.com/bruce_southside/status/1040164657758126080
[1] https://twitter.com/natalieben/status/1040148046057799680
[1] https://twitter.com/ellieskitchenuk/status/1035496057436889088
[1] https://twitter.com/morrisons/status/1027100050873298944
[1] https://twitter.com/IcelandRichard/status/1039773295896395776

Top URLs in Tweet in G4:
[1] https://twitter.com/thabearded1/status/1039934998328090626

Top URLs in Tweet in G5:
[1] https://metro.co.uk/2018/09/12/thug-spray-paints-homeless-man-sitting-outside-supermarket-7935999/

Top URLs in Tweet in G8:
[1] https://wingsoverscotland.com/the-six-key-facts-about-gers-2018-edition/#more-105649
[1] https://www.theguardian.com/politics/2017/aug/23/independent-scotland-would-need-to-cut-deficit-says-sturgeon
[1] https://europa.eu/european-union/about-eu/countries/member-countries_en

Top URLs in Tweet in G9:
[39] https://twitter.com/tesco/status/1039071558189371392

Top URLs in Tweet in G10:
[3] http://thenational.scot/news/16859653.scots-firm-brewgooder-to-give-ghana-clean-water-thanks-to-tesco-deal/

Top Domains
Top Domains in Tweet in Entire Graph:
[514] twitter.com
[166] co.uk
[63] tesco.com
[26] theguardian.com
[25] marketingweek.com
[23] instagram.com
[22] trib.al
[21] youtube.com
[18] facebook.com
[18] tesco-careers.com

Top Domains in Tweet in G1:
[126] twitter.com
[53] tesco.com
[14] tesco-careers.com
[13] tesco-baby.com
[12] co.uk
[7] tes.co
[4] youtu.be
[4] youtube.com
[4] swarmapp.com
[4] plantbasednews.org

Top Domains in Tweet in G2:
[156] twitter.com
[65] co.uk
[18] instagram.com
[10] facebook.com
[9] sharethislah.com
[8] theguardian.com
[7] alljobsintheuk.com
[7] swarmapp.com
[7] kentlive.news
[6] marketingweek.com

Top Domains in Tweet in G3:
[8] twitter.com
[4] org.uk
[2] northernfinancialreview.com
[1] buff.ly
[1] theguardian.com
[1] medium.com
[1] co.uk

Top Domains in Tweet in G4:
[1] twitter.com

Top Domains in Tweet in G5:
[1] co.uk

Top Domains in Tweet in G8:
[1] wingsoverscotland.com
[1] theguardian.com
[1] europa.eu

Top Domains in Tweet in G9:
[39] twitter.com

Top Domains in Tweet in G10:
[3] thenational.scot

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[113] tesco
[101] win
[66] giveaway
[21] vegan
[21] bagsofhelp
[20] competition
[19] freebiefriday
[15] larazade
[15] louisvuittondabomb
[14] community



Top Hashtags in Tweet in G1:
[21] tesco
[21] win
[17] vegan
[15] larazade
[13] oumph
[11] bigcollection
[10] tescoandjamie
[9] gbbo
[6] shareoumphwithfriends
[6] bagsofhelp

Top Hashtags in Tweet in G2:
[33] tesco
[5] heartnews
[4] jamieoliver
[3] shopwellforless
[3] retail
[3] vegan
[3] amazon
[2] shopping
[2] retailnews
[2] wine

Top Hashtags in Tweet in G3:
[79] win
[62] giveaway
[19] freebiefriday
[18] competition
[7] shoppersrevolt
[2] compostable
[2] composting
[2] tesco
[2] sainsburys
[2] plasticfree

Top Hashtags in Tweet in G4:
[1] jaipurinacan
[1] yeswecan
[1] jaipuripa
[1] dothecancan
[1] canyoubelieveit
[1] cheapbooze
[1] autocorrect

Top Hashtags in Tweet in G8:
[1] keepscotlandthebrand

Top Words
Top Words in Tweet in Entire Graph:
[3682] Words in Sentiment List#1: Positive
[2541] Words in Sentiment List#2: Negative
[28] Words in Sentiment List#3: Angry/Violent
[112808] Non-categorized Words
[119032] Total Words
[4476] tesco
[633] s
[381] 2
[379] out
[363] jamieoliver

Top Words in Tweet in G1:
[1402] tesco
[343] jamieoliver
[265] 2
[233] hi
[188] thanks
[178] store
[169] please
[143] sorry
[136] s
[116] 1

Top Words in Tweet in G2:
[789] tesco
[117] s
[73] t
[58] out
[57] going
[50] discount
[49] now
[45] one
[44] new
[44] up

Top Words in Tweet in G3:
[206] tesco
[202] win
[131] asda
[72] meatlust
[66] sainsburys
[65] 1
[62] bottle
[62] giveaway
[62] fact
[61] 50

Top Words in Tweet in G4:
[54] tesco
[48] thornbridge
[33] cans
[32] lovely
[24] jaipur
[24] here
[17] case
[17] s
[16] missed
[16] news

Top Words in Tweet in G5:
[66] depraved
[66] deal
[66] beggars
[66] street
[66] thug
[66] sprays
[66] homeless
[66] man
[66] red
[66] paint

Top Words in Tweet in G6:
[58] adult
[57] kid
[57] always
[57] thought
[57] going
[57] supermarket
[57] funnest
[57] shit
[57] now
[57] m

Top Words in Tweet in G7:
[59] tesco
[59] employee
[58] please
[58] boss
[58] put
[58] each
[58] individual
[58] pea
[58] mouth
[58] spit

Top Words in Tweet in G8:
[102] tesco
[94] keepscotbrand
[89] serena_arif
[28] scottish
[24] stuartpoet
[23] british
[20] scotland
[19] swanage123
[16] s
[16] ankhassa

Top Words in Tweet in G9:
[55] meal
[38] goodbye
[38] deal
[37] mothecomedian
[17] seen
[17] jamie
[17] oliver
[17] tesco
[17] s
[17] new

Top Words in Tweet in G10:
[3] brewgooder
[3] already
[3] helped
[3] more
[3] 40
[3] 000
[3] people
[3] malawi
[2] scotnational

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[280] tesco,jamieoliver
[136] tesco,s
[130] meal,deals
[128] win,win
[101] meal,deal
[98] outside,tesco
[96] jamie,oliver
[93] don,t
[93] tesco,keepscotbrand
[93] asda,tesco

Top Word Pairs in Tweet in G1:
[276] tesco,jamieoliver
[68] full,name
[65] 1,2
[64] 2,2
[41] dm,full
[41] please,dm
[34] really,sorry
[30] don,t
[28] pass,details
[28] tesco,stores

Top Word Pairs in Tweet in G2:
[39] tesco,s
[28] tesco,supermarket
[26] supermarket,going
[26] going,discount
[26] discount,jack's
[26] jamie,oliver
[18] meal,deals
[17] went,tesco
[17] don,t
[16] go,tesco

Top Word Pairs in Tweet in G3:
[120] win,win
[74] asda,tesco
[61] 1,50
[60] win,5x
[60] 5x,bottle
[60] bottle,giveaway
[60] giveaway,celebrate
[60] celebrate,fact
[60] fact,promotion
[60] promotion,1

Top Word Pairs in Tweet in G4:
[23] jaipur,cans
[23] cans,here
[22] thornbridge,tesco
[16] case,missed
[16] missed,news
[16] news,jaipur
[16] here,s
[16] s,lovely
[16] lovely,gif
[16] gif,illustrate

Top Word Pairs in Tweet in G5:
[66] depraved,deal
[66] deal,beggars
[66] beggars,street
[66] street,thug
[66] thug,sprays
[66] sprays,homeless
[66] homeless,man
[66] man,red
[66] red,paint
[66] paint,outside

Top Word Pairs in Tweet in G6:
[57] kid,always
[57] always,thought
[57] thought,going
[57] going,supermarket
[57] supermarket,adult
[57] adult,funnest
[57] funnest,shit
[57] shit,now
[57] now,m
[56] mermatriarch,kid

Top Word Pairs in Tweet in G7:
[59] tesco,employee
[58] employee,please
[58] please,boss
[58] boss,put
[58] put,each
[58] each,individual
[58] individual,pea
[58] pea,mouth
[58] mouth,spit
[58] spit,back

Top Word Pairs in Tweet in G8:
[93] tesco,keepscotbrand
[49] serena_arif,tesco
[17] stuartpoet,serena_arif
[15] swanage123,stuartpoet
[10] gorbalsgoebbels,tesco
[8] scotlandsfuture,tesco
[8] union,flag
[7] hi,tesco
[7] don,t
[7] lynnemccormic20,stuartpoet

Top Word Pairs in Tweet in G9:
[38] goodbye,meal
[38] meal,deal
[37] mothecomedian,goodbye
[17] seen,jamie
[17] jamie,oliver
[17] oliver,tesco
[17] tesco,s
[17] s,new
[17] new,healthy
[17] healthy,eating

Top Word Pairs in Tweet in G10:
[3] brewgooder,already
[3] already,helped
[3] helped,more
[3] more,40
[3] 40,000
[3] 000,people
[3] people,malawi
[2] scotnational,brewgooder

Top Replied-To
Top Replied-To in Entire Graph:
@tesco
@serena_arif
@bootstrapcook
@thornbridge
@bushontheradio
@swanage123
@northernmanv2
@jamieoliver
@lynnemccormic20
@meatlust

Top Replied-To in G1:
@tesco
@bootstrapcook
@bushontheradio
@northernmanv2
@jamieoliver
@lucozadeenergy
@welshwench_xo
@smod123
@dameandthatgame
@yahyah_gunn

Top Replied-To in G3:
@meatlust
@tesco
@ellieskitchenuk
@joseph_healey_
@itvnews
@yarnsniffer
@wrigglefingers
@aldiuk
@greenpeaceuk
@lilzzyyyyy

Top Replied-To in G4:
@thornbridge
@thabearded1
@mjpo007
@jmrogers2000
@trentendrob
@tonytrentend
@p_taylor67
@jamesmarriott
@beeroclockshow
@sheffhopcast

Top Replied-To in G6:
@cjtudor

Top Replied-To in G8:
@serena_arif
@swanage123
@lynnemccormic20
@steviebrogues
@garetht68496541
@ankhassa
@stuartpoet
@miltonfox6141
@mrbucksboy
@bilko89

Top Replied-To in G10:
@johntho29498413

Top Mentioned
Top Mentioned in Entire Graph:
@tesco
@jamieoliver
@asda
@keepscotbrand
@sainsburys
@imajsaclaimant
@meatlust
@sidneyphlegm
@mermatriarch
@aldiuk

Top Mentioned in G1:
@tesco
@jamieoliver
@bootstrapcook
@eat_oumph
@lucozadeenergy
@scottie_bairn
@1stepsnutrition
@sweetpeapantry
@thebhf
@tombraider

Top Mentioned in G2:
@carolinahawkins
@sally36523509
@stevenneil12
@linda_maddison
@lormartin
@polimericanews
@greenjinn
@elmaeurope
@9livesfurniture

Top Mentioned in G3:
@tesco
@asda
@sainsburys
@meatlust
@aldiuk
@lidluk
@waitrose
@morrisons
@marksandspencer
@coopukfood

Top Mentioned in G4:
@thornbridge
@tesco
@vinylfrog
@thornbridgeshop
@thornbridgeg
@thornbridgejb
@thornbridgesi
@thornbridgerebs
@thornbridge_j7
@mazymixer

Top Mentioned in G5:
@imajsaclaimant
@bootstrapcook

Top Mentioned in G6:
@mermatriarch

Top Mentioned in G7:
@sidneyphlegm

Top Mentioned in G8:
@tesco
@keepscotbrand
@serena_arif
@stuartpoet
@ankhassa
@scotlandsfuture
@gorbalsgoebbels
@swanage123
@porthynys
@lynnemccormic20

Top Mentioned in G9:
@mothecomedian
@madeinpoortaste

Top Mentioned in G10:
@scotnational
@robertt17047286
@ermedale
@tenaciousv56
@gri64
@dointhebiz1
@stewartnial
@nmckay958
@scottfree2018
@theeurogirl

Top Tweeters
Top Tweeters in Entire Graph:
@virginmedia
@amazonhelp
@tesco
@coventryupdate
@nvpeople
@o2
@ee
@bev_metallica
@british_airways
@buletinmalaysia

Top Tweeters in G1:
@tesco
@cleandropmobile
@bbcnews
@principia
@jmcefalas
@abcdiagnosis
@moonlightlady2
@humptyscrumpty
@paulpaul49
@sunnylowden

Top Tweeters in G2:
@buletinmalaysia
@thenewsglobe
@dakotafinancial
@malaysiandaily
@uber_buyer
@mysouthend
@ukdealshot
@thesun
@c255666a459a495
@sexualjumanji

Top Tweeters in G3:
@bev_metallica
@british_airways
@sainsburys
@sportsmadmum
@bliadhnaichean
@asdaserviceteam
@marksandspencer
@needaphone
@trulovesroo
@londonbirdlucy

Top Tweeters in G4:
@selcamra
@mazymixer
@thabearded1
@beeroclockshow
@grassrootsdnc
@hoppytweets
@beerdetective
@beeragentuksean
@jayblair1996
@mjpo007

Top Tweeters in G5:
@s9tmt
@mojos55
@shinejob
@inclinepress
@roxann_minerals
@andreadudding
@catjohnson42
@helpforbear
@60sleigh
@imajsaclaimant

Top Tweeters in G6:
@m0namour
@lavillanelie
@pippalowthorpe
@smoothseastyles
@shinymoitres
@_weiirdgurl_
@ellewltn
@fw_medieval
@welshsnarker
@ewolamme

Top Tweeters in G7:
@notalishaa
@chloemilia
@aprilwbu
@nawonjae
@gnarfolk
@narryohniall
@babiikait
@sidneyphlegm
@reallucassams
@revivadrin

Top Tweeters in G8:
@mckinlay_liz
@rangersfranky
@firstfinequine
@porthynys
@ankhassa
@scotlandsfuture
@gorbalsgoebbels
@lass_ayrshire
@elvishcostello
@graemeburton

Top Tweeters in G9:
@mxsays
@mothecomedian
@sonny_powar
@1amusti
@jessicabirdtw
@daniellaw99
@szvnx
@beadeguise
@caitlinmcdon_
@ap96__

Top Tweeters in G10:
@2351onthelist
@jegteg
@uncleprober
@stillyesscot
@gri64
@kallemet86
@theeurogirl
@planet_pedro
@louisestewartls
@nmckay958