ʻO kaʻu nīnau MySQL no ka huki ʻana i nā ʻāpana ma WordPress

Depositphotos 12429678 s

I kēia mau lā, ua ʻike ʻia nā pou aʻu i kākau ai e pili ana i koʻu ola home i ka loaʻa ʻana o nā ʻaoʻao ʻē aʻe he nui aʻe ma mua o kekahi o kaʻu kumuhana ʻē aʻe. Kākoʻo ia i ka ʻaoʻao pilikino o ka blog ʻana ka mea e ʻumeʻume ai i nā mea heluhelu hou aʻe no laila makemake wau e ʻike. ʻO kekahi o kaʻu mau pou i pili i koʻu ola pilikino, hoʻohui wau i kahi hulina kikoʻī i. Hoʻopili ʻia ke koena o nā ʻāpana e pili ana i ka ʻike. Ua hana wau i kēia ma ke kumu i hiki ai iaʻu ke hōʻike ma ia mea. Ua hiki mai kēlā manawa!

Nīnau WordPress

ʻAʻole maʻalahi ia e like me kou noʻonoʻo e noʻonoʻo ai. Ua lawe ka hana holoʻokoʻa iaʻu i kekahi mau hola mai ka ʻikepili e hōʻike! ʻO ka wī mua ka huki ʻana i ka ʻikepili mai kaʻu waihona pūnaewele blog. I ka WordPress, koi ia i kahi nīnau noi maikaʻi ma waena o ʻekolu papa, nā kia, nā post2cats, a me nā waeʻano. Inā makemake ʻoe e hana i kēia, eia ka nīnau:

SELECT `post_date`,` cat_name` MAI 'wp_posts` LEFT JOIN `wp_post2cat` ON` wp_posts`.ID = `wp_post2cat`.post_id LEFT JOIN` wp_categories` ON ​​`wp_categories`.cat_ID =` wp_post2cat` .category

E hoʻomaopopo e loaʻa iā ʻoe ma mua o hoʻokahi mau moʻolelo i kēlā me kēia pou inā koho ʻoe i nā mahele he nui i kahi pou. Maikaʻi kēlā, hana maoli wau i kēlā i kaʻu loiloi.

Google Analytics

Maʻalahi loa ʻo Google e huki i ka ʻikepili ma ka lā āu e pono ai a hoʻokuʻu aku iā ia ma ke ʻano he CSV file. Ua huki wale wau i ka launa like a me ka helu o nā ʻaoʻao ʻaoʻao. A laila ua hoʻohui mākou i nā kumuwaiwai ʻelua, nā pou blog a me nā mahele a me nā ʻaoʻao ʻaoʻao e pili ana. Nā mea leʻaleʻa!

Ka Ikepili

ʻO ka hopena aʻe ka leʻaleʻa! Aia kahi moʻo o nā nīnau a me nā ʻanuʻu āu e hele ai (ʻaʻole wau makemake e hele i kēlā kikoʻī ma aneʻi) akā ʻo ka hopena kumu makemake wau e helu i ka helu o nā ʻaoʻao i hoʻokaʻawale ʻia e ka helu o nā pou i kēlā me kēia mahele. A laila helu wau i nā manaʻo awelika no kēlā me kēia pou ma ka blog holoʻokoʻa a hoʻohālikelike i nā hopena.

ʻO ka mea āu e ʻike ai ma lalo nei kahi loiloi o ka Papa Kuhikuhi o nā ʻaoʻao ʻaoʻao e ka waeʻano. Kaomi ma ke kiʻi inā makemake ʻoe e ʻike i ka nui piha. ʻO kahi papa inoa o 100 ka awelika. ʻO ka papa kuhikuhi o 200 ʻo ia ka ʻelua mau manawa o ka mahele i nā hits o ka pou maʻamau. ʻO kahi papa inoa o 50 ka hapalua o ka awelika.

Papa Kuhikuhi Māhele Blog

hopena a

