Xisaabinta tusmada muuqaalka SISTRIX

Iyadoo ay weheliso Xovi, qalabka SISTRIX waa barnaamijka falanqaynta ugu badan ee Jarmalka ee aagga SEO. Tusaha muuqalka wuxuu isu dhigay inuu yahay halbeeg-qiyaas ah aragtida bogga Google-ka raadinta. Halbeegyada lagu daro xisaabinteeda waa, tusaale ahaan , halkan iyo halkan iyo halkan iyo halkan iyo halkan , laakiin qaacidada xisaabinta saxda ah si rasmi ah looma daabicin. Kuwa soo socdaa waa natiijooyinka cilmi-baadhis shakhsiyeed oo lix bilood ah, kuwaas oo aan sheegan inay dhammaystiran yihiin ama sax yihiin.


Leh

  • \(A_l\): SISTRIX Keyword Desk (lacagta kala duwan ee ereyada muhiimka ah ee si adag loo qeexay ee waddan gaar ah, set waxaa ku jira joogto ah - ku salaysan taraafikada ku salaysan celceliska 12-bilood - iyo ka yar, saami kala duwan)
  • \(\vert A_l \vert\) : \(A_l\) leh \(A_l\) \(\vert A_{DE} \vert = 1.000.000\) (status: 01.10.2021)
  • \(k \in A_l\): Kelmad furan \(A_l\)
  • \(u\): URL (si loogu tarjumo domain, subdomain, directory, URL shaqsi, iyadoo ku xidhan qaabka)
  • \(r_{uklgt}\) : Qiimaynta URL \(u\) ee natiijooyinka raadinta organic ee mashiinka raadinta Google ee ereyga muhiimka ah \(k\) ee dalka \(l\) ee nooca aaladda \(g\) waqtiga \(t\)
  • \(s_{klgt}\) : Mugga raadinta (celcelis ahaan weydiimaha raadinta bishiiba xogta SISTRIX, ee aan ka iman Google Keyword Planner , laakiin, sida ku cad bayaankeenna, laga soo ururiyey in ka badan darsin inta badan xogta ka ganacsada) ee ereyga muhiimka ah \(k\) im Dalka \(l\) nooca aaladda \(g\) waqtiga \(t\)
  • \(c_{uklgt}\) : \(c_{uklgt}\) qiyaasay URL-ka \(u\) ee ereyga muhiimka ah \(k\) ee dalka \(l\) ee nooca aaladda \(g\) waqtiga \(t\)
  • \(l \in L=\{DE;...;JP\}\) : Waddan leh \(\vert L \vert=30\) (sida: 01.06.2021)
  • \(g\in\{D;M\}\): Nooca aaladda (desktop/mobile)
  • \(t\): Waqtiga (taariikhda 00:00:00 subaxnimo)
  • \(S_{ulgt}\) : SISTRIX tusmada muuqaalka ee URL \(u\) dalka \(l\) ee ku yaal nooca aaladda \(g\) waqtiga \(t\)
  • \(W_S = \, \mathbb{Q}^{+}_{0}\) qiyamka \(W_S = \, \mathbb{Q}^{+}_{0}\)

waa lagu dabaqi karaa

$$S_{ulgt} = \sum_{k=1}^{\vert A_l \vert} f(r_{uklgt}, c_{uklgt})$$

leh

$$\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}$$

Qaaciidadan waxaa inta badan soo saaray injineerada gadaal ka ah iyada oo inta badan gacan laga helayo SISTRIX A PI ee rasmiga ah. Fikradda aasaasiga ah waxay ahayd: Dhibka ku yaree tusaalooyin fudud (hel URLs leh tusmooyin muuqaal togan oo leh hal/laba/saddex/... keywords) ka dibna isku day inaad soo saarto kiisas aad u adag.

