Bebarengan karo Xovi, alat SISTRIX minangka program analisis sing paling akeh digunakake ing Jerman ing wilayah SEO. Indeks visibilitas wis dadi standar kuasi kanggo visibilitas kaca ing panelusuran Google. Paramèter sing kalebu ing pitungan iku, contone , diterangno kene lan kene lan kene lan kene lan kene , nanging rumus pitungan pas ora kanthi resmi. Ing ngisor iki minangka asil riset pribadiku nem sasi, sing ora ngaku lengkap utawa bener.
Karo
- \(A_l\): Set tembung kunci SISTRIX (jumlah tembung kunci sing diurutake kanthi tegas kanggo negara tartamtu, set ngemot bagean sing tetep - diklumpukake kanthi basis lalu lintas rata-rata 12 sasi - uga bagean sing luwih cilik)
- \(\vert A_l \vert\) : \(A_l\) kanthi \(A_l\) \(\vert A_{DE} \vert = 1.000.000\) (status: 01.10.2021)
- \(k \in A_l\): Keyword mati \(A_l\)
- \(u\): URL (kanggo diinterpretasikake minangka domain, subdomain, direktori, URL individu, gumantung saka format)
- \(r_{uklgt}\) : Peringkat URL \(u\) ing asil panelusuran organik mesin telusur Google kanggo tembung kunci \(k\) ing negara \(l\) ing jinis piranti \(g\) ing wektu \(t\)
- \(s_{klgt}\) : Volume telusuran (rata-rata pitakon telusuran saben wulan kanthi data saka SISTRIX, dudu saka Google Keyword Planner , nanging miturut pernyataan perusahaan dhewe, dikumpulake saka luwih saka rolas panyedhiya data sing biasane eksternal) kanggo tembung kunci \(k\) ing negara \(l\) ing jinis piranti \(g\) ing wektu \(t\)
- \(c_{uklgt}\) : Kira-kira klik ing URL \(u\) kanggo tembung kunci \(k\) ing negara \(l\) ing jinis piranti \(g\) ing wektu \(t\)
- \(l \in L=\{DE;...;JP\}\) : Negara kanthi \(\vert L \vert=30\) (ing: 01.06.2021)
- \(g\in\{D;M\}\): Jinis piranti (desktop / seluler)
- \(t\): Wektu (tanggal ing 00:00:00)
- \(S_{ulgt}\) : Indeks visibilitas SISTRIX saka URL \(u\) negara \(l\) ing jinis piranti \(g\) ing wektu \(t\)
- \(W_S = \, \mathbb{Q}^{+}_{0}\) nilai \(W_S = \, \mathbb{Q}^{+}_{0}\)
ditrapake
$$S_{ulgt} = \sum_{k=1}^{\vert A_l \vert} f(r_{uklgt}, c_{uklgt})$$
karo
$$\begin{multline} \mathbb{N_0} \times \mathbb{Q}^{+}_{0} \to \, \mathbb{Q}^{+}_{0}, f(r, c) = ((1-\text{sgn}(r - 1)^2) \cdot ((1-\text{ceil}(0.5 \cdot \text{sgn}(c-34{,}4796))) \cdot 0{,}0194 + \\ (\text{ceil}(0.5 \cdot \text{sgn}(c-34{,}4796))) \cdot ((1+\text{floor}(0.5 \cdot \text{sgn}(c-378{,}325))) \cdot 0{,}125 - \\ (\text{floor}(0.5 \cdot \text{sgn}(c-378{,}325))) \cdot (0{,}0004 \cdot c + 0{,}0119)))) + (\text{sgn}(r-1)^2 \cdot \\ ((1-\text{sgn}(r - 2)^2) \cdot ((1-\text{ceil}(0.5 \cdot \text{sgn}(c-17{,}418))) \cdot 0{,}0136 + \\ (\text{ceil}(0.5 \cdot \text{sgn}(c-17{,}418))) \cdot ((1+\text{floor}(0.5 \cdot \text{sgn}(c-230{,}6839))) \cdot 0{,}125 - \\ (\text{floor}(0.5 \cdot \text{sgn}(c-230{,}6839))) \cdot (0{,}0006 \cdot c + 0{,}0035)))) + (\text{sgn}(r-2)^2 \cdot \\ ((1-\text{sgn}(r - 3)^2) \cdot ((1-\text{ceil}(0.5 \cdot \text{sgn}(c-11{,}0236))) \cdot 0{,}0098 + \\ (\text{ceil}(0.5 \cdot \text{sgn}(c-11{,}0236))) \cdot ((1+\text{floor}(0.5 \cdot \text{sgn}(c-231{,}3121))) \cdot 0{,}125 - \\ (\text{floor}(0.5 \cdot \text{sgn}(c-231{,}3121))) \cdot (0{,}0006 \cdot c + 0{,}0025)))) + (\text{sgn}(r-3)^2 \cdot \\ ((1-\text{sgn}(r - 4)^2) \cdot ((1-\text{ceil}(0.5 \cdot \text{sgn}(c-8{,}8619))) \cdot 0{,}0077 + \\ (\text{ceil}(0.5 \cdot \text{sgn}(c-8{,}8619))) \cdot ((1+\text{floor}(0.5 \cdot \text{sgn}(c-219{,}6195))) \cdot 0{,}125 - \\ (\text{floor}(0.5 \cdot \text{sgn}(c-219{,}6195))) \cdot (0{,}0006 \cdot c + 0{,}002)))) + (\text{sgn}(r-4)^2 \cdot \\ ((1-\text{sgn}(r - 5)^2) \cdot ((1-\text{ceil}(0.5 \cdot \text{sgn}(c-8{,}0684))) \cdot 0{,}0068 + \\ (\text{ceil}(0.5 \cdot \text{sgn}(c-8{,}0684))) \cdot ((1+\text{floor}(0.5 \cdot \text{sgn}(c-249{,}3706))) \cdot 0{,}125 - \\ (\text{floor}(0.5 \cdot \text{sgn}(c-249{,}3706))) \cdot (0{,}0006 \cdot c + 0{,}0017)))) + (\text{sgn}(r-5)^2 \cdot \\ ((1-\text{sgn}(r - 6)^2) \cdot ((1-\text{ceil}(0.5 \cdot \text{sgn}(c-5{,}357))) \cdot 0{,}0058 + \\ (\text{ceil}(0.5 \cdot \text{sgn}(c-5{,}357))) \cdot ((1+\text{floor}(0.5 \cdot \text{sgn}(c-133{,}2103))) \cdot 0{,}1011 - \\ (\text{floor}(0.5 \cdot \text{sgn}(c-133{,}2103))) \cdot (0{,}0007 \cdot c + 0{,}0015)))) + (\text{sgn}(r-6)^2 \cdot \\ ((1-\text{sgn}(r - 7)^2) \cdot ((1-\text{ceil}(0.5 \cdot \text{sgn}(c-4{,}3643))) \cdot 0{,}0049 + \\ (\text{ceil}(0.5 \cdot \text{sgn}(c-4{,}3643))) \cdot ((1+\text{floor}(0.5 \cdot \text{sgn}(c-90{,}3704))) \cdot 0{,}0727 - \\ (\text{floor}(0.5 \cdot \text{sgn}(c-90{,}3704))) \cdot (0{,}0008 \cdot c + 0{,}0013)))) + (\text{sgn}(r-7)^2 \cdot \\ ((1-\text{sgn}(r - 8)^2) \cdot ((1-\text{ceil}(0.5 \cdot \text{sgn}(c-3{,}3292))) \cdot 0{,}0039 + \\ (\text{ceil}(0.5 \cdot \text{sgn}(c-3{,}3292))) \cdot ((1+\text{floor}(0.5 \cdot \text{sgn}(c-87{,}6123))) \cdot 0{,}0706 - \\ (\text{floor}(0.5 \cdot \text{sgn}(c-87{,}6123))) \cdot (0{,}0008 \cdot c + 0{,}0011)))) + (\text{sgn}(r-8)^2 \cdot \\ ((1-\text{sgn}(r - 9)^2) \cdot ((1-\text{ceil}(0.5 \cdot \text{sgn}(c-2{,}944))) \cdot 0{,}0029 + \\ (\text{ceil}(0.5 \cdot \text{sgn}(c-2{,}944))) \cdot ((1+\text{floor}(0.5 \cdot \text{sgn}(c-75{,}6014))) \cdot 0{,}0515 - \\ (\text{floor}(0.5 \cdot \text{sgn}(c-75{,}6014))) \cdot (0{,}0007 \cdot c + 0{,}0012)))) + (\text{sgn}(r-9)^2 \cdot \\ ((1-\text{sgn}(r - 10)^2) \cdot ((1-\text{ceil}(0.5 \cdot \text{sgn}(c-2{,}4797))) \cdot 0{,}0019 + \\ (\text{ceil}(0.5 \cdot \text{sgn}(c-2{,}4797))) \cdot ((1+\text{floor}(0.5 \cdot \text{sgn}(c-36{,}7911))) \cdot 0{,}0199 - \\ (\text{floor}(0.5 \cdot \text{sgn}(c-36{,}7911))) \cdot (0{,}0005 \cdot c + 0{,}0005)))) + (\text{sgn}(r-10)^2 \cdot 0)))))))))) \end{multline}$$
Formula iki utamane dijupuk liwat rekayasa balik nggunakake SISTRIX A PI resmi. Ide dhasare yaiku: nyuda masalah dadi conto sing prasaja (golek URL kanthi indeks visibilitas positif mung nggunakake siji/loro/telu/... tembung kunci) banjur coba ngasilake maneh kasus sing luwih kompleks.
Properties saka indeks visibilitas:
- Mung tembung kunci saka "set tembung kunci permanen" saka 1.000.000 tembung kunci sing kalebu ing indeks visibilitas, dudu tembung kunci saka "database lengkap" sing terus berkembang (sing adaptasi karo acara lan kahanan saiki), sing saiki kalebu 100.000.000 tembung kunci (Ing Oktober 1, 2021). Klompok tembung kunci kasebut bisa gampang disaring kanthi milih nilai ing "Tanggal" utawa kanthi nyetel nilai ditambah dadi 0 ing API. Data standar utawa data historis tetep lan wis diklumpukake saben minggu wiwit 2008, saiki saben dina.
- Hit AMP ora kalebu ing indeks visibilitas.
- Disaranake miwiti analisa ing negara sing bubar digawe kayata Romania, Kroasia, Slovenia & Bulgaria utawa nggawe indeks visibilitas sampeyan dhewe . Alesan kanggo iki yaiku SISTRIX nggawa "bagasi sejarah" ing negara-negara kaya Jerman, sing tegese tembung kunci sing biyen duwe bobot sing luwih dhuwur saiki dilebokake malah luwih saka sing dikarepake, sanajan volume telusuran kurang (sanajan suwe). Miturut dhukungan, kabeh kudu diatur kanthi bertahap lan ora katon maneh ing jangka panjang.
- Beda karo asumsi asliku, volume telusuran mung nduweni peran ora langsung ing indeks visibilitas. Nanging, klik sing diarepake penting banget. Hubungan antarane volume telusuran lan kira-kira klik utamane adhedhasar maksud telusuran sing dikira-kira, sing uga dituduhake. SISTRIX dhewe nuduhake iki kanthi jelas .
- Jumlah klik sing diarepake minangka faktor pendorong indeks visibilitas. Pengaruhe diwatesi munggah lan mudhun, tegese indeks visibilitas tansah fluktuatif sacara linier antarane wates ndhuwur lan ngisor.
- Klik ora bisa diakses liwat API resmi, nanging mung liwat antarmuka web utawa liwat ekspor CSV manual. Ing kasus loro kasebut, nilai kasebut dibunderaké, nanging DOM saka tampilan "Kata Kunci" uga ngemot nilai asli.:
Rumus ing ngisor iki uga bisa digunakake ing Excel utawa Google Sheets; Iku ngitung indeks visibilitas kanggo spreadsheet sing saben baris ngemot tembung kunci kanthi posisi ing kolom A lan klik sing dikarepake ing kolom B.:
=SUMME(WENN(A1:A999999=1;WENN(B1:B999999<=34,479607495389;0,0194;WENN(B1:B999999>=378,32500379436;0,125;(0,00037306471297181*B1:B999999+0,011944496557952))); WENN(A1:A999999=2;WENN(B1:B999999<=17,418044883225;0,0136;WENN(B1:B999999>=230,68394113271;0,125;(0,00055449577110866*B1:B999999+0,0035350976909409))); WENN(A1:A999999=3;WENN(B1:B999999<=11,023611716899;0,0098;WENN(B1:B999999>=231,31214231278;0,125;(0,00059715499256153*B1:B999999+0,0025455442270028))); WENN(A1:A999999=4;WENN(B1:B999999<=8,8618633829445;0,0077;WENN(B1:B999999>=219,61948739302;0,125;(0,00063710437878404*B1:B999999+0,0020405503130787))); WENN(A1:A999999=5;WENN(B1:B999999<=8,0683702817689;0,0068;WENN(B1:B999999>=249,37064996217;0,125;(0,00058906284391034*B1:B999999+0,0017391721053351))); WENN(A1:A999999=6;WENN(B1:B999999<=5,3569717824498;0,0058;WENN(B1:B999999>=133,21031841331;0,1011;(0,00074744619531311*B1:B999999+0,0015021940435474))); WENN(A1:A999999=7;WENN(B1:B999999<=4,3643109311333;0,0049;WENN(B1:B999999>=90,370431493381;0,0727;(0,00078977592541601*B1:B999999+0,0012962057526498))); WENN(A1:A999999=8;WENN(B1:B999999<=3,3291657423134;0,0039;WENN(B1:B999999>=87,612293584114;0,0706;(0,00079399080394233*B1:B999999+0,0010648385910406))); WENN(A1:A999999=9;WENN(B1:B999999<=2,9439881662062;0,0029;WENN(B1:B999999>=75,601377547472;0,0515;(0,00066458507066795*B1:B999999+0,0011972721128791))); WENN(A1:A999999=10;WENN(B1:B999999<=2,4796588403417;0,0019;WENN(B1:B999999>=36,79114711734;0,0199;(0,00052397754322654*B1:B999999+0,00053850952142599))); 0)))))))))))Iki ngidini asil ing ngisor iki diprodhuksi:
| Negara | Piranti | Tanggal | \(S_{echt}\) | \(S_{berechnet}\) | \(\Delta\) | \(\Delta_{\%}\) | Url / direktori |
| SI | M. | 29.10.21 | \( 0{,}1348 \) | \( 0{,}1348 \) | \( 0{,}0000 \) | \( 0{,}00% \) | https://support.google.com/youtube/?hl=sl |
| SI | M. | 29.10.21 | \( 0{,}2156 \) | \( 0{,}2155 \) | \( 0{,}0001 \) | \( 0{,}05% \) | https://Me.twitter.com/youtube |
| SI | M. | 29.10.21 | \( 0{,}3746 \) | \( 0{,}3740 \) | \( 0{,}0006 \) | \( 0{,}16% \) | https://sl.m.wikipedia.org/wiki/YouTube |
| SI | M. | 29.10.21 | \( 0{,}6771 \) | \( 0{,}6760 \) | \( 0{,}0011 \) | \( 0{,}16% \) | https://m.facebook.com/youtube/ |
| SI | M. | 29.10.21 | \( 0{,}6836 \) | \( 0{,}6830 \) | \( 0{,}0006 \) | \( 0{,}09% \) | https://x2convert.com/en117/download-youtube-to-mp3-music |
| SI | M. | 29.10.21 | \( 0{,}7636 \) | \( 0{,}7555 \) | \( 0{,}0081 \) | \( 1{,}06% \) | https://www.youtubekids.com/ |
| SI | M. | 29.10.21 | \( 0{,}8749 \) | \( 0{,}8730 \) | \( 0{,}0019 \) | \( 0{,}22% \) | https://www.4kdownload.com/products/youtubetomp3/6 |
| SI | M. | 29.10.21 | \( 4{,}0020 \) | \( 3{,}9980 \) | \( 0{,}0040 \) | \( 0{,}10% \) | https://ytmp3.cc/en23/ |
| SI | M. | 29.10.21 | \( 8{,}0520 \) | \( 8{,}0520 \) | \( 0{,}0000 \) | \( 0{,}00% \) | https://support.google.com/youtube/ |
| SI | M. | 29.10.21 | \( 11{,}6600 \) | \( 11{,}6100 \) | \( 0{,}0500 \) | \( 0{,}43% \) | https://m.facebook.com/events/ |
| SI | M. | 29.10.21 | \( 19{,}7000 \) | \( 19{,}6890 \) | \( 0{,}0110 \) | \( 0{,}06% \) | https://minecraft.fandom.com/wiki/ |
| SI | M. | 29.10.21 | \( 32{,}5900 \) | \( 32{,}5890 \) | \( 0{,}0010 \) | \( 0{,}00% \) | https://hr.m.wikipedia.org/wiki/ |
| RO | M. | 29.10.21 | \( 0{,}1516 \) | \( 0{,}1516 \) | \( 0{,}0000 \) | \( 0{,}00% \) | https://lol.fandom.com/wiki/LCK/2021_Season/Summer_Season |
| Bp | M. | 29.10.21 | \( 0{,}2191 \) | \( 0{,}2190 \) | \( 0{,}0000 \) | \( 0{,}00% \) | https://starwars.fandom.com/wiki/Mandalorian |
| BG | M. | 03.11.21 | \( 0{,}3703 \) | \( 0{,}3702 \) | \( 0{,}0001 \) | \( 0{,}03% \) | https://leagueoflegends.fandom.com/wiki/List_of_champions |
Bentenane antarane nilai nyata lan sing diitung asale saka kesalahan pembulatan lan dataset winates sing digunakake kanggo nglatih model kasebut. Panjelasan ing ndhuwur bisa dadi dhasar kanggo nyempurnakake rumus luwih lanjut lan, contone, ngetung hubungan antarane volume telusuran lan klik sing diarepake. Sapa wae sing kasengsem karo skrip sing dikembangake sajrone risetku olèh ngubungi aku .