FAQ | Problem?

#pr_2018-07-11_13-07-49.xlsx
#pr_2018-07-11_13-07-49.xlsx
From:
NodeXLExcelAutomator
Uploaded on:
July 11, 2018
Short Description:
#pr via NodeXL http://bit.ly/2udgvPn
@skypeace_teojin
@ld_girls
@prisus
@neo_neo66
@caddymarketing
@prnews
@chloe_de_young
@prowly_com
@honoka7000
@_yunachannel

Top hashtags:
#pr
#marketing
#羞酢
#ãƒÿチョ
#ऐ_सखी
#すっぴん素肜プロジェクト

Description:
Description
The graph represents a network of 4,950 Twitter users whose tweets in the requested range contained "#pr", or who were replied to or mentioned in those tweets. The network was obtained from the NodeXL Graph Server on Wednesday, 11 July 2018 at 20:09 UTC.

The requested start date was Wednesday, 11 July 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 12-day, 0-hour, 50-minute period from Thursday, 28 June 2018 at 14:59 UTC to Tuesday, 10 July 2018 at 15:50 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 : 4950
Unique Edges : 5123
Edges With Duplicates : 1706
Total Edges : 6829
Number of Edge Types : 3
Mentions : 5033
Tweet : 1723
Replies to : 73
Self-Loops : 1723
Reciprocated Vertex Pair Ratio : 0.0297273133661153
Reciprocated Edge Ratio : 0.0577382244410679
Connected Components : 1264
Single-Vertex Connected Components : 639
Maximum Vertices in a Connected Component : 535
Maximum Edges in a Connected Component : 854
Maximum Geodesic Distance (Diameter) : 15
Average Geodesic Distance : 3.779983
Graph Density : 0.00018805962228876
Modularity : 0.714568
NodeXL Version : 1.0.1.400

Top Influencers: Top 10 Vertices, Ranked by Betweenness Centrality
Top URLs
Top URLs in Tweet in Entire Graph:
[305] https://goo.gl/v2kaxP
[101] https://selpy.co.jp/
[68] https://goo.gl/qwnBP1
[45] https://goo.gl/mhpv6t
[39] https://www.oricon.co.jp/special/51375/?utm_source=Twitter&utm_medium=social&ref_cd=jstw006-1
[36] http://www.amazon.com/Aligned-Hunted-Kristy-Anne-Berridge/dp/0987524763
[31] https://goo.gl/5yuspU
[26] http://www.amazon.com/Aligned-3-Hunted-Kristy-Berridge-ebook/dp/B00U9TUS5Y
[25] https://goo.gl/2Xfd8J
[24] https://www.youtube.com/watch?v=HfitA8PZvxw&feature=youtu.be


Top URLs in Tweet in G1:
[78] https://selpy.co.jp/
[17] http://www.rakuten.co.jp/surfdesign/
[14] http://bit.ly/2u96CkF
[10] http://bit.ly/2MQYj4M
[10] https://share.payoneer.com/nav/m7nAy-64iwxx-FqJ1S3V6BWKMo7FIHhQLsWScQhdIBxPCoO6pmM99DH6Sv8r2khX3MBOZnJL0VNxg3-sKwGYjw2
[10] http://bit.ly/2uaz71w
[7] http://www.rakuten.ne.jp/gold/surfdesign/
[6] http://shop.avr-music.com/
[5] http://www.gorkana.com/2017/02/five-reasons-pr-has-an-edge-in-content-creation/?ref=quuu&utm_source=quuu
[5] https://rfpalooza.com/latest-advertising-marketing-rfps-2/rfp-single/RFP5b314e4d525c6/

Top URLs in Tweet in G2:
[1] https://www.j-cast.com/bookwatch/feature/kajo201806.html#book-2
[1] https://www.j-cast.com/bookwatch/2018/04/25007238.html
[1] https://www.j-cast.com/bookwatch/2018/06/26007547.html
[1] https://www.j-cast.com/bookwatch/feature/kajo201806.html#book-3
[1] https://www.j-cast.com/bookwatch/book058/2018/05/25007400.html
[1] https://www.j-cast.com/bookwatch/book047/2018/06/12007490.html
[1] http://news.livedoor.com/article/detail/14921338/
[1] http://news.livedoor.com/article/detail/14868395/

Top URLs in Tweet in G3:
[287] https://goo.gl/v2kaxP
[20] https://app.adjust.com/2tjkqy?campaign=201806_thailand_vaz&adgroup=20180629&creative=skypeace_UC8_wmm5DX9mb4jrLiw8ZYzw
[2] https://goo.gl/mhpv6t