Astaamaha tusmada tusmada:

  • Keliya ereyada muhiimka ah ee "xeerka ereyga joogtada ah" ee 1,000,000 ereyada muhiimka ah ayaa lagu daraa tusmada muuqaalka, ma aha ereyada muhiimka ah ee si joogto ah u ballaarinaya "database dhameystiran" (kaas oo la qabsanaya dhacdooyinka iyo duruufaha hadda jira), kaas oo hadda ka kooban 100,000,000 ereyada muhiimka ah ( Laga bilaabo Oktoobar 1-da, 2021). Kooxaha ereyada muhiimka ah ee kala duwan ayaa si fudud loo sifeyn karaa iyadoo la dooranayo qiimaha hoos yimaada "Taariikhda" ama iyadoo la dejinayo qiimaha lagu kordhiyay 0 gudaha API. Xogta caadiga ah ama xogta taariikheed waa joogto waxaana la ururiyey toddobaadle ilaa 2008, hadda maalin kasta.
  • Hits AMP kuma jiraan tusmada aragga.
  • Waxaa lagu talinayaa in lagu bilaabo falanqaynta ee dalalka dhawaan la abuuray sida Romania, Croatia, Slovenia iyo Bulgaria ama adiga oo abuuraya tusmada muuqashada adiga kuu gaar ah. Sababta tani waa SISTRIX waxay wadataa "ballast taariikhiga ah" ee waddamo ay ka mid yihiin Jarmalka, taas oo macnaheedu yahay in ereyada muhiimka ah ee la siin jiray miisaan sare ayaa hadda la isticmaalayaa xitaa in ka badan hal la filayo, inkastoo (sidoo kale waqti dheer) ) mug raadin hoose. Marka loo eego taageerada, wax walba waa in si tartiib tartiib ah loo hagaajiyo oo aan la arki karin mustaqbalka fog.
  • Si ka soo horjeeda malahayga asalka ah, mugga raadinta ayaa kaliya ka ciyaara door aan toos ahayn tusmada aragga. Taa beddelkeeda, gujisyada la filayo waa muhiim. Xidhiidhka ka dhexeeya mugga raadinta iyo qiyaasaha dhagsigu waxa uu inta badan ku salaysan yahay ujeeddada raadinta la qiyaasay, kaas oo sidoo kale la tilmaamay. SISTRIX lafteedu waxay si cad u tilmaamaysaa tan.
  • Dhagsiimada la filayo ayaa ah qodobka wadista ka dambeeya Tusmada Muuqaalka. Saamayntoodu kor iyo hoos ayay u xidhan tahay, si tusmada tusmaynta ay had iyo jeer u dhexayso xadka sare iyo hoose iyo toosan u dhexeeya.
  • Dhagsiimada laguma heli karo API-ga rasmiga ah, laakiin kaliya iyada oo loo marayo interface interface ama dhoofinta gacanta ee CSV. Labada xaaladoodba, qiyamku waa la soo koobay, laakiin DOM ee "Erayada Keywords" waxay sidoo kale ka kooban tahay qiyamka asalka ah.:
Marka lagu daro qiyamka wareegsan, waxa kale oo aad ka heli kartaa qiyamka cayriin.

Qaabka soo socda ayaa sidoo kale lagu isticmaali karaa Excel ama Google Sheets; Waxay xisaabinaysaa tusaha aragga ee xaashida shaqada kaas oo saf kastaa ka kooban yahay kelmad muhiim ah oo leh booskeeda tiirka A iyo dhagsiinteeda la filayo ee tiirka B.:

=SUMME(WENN(A1:A999999=1;WENN(B1:B999999=378,32500379436;0,125;(0,00037306471297181*B1:B999999+0,011944496557952))); WENN(A1:A999999=2;WENN(B1:B999999=230,68394113271;0,125;(0,00055449577110866*B1:B999999+0,0035350976909409))); WENN(A1:A999999=3;WENN(B1:B999999=231,31214231278;0,125;(0,00059715499256153*B1:B999999+0,0025455442270028))); WENN(A1:A999999=4;WENN(B1:B999999=219,61948739302;0,125;(0,00063710437878404*B1:B999999+0,0020405503130787))); WENN(A1:A999999=5;WENN(B1:B999999=249,37064996217;0,125;(0,00058906284391034*B1:B999999+0,0017391721053351))); WENN(A1:A999999=6;WENN(B1:B999999=133,21031841331;0,1011;(0,00074744619531311*B1:B999999+0,0015021940435474))); WENN(A1:A999999=7;WENN(B1:B999999=90,370431493381;0,0727;(0,00078977592541601*B1:B999999+0,0012962057526498))); WENN(A1:A999999=8;WENN(B1:B999999=87,612293584114;0,0706;(0,00079399080394233*B1:B999999+0,0010648385910406))); WENN(A1:A999999=9;WENN(B1:B999999=75,601377547472;0,0515;(0,00066458507066795*B1:B999999+0,0011972721128791))); WENN(A1:A999999=10;WENN(B1:B999999=36,79114711734;0,0199;(0,00052397754322654*B1:B999999+0,00053850952142599))); 0)))))))))))

