ʻ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 ma 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ā ʻike 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 kūpono 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ō i luna loa nā wahi o ka mākaukau aʻ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 hānai 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 ʻana 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 kaʻu mea hoihoi e pili ana i ka helu Daily Reads, ʻaʻole au e heluhelu i nā pou papa inoa loulou. Akā ʻaneʻane ʻike wau iaʻu i ka nānā ʻana i kāu.

    Ua manaʻo wau no ka mea like ko mākou makemake, a pēlā paha. Akā, me he mea lā ua paʻa me ka nui o nā mea heluhelu ʻē aʻe pū kekahi.

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

    • 2

      ʻO ia kaʻu mea e ʻimi nei ma ia mea, e Tony. ʻAʻole hiki iaʻu ke koho i kahi loulou ma waho o ke kumuhana o kaʻu blog… a heluhelu maoli wau i kēlā mau ʻatikala a makemake wau iā lākou ma mua o ka hoʻouna ʻana iā lākou!

      Loaʻa iaʻu iā lākou mai kahi helu nui o nā wahi, me nā mākaʻikaʻi Search Engine, blogs, nā pūnaewele bookmarking, etc.

      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.