Top URLs in Tweet in G4:
[68] https://goo.gl/qwnBP1
[43] https://goo.gl/mhpv6t
[31] https://goo.gl/5yuspU
[25] https://goo.gl/2Xfd8J
[20] https://goo.gl/7vhm57
[18] https://goo.gl/v2kaxP
[16] https://go.onelink.me/BAuo/9062dc50
[10] https://goo.gl/9y4Z4C
[5] https://app.adjust.com/2tjkqy?campaign=201806_thailand_vaz&adgroup=20180629&creative=neo_UClPLW-9Nfbvf76ksj-4c1kQ
[5] https://lipscosme.com/?pid=Tw&c=hnk

Top URLs in Tweet in G5:
[38] https://www.oricon.co.jp/special/51375/?utm_source=Twitter&utm_medium=social&ref_cd=jstw006-1
[9] https://www.oricon.co.jp/special/51331/?utm_source=Twitter&utm_medium=social&ref_cd=jstw003
[9] https://cards.twitter.com/cards/18ce53w4yc5/5x3vz
[4] https://www.oricon.co.jp/special/51310/?utm_source=Twitter&utm_medium=social&ref_cd=jstw006
[3] https://www.oricon.co.jp/special/51299/?utm_source=Twitter&utm_medium=social&ref_cd=jstw006
[2] https://www.oricon.co.jp/special/2018/bachelor/?utm_source=Twitter&utm_medium=social&ref_cd=jstw006
[1] https://cards.twitter.com/cards/18ce53w4yc5/5wga9

Top URLs in Tweet in G6:
[3] http://michellegarrett.com/2018/05/30/5-things-you-should-never-hear-a-pr-person-say/
[3] http://ow.ly/O9dm30kONAU
[2] https://www.meltwater.com/blog/how-brands-should-apologize/?utm_source=twitter&utm_medium=social&utm_campaign=newscred
[2] https://twitter.com/Meltwater/status/1012126694948458496
[2] https://prowly.com/magazine/2018/06/20/better-safe-than-sorry-your-crisis-communication-plan-from-a-to-z/
[2] https://buff.ly/2u7rt86
[2] https://www.meltwater.com/blog/how-to-measure-pr-roi-align-kpis-to-business-goals/?utm_source=twitter&utm_medium=social&utm_campaign=newscred
[2] https://www.meltwater.com/blog/infographic-taking-the-pulse-of-pr-and-social-media-jobs/?utm_source=social&utm_medium=twitter&utm_campaign=blog
[2] https://www.meltwater.com/blog/seo-for-pr-pros-how-search-can-get-your-message-out/?utm_source=twitter&utm_medium=social&utm_campaign=newscred
[2] http://bit.ly/2MIUcI5

Top URLs in Tweet in G9:
[3] http://www.reverbnation.com/davidmartinezmusic
[1] http://indiemusicwomen.com/featured/discover-multi-genre-singer-songwriter-linda-marks/

Top URLs in Tweet in G10:
[2] https://buff.ly/2z2tb0l
[2] https://twitter.com/ellaminty/status/1012355076176916480
[2] https://www.cipr.co.uk/content/training?utm_source=NPS%20email&utm_medium=NPS%20email&utm_campaign=NPS%20sharing
[2] http://www.aura-pr.com/blog/pr-mindset/
[2] http://prfest.co.uk/2018/07/02/pr-space-announce/
[2] https://www.fpb.org/our-media-room/
[1] https://www.brandwatch.com/blog/lessons-marketing-teams-can-take-from-newsrooms-for-more-successful-agile-marketing-initiatives/
[1] https://www.eventbrite.co.uk/e/ultimate-broadcast-pr-training-day-how-to-get-your-clients-on-tv-and-radio-tickets-46902552798
[1] http://ow.ly/ZiHK30kEgxe
[1] https://gph.is/1oo5uWj

Top Domains
Top Domains in Tweet in Entire Graph:
[548] goo.gl
[225] bit.ly
[206] co.jp
[147] twitter.com
[108] instagram.com
[89] ow.ly
[87] buff.ly
[65] youtube.com
[62] amazon.com
[58] co.uk

Top Domains in Tweet in G1:
[98] co.jp
[92] bit.ly
[57] instagram.com
[45] twitter.com
[30] ow.ly
[23] ift.tt
[18] facebook.com
[15] co.uk
[13] goo.gl
[12] ziprecruiter.com

Top Domains in Tweet in G2:
[6] j-cast.com
[2] livedoor.com