ʻAʻole maikaʻi kaʻu i manaʻo ai, akā manaʻo wau he mea kūpono kekahi o ia. Ma ka palena haʻahaʻa loa o ka pālākiō (ʻākau), ʻike mākou i kekahi mau kumuhana saturated, ʻeā? Politics, Technology, Business, Blogging, etc. ʻike pū mākou i kekahi mau kumuhana niche, nui loa e like me Google Maps. ʻOiai ʻaʻole ia he kumuhana mua o kaʻu blog, kanalua ʻole wau ke hāpai nei i ka nui o ka nānā no kēlā.

He make-waena maoli ʻo Homefront! Ua manaʻo wau e papa kiʻekiʻe ʻo ia akā ʻo ka ʻoiaʻiʻo ʻaʻole ia ma lalo o ka papa kuhikuhi e haʻi iaʻu ʻaʻole ia he mea e hōʻeha ai i kaʻu blog. Ke kōkua nei anei ia? Maliʻa paha ma ka hoʻopaʻa ʻana, akā ʻaʻole ka nānā pono ʻana i ka ʻaoʻao.

ʻO ka mea e uwō maoli i luna ʻo nā wahi o ka loea i loaʻa iaʻu. Kālailai… auwē! Manaʻo wau he wahi kumuhana kēia e ʻuwā nei no ke kōkua. ʻAʻole nui loa ka pūnaewele analytics blog ma laila! Makemake ka poʻe e ʻike pehea e hoʻohana ai analytics, pehea e hoʻokō ai, a laila pehea e hōʻike ai a hana ai i nā hoʻololi e pili ana iā ia (e like me kēia pou!).

ʻO ka mea hoihoi hoihoi ʻē aʻe kaʻu "Daily Reads". Ua noʻonoʻo pono wau i waena o ke ala kēlā mau mea, akā kiʻekiʻe loa lākou. Makemake ka poʻe i ka mea aʻu e heluhelu nei a paipai iā lākou! Maikaʻi loa kēlā. I kēlā me kēia lā heluhelu wau i loko o nā haneli a me nā pūnaewele a hoʻāʻo wau e huki i nā moʻolelo kūikawā e mahalo ai ka poʻe. I nā manawa he nui, he mau loulou kēia i nā blog ʻē aʻe aʻu e ʻike hoihoi a makemake wau e hoʻohele. ʻIke ʻia ke pili aloha i pili i kēia uku!

Aia iā ʻoe ia! He mau makahiki o ka ʻikepili o ka poʻe heluhelu! Makemake au e hana i ka mea maʻalahi e hana i kēia kālailai i ka manawa aʻe. Makemake au e hana i ka hana ʻana i nā ʻāpana i kaʻu analytics nā hōʻike i hiki iaʻu ke nānā pono iā lākou.

3 Comments

  1. 1

    ʻO nā mea aʻu e hoihoi ai e pili ana i ka helu Heluhelu Daily he kakaʻikahi wau, inā paha, e heluhelu i nā pou papa inoa link. Akā ʻaneʻane ʻike wau i ka nānā ʻana iā ʻoe iho i kāu.

    Ua manaʻo wau no ka mea like kā mākou hoihoi, a ʻo ia paha. Akā me he mea lā ke kuʻi nei ia me nā mea heluhelu he nui pū kekahi.

    Ua loaʻa iaʻu kekahi mau mea maikaʻi mai kāu Daily Reads. Loaʻa paha iā ʻoe kahi mākaukau no ka kānana ʻana i loko o ka ʻōpala no mākou 🙂

    • 2

      ʻO ia nō kaʻu e ukali nei ma ia mea, e Tony. Kākaʻikahi loa wau e koho i kahi loulou ma waho o ke kumuhana o kaʻu blog ... a heluhelu maoli wau i kēlā mau ʻatikala a makemake iā lākou ma mua o ka kau ʻana iā lākou.

      ʻIke wau iā lākou mai kahi [hoʻomākeʻaka] helu nui o nā wahi, e like me nā ʻenekini Search Engine, nā blog, nā pūnaewele kākau pūnaewele, a pēlā aku.

      Mahalo, Tony!

Pehea kou manaʻo?

Ke hoʻohana nei kēia pūnaewele i ka Akismet e ho'ēmi i ka spam. E aʻo pehea e hanaʻia ai kāuʻikeʻikepili.