{"id":753,"date":"2026-11-21T13:58:00","date_gmt":"2026-11-21T10:58:00","guid":{"rendered":"https:\/\/porego.com\/blog\/?p=753"},"modified":"2026-11-18T21:52:20","modified_gmt":"2026-11-18T18:52:20","slug":"sessiz-musteri-kaybi","status":"publish","type":"post","link":"https:\/\/porego.com\/blog\/sessiz-musteri-kaybi\/","title":{"rendered":"Tekrar Sat\u0131n Alma Oran\u0131 Nas\u0131l Hesaplan\u0131r? Ge\u00e7 Teslimat\u0131n Sessiz Kayb\u0131n\u0131 Kohortla Bulun"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Ge\u00e7 gelen bir koli i\u00e7in m\u00fc\u015fteri size yazarsa elinizde bir kay\u0131t olur: mesaj, arama notu, belki bir kupon. Yazmazsa tek iz, sipari\u015f d\u00f6k\u00fcm\u00fcn\u00fczde hi\u00e7 olu\u015fmayan ikinci sat\u0131rd\u0131r. O sat\u0131r\u0131 g\u00f6rmenin yolu tekrar sat\u0131n alma oran\u0131n\u0131 tek say\u0131 olarak de\u011fil, ilk sipari\u015fin nas\u0131l teslim edildi\u011fine g\u00f6re gruplarda hesaplamakt\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">T\u00dc\u0130K&#8217;in Hanehalk\u0131 Bili\u015fim Teknolojileri Kullan\u0131m Ara\u015ft\u0131rmas\u0131&#8217;n\u0131n 2025 verisine (<a href=\"https:\/\/ec.europa.eu\/eurostat\/databrowser\/view\/isoc_ec_iprb21\/default\/table?lang=en\" target=\"_blank\" rel=\"noopener\">Eurostat veri taban\u0131nda<\/a>) g\u00f6re son \u00fc\u00e7 ayda internetten al\u0131\u015fveri\u015f yapan bireylerin %12,7&#8217;si teslimat\u0131n belirtilenden yava\u015f geldi\u011fini s\u00f6yledi; yani yakla\u015f\u0131k her 8 ki\u015fiden biri en az bir kez ge\u00e7 teslimat ya\u015fad\u0131. Ayn\u0131 grupta %11,8 yanl\u0131\u015f ya da hasarl\u0131 \u00fcr\u00fcn teslimi, %28,9 ise herhangi bir sorun bildirdi. Veri bu ki\u015filerin ka\u00e7\u0131n\u0131n sat\u0131c\u0131ya yazd\u0131\u011f\u0131n\u0131 s\u00f6ylemez.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Tekrar sat\u0131n alma oran\u0131 nas\u0131l hesaplan\u0131r?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Bu yaz\u0131da tekrar sat\u0131n alma oran\u0131 \u015fudur: belirli bir d\u00f6nemde ilk sipari\u015fini veren m\u00fc\u015fterilerden, ilk sipari\u015ften sonraki 90 g\u00fcn i\u00e7inde ikinci kez sipari\u015f verenlerin oran\u0131; paydada yaln\u0131z 90 g\u00fcn\u00fc dolmu\u015f ilk sipari\u015f sahipleri vard\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D\u00f6nem oran\u0131 (d\u00f6nem i\u00e7inde iki ve daha fazla sipari\u015f veren m\u00fc\u015fteri \u00f7 o d\u00f6nemdeki m\u00fc\u015fteri) ise yan\u0131lt\u0131r. Eyl\u00fcl-Kas\u0131m aras\u0131nda 1.000 m\u00fc\u015fterinin 180&#8217;i iki ve \u00fczeri sipari\u015f verdi: 180 \u00f7 1.000 = %18,0. Kas\u0131m kampanyas\u0131yla tek sipari\u015fli 400 yeni m\u00fc\u015fteri gelince 180 \u00f7 1.400 = %12,86 olur. Kimse ka\u00e7madan oran 5 puan d\u00fc\u015ft\u00fc, \u00e7\u00fcnk\u00fc d\u00f6nem sonunda gelen m\u00fc\u015fterinin ikinci kez almaya vakti olmad\u0131.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">M\u00fc\u015fteriyi hangi alanla tan\u0131yacaks\u0131n\u0131z?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Misafir sipari\u015fte ayn\u0131 ki\u015fi her seferinde farkl\u0131 e-postayla gelebilir. <a href=\"https:\/\/woocommerce.com\/document\/woocommerce-analytics\/customers-report\/\" target=\"_blank\" rel=\"noopener\">WooCommerce&#8217;in m\u00fc\u015fteri raporu<\/a> kay\u0131tl\u0131 m\u00fc\u015fterilerle misafirleri birlikte listeler; misafir ayn\u0131 e-postayla birden \u00e7ok sipari\u015f verirse bu sipari\u015fleri ayn\u0131 m\u00fc\u015fteri kayd\u0131na ba\u011flar. Raporda fatura telefonu s\u00fctunu varsay\u0131lan olarak gizlidir, s\u00fctun men\u00fcs\u00fcnden a\u00e7\u0131l\u0131r. Bu tabloda anahtar telefonun son 10 hanesidir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&#8220;+90 532 123 45 67&#8221;, &#8220;0532-123-4567&#8221;, &#8220;532 123 4567&#8221; ve &#8220;05321234567&#8221; yaz\u0131mlar\u0131n\u0131n hepsi bo\u015fluk ve tire silinip son 10 hane al\u0131n\u0131nca &#8220;5321234567&#8221; olur. &#8220;(0532) 123 45 67&#8221; ise &#8220;32)1234567&#8221; verir; parantezli yaz\u0131m i\u00e7in form\u00fcle ayr\u0131ca bir YER\u0130NEKOY eklenir (a\u015fa\u011f\u0131da).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">90 g\u00fcn\u00fc dolmayan ilk sipari\u015fi tabloya almay\u0131n<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">90 g\u00fcn evrensel bir kural de\u011fil, bu yaz\u0131n\u0131n se\u00e7ti\u011fi penceredir. \u00dcr\u00fcn\u00fcn\u00fcz\u00fcn do\u011fal yeniden al\u0131m aral\u0131\u011f\u0131na g\u00f6re de\u011fi\u015ftirebilirsiniz, ama bir kez se\u00e7ince her kohortta ayn\u0131 kalmal\u0131. D\u00f6k\u00fcm tarihi 18 Kas\u0131m 2026 ise 18 Kas\u0131m \u2212 90 g\u00fcn = 20 A\u011fustos: o d\u00f6k\u00fcmde en son 20 A\u011fustos&#8217;ta verilen ilk sipari\u015fler tabloya girer, sonrakilerin 90 g\u00fcn\u00fc hen\u00fcz dolmad\u0131.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0130lk sipari\u015fi teslim deneyimine g\u00f6re be\u015f gruba ay\u0131r\u0131n<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1344\" height=\"752\" src=\"https:\/\/porego.com\/blog\/wp-content\/uploads\/2026\/11\/ilk-siparis-gruplari-kart-desteleri.webp\" alt=\"Depo ofisindeki masada farkl\u0131 renk k\u0131ska\u00e7larla ayr\u0131lm\u0131\u015f be\u015f deste bo\u015f kart ve turuncu k\u0131ska\u00e7l\u0131 desteye bir kart daha b\u0131rakan el\" class=\"wp-image-752\" srcset=\"https:\/\/porego.com\/blog\/wp-content\/uploads\/2026\/11\/ilk-siparis-gruplari-kart-desteleri.webp 1344w, https:\/\/porego.com\/blog\/wp-content\/uploads\/2026\/11\/ilk-siparis-gruplari-kart-desteleri-300x168.webp 300w, https:\/\/porego.com\/blog\/wp-content\/uploads\/2026\/11\/ilk-siparis-gruplari-kart-desteleri-1024x573.webp 1024w, https:\/\/porego.com\/blog\/wp-content\/uploads\/2026\/11\/ilk-siparis-gruplari-kart-desteleri-768x430.webp 768w\" sizes=\"auto, (max-width: 1344px) 100vw, 1344px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Tek bir oran fark\u0131 gizler. A\u015fa\u011f\u0131daki \u00f6rnek kohortta (sonraki b\u00f6l\u00fcmde) genel oran %18,4 \u00e7\u0131kar, gruplar ise %10,7 ile %21,0 aras\u0131nda da\u011f\u0131l\u0131r. Her ilk sipari\u015fi \u015fu gruplardan birine koyun:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead><tr><th>Grup<\/th><th>Ne zaman bu gruba girer<\/th><th>Nas\u0131l okunur<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>Zaman\u0131nda<\/td><td>\u00dcr\u00fcn teslim edildi, teslim s\u00fcresi N2&#8217;yi a\u015fmad\u0131, sorun kodu yok<\/td><td>Kar\u015f\u0131la\u015ft\u0131rma taban\u0131<\/td><\/tr>\n<tr><td>Ge\u00e7<\/td><td>\u00dcr\u00fcn teslim edildi, teslim s\u00fcresi N2&#8217;yi a\u015ft\u0131, sorun kodu yok<\/td><td>Tabanla fark\u0131 s\u0131nan\u0131r<\/td><\/tr>\n<tr><td>Sorunlu<\/td><td>\u00dcr\u00fcn teslim edildi ama sorun kodu var: yanl\u0131\u015f, hasarl\u0131, eksik \u00fcr\u00fcn ya da yeniden g\u00f6nderim<\/td><td>Tabanla fark\u0131 s\u0131nan\u0131r<\/td><\/tr>\n<tr><td>\u0130ade<\/td><td>M\u00fc\u015fteri \u00fcr\u00fcn\u00fc teslim ald\u0131, sonra iade etti<\/td><td>Ayr\u0131 okunur; teslimat d\u0131\u015f\u0131 nedenler de ta\u015f\u0131r<\/td><\/tr>\n<tr><td>Teslim al\u0131nmad\u0131<\/td><td>\u00dcr\u00fcn m\u00fc\u015fteriye ula\u015fmad\u0131 (\u00f6r. kap\u0131da \u00f6demede teslim al\u0131nmad\u0131)<\/td><td>Oran hesaplanmaz; sipari\u015f onay\u0131n\u0131 \u00f6l\u00e7er<\/td><\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Teslim al\u0131nmayan ilk sipari\u015f orana girmez: m\u00fc\u015fteri \u00fcr\u00fcn\u00fc hi\u00e7 almad\u0131\u011f\u0131 i\u00e7in bu sat\u0131r teslimat deneyimini de\u011fil sipari\u015f onay\u0131n\u0131 \u00f6l\u00e7er (<a href=\"https:\/\/porego.com\/blog\/kapida-odeme-iadeleri-nasil-azaltilir\/\">kap\u0131da \u00f6deme iadeleri rehberi<\/a>). M\u00fc\u015fteri talebiyle iade edilen ilk sipari\u015f ayr\u0131 sat\u0131rd\u0131r. Sorunlu ve \u0130ade gruplar\u0131ndaki sorun kodunu nas\u0131l tutaca\u011f\u0131n\u0131z i\u00e7in <a href=\"https:\/\/porego.com\/blog\/iade-orani-nasil-dusurulur-e-ticaret\/\">iade oran\u0131 yaz\u0131s\u0131ndaki neden kodu y\u00f6ntemine<\/a> bak\u0131n.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Ge\u00e7 teslimin \u00f6l\u00e7\u00fcs\u00fc sizin verdi\u011finiz s\u00fcre<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Teslim s\u00fcresi = teslim tarihi \u2212 sipari\u015f tarihi, takvim g\u00fcn\u00fcyle. E\u015fik (N2), sitenizde s\u00f6z verdi\u011finiz s\u00fcredir; i\u015f g\u00fcn\u00fcyle s\u00f6z verdiyseniz tek bir takvim g\u00fcn\u00fc kar\u015f\u0131l\u0131\u011f\u0131 se\u00e7ip her kohortta ayn\u0131 tutun. Teslim tarihini <a href=\"https:\/\/porego.com\/blog\/kargo-takip-sistemi-nasil-calisir-e-ticarette-surecler-ve-avantajlari-2026-rehberi\/\">takip kayd\u0131ndan<\/a> al\u0131n.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Porego&#8217;da nas\u0131l yap\u0131l\u0131r?<\/strong> Porego&#8217;da g\u00f6nderi olu\u015ftururken firmalar\u0131n fiyatlar\u0131n\u0131 ve teslimat s\u00fcrelerini tek panelde kar\u015f\u0131la\u015ft\u0131r\u0131rs\u0131n\u0131z. Ge\u00e7 grubunuz bir firmada toplan\u0131yorsa o firman\u0131n panelde g\u00f6sterilen s\u00fcresini tablonuzdaki ger\u00e7ekle\u015fen s\u00fcrelerle kar\u015f\u0131la\u015ft\u0131r\u0131n. <a href=\"https:\/\/porego.com\/tr\/legal\/platform-kurallari-ve-ekler\/\">Platform Kurallar\u0131 ve Ekler<\/a>&#8216;e g\u00f6re panelde g\u00f6sterilen teslim s\u00fcreleri tahmini olabilir (B\u00f6l\u00fcm 3, m. 8.2); D s\u00fctununa bu y\u00fczden takip kayd\u0131ndaki teslim tarihini yaz\u0131n.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Excel&#8217;de kohort tablosu nas\u0131l kurulur?<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Sipari\u015f d\u00f6k\u00fcm\u00fcnden al\u0131nacak s\u00fctunlar<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Tabloda her sat\u0131r bir sipari\u015ftir, \u00fcr\u00fcn sat\u0131r\u0131 de\u011fil; \u00fc\u00e7 \u00fcr\u00fcnl\u00fc sipari\u015f tek sat\u0131rd\u0131r.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n\n<li>Sipari\u015f numaras\u0131 (A)<\/li>\n\n\n<li>Sipari\u015f tarihi, yaln\u0131z g\u00fcn (B). D\u00f6k\u00fcmde saat de varsa g\u00fcn\u00fc ayr\u0131 s\u00fctuna al\u0131n.<\/li>\n\n\n<li>M\u00fc\u015fteri telefonu, ham h\u00e2liyle (C)<\/li>\n\n\n<li>Teslim tarihi (D), takip kayd\u0131ndan. Bo\u015f sat\u0131rlar\u0131 \u00f6nce doldurun ya da ay\u0131klay\u0131n, \u00e7\u00fcnk\u00fc bo\u015f D zaman\u0131nda g\u00f6r\u00fcn\u00fcr.<\/li>\n\n\n<li>Son durum (E): &#8220;Teslim edildi&#8221;, &#8220;Teslim al\u0131nmad\u0131&#8221; ya da &#8220;\u0130ade&#8221;<\/li>\n\n\n<li>Sorun kodu (F): bo\u015f, &#8220;Yanl\u0131\u015f&#8221;, &#8220;Hasarl\u0131&#8221;, &#8220;Eksik&#8221; ya da &#8220;Yeniden g\u00f6nderim&#8221;<\/li>\n\n\n<li>M\u00fc\u015fteri size yazd\u0131 m\u0131 (G): &#8220;E&#8221; ya da &#8220;H&#8221;. Destek kay\u0131tlar\u0131, WhatsApp ve e-posta kutusundan doldurulur.<\/li>\n\n\n<li>Kargo firmas\u0131, al\u0131c\u0131 ili ve \u00fcr\u00fcn s\u00fctunlar\u0131 (son b\u00f6l\u00fcmdeki s\u00fczme i\u00e7in)<\/li>\n\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\u0130ptal edilen sipari\u015fleri \u00e7\u0131kar\u0131n. Tabloyu B s\u00fctununa g\u00f6re eskiden yeniye s\u0131ralay\u0131n; ilk sipari\u015f form\u00fcl\u00fc bu s\u0131raya dayan\u0131r. N1 h\u00fccresine d\u00f6k\u00fcm tarihini, N2 h\u00fccresine s\u00f6z verdi\u011finiz teslim s\u00fcresini (takvim g\u00fcn\u00fc) yaz\u0131n. B ve D s\u00fctunlar\u0131 metin de\u011fil tarih bi\u00e7iminde olmal\u0131; metin bi\u00e7imli tarihte 90 g\u00fcn \u00f6l\u00e7\u00fct\u00fc s\u0131f\u0131r d\u00f6nd\u00fcr\u00fcr.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Sat\u0131r ve grup form\u00fclleri<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Sat\u0131r form\u00fcllerini 2. sat\u0131ra yaz\u0131p a\u015fa\u011f\u0131 \u00e7ekin:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead><tr><th>S\u00fctun<\/th><th>Ne verir<\/th><th>T\u00fcrk\u00e7e Excel<\/th><th>\u0130ngilizce Excel<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>H2<\/td><td>M\u00fc\u015fteri anahtar\u0131 (telefonun son 10 hanesi)<\/td><td><code>=SA\u011eDAN(YER\u0130NEKOY(YER\u0130NEKOY(C2;\" \";\"\");\"-\";\"\");10)<\/code><\/td><td><code>=RIGHT(SUBSTITUTE(SUBSTITUTE(C2,\" \",\"\"),\"-\",\"\"),10)<\/code><\/td><\/tr>\n<tr><td>I2<\/td><td>\u0130lk sipari\u015f mi (1\/0)<\/td><td><code>=E\u011eER(E\u011eERSAY(H$2:H2;H2)=1;1;0)<\/code><\/td><td><code>=IF(COUNTIF(H$2:H2,H2)=1,1,0)<\/code><\/td><\/tr>\n<tr><td>J2<\/td><td>Sonraki 90 g\u00fcnde sipari\u015f var m\u0131 (1\/0)<\/td><td><code>=E\u011eER(\u00c7OKE\u011eERSAY(H:H;H2;B:B;\"&gt;\"&amp;B2;B:B;\"&lt;=\"&amp;(B2+90))&gt;0;1;0)<\/code><\/td><td><code>=IF(COUNTIFS(H:H,H2,B:B,\"&gt;\"&amp;B2,B:B,\"&lt;=\"&amp;(B2+90))&gt;0,1,0)<\/code><\/td><\/tr>\n<tr><td>K2<\/td><td>Grup<\/td><td><code>=E\u011eER(E2=\"Teslim al\u0131nmad\u0131\";\"Teslim al\u0131nmad\u0131\";E\u011eER(E2=\"\u0130ade\";\"\u0130ade\";E\u011eER(F2&lt;&gt;\"\";\"Sorunlu\";E\u011eER(D2-B2&gt;$N$2;\"Ge\u00e7\";\"Zaman\u0131nda\"))))<\/code><\/td><td><code>=IF(E2=\"Teslim al\u0131nmad\u0131\",\"Teslim al\u0131nmad\u0131\",IF(E2=\"\u0130ade\",\"\u0130ade\",IF(F2&lt;&gt;\"\",\"Sorunlu\",IF(D2-B2&gt;$N$2,\"Ge\u00e7\",\"Zaman\u0131nda\"))))<\/code><\/td><\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Grup \u00f6zetini ayr\u0131 bir alana yaz\u0131n: P2&#8217;de grup ad\u0131 (\u00f6r. Ge\u00e7), Q2&#8217;de m\u00fc\u015fteri say\u0131s\u0131, R2&#8217;de d\u00f6nen m\u00fc\u015fteri, S2&#8217;de oran.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead><tr><th>H\u00fccre<\/th><th>Ne verir<\/th><th>T\u00fcrk\u00e7e Excel<\/th><th>\u0130ngilizce Excel<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>Q2<\/td><td>Olgunla\u015fm\u0131\u015f ilk sipari\u015f say\u0131s\u0131<\/td><td><code>=\u00c7OKE\u011eERSAY(K:K;P2;I:I;1;B:B;\"&lt;=\"&amp;($N$1-90))<\/code><\/td><td><code>=COUNTIFS(K:K,P2,I:I,1,B:B,\"&lt;=\"&amp;($N$1-90))<\/code><\/td><\/tr>\n<tr><td>R2<\/td><td>Bunlardan 90 g\u00fcnde d\u00f6nen<\/td><td><code>=\u00c7OKE\u011eERSAY(K:K;P2;I:I;1;J:J;1;B:B;\"&lt;=\"&amp;($N$1-90))<\/code><\/td><td><code>=COUNTIFS(K:K,P2,I:I,1,J:J,1,B:B,\"&lt;=\"&amp;($N$1-90))<\/code><\/td><\/tr>\n<tr><td>S2<\/td><td>Tekrar sat\u0131n alma oran\u0131<\/td><td><code>=R2\/Q2<\/code><\/td><td><code>=R2\/Q2<\/code><\/td><\/tr>\n<tr><td>Yazan \/ yazmayan<\/td><td>Q2 ve R2&#8217;ye ek \u00f6l\u00e7\u00fct<\/td><td><code>\u2026;G:G;\"E\")<\/code> ya da <code>\u2026;G:G;\"H\")<\/code><\/td><td><code>\u2026,G:G,\"E\")<\/code> ya da <code>\u2026,G:G,\"H\")<\/code><\/td><\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Form\u00fcl hata verirse \u00f6nce ay\u0131r\u0131c\u0131ya bak\u0131n; b\u00f6lge ayar\u0131 virg\u00fcl bekleyen Excel&#8217;de noktal\u0131 virg\u00fcller virg\u00fcle \u00e7evrilir. Telefonlar parantezle yaz\u0131lm\u0131\u015fsa H2&#8217;deki YER\u0130NEKOY&#8217;a &#8220;(&#8221; ve &#8220;)&#8221; i\u00e7in birer katman daha ekleyin. Ayn\u0131 g\u00fcn verilen ikinci sipari\u015f J s\u00fctununda say\u0131lmaz; o \u00e7o\u011fu zaman ilk sepetin tamamlanmas\u0131d\u0131r.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00d6rnek kohort: ge\u00e7 teslim edilen 140 m\u00fc\u015fteri ka\u00e7 sipari\u015f eksik b\u0131rakt\u0131?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u00d6rnek: 1 Haziran-20 A\u011fustos 2026 aras\u0131nda ilk sipari\u015fini veren 1.000 m\u00fc\u015fteri, d\u00f6k\u00fcm tarihi 18 Kas\u0131m 2026, sitede s\u00f6z verilen teslim s\u00fcresi 4 takvim g\u00fcn\u00fc; ikinci sipari\u015fin ortalama tutar\u0131 720 TL, katk\u0131 pay\u0131 %28 (KDV hari\u00e7; \u00fcr\u00fcn, kargo, komisyon ve \u00f6deme maliyeti d\u00fc\u015f\u00fclm\u00fc\u015f).<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<caption>\u00d6rnek kohort, ilk sipari\u015fler 1 Haziran-20 A\u011fustos 2026<\/caption>\n<thead><tr><th>Grup (ilk sipari\u015f)<\/th><th>M\u00fc\u015fteri<\/th><th>90 g\u00fcnde ikinci sipari\u015f<\/th><th>Tekrar sat\u0131n alma oran\u0131<\/th><th>Zaman\u0131nda grubuyla z<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>Zaman\u0131nda<\/td><td>700<\/td><td>147<\/td><td>%21,0<\/td><td>taban<\/td><\/tr>\n<tr><td>Ge\u00e7<\/td><td>140<\/td><td>15<\/td><td>%10,7<\/td><td>2,82<\/td><\/tr>\n<tr><td>Sorunlu<\/td><td>60<\/td><td>8<\/td><td>%13,3<\/td><td>1,41<\/td><\/tr>\n<tr><td>\u0130ade (m\u00fc\u015fteri talebiyle)<\/td><td>55<\/td><td>6<\/td><td>%10,9<\/td><td>1,79<\/td><\/tr>\n<tr><td>Teslim al\u0131nmad\u0131<\/td><td>45<\/td><td>say\u0131lmaz<\/td><td>hesaplanmaz<\/td><td>yok<\/td><\/tr>\n<tr><td><strong>Genel (teslim al\u0131nmad\u0131 hari\u00e7)<\/strong><\/td><td><strong>955<\/strong><\/td><td><strong>176<\/strong><\/td><td><strong>%18,4<\/strong><\/td><td>yok<\/td><\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Ge\u00e7 grupta 140 m\u00fc\u015fterinin 140 \u00d7 0,21 = 29,4&#8217;\u00fcn\u00fcn d\u00f6nmesi beklenirdi, 15&#8217;i d\u00f6nd\u00fc. Eksik yakla\u015f\u0131k 14 ikinci sipari\u015f: ge\u00e7 teslim edilen yakla\u015f\u0131k her 10 m\u00fc\u015fteride bir ikinci sipari\u015f.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Fark ger\u00e7ek mi, g\u00fcr\u00fclt\u00fc m\u00fc?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0130ki oran\u0131 kar\u015f\u0131la\u015ft\u0131rmak i\u00e7in <a href=\"https:\/\/www.itl.nist.gov\/div898\/handbook\/prc\/section3\/prc33.htm\" target=\"_blank\" rel=\"noopener\">NIST&#8217;in iki oran testi<\/a> kullan\u0131l\u0131r. n1, x1 birinci grubun m\u00fc\u015fteri ve d\u00f6nen say\u0131s\u0131, n2, x2 ikincininki; \u00f6rnekte n1 = 700, x1 = 147, n2 = 140, x2 = 15.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ortak oran: <code>p = (x1 + x2) \/ (n1 + n2)<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Test de\u011feri: <code>z = (x1\/n1 - x2\/n2) \/ \u221a( p \u00d7 (1 - p) \u00d7 (1\/n1 + 1\/n2) )<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Excel&#8217;de (Q ve R s\u00fctunlar\u0131; 2. sat\u0131r Zaman\u0131nda, 3. sat\u0131r Ge\u00e7):<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>T\u00fcrk\u00e7e: <code>=(R2\/Q2-R3\/Q3)\/KAREK\u00d6K(((R2+R3)\/(Q2+Q3))*(1-(R2+R3)\/(Q2+Q3))*(1\/Q2+1\/Q3))<\/code><\/li>\n\n\n<li>\u0130ngilizce: <code>=(R2\/Q2-R3\/Q3)\/SQRT(((R2+R3)\/(Q2+Q3))*(1-(R2+R3)\/(Q2+Q3))*(1\/Q2+1\/Q3))<\/code><\/li>\n\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Sonu\u00e7 eksi \u00e7\u0131karsa i\u015faretini yok say\u0131n; 1,96&#8217;n\u0131n (<a href=\"https:\/\/www.itl.nist.gov\/div898\/handbook\/eda\/section3\/eda3671.htm\" target=\"_blank\" rel=\"noopener\">NIST&#8217;in normal da\u011f\u0131l\u0131m tablosunda<\/a> 0,975 i\u00e7in verilen kritik de\u011fer) \u00fcst\u00fcndeyse fark %95 d\u00fczeyinde g\u00fcr\u00fclt\u00fcden ayr\u0131l\u0131r, alt\u0131ndaysa bir kohort daha bekleyin. \u00d6rnekte Ge\u00e7 grup i\u00e7in z = 2,82 \u00e7\u0131kar. Sorunlu grubun fark\u0131 21,0 \u2212 13,3 = 7,7 puand\u0131r ve g\u00f6ze b\u00fcy\u00fck g\u00f6r\u00fcn\u00fcr, ama z = 1,41 oldu\u011fu i\u00e7in hen\u00fcz karar verdirmez.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">K\u00fc\u00e7\u00fck grup oynakt\u0131r: 60 ki\u015filik grupta tek bir m\u00fc\u015fteri oran\u0131 1,7 puan oynat\u0131r, 140 ki\u015filikte 0,7 puan. NIST bu yakla\u015f\u0131m\u0131 \u00f6rneklemler &#8220;makul \u00f6l\u00e7\u00fcde b\u00fcy\u00fck&#8221; oldu\u011funda kullan\u0131r, say\u0131sal s\u0131n\u0131r vermez; biz de vermiyoruz.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Eksik sipari\u015fi TL&#8217;ye \u00e7evirin<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Kay\u0131p = eksik sipari\u015f \u00d7 k. Burada k ikinci sipari\u015fin katk\u0131s\u0131d\u0131r: ortalama tutar \u00d7 katk\u0131 pay\u0131. Kargonun sipari\u015f ba\u015f\u0131na pay\u0131 i\u00e7in <a href=\"https:\/\/porego.com\/blog\/siparis-basina-kargo-maliyeti\/\">sipari\u015f ba\u015f\u0131na kargo maliyeti yaz\u0131s\u0131na<\/a> bak\u0131n. \u00d6rnekte k = 720 \u00d7 0,28 = 201,6 TL, kay\u0131p 14,4 \u00d7 201,6 = 2.903 TL (90 g\u00fcnl\u00fck pencerede), ge\u00e7 teslim ba\u015f\u0131na 20,7 TL. Katk\u0131 pay\u0131 %12 olsayd\u0131 k = 86,4 TL, kay\u0131p 1.244 TL, ge\u00e7 teslim ba\u015f\u0131na 8,9 TL olurdu. Bu tutarlar \u00f6rnektir, k yerine kendi rakam\u0131n\u0131z\u0131 koyun.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Fark hi\u00e7 olmasayd\u0131? Ge\u00e7 grupta 27 m\u00fc\u015fteri d\u00f6nseydi (27 \u00f7 140 = %19,3) z = 0,46 \u00e7\u0131kard\u0131 ve tabloda d\u00fczeltilecek bir \u015fey g\u00f6r\u00fcnmezdi.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Porego&#8217;da nas\u0131l yap\u0131l\u0131r?<\/strong> Uygulamalar&#8217;daki K\u00e2r-Zarar Hesaplama; Meta ve Google Ads maliyetini, kargoyu, komisyonu ve \u00fcr\u00fcn maliyetini hesaba katarak sipari\u015f baz\u0131nda net k\u00e2r verir. Form\u00fcldeki k&#8217;yi \u00f6rnekteki varsay\u0131mdan (720 TL \u00d7 %28) de\u011fil, bu rakamdan al\u0131n. Uygulaman\u0131n g\u00f6sterdi\u011fi k\u00e2r verilmi\u015f sipari\u015fe aittir; gelmeyen ikinci sipari\u015fin tutar\u0131n\u0131 yukar\u0131daki form\u00fcl verir. Uygulama, Porego&#8217;nun <a href=\"https:\/\/porego.com\/sss\">SSS sayfas\u0131ndaki<\/a> listede BETA etiketiyle ve &#8220;\u00dccretsiz&#8221; ibaresiyle yer al\u0131yor; \u00fccretler de\u011fi\u015febilir, panelden kontrol edin. Reklam bedelini Meta ve Google&#8217;a siz \u00f6dersiniz, bu bedel uygulaman\u0131n \u00fccreti de\u011fildir.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Yazan ve yazmayan m\u00fc\u015fteriyi ay\u0131r\u0131n<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Ge\u00e7 grubu G s\u00fctunuyla ikiye b\u00f6l\u00fcn: Q2 ve R2 form\u00fcllerine &#8220;E&#8221; ya da &#8220;H&#8221; \u00f6l\u00e7\u00fct\u00fcn\u00fc ekleyin. \u00d6rnekte 140 ge\u00e7 teslimin 36&#8217;s\u0131 yazd\u0131, 104&#8217;\u00fc yazmad\u0131; ge\u00e7 teslim edilen her 4 m\u00fc\u015fteriden yakla\u015f\u0131k 3&#8217;\u00fc hi\u00e7 yazmad\u0131, destek kutusu ge\u00e7 teslimlerin d\u00f6rtte birini g\u00f6sterdi. Yazanlar\u0131n 6 \u00f7 36 = %16,7&#8217;si, yazmayanlar\u0131n 9 \u00f7 104 = %8,7&#8217;si d\u00f6nd\u00fc.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Fark var gibi g\u00f6r\u00fcn\u00fcr ama z = 1,34, yani 1,96&#8217;n\u0131n alt\u0131nda: bu \u00f6rnekte fark g\u00fcr\u00fclt\u00fcden ayr\u0131lmaz. &#8220;\u015eik\u00e2yet etmeyen daha az d\u00f6ner&#8221; iddias\u0131n\u0131 bu \u00f6rnek kan\u0131tlam\u0131yor. Kendi verinizde birka\u00e7 kohort biriktirdikten sonra tekrar bak\u0131n.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ge\u00e7 teslimler nerede toplan\u0131yor?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Kohort tablosu nedeni s\u00f6ylemez, yaln\u0131z fark\u0131 s\u00f6yler. Ge\u00e7 sat\u0131rlar\u0131 kargo firmas\u0131, al\u0131c\u0131 ili ve \u00fcr\u00fcn s\u00fctunuyla s\u00fcz\u00fcn. Ge\u00e7 teslimler tek bir ile ya da \u00fcr\u00fcne y\u0131\u011f\u0131l\u0131yorsa fark oradan da gelebilir; kar\u015f\u0131la\u015ft\u0131rmay\u0131 ayn\u0131 il ya da \u00fcr\u00fcn i\u00e7inde tekrarlay\u0131n. \u00d6nleyici ad\u0131m olarak <a href=\"https:\/\/porego.com\/blog\/kargo-otomasyon-kurallari\/\">hareketsiz g\u00f6nderi kural\u0131<\/a> var, ayr\u0131nt\u0131s\u0131 o yaz\u0131da.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bir sonraki \u00e7eyrekte tabloyu ayn\u0131 90 g\u00fcnle, ayn\u0131 N2 e\u015fi\u011fiyle ve ayn\u0131 m\u00fc\u015fteri anahtar\u0131yla yeniden kurun; bunlardan biri de\u011fi\u015firse iki tablo kar\u015f\u0131la\u015ft\u0131r\u0131lamaz.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">S\u0131k sorulan sorular<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Tekrar sat\u0131n alma oran\u0131 ka\u00e7 olmal\u0131?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">T\u00fcrkiye i\u00e7in kayna\u011f\u0131 a\u00e7\u0131k bir ortalama bulamad\u0131k. Kendi \u00f6nceki kohortunuzla kar\u015f\u0131la\u015ft\u0131r\u0131n; pencere, m\u00fc\u015fteri anahtar\u0131 ve N2 ayn\u0131 kal\u0131rsa iki \u00e7eyrek aras\u0131ndaki fark anlam ta\u015f\u0131r.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Shopify&#8217;daki tekrar m\u00fc\u015fteri raporu neden benim tablomdan farkl\u0131 sonu\u00e7 veriyor?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Tan\u0131m ve pencere farkl\u0131d\u0131r. <a href=\"https:\/\/help.shopify.com\/en\/manual\/reports-and-analytics\/shopify-reports\/report-types\/default-reports\/customers-reports\" target=\"_blank\" rel=\"noopener\">Shopify&#8217;\u0131n yard\u0131m sayfas\u0131na<\/a> g\u00f6re geri d\u00f6nen m\u00fc\u015fteri, verdi\u011fi sipari\u015fte sipari\u015f ge\u00e7mi\u015finde en az bir sipari\u015f daha bulunan m\u00fc\u015fteridir. Kohort raporu (Customer cohort analysis) ilk sipari\u015f tarihine g\u00f6re hafta, ay ya da \u00e7eyrek aral\u0131\u011f\u0131 kullan\u0131r ve &#8220;Period 0&#8221; ilk sipari\u015fle ayn\u0131 d\u00f6nemdeki tekrar sipari\u015fleri de sayar. Bu tablo ise ilk sipari\u015ften sonraki 90 g\u00fcn\u00fc sayar.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Pazaryeri sipari\u015flerini ayn\u0131 tabloya katmal\u0131 m\u0131y\u0131m?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Her kanal\u0131 ayr\u0131 kohort olarak hesaplay\u0131n. Birle\u015ftirecekseniz telefonun iki d\u00f6k\u00fcmde ayn\u0131 bi\u00e7imde geldi\u011fini kontrol edin; yoksa ayn\u0131 ki\u015fi iki m\u00fc\u015fteri g\u00f6r\u00fcn\u00fcr.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Kap\u0131da \u00f6demede teslim al\u0131nmayan sipari\u015fleri ne yapmal\u0131y\u0131m?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Ayr\u0131 sat\u0131rda tutun, orana katmay\u0131n.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u015eik\u00e2yet etmeyen m\u00fc\u015fteriyi destek kutusunda de\u011fil, gelmeyen ikinci sipari\u015fte g\u00f6r\u00fcrs\u00fcn\u00fcz. \u0130lk sipari\u015fleri teslim deneyimine g\u00f6re gruplay\u0131p fark\u0131n g\u00fcr\u00fclt\u00fc olup olmad\u0131\u011f\u0131n\u0131 tek form\u00fclle s\u0131namay\u0131 g\u00f6steriyoruz.<\/p>\n","protected":false},"author":1,"featured_media":751,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[70],"tags":[88,72,91],"class_list":["post-753","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-e-ticaret-rehberi","tag-musteri-memnuniyeti","tag-siparis-yonetimi","tag-teslimat-basarisi"],"_links":{"self":[{"href":"https:\/\/porego.com\/blog\/wp-json\/wp\/v2\/posts\/753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/porego.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/porego.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/porego.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/porego.com\/blog\/wp-json\/wp\/v2\/comments?post=753"}],"version-history":[{"count":1,"href":"https:\/\/porego.com\/blog\/wp-json\/wp\/v2\/posts\/753\/revisions"}],"predecessor-version":[{"id":758,"href":"https:\/\/porego.com\/blog\/wp-json\/wp\/v2\/posts\/753\/revisions\/758"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/porego.com\/blog\/wp-json\/wp\/v2\/media\/751"}],"wp:attachment":[{"href":"https:\/\/porego.com\/blog\/wp-json\/wp\/v2\/media?parent=753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/porego.com\/blog\/wp-json\/wp\/v2\/categories?post=753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/porego.com\/blog\/wp-json\/wp\/v2\/tags?post=753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}