Top Domains in Tweet in G3:
[289] goo.gl
[20] adjust.com

Top Domains in Tweet in G4:
[216] goo.gl
[21] onelink.me
[15] adjust.com
[9] lipscosme.com
[2] pyuan-distance.jp
[2] youtube.com
[2] tiktokv.com

Top Domains in Tweet in G5:
[56] co.jp
[10] twitter.com

Top Domains in Tweet in G6:
[10] meltwater.com
[8] twitter.com
[8] buff.ly
[8] bit.ly
[6] ow.ly
[4] prnewsonline.com
[3] michellegarrett.com
[3] mrmediatraining.com
[3] presspage.com
[2] prowly.com

Top Domains in Tweet in G9:
[3] reverbnation.com
[1] indiemusicwomen.com

Top Domains in Tweet in G10:
[9] co.uk
[7] buff.ly
[7] twitter.com
[5] ow.ly
[2] prmoment.com
[2] responsesource.com
[2] aura-pr.com
[2] fpb.org
[1] brandwatch.com
[1] gph.is

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[3813] pr
[311] marketing
[282] 羞酢
[282] ãƒÿチョ
[228] ऐ_सखी
[163] すっぴん素肜プロジェクト
[160] publicrelations
[132] sk2フェイシャルトリートメントエッセンス
[115] socialmedia
[104] selpy_app



Top Hashtags in Tweet in G1:
[905] pr
[105] marketing
[81] selpy_app
[78] selpy
[74] セルピー
[72] publicrelations
[71] 日常ぜ価値に変わるアプリ
[51] media
[34] socialmedia
[30] branding

Top Hashtags in Tweet in G2:
[282] 羞酢
[282] ãƒÿチョ
[47] プレゼント
[31] 菅沼勇åÿº
[31] 資産
[10] pr
[7] ai
[7] かずみん
[7] 秀咜システãƒ
[7] ず金

Top Hashtags in Tweet in G3:
[24] pr
[2] いいアゴ乗ってんね

Top Hashtags in Tweet in G4:
[128] pr
[38] tiktok
[19] だ゜でもダンス
[13] だ゜でもダンス踚ってみãÿよ
[9] lips
[8] tiktokerと繋ぜ゚ãÿい
[4] tiktokいいアゴ乗ってんね
[2] ねず
[2] 歩乃華
[2] tiktokjapan

Top Hashtags in Tweet in G5:
[132] pr
[113] すっぴん素肜プロジェクト
[113] sk2フェイシャルトリートメントエッセンス
[9] 黒島結菜
[9] 東京駅
[9] 東京ステーションシティ
[4] 杏
[4] 若林正恭
[4] オードリー
[4] 大西礼蚳

Top Hashtags in Tweet in G6:
[79] pr
[7] mediarelations
[6] publicrelations
[5] socialmedia
[5] cmo
[3] freelance
[3] crisiscommunication
[3] roi
[3] scarlettjohansson
[3] lgbt

Top Hashtags in Tweet in G7:
[78] raindrop
[1] pr
[1] 2fa
[1] blockchain
[1] hydro

Top Hashtags in Tweet in G8:
[228] ऐ_सखी
[156] pr
[24] ऐ_सखी
[15] चिà¤ÿ्ठी
[7] झील
[5] स्वरा
[4] सुनो
[4] बादल
[3] बादल
[2] चिट्ठी

Top Hashtags in Tweet in G9:
[25] pr
[13] socialmedia
[7] kicma
[6] country
[5] arts
[5] charity
[5] tours
[5] pier99
[4] awards
[4] radio

Top Hashtags in Tweet in G10:
[62] pr
[12] comms
[9] prtips
[8] hacksforflacks
[6] mediarelations
[5] whatjournoswant
[4] mediatips
[4] ai
[4] publicrelations
[3] seo

Top Words
Top Words in Tweet in Entire Graph:
[2573] Words in Sentiment List#1: Positive
[700] Words in Sentiment List#2: Negative
[5] Words in Sentiment List#3: Angry/Violent
[246753] Non-categorized Words
[250028] Total Words
[61729] ã
[18818] à
[18350] ãƒ
[6597] å
[4889] ï

Top Words in Tweet in G1:
[3526] ã
[1368] ãƒ
[960] pr
[560] å
[271] æ
[217] è
[211] ðÿ
[197] â
[179] ï
[164] ç

Top Words in Tweet in G2:
[10493] ã
[5804] ãƒ
[2425] ï
[1219] é
[909] å
[633] ϋ
[619] ό
[613] â
[603] ªã
[519] æ

