Umbuzo we-MySQL Wokudonsa Izigaba ku-WordPress

Ama-Depositphotos 12429678 s

Muva nje, kuvele ukuthi engikubhalile ngempilo yami yasekhaya kubonakale kuthola ukubukwa kwamakhasi okuningi kunezinye izihloko zami. Kungasekela ukuthi isici somuntu siqu sokubhuloga yilokho okuheha abafundi abaningi ngakho-ke bengifuna ukuthola. Noma yikuphi okuthunyelwe kwami ​​okuthinta impilo yami yangasese, ngifaka umbuzo othize ku. Zonke ezinye izigaba zisetshenziswa ngokuya ngokuqukethwe. Lokhu ngikwenze ngenhloso ukuze ngigcine ngibike ngakho. Sesifikile leso sikhathi!

Umbuzo we-WordPress

Akulula njengoba ungacabanga ukukuthola, noma kunjalo. Yonke inqubo ingithathe amahora ambalwa kusuka kudatha ukubika! Inselelo yokuqala bekungukukhipha idatha ku-database yami yebhulogi. Ku-WordPress, kudinga umbuzo omuhle wokujoyina phakathi kwamatafula amathathu, okuthunyelwe, okuthunyelwe2cats, nezigaba. Uma ungathanda ukwenza lokhu, nanku umbuzo:

KHETHA `usuku_posi`,` cat_name` FROM `wp_posts` LEFT JOIN` wp_post2cat` ON `wp_posts`.ID =` wp_post2cat`.post_id LEFT JOIN `wp_categories` ON` wp_categories`.cat_ID = `wp_post2`

Qaphela ukuthi empeleni uzobuyisa ngaphezu kwerekhodi elilodwa ngeposi uma ukhethe izigaba eziningi kokuthunyelwe. Kulungile, empeleni ngibhekana nalokho ekuhlaziyweni kwami.

-Google Analytics

I-Google yenza kube lula ukudonsa idatha ngosuku oyidingayo futhi uyihambise njengefayela le-CSV. Ngimane ngadonsa ibanga losuku elifanayo nenombolo yokubukwa kwamakhasi. Ngibe sengiyihlanganisa yomibili imithombo, okuthunyelwe kwebhulogi nezigaba nokubukwa kwekhasi okuhambisanayo. Izinto ezimnandi!

Analysis

Isinyathelo esilandelayo yiso esimnandi! Kunochungechunge lwemibuzo nezinyathelo okufanele udlule kuzo (angifuni ukungena emininingwaneni eminingi lapha) kepha umphumela oyisisekelo ngukuthi ngifuna ukubala inani lokubukwa kwamakhasi okuhlukaniswe ngenani lokuthunyelwe esigabeni ngasinye. Ngibe sengibala ukubukwa okujwayelekile ngokuthunyelwe ngakunye kubhulogi yonke bese ngiqhathanisa imiphumela.

Lokho okubonayo ngezansi ukuhlaziywa kwe-Index of Page Views by Category. Chofoza esithombeni uma ungathanda ukusibona sigcwele. Inkomba ye-100 isilinganiso. Inkomba engu-200 isho ukuthi isigaba sinezikhathi eziphindwe kabili kokushaywayo kokuthunyelwe okujwayelekile. Inkomba yama-50 yingxenye yesilinganiso.

Inkomba Yesigaba Sebhulogi

iziphetho

Hhayi lokho ebengikulindele, kepha ngicabanga ukuthi okunye kunengqondo. Emaphethelweni aphansi kakhulu esikalini (kwesokudla), sibona izihloko ezigcwele, akunjalo? Ezombusazwe, ezobuchwepheshe, ezebhizinisi, ukubhuloga, njll. Futhi sibona izihloko ezithile kakhulu, ezinjenge-Google Maps. Njengoba kungesona isihloko esiyinhloko sebhulogi yami, Akungabazeki ukuthi ngidonsela ukunakwa okuningi ngalokho.

Isizinda sangaphambili sasicishe sifile! Bengicabanga ukuthi izokhomba ngaphezulu kepha iqiniso lokuthi alikho ngaphansi kwenkomba lingitshela ukuthi ayilimazi neze ibhulogi yami. Ngabe kuyasiza? Mhlawumbe ekugcineni, kepha hhayi ukubukwa kwekhasi okuqondile.

Okubhonga kakhulu phezulu yizindawo zobuchwepheshe enginazo. Izibalo… wow! Ngicabanga ukuthi le yindawo yesihloko ekhalela usizo. Azikho iwebhu eziningi kakhulu analytics amabhulogi laphaya! Abantu bafuna ukwazi ukuthi bangayisebenzisa kanjani analytics, ukuthi ungayisebenzisa kanjani, nokuthi ungabika kanjani futhi wenze izinguquko ngokususelwa kuyo (njengalokhu okuthunyelwe!).

Enye into ethokozisayo yi- "Daily Reads" yami. Ngacabanga ngokuqinisekile ukuthi lezo zizoba maphakathi nomgwaqo, kepha empeleni ziphakeme kakhulu. Abantu banesithakazelo kulokhu engikufundayo futhi ngincoma kubo! Kuzwakala kukuhle lokho. Nsuku zonke ngifunda amakhulukhulu wokuphakelwa namasayithi futhi ngizama ukubuyisa izindaba ezihlukile abantu abangazazisa. Izikhathi eziningi, lezi yizixhumanisi kwamanye amabhulogi engiwathola ethakazelisa futhi ngifuna ukuwadlulisa. Kubonakala sengathi ubudlelwano obubandakanyekile kulokhu kuyasiza!

Lapho unayo! Idatha ebiza iminyaka yokufunda! Ngingathanda kakhulu ukwenza kube lula kakhulu ukwenza lokhu kuhlaziya ngokuzayo. Ngifuna ukusebenza ngokuzenzela izigaba zibe yi- analytics ibika ukuze ngikwazi ukubabhekisisa.

3 Amazwana

  1. 1

    Engikuthola kuthakazelisa ngenombolo yeDaily Reads angivamile ukuthi, uma kwenzeka, ngifunde okuthunyelwe kohlu lwezixhumanisi. Kepha cishe njalo ngizithola ngithwebula okwakho.

    Bengicabanga ukuthi kungenxa yokuthi sinezintshisakalo ezifanayo, futhi kungaba njalo. Kepha kubukeka sengathi ishaya nabanye abafundi abaningi futhi.

    Ngithole izinto ezinhle kuma-Daily Reads wakho. Mhlawumbe unekhono nje lokuhlunga ngokungafuneki kwethu 🙂

    • 2

      Yilokho engikulandelayo ngemuva kwalokho, Tony. Akuvamile kakhulu ukuthi ngikhethe isixhumanisi esingaphandle kwesihloko sebhulogi yami… futhi ngiyazifunda ngempela lezo zihloko futhi ngiyazithanda ngaphambi kokuzithumela!

      Ngibathola ezindaweni eziningi [ezihlekisayo], kufaka phakathi izexwayiso ze-Search Engine, amabhulogi, amasayithi amabhukumaka enhlalo, njll.

      Ngiyabonga, Tony!

UCABANGANI?

Le sayithi isebenzisa i-Akismet ukunciphisa ugaxekile. Funda ukuthi idatha yakho yokuphawula isetshenziswa kanjani.