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 kalebu konstan - adhedhasar lalu lintas adhedhasar rata-rata 12 sasi - lan proporsi sing luwih cilik, beda-beda)
- \(\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 (pitakon telusuran rata-rata saben sasi kanthi data saka SISTRIX, dudu saka Google Keyword Planner , nanging, miturut statement kita dhewe, akumulasi saka luwih saka selusin biasane pedagang data eksternal) kanggo tembung kunci \(k\) im 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 kanggo miwiti analisis ing negara-negara sing nembe ditambahake kayata Rumania, Kroasia, Slovenia, lan Bulgaria, utawa kanthi nggawe indeks visibilitas dhewe . Iki amarga SISTRIX nggawa "bagasi historis" ing negara-negara kaya Jerman, sing tegese tembung kunci kanthi bobot sing luwih dhuwur ing jaman kepungkur, sanajan (sanajan wis suwe) volume telusuran kurang, saiki isih duwe pengaruh sing luwih kuat tinimbang sing dikarepake. Miturut dhukungan, iki bakal diatur kanthi bertahap lan pungkasane bakal ilang.
- 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 lembar kerja 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 .