Top Words in Tweet in G3:
[9412] ã
[1174] ãƒ
[883] å
[878] ç
[873] ϋ
[584] è
[582] â
[576] æš
[315] ï
[306] skypeace_teojin

Top Words in Tweet in G4:
[9825] ã
[1296] ãƒ
[661] ϋ
[641] ç
[557] ï
[527] å
[449] ÿã
[440] æ
[423] ðÿ
[412] è

Top Words in Tweet in G5:
[2656] ã
[1496] ãƒ
[554] å
[356] ç
[265] è
[244] â
[194] æ
[150] ッãƒ
[132] pr
[126] oricon

Top Words in Tweet in G6:
[96] pr
[16] here
[16] â
[16] media
[15] prisus
[13] prnews
[13] communicators
[11] crisis
[11] dc
[10] help

Top Words in Tweet in G7:
[156] next
[78] wow
[78] dozens
[78] companies
[78] implementing
[78] raindrop
[78] launch
[78] week
[78] include
[77] hydrogenapi

Top Words in Tweet in G8:
[18735] à
[337] ψ
[309] ªà
[299] ˆà
[258] µà
[234] pinaky13
[230] _à
[174] šà
[163] ˆ
[156] pr

Top Words in Tweet in G9:
[267] ðÿ
[42] ladylakemusic
[25] pr
[20] â
[17] ï
[16] years
[15] celebrating
[14] ðÿž
[13] socialmedia
[13] reach

Top Words in Tweet in G10:
[75] pr
[14] comms
[12] ninemediauk
[11] here
[10] out
[9] prtips
[9] need
[9] s
[9] read
[8] looking

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[30449] ã,ã
[16702] à,à
[6937] ãƒ,ãƒ
[6804] ãƒ,ã
[6519] ã,ãƒ
[1961] å,ã
[1796] œã,ã
[1777] ã,è
[1674] ã,ï
[1651] ã,œã

Top Word Pairs in Tweet in G1:
[1632] ã,ã
[610] ãƒ,ãƒ
[533] ã,ãƒ
[375] ãƒ,ã
[331] å,ã
[151] ã,å
[102] t,co
[100] https,t
[98] è,ã
[89] æ,å

Top Word Pairs in Tweet in G2:
[4311] ã,ã
[2688] ã,ãƒ
[2202] ãƒ,ãƒ
[1924] ãƒ,ã
[662] ãƒ,ï
[612] é,ã
[612] å,œå
[583] ã,ï
[575] ï,ã
[562] ã,â

Top Word Pairs in Tweet in G3:
[4713] ã,ã
[588] ãƒ,ã
[586] ç,ã
[580] ã,œã
[578] ã,è
[577] å,ç
[577] œã,ã
[300] ã,ï
[293] å,ã
[293] ã,ãƒ

Top Word Pairs in Tweet in G4:
[5500] ã,ã
[699] ãƒ,ã
[475] ç,ã
[438] ã,ÿã
[428] ã,œã
[369] œã,ã
[338] ã,è
[314] æ,ã
[314] ãƒ,ãƒ
[284] ã,ï

Top Word Pairs in Tweet in G5:
[1325] ã,ã
[641] ãƒ,ãƒ
[463] ãƒ,ã
[303] ã,ãƒ
[226] ã,ç
[226] ç,è
[201] ã,å
[159] â,ã
[150] ッãƒ,ã
[122] ã,pr

Top Word Pairs in Tweet in G6:
[8] global,ceo
[8] ceo,gherbette
[8] power,list
[8] list,2018
[8] 2018,ranks
[8] ranks,powerful
[8] powerful,communicators
[7] pr,pros
[7] social,media
[7] up,here

Top Word Pairs in Tweet in G7:
[78] wow,dozens
[78] dozens,companies
[78] companies,implementing
[78] implementing,raindrop
[78] raindrop,launch
[78] launch,next
[78] next,week
[78] week,next
[78] next,include
[77] hydrogenapi,wow

Top Word Pairs in Tweet in G8:
[16637] à,à
[332] à,œà
[315] œà,à
[309] à,ªà
[308] ªà,à
[291] ˆà,à
[284] à,ˆà
[256] µà,à
[252] à,µà
[230] à,_à

Top Word Pairs in Tweet in G9:
[198] ðÿ,ðÿ
[17] â,ï
[13] ladylakemusic,pr
[13] socialmedia,reach
[12] 12,years
[11] celebrating,12
[11] pr,ðÿ
[9] ðÿ,ladylake
[9] ladylake,entertainment
[9] entertainment,pr