Tani waxay u oggolaanaysaa natiijooyinka soo socda in la soo saaro:

DalkaQalabkaTaariikhda\(S_{echt}\)\(S_{berechnet}\)\(\Delta\)\(\Delta_{\%}\)Url / hagaha
SIM.29.10.21\( 0{,}1348 \)\( 0{,}1348 \)\( 0{,}0000 \)\( 0{,}00% \)https://support.google.com/youtube/?hl=sl
SIM.29.10.21\( 0{,}2156 \)\( 0{,}2155 \)\( 0{,}0001 \)\( 0{,}05% \)https://Me.twitter.com/youtube
SIM.29.10.21\( 0{,}3746 \)\( 0{,}3740 \)\( 0{,}0006 \)\( 0{,}16% \)https://sl.m.wikipedia.org/wiki/YouTube
SIM.29.10.21\( 0{,}6771 \)\( 0{,}6760 \)\( 0{,}0011 \)\( 0{,}16% \)https://m.facebook.com/youtube/
SIM.29.10.21\( 0{,}6836 \)\( 0{,}6830 \)\( 0{,}0006 \)\( 0{,}09% \)https://x2convert.com/en117/download-youtube-to-mp3-music
SIM.29.10.21\( 0{,}7636 \)\( 0{,}7555 \)\( 0{,}0081 \)\( 1{,}06% \)https://www.youtubekids.com/
SIM.29.10.21\( 0{,}8749 \)\( 0{,}8730 \)\( 0{,}0019 \)\( 0{,}22% \)https://www.4kdownload.com/products/youtubetomp3/6
SIM.29.10.21\( 4{,}0020 \)\( 3{,}9980 \)\( 0{,}0040 \)\( 0{,}10% \)https://ytmp3.cc/en23/
SIM.29.10.21\( 8{,}0520 \)\( 8{,}0520 \)\( 0{,}0000 \)\( 0{,}00% \)https://support.google.com/youtube/
SIM.29.10.21\( 11{,}6600 \)\( 11{,}6100 \)\( 0{,}0500 \)\( 0{,}43% \)https://m.facebook.com/events/
SIM.29.10.21\( 19{,}7000 \)\( 19{,}6890 \)\( 0{,}0110 \)\( 0{,}06% \)https://minecraft.fandom.com/wiki/
SIM.29.10.21\( 32{,}5900 \)\( 32{,}5890 \)\( 0{,}0010 \)\( 0{,}00% \)https://hr.m.wikipedia.org/wiki/
ROM.29.10.21\( 0{,}1516 \)\( 0{,}1516 \)\( 0{,}0000 \)\( 0{,}00% \)https://lol.fandom.com/wiki/LCK/2021_Season/Summer_Season
MUDANEM.29.10.21\( 0{,}2191 \)\( 0{,}2190 \)\( 0{,}0000 \)\( 0{,}00% \)https://starwars.fandom.com/wiki/Mandalorian
BGM.03.11.21\( 0{,}3703 \)\( 0{,}3702 \)\( 0{,}0001 \)\( 0{,}03% \)https://leagueoflegends.fandom.com/wiki/List_of_champions

Farqiga u dhexeeya qiyamka dhabta ah iyo kuwa la xisaabiyay waxaa sababa khaladaadka soo koobaya iyo xogta xaddidan ee ku saleysan tababarka qaabka. Odhaahyada kor ku xusan waxay u adeegi karaan saldhig si loo sii sifeeyo qaacidada iyo, tusaale ahaan, xisaabinta xidhiidhka ka dhexeeya mugga raadinta iyo gujisyada la filayo. Haddii aad xiisaynayso qoraallada soo kacay intii aan cilmi-baadhista ku jiray, fadlan xor u noqo inaad ila soo xidhiidho .

Dib u laabo