Top Word Pairs in Tweet in G10:
[9] prtips,pr
[7] pr,comms
[7] hacksforflacks,prtips
[5] pr,mediarelations
[5] long,term
[4] mediarelations,whatjournoswant
[4] whatjournoswant,mediatips
[4] mediatips,comms
[4] fascinating,podcast
[4] podcast,therealprmoment

Top Replied-To
Top Mentioned
Top Mentioned in Entire Graph:
@skypeace_teojin
@ld_girls
@pinaky13
@oricon
@neo_neo66
@hydrogenapi
@honoka7000
@okss_emma_2121
@tastemade_japan
@jcast_book

Top Mentioned in G1:
@andoniapr
@kllanosglez
@yozzeko

Top Mentioned in G2:
@ld_girls
@jcast_book

Top Mentioned in G3:
@skypeace_teojin
@honoka7000
@tiktok_japan

Top Mentioned in G4:
@neo_neo66
@honoka7000
@_yunachannel
@tiktok_japan
@_yuuun_s2
@2_5_2555
@skypeace_teojin
@pinkid1412
@_roa666
@twilight___

Top Mentioned in G5:
@oricon
@bachelorjapan

Top Mentioned in G6:
@prisus
@prnews
@prweekus
@prdaily
@gherbette
@meltwater
@muckrack
@christinashadle
@msl_group
@bradmarley

Top Mentioned in G7:
@hydrogenapi

Top Mentioned in G8:
@pinaky13
@historyinder27

Top Mentioned in G9:
@ladylakemusic
@davidmartinezmu
@lsmheart
@ladylakejen
@texasselect
@drjimmystar
@mark1952ind
@sherocksplanet
@jimmystarshow
@lizzjustlizz

Top Mentioned in G10:
@ninemediauk
@theprfest
@therealprmoment
@mgreer_pr
@hopeandglorypr
@jamesmacintosh
@responsesource
@prkezza
@plcreatives
@padsky

Top Tweeters
Top Tweeters in Entire Graph:
@cas_2050001283
@paul_cude
@marshawright
@arkangelscrap
@kirin_brewery
@piyuanker12
@tuttosulinux
@klm
@lemon1931
@royalmail

Top Tweeters in G1:
@cas_2050001283
@tuttosulinux
@vg_urg
@vek_toh
@cyberstormonfiv
@platinumvoicepr
@butterflymum83
@lambquest
@starlightpr1
@atheek_ahamath

Top Tweeters in G2:
@okinawakaribu
@ssachu
@twinbird4949
@aa2222aa
@cafe_angy
@ruk_syuyu
@kuronekocat2010
@debuneko5
@kirakirakirei5
@yumimindamu

Top Tweeters in G3:
@satoshior_11246
@ai_flower9
@youtuberlove18a
@yuutan_1106
@f_s_adyu_
@sm4978cas
@haji_fish_pokio
@gldhv3jyyuw24m3
@kana_jin_0612
@yutb8knjn8bsk

Top Tweeters in G4:
@neo_neo66
@fut_013
@neo_neo1114
@maoooo_vez14
@0527my391
@haru__kaaa
@_roa666
@yurari0601
@okayama1991
@sayaka20021226

Top Tweeters in G5:
@lemon1931
@74irosocco
@an_punch
@minna_no_kswg
@douzen88
@aki3072
@sakazuki_kou
@giu_9_brj
@baraschechath
@oricon

Top Tweeters in G6:
@klm
@mcdonalds
@marketwatch
@thetodayshow
@starbucks
@jgombita
@monster
@lucreciaaldao
@prnews
@bibonix

Top Tweeters in G7:
@a1iu_
@exp_mark
@emmanuel4u
@kizilprofil
@takip_airdrop
@jmocity
@longs60
@drdebuneko
@butkovic_elena
@judeiko

Top Tweeters in G8:
@p_85265836
@kanchkanchi03
@rameshagrawal95
@bhayalal
@sarojshrnm
@anilmauryaa
@ashu89995
@ialokshukla
@ajoybahadursbi
@naadan_prinda

Top Tweeters in G9:
@drjimmystar
@mark1952ind
@jim_b60
@ladylakemusic
@thedavidbowers
@catorwebradio
@charlieslang
@lizzjustlizz
@rockmebabytv
@hope2259

Top Tweeters in G10:
@talentedladies
@neli_ngqulana
@janetmachuka_
@10yetis
@gmpolice
@esparkglobal
@therealprmoment
@brandwatch
@padsky
@the_fpb