{"id":524,"date":"2026-11-15T20:03:00","date_gmt":"2026-11-15T17:03:00","guid":{"rendered":"https:\/\/porego.com\/blog\/?p=524"},"modified":"2026-11-10T10:56:26","modified_gmt":"2026-11-10T07:56:26","slug":"basabas-roas-nasil-hesaplanir","status":"publish","type":"post","link":"https:\/\/porego.com\/blog\/basabas-roas-nasil-hesaplanir\/","title":{"rendered":"Ba\u015faba\u015f ROAS Nas\u0131l Hesaplan\u0131r? Kap\u0131da \u00d6deme, \u0130ade ve Kargo Dahil Form\u00fcl"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Reklam panelinde iki kampanya da 5 ROAS g\u00f6steriyor. Biri kartl\u0131, \u00f6teki kap\u0131da \u00f6demeli sipari\u015flerden geliyorsa kargo, teslim al\u0131nmay\u0131p d\u00f6nen paket ve tahsilat bedeli y\u00fcz\u00fcnden biri reklam bedelinden sonra k\u00e2r b\u0131rak\u0131rken \u00f6teki zarar yazabilir. Panel ayn\u0131, sonu\u00e7 ters. Bu yaz\u0131 kap\u0131da \u00f6demeyi de kabul eden ma\u011fazalar i\u00e7in yaz\u0131ld\u0131 ve sonunda elinizde \u00fc\u00e7 \u015fey olacak: \u00f6deme y\u00f6ntemine g\u00f6re ayr\u0131 ba\u015faba\u015f ROAS e\u015fi\u011fi, bunu hesaplatan iki Excel h\u00fccresi ve sipari\u015f ba\u015f\u0131na harcayabilece\u011finiz reklam tavan\u0131. Kargo \u00fccretlerini bilerek rakamla vermiyoruz; tutar firmaya, desiye, b\u00f6lgeye ve anla\u015fmaya g\u00f6re de\u011fi\u015fir. Form\u00fcllere kendi faturan\u0131zdaki tutarlar\u0131 koyun.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ba\u015faba\u015f ROAS nedir, 1 \u00f7 marj neden yetmez?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Ba\u015faba\u015f ROAS, reklamdan \u00f6nce elinizde kalan paran\u0131n reklam bedelini tam kar\u015f\u0131lad\u0131\u011f\u0131 orand\u0131r. Bu e\u015fi\u011fin alt\u0131nda kampanya zarar yazar, \u00fcst\u00fcnde k\u00e2r b\u0131rak\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">T\u00fcrk\u00e7e kaynaklarda s\u0131k g\u00f6r\u00fclen k\u0131sayol <a href=\"https:\/\/www.ikas.com\/tr\/blog\/roas-ve-roi-nedir-nasil-hesaplanir\" target=\"_blank\" rel=\"noopener\">1 \u00f7 katk\u0131 marj\u0131<\/a> form\u00fcl\u00fcd\u00fcr. ikas yaz\u0131s\u0131 katk\u0131 marj\u0131n\u0131 sat\u0131\u015ftan de\u011fi\u015fken maliyetler \u00e7\u0131k\u0131nca kalan tutar diye tan\u0131mlar; bu yaz\u0131da reklam bu maliyetlerin d\u0131\u015f\u0131nda tutulur, nedenini bir sonraki paragrafta anlat\u0131yoruz. Form\u00fcl do\u011fru, ama marj\u0131 nas\u0131l hesaplad\u0131\u011f\u0131n\u0131za ba\u011fl\u0131. A\u015fa\u011f\u0131daki \u00f6rnekte 500 TL&#8217;lik sipari\u015fte \u00fcr\u00fcn 180 TL; yaln\u0131z \u00fcr\u00fcn marj\u0131na bakarsan\u0131z (500 \u2212 180) \u00f7 500 = %64 \u00e7\u0131kar ve e\u015fik 1,56 g\u00f6r\u00fcn\u00fcr. Kargoyu, d\u00f6nen paketi ve tahsilat bedelini kat\u0131nca ayn\u0131 ma\u011fazan\u0131n e\u015fi\u011fi belirgin bi\u00e7imde y\u00fckselir; ne kadar y\u00fckseldi\u011fini a\u015fa\u011f\u0131daki form\u00fcle kendi kargo tutarlar\u0131n\u0131z\u0131 koyarak g\u00f6r\u00fcrs\u00fcn\u00fcz.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Katk\u0131ya reklam harcamas\u0131 girmez; reklam\u0131 d\u00fc\u015f\u00fclm\u00fc\u015f bir marj\u0131 form\u00fcle koyarsan\u0131z reklam\u0131 iki kez sayars\u0131n\u0131z.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/porego.com\/blog\/kapida-odeme-iadeleri-nasil-azaltilir\/\">Kap\u0131da \u00f6deme iadelerini azaltma rehberi<\/a> ba\u015fka bir soruyu cevaplar: orada reklam k\u00e2r hesab\u0131n\u0131n i\u00e7indedir ve soru &#8220;ka\u00e7 teslimde zarar ederim&#8221; olur. Burada reklam hesab\u0131n d\u0131\u015f\u0131nda kal\u0131r ve soru &#8220;reklama sipari\u015f ba\u015f\u0131na en \u00e7ok ne kadar harcayabilirim&#8221; olur.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00d6nce panelin neyi sayd\u0131\u011f\u0131na bak\u0131n<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Form\u00fcle girmeden, reklam panelindeki ciro rakam\u0131n\u0131n neyi kapsad\u0131\u011f\u0131n\u0131 netle\u015ftirin. Payda bu rakam olacak.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Sipari\u015f an\u0131 m\u0131, teslim mi?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Meta pikselinde <a href=\"https:\/\/developers.facebook.com\/docs\/meta-pixel\/reference\" target=\"_blank\" rel=\"noopener\">Purchase olay\u0131<\/a>, sat\u0131n alma yap\u0131ld\u0131\u011f\u0131nda veya \u00f6deme ak\u0131\u015f\u0131 tamamland\u0131\u011f\u0131nda tetiklenir. Bizim yorumumuz \u015fu: kap\u0131da \u00f6demede \u00f6deme ak\u0131\u015f\u0131 sipari\u015f verilirken tamamlanm\u0131\u015f say\u0131labilir ve teslim edilmeyecek sipari\u015f o anda ciroya girmi\u015f olabilir. Bu kurulumunuza ba\u011fl\u0131d\u0131r; kendi kurulumunuzu a\u015fa\u011f\u0131daki kar\u015f\u0131la\u015ft\u0131rmayla s\u0131nay\u0131n.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">De\u011ferin i\u00e7inde KDV var m\u0131?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Olaya giden de\u011feri kurulum belirler; Purchase olay\u0131nda <code>currency<\/code> ve <code>value<\/code> zorunludur ve <code>value<\/code> olay\u0131n i\u015fletmeye de\u011feridir. Google Analytics 4 taraf\u0131nda ise <a href=\"https:\/\/developers.google.com\/analytics\/devguides\/collection\/ga4\/reference\/events\" target=\"_blank\" rel=\"noopener\">sat\u0131n alma olay\u0131n\u0131n value alan\u0131na kargo ve vergi eklenmemesi<\/a> yaz\u0131l\u0131d\u0131r; bu yaln\u0131z o belge i\u00e7in ge\u00e7erlidir, Meta ya da ma\u011faza eklentiniz i\u00e7in varsaymay\u0131n. Tek bir sipari\u015fin paneldeki de\u011ferini ma\u011faza kayd\u0131yla kar\u015f\u0131la\u015ft\u0131r\u0131n. Fark, e\u015fi\u011fi ciddi oynat\u0131r: ayn\u0131 katk\u0131yla sipari\u015f 600 TL say\u0131l\u0131rsa e\u015fik 600 \u00f7 katk\u0131, 500 TL say\u0131l\u0131rsa 500 \u00f7 katk\u0131 olur; KDV dahil tabanda e\u015fik %20 y\u00fcksek \u00e7\u0131kar.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Google Ads&#8217;te oran y\u00fczde olarak g\u00f6r\u00fcn\u00fcr<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Google Ads&#8217;te <a href=\"https:\/\/support.google.com\/google-ads\/answer\/6268637?hl=tr\" target=\"_blank\" rel=\"noopener\">hedef ROAS<\/a>, reklama harcanan her lira i\u00e7in elde etmek istedi\u011finiz ortalama d\u00f6n\u00fc\u015f\u00fcm de\u011feridir. Raporda &#8220;D\u00f6n\u015f. de\u011feri\/maliyet&#8221; s\u00fctununu 100 ile \u00e7arparsan\u0131z hedef ROAS y\u00fczdesine ula\u015f\u0131rs\u0131n\u0131z.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">E\u015fi\u011fi kurmak i\u00e7in gereken alt\u0131 d\u00f6k\u00fcm<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Hesab\u0131 son sonu\u00e7lanm\u0131\u015f sipari\u015flerle kurun. Yoldaki sipari\u015f hen\u00fcz teslim de olmad\u0131, d\u00f6nmedi de; sayarsan\u0131z teslim oran\u0131 oldu\u011fundan iyi g\u00f6r\u00fcn\u00fcr.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n\n<li>Son sonu\u00e7lanm\u0131\u015f sipari\u015flerin durum listesi<\/li>\n\n\n<li>Kart ve kap\u0131da \u00f6deme ayr\u0131m\u0131<\/li>\n\n\n<li>\u00dcr\u00fcn al\u0131\u015f maliyeti<\/li>\n\n\n<li>Kargo faturas\u0131 (gidi\u015f, d\u00f6n\u00fc\u015f, kap\u0131da \u00f6deme bedeli)<\/li>\n\n\n<li>\u00d6deme kurulu\u015fu komisyon d\u00f6k\u00fcm\u00fc<\/li>\n\n\n<li>Reklam paneli harcama ve ciro raporu ile reklam faturas\u0131<\/li>\n\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Reklam faturan\u0131zdaki toplam\u0131 panelin harcamas\u0131yla kar\u015f\u0131la\u015ft\u0131r\u0131n. Fatura daha y\u00fcksekse fark\u0131 reklam bedeline ekleyin; bu yaz\u0131daki hesap harcamay\u0131 panel rakam\u0131 kabul eder.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Kap\u0131da \u00f6deme dahil ba\u015faba\u015f ROAS form\u00fcl\u00fc<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A\u015fa\u011f\u0131daki sepet, \u00fcr\u00fcn maliyeti, paket ve y\u0131pranma tutarlar\u0131 <strong>\u00f6rnektir<\/strong>: sepet KDV dahil 600 TL (%20 KDV varsay\u0131m\u0131yla KDV hari\u00e7 500 TL), maliyetler KDV hari\u00e7, reklam paneli sipari\u015fi KDV dahil 600 TL say\u0131yor. Gidi\u015f kargosu (K), d\u00f6n\u00fc\u015f kargosu (D) ve kap\u0131da \u00f6deme bedeli (T) i\u00e7in rakam vermiyoruz; bunlar\u0131 kendi kargo faturan\u0131zdan al\u0131n. \u00d6rnekte kap\u0131da \u00f6deme bedelinin yaln\u0131z teslimde do\u011fdu\u011fu varsay\u0131ld\u0131; s\u00f6zle\u015fmeniz farkl\u0131ysa T&#8217;yi d\u00f6nen sipari\u015fe de uygulay\u0131n.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead><tr><th>Harf<\/th><th>Anlam\u0131<\/th><th>\u00d6rnekteki de\u011fer<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>S<\/td><td>KDV hari\u00e7 sepet<\/td><td>500 TL<\/td><\/tr>\n<tr><td>P<\/td><td>Panelin sayd\u0131\u011f\u0131 de\u011fer<\/td><td>600 TL<\/td><\/tr>\n<tr><td>C<\/td><td>\u00dcr\u00fcn maliyeti<\/td><td>180 TL<\/td><\/tr>\n<tr><td>K<\/td><td>Gidi\u015f kargosu<\/td><td>Kargo faturan\u0131zdaki tutar<\/td><\/tr>\n<tr><td>Pk<\/td><td>Paket ve i\u015f\u00e7ilik<\/td><td>15 TL<\/td><\/tr>\n<tr><td>D<\/td><td>D\u00f6n\u00fc\u015f kargosu<\/td><td>Kargo faturan\u0131zdaki tutar<\/td><\/tr>\n<tr><td>Y<\/td><td>Y\u0131pranma<\/td><td>15 TL<\/td><\/tr>\n<tr><td>T<\/td><td>Tahsilat bedeli<\/td><td>Kart komisyonu 18 TL (600 \u00d7 %3) veya kargo faturan\u0131zdaki kap\u0131da \u00f6deme bedeli<\/td><\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">K ve D i\u00e7in kendi fiyat\u0131n\u0131z\u0131 <a href=\"https:\/\/porego.com\/kargo-fiyatlari\">kargo fiyatlar\u0131 sayfas\u0131ndan<\/a> alabilirsiniz. Sayfadaki fiyatlar KDV hari\u00e7tir ve kap\u0131da \u00f6deme se\u00e7ilince kap\u0131da \u00f6deme ve komisyon \u00fccretleri ayr\u0131ca uygulan\u0131r. \u00dcr\u00fcn\u00fcn\u00fcz\u00fcn \u00f6l\u00e7\u00fcs\u00fcne g\u00f6re gidi\u015f kargosunu <a href=\"https:\/\/porego.com\/desi-hesaplama\">desi hesaplama arac\u0131yla<\/a> bulabilirsiniz.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Elde kalan sipari\u015fin katk\u0131s\u0131 (A)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Sepetten \u00fcr\u00fcn, gidi\u015f kargosu, paket ve tahsilat bedeli d\u00fc\u015f\u00fcl\u00fcr: <strong>A = S \u2212 C \u2212 K \u2212 Pk \u2212 T<\/strong>. Kartta 500 \u2212 180 \u2212 15 \u2212 18 \u2212 K = 287 \u2212 K, kap\u0131da \u00f6demede 500 \u2212 180 \u2212 15 \u2212 K \u2212 T = 305 \u2212 K \u2212 T kal\u0131r.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Teslim al\u0131nmayan sipari\u015fin kayb\u0131 (Z)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Teslim al\u0131nmay\u0131p g\u00f6ndericiye d\u00f6nen sipari\u015fte gidi\u015f, d\u00f6n\u00fc\u015f, paket ve y\u0131pranma birlikte gider: <strong>Z = K + D + Pk + Y<\/strong>, yani \u00f6rnekte K + D + 30 TL. Kargoya \u00e7\u0131kmadan iptal edilen sipari\u015f bu kayb\u0131 do\u011furmaz; \u00f6rnekte kargo, paket ve iade masraf\u0131 olu\u015fmaz.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Teslimden sonra m\u00fc\u015fteri talebiyle yap\u0131lan iade ayr\u0131 bir kalemdir: farkl\u0131 \u00fccretlendirilebilir ve \u00fcr\u00fcn farkl\u0131 durumda d\u00f6ner. Bu iadelerin masraf\u0131n\u0131, kart komisyonunun geri gelip gelmemesi gibi ayr\u0131nt\u0131larla birlikte kendi s\u00f6zle\u015fmenize g\u00f6re ayr\u0131ca hesaplay\u0131n; Z&#8217;ye kar\u0131\u015ft\u0131rmay\u0131n.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">E\u015fik<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Reklam\u0131n sayd\u0131\u011f\u0131 sipari\u015flerde t elde kalan oran\u0131, d teslim al\u0131nmay\u0131p d\u00f6nen oran\u0131d\u0131r; 1 \u2212 t \u2212 d kargoya \u00e7\u0131kmadan iptal edilen orand\u0131r. O ise sipari\u015f ba\u015f\u0131na onay maliyetidir (onay arac\u0131 kullanm\u0131yorsan\u0131z s\u0131f\u0131r). Sipari\u015f ba\u015f\u0131na katk\u0131 ve e\u015fik \u015f\u00f6yle bulunur:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Katk\u0131 = t \u00d7 A \u2212 d \u00d7 Z \u2212 O<\/strong><br><strong>Ba\u015faba\u015f ROAS = P \u00f7 Katk\u0131<\/strong><\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">Katk\u0131, ayn\u0131 zamanda sipari\u015f ba\u015f\u0131na reklam tavan\u0131n\u0131zd\u0131r: bu tutar\u0131n \u00fcst\u00fcnde reklama harcarsan\u0131z o sipari\u015f zarar yazar.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ayn\u0131 ma\u011fazada \u00fc\u00e7 ayr\u0131 e\u015fik<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A\u015fa\u011f\u0131daki oranlar <strong>\u00f6rnek varsay\u0131md\u0131r, sekt\u00f6r verisi de\u011fildir<\/strong>; kendi sonu\u00e7lanm\u0131\u015f sipari\u015flerinizden \u00f6l\u00e7\u00fcn. Kart sipari\u015flerinde t %92, d %8 al\u0131yoruz. Onays\u0131z kap\u0131da \u00f6demede t %75, d %25. Onayl\u0131 kap\u0131da \u00f6demede sipari\u015flerin %12&#8217;si kargodan \u00f6nce iptal oluyor, kargoya verilenin %88&#8217;i teslim ediliyor; bu t&#8217;yi %77,44, d&#8217;yi %10,56 yapar ve O i\u00e7in 2 TL varsay\u0131yoruz (uygulama fiyat\u0131 de\u011fildir). K, D ve T yerine kendi tutarlar\u0131n\u0131z\u0131 koydu\u011funuzda \u00fc\u00e7 ak\u0131\u015f\u0131n katk\u0131s\u0131 ve e\u015fi\u011fi \u015f\u00f6yle \u00e7\u0131kar:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead><tr><th>\u00d6deme ve ak\u0131\u015f<\/th><th>Sipari\u015f ba\u015f\u0131na katk\u0131 (reklam tavan\u0131)<\/th><th>Ba\u015faba\u015f ROAS<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>Kart<\/td><td>0,92 \u00d7 (287 \u2212 K) \u2212 0,08 \u00d7 (K + D + 30)<\/td><td>600 \u00f7 katk\u0131<\/td><\/tr>\n<tr><td>Kap\u0131da \u00f6deme, onays\u0131z<\/td><td>0,75 \u00d7 (305 \u2212 K \u2212 T) \u2212 0,25 \u00d7 (K + D + 30)<\/td><td>600 \u00f7 katk\u0131<\/td><\/tr>\n<tr><td>Kap\u0131da \u00f6deme, onayl\u0131<\/td><td>0,7744 \u00d7 (305 \u2212 K \u2212 T) \u2212 0,1056 \u00d7 (K + D + 30) \u2212 2<\/td><td>600 \u00f7 katk\u0131<\/td><\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Ayl\u0131k sonucu da ayn\u0131 katk\u0131yla bulursunuz. 1.000 sipari\u015f, panelde 5 ROAS ve 600.000 TL panel cirosu i\u00e7in reklam bedeli 120.000 TL&#8217;dir; reklam sonras\u0131 kalan 1.000 \u00d7 katk\u0131 \u2212 120.000 TL olur. Yani bu \u00f6rnekte sipari\u015f ba\u015f\u0131na katk\u0131 120 TL&#8217;nin alt\u0131nda kalan ak\u0131\u015f, panel 5 ROAS g\u00f6sterse de ay\u0131 zararla kapat\u0131r. \u00d6rnek oranlarla kart\u0131n katk\u0131s\u0131, K, D ve T ne olursa olsun onays\u0131z kap\u0131da \u00f6demeninkinden y\u00fcksektir; ayn\u0131 panel ROAS&#8217;\u0131n\u0131n bir ak\u0131\u015fta k\u00e2r, \u00f6tekinde zarar olabilmesinin nedeni budur.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ayn\u0131 sipari\u015f KDV hari\u00e7 tabanda okunursa her sat\u0131rda 600 yerine 500&#8217;e b\u00f6lersiniz. Tek ma\u011faza ortalamas\u0131 da kullanmay\u0131n: kart ile kap\u0131da \u00f6deme kar\u0131\u015f\u0131m\u0131 de\u011fi\u015fince e\u015fik de\u011fi\u015fir.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Onay e\u015fi\u011fi her zaman d\u00fc\u015f\u00fcrmez<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Onay her \u00fcr\u00fcnde i\u015fe yaramaz. Maliyeti 65 TL olan bir \u00fcr\u00fcn d\u00fc\u015f\u00fcn\u00fcn; kap\u0131da \u00f6demede katk\u0131s\u0131 A = 500 \u2212 65 \u2212 15 \u2212 K \u2212 T = 420 \u2212 K \u2212 T olur. Onays\u0131z, t %75 ve d %25 ile 0,75 \u00d7 A \u2212 0,25 \u00d7 Z kal\u0131r. Onay teslim edilecek m\u00fc\u015fteriyi de eliyor; t %60, d %5, O 2 TL olursa 0,60 \u00d7 A \u2212 0,05 \u00d7 Z \u2212 2 kal\u0131r (oranlar \u00f6rnek varsay\u0131md\u0131r, sekt\u00f6r verisi de\u011fildir). \u0130kisinin fark\u0131 0,15 \u00d7 A \u2212 0,20 \u00d7 Z + 2&#8217;dir. Bu fark s\u0131f\u0131r\u0131n \u00fcst\u00fcndeyse, yani \u00fcr\u00fcn\u00fcn katk\u0131s\u0131 y\u00fcksek ve teslim al\u0131nmayan sipari\u015fin kayb\u0131 g\u00f6rece k\u00fc\u00e7\u00fckse, onay bu \u00fcr\u00fcnde sipari\u015f ba\u015f\u0131na daha az b\u0131rak\u0131r ve e\u015fi\u011fi y\u00fckseltir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Porego&#8217;da nas\u0131l yap\u0131l\u0131r?<\/strong> Onayl\u0131 kap\u0131da \u00f6deme sat\u0131r\u0131n\u0131 ger\u00e7e\u011fe yakla\u015ft\u0131rmak i\u00e7in Uygulamalar sayfas\u0131ndan WhatsApp Kap\u0131da \u00d6deme Onay\u0131&#8217;n\u0131 a\u00e7\u0131n ve ma\u011faza ayar\u0131nda &#8220;Onay gelmeden kargo kodu al\u0131nmas\u0131n&#8221; se\u00e7ene\u011fini i\u015faretleyin. Bu durumda kargoya yaln\u0131z &#8220;Onayl\u0131yorum&#8221; butonuna basan m\u00fc\u015fterinin sipari\u015fi \u00e7\u0131kar; sonu\u00e7, t ve d rakamlar\u0131n\u0131z\u0131n onay a\u00e7\u0131ld\u0131ktan sonra ayr\u0131 \u00f6l\u00e7\u00fclebilmesidir. Onay teslim oran\u0131n\u0131 garanti etmez. \u00dccret taraf\u0131nda Porego&#8217;nun kalemi sabit ayl\u0131k uygulama \u00fccretidir; Meta taraf\u0131n\u0131n \u00fccreti ayr\u0131 bir konudur.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Teslim oran\u0131 d\u00fc\u015ft\u00fck\u00e7e e\u015fik nas\u0131l ka\u00e7ar?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A\u015fa\u011f\u0131daki tablo onays\u0131z kap\u0131da \u00f6demeyi g\u00f6steriyor, iptal yok ve panel cirosu KDV dahil. Teslim oran\u0131 t ise d\u00f6nen oran 1 \u2212 t&#8217;dir; A = 305 \u2212 K \u2212 T ve Z = K + D + 30 i\u00e7in katk\u0131 t \u00d7 A \u2212 (1 \u2212 t) \u00d7 Z, e\u015fik 600 \u00f7 katk\u0131 olur. Katk\u0131 teslim oran\u0131yla do\u011frusal azal\u0131r, e\u015fik ise do\u011frusal de\u011fil, h\u0131zlanarak y\u00fckselir.<\/p>\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\/donen-koli-arabasi.webp\" alt=\"Dar depo koridorunda birka\u00e7 y\u0131pranm\u0131\u015f kolinin el arabas\u0131yla raflara ta\u015f\u0131nmas\u0131\" class=\"wp-image-523\" srcset=\"https:\/\/porego.com\/blog\/wp-content\/uploads\/2026\/11\/donen-koli-arabasi.webp 1344w, https:\/\/porego.com\/blog\/wp-content\/uploads\/2026\/11\/donen-koli-arabasi-300x168.webp 300w, https:\/\/porego.com\/blog\/wp-content\/uploads\/2026\/11\/donen-koli-arabasi-1024x573.webp 1024w, https:\/\/porego.com\/blog\/wp-content\/uploads\/2026\/11\/donen-koli-arabasi-768x430.webp 768w\" sizes=\"auto, (max-width: 1344px) 100vw, 1344px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead><tr><th>Teslim oran\u0131<\/th><th>Katk\u0131<\/th><th>E\u015fik<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>%95<\/td><td>0,95 \u00d7 A \u2212 0,05 \u00d7 Z<\/td><td>600 \u00f7 katk\u0131<\/td><\/tr>\n<tr><td>%85<\/td><td>0,85 \u00d7 A \u2212 0,15 \u00d7 Z<\/td><td>600 \u00f7 katk\u0131<\/td><\/tr>\n<tr><td>%75<\/td><td>0,75 \u00d7 A \u2212 0,25 \u00d7 Z<\/td><td>600 \u00f7 katk\u0131<\/td><\/tr>\n<tr><td>%65<\/td><td>0,65 \u00d7 A \u2212 0,35 \u00d7 Z<\/td><td>600 \u00f7 katk\u0131<\/td><\/tr>\n<tr><td>%55<\/td><td>0,55 \u00d7 A \u2212 0,45 \u00d7 Z<\/td><td>600 \u00f7 katk\u0131<\/td><\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Her 1 puanl\u0131k teslim oran\u0131 sipari\u015f ba\u015f\u0131na (A + Z) \u00d7 0,01 TL eder; 100 sipari\u015fte bir ek teslim A + Z TL demektir. Katk\u0131n\u0131n s\u0131f\u0131ra indi\u011fi teslim oran\u0131 Z \u00f7 (A + Z)&#8217;dir. 100 sipari\u015fte 100 \u00d7 Z \u00f7 (A + Z) teslimin alt\u0131nda reklams\u0131z bile para kalmaz.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Maliyeti 300 TL olan \u00fcr\u00fcnde katk\u0131 A = 500 \u2212 300 \u2212 15 \u2212 K \u2212 T = 185 \u2212 K \u2212 T&#8217;ye iner. Z ayn\u0131 kald\u0131\u011f\u0131 i\u00e7in s\u0131f\u0131r katk\u0131 noktas\u0131 Z \u00f7 (A + Z) y\u00fckselir ve ayn\u0131 teslim oran\u0131nda katk\u0131 t \u00d7 120 TL d\u00fc\u015fer; %75 teslimde 0,75 \u00d7 120 = 90 TL. Katk\u0131 s\u0131f\u0131r\u0131n alt\u0131na inerse e\u015fik yoktur. S\u0131f\u0131r katk\u0131 noktas\u0131n\u0131n alt\u0131nda reklam ROAS&#8217;\u0131 ka\u00e7 olursa olsun zarar edilir. Orada \u00e7\u00f6z\u00fcm daha iyi ROAS de\u011fil, teslim oran\u0131 ya da \u00fcr\u00fcn maliyetidir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Porego&#8217;da nas\u0131l yap\u0131l\u0131r?<\/strong> Ba\u015faba\u015f ROAS uygulamas\u0131 ger\u00e7ek sipari\u015flerinizden hesaplar; iade oran\u0131, kargo ve tahsilat maliyetleri hesaba dahildir. \u00dcr\u00fcn bazl\u0131 e\u015fi\u011fi ve teslim oran\u0131 duyarl\u0131l\u0131\u011f\u0131n\u0131 okuyabilirsiniz. \u00c7\u0131kan e\u015fik taband\u0131r: kampanyan\u0131n panel rakam\u0131n\u0131 e\u015fikle kar\u015f\u0131la\u015ft\u0131r\u0131p b\u00fct\u00e7e karar\u0131n\u0131 siz verirsiniz.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Excel&#8217;de iki h\u00fccreyle kurun<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Sipari\u015f sayfas\u0131nda her sat\u0131r bir sipari\u015fi g\u00f6stersin; D s\u00fctununa &#8220;Teslim&#8221;, &#8220;D\u00f6nen&#8221; veya &#8220;\u0130ptal&#8221; yaz\u0131n. Yoldaki sipari\u015fler listeye girmesin. T\u00fcrkiye&#8217;deki Excel&#8217;de ay\u0131r\u0131c\u0131 genellikle noktal\u0131 virg\u00fcld\u00fcr; form\u00fcl hata verirse <code>;<\/code> yerine <code>,<\/code> deneyin. Form\u00fcller <a href=\"https:\/\/support.microsoft.com\/tr-tr\/office\/e%C4%9Fersay-i%C5%9Flevi-e0de10c6-f885-4e71-abb4-1f464816df34\" target=\"_blank\" rel=\"noopener\">E\u011eERSAY<\/a> (\u0130ngilizcesi COUNTIF) ve <a href=\"https:\/\/support.microsoft.com\/tr-tr\/office\/e%C4%9Fer-i%C5%9Flevi-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2\" target=\"_blank\" rel=\"noopener\">E\u011eER<\/a> (\u0130ngilizcesi IF) i\u015flevlerini kullan\u0131r.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead><tr><th>H\u00fccre<\/th><th>\u0130\u00e7erik<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>Sipari\u015f sayfas\u0131, t<\/td><td><code>=E\u011eERSAY(D2:D1001;\"Teslim\")\/(E\u011eERSAY(D2:D1001;\"Teslim\")+E\u011eERSAY(D2:D1001;\"D\u00f6nen\")+E\u011eERSAY(D2:D1001;\"\u0130ptal\"))<\/code><\/td><\/tr>\n<tr><td>Sipari\u015f sayfas\u0131, d<\/td><td><code>=E\u011eERSAY(D2:D1001;\"D\u00f6nen\")\/(E\u011eERSAY(D2:D1001;\"Teslim\")+E\u011eERSAY(D2:D1001;\"D\u00f6nen\")+E\u011eERSAY(D2:D1001;\"\u0130ptal\"))<\/code><\/td><\/tr>\n<tr><td>Hesap sayfas\u0131 B1 ile B10<\/td><td>B1 = P, B2 = S, B3 = C, B4 = K, B5 = Pk, B6 = T, B7 = Z, B8 = t, B9 = d, B10 = O. B8 ve B9&#8217;a sipari\u015f sayfas\u0131ndaki t ve d h\u00fccrelerine ba\u015fvuru yaz\u0131n (\u00f6r. =Sipari\u015f!F2).<\/td><\/tr>\n<tr><td>B11 (katk\u0131)<\/td><td><code>=B8*(B2-B3-B4-B5-B6)-B9*B7-B10<\/code><\/td><\/tr>\n<tr><td>B12 (e\u015fik)<\/td><td><code>=E\u011eER(B11&lt;=0;\"Reklam kurtarmaz\";B1\/B11)<\/code><\/td><\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">S\u0131nama i\u00e7in onays\u0131z kap\u0131da \u00f6deme girdilerini kendi K, D ve T tutarlar\u0131n\u0131zla yaz\u0131n: B11, elle hesaplad\u0131\u011f\u0131n\u0131z 0,75 \u00d7 (305 \u2212 K \u2212 T) \u2212 0,25 \u00d7 (K + D + 30) ile, B12 de 600 \u00f7 B11 ile ayn\u0131 \u00e7\u0131kmal\u0131. S\u0131nama de\u011feri tutmuyorsa \u00f6nce ay\u0131r\u0131c\u0131y\u0131 (; yerine ,) ve D s\u00fctunundaki yaz\u0131m\u0131 (Teslim\/D\u00f6nen\/\u0130ptal birebir) kontrol edin.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">E\u015fi\u011fi kampanya karar\u0131na \u00e7evirin<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Kampanyay\u0131 \u00f6deme y\u00f6ntemine g\u00f6re ayr\u0131 okuyun. Panelde 5 ROAS g\u00f6ren kampanya kartl\u0131 trafikte e\u015fi\u011fin \u00fcst\u00fcnde, onays\u0131z kap\u0131da \u00f6demede alt\u0131nda kalabilir. Bunun i\u00e7in kampanyay\u0131, m\u00fcmk\u00fcnse reklam setini \u00f6deme ak\u0131\u015f\u0131na g\u00f6re ay\u0131r\u0131n ya da sonu\u00e7lanm\u0131\u015f sipari\u015fleri iki gruba b\u00f6l\u00fcp her grubun e\u015fi\u011fini kendi rakam\u0131yla bulun.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sipari\u015f ba\u015f\u0131na reklam tavan\u0131 i\u00e7in tablodaki katk\u0131ya kendi K, D ve T tutarlar\u0131n\u0131z\u0131 koyun; her ak\u0131\u015f\u0131n tavan\u0131 ayr\u0131 \u00e7\u0131kar. Sipari\u015f ba\u015f\u0131na 30 TL b\u0131rakmak istiyorsan\u0131z (\u00f6rnek bir hedef) payda k\u00fc\u00e7\u00fcl\u00fcr: <strong>P \u00f7 (Katk\u0131 \u2212 30)<\/strong>. Her sat\u0131rda katk\u0131dan 30 TL d\u00fc\u015f\u00fcp 600&#8217;e b\u00f6lersiniz; katk\u0131 30 TL&#8217;yi ge\u00e7miyorsa o ak\u0131\u015fta bu hedefe ula\u015fan bir ROAS yoktur. Kira ve maa\u015f gibi sabit giderler bu hesapta yoktur.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Porego&#8217;da nas\u0131l yap\u0131l\u0131r?<\/strong> K\u00e2r-Zarar Hesaplama uygulamas\u0131 Meta ve Google Ads maliyetini, kargoyu, komisyonu ve \u00fcr\u00fcn maliyetini birle\u015ftirip sipari\u015f bazl\u0131 net k\u00e2r\u0131 g\u00f6sterir. E\u015fi\u011fi Ba\u015faba\u015f ROAS&#8217;ta, ger\u00e7ekle\u015fen k\u00e2r\u0131 burada okursunuz. Kargo maliyeti kalemlerini d\u00fc\u015f\u00fcrmek i\u00e7in <a href=\"https:\/\/porego.com\/blog\/kargo-maliyetleri-nasil-dusurulur-e-ticaret\/\">kargo maliyeti rehberine<\/a>, sipari\u015f durumu verisini okumak i\u00e7in <a href=\"https:\/\/porego.com\/blog\/e-ticarette-siparis-ve-kargo-verilerini-dogru-yorumlama-rehberi\/\">sipari\u015f ve kargo verisi rehberine<\/a> bakabilirsiniz. Kap\u0131da \u00f6demeye yeni ba\u015fl\u0131yorsan\u0131z <a href=\"https:\/\/porego.com\/blog\/kapida-odemeli-kargo-nasil-gonderilir\/\">kap\u0131da \u00f6demeli kargo rehberi<\/a> i\u015fe yarar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">E\u015fi\u011fi hesaplamadan \u00f6nce son sonu\u00e7lanm\u0131\u015f sipari\u015flerinizi Teslim, D\u00f6nen ve \u0130ptal diye ay\u0131r\u0131n; kart ile kap\u0131da \u00f6demeyi iki ayr\u0131 sayfada tutun. t ve d o zaman kendili\u011finden \u00e7\u0131kar.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">S\u0131k sorulan sorular<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Ba\u015faba\u015f ROAS ile hedef ROAS aras\u0131ndaki fark nedir?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Ba\u015faba\u015f ROAS&#8217;ta reklamdan sonra sipari\u015f ba\u015f\u0131na kalan tutar s\u0131f\u0131rd\u0131r. Hedef ROAS&#8217;ta paydadan b\u0131rakmak istedi\u011finiz tutar d\u00fc\u015f\u00fcl\u00fcr: \u00f6rnekte 30 TL hedef, e\u015fi\u011fi 600 \u00f7 Katk\u0131&#8217;dan 600 \u00f7 (Katk\u0131 \u2212 30)&#8217;a \u00e7\u0131kar\u0131r. Buradaki hedef, Google Ads&#8217;teki Hedef ROAS teklif ayar\u0131 de\u011fil, sizin b\u0131rakmak istedi\u011finiz k\u00e2rdan t\u00fcreyen e\u015fiktir; Google&#8217;a girdi\u011finiz hedefi bu e\u015fi\u011fin alt\u0131na \u00e7ekmeyin.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Kap\u0131da \u00f6demede ba\u015faba\u015f ROAS neden daha y\u00fcksek \u00e7\u0131kar?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Her zaman \u00e7\u0131kmaz; teslim oran\u0131na ve tahsilat bedeline ba\u011fl\u0131d\u0131r. Teslim al\u0131nmay\u0131p d\u00f6nen her sipari\u015f Z = K + D + Pk + Y kadar kaybettirir; \u00f6rnekte onays\u0131z kap\u0131da \u00f6demenin d\u00f6nen oran\u0131 kart\u0131nkinden y\u00fcksek varsay\u0131ld\u0131.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">E\u015fi\u011fi KDV dahil mi hari\u00e7 mi hesaplamal\u0131y\u0131m?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Panelin g\u00f6rd\u00fc\u011f\u00fc de\u011ferle ayn\u0131 tabanda; \u00f6rnekte paya KDV dahil 600 TL ya da hari\u00e7 500 TL girer ve dahil tabanda e\u015fik %20 y\u00fcksek \u00e7\u0131kar.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Sabit giderler ba\u015faba\u015f ROAS&#8217;a girer mi?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Girmez. Kira ve maa\u015f i\u00e7in b\u0131rakmak istedi\u011finiz tutar\u0131 paydadan d\u00fc\u015fersiniz.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Tek \u00fcr\u00fcn i\u00e7in ayr\u0131 e\u015fik gerekir mi?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Marj\u0131 ya da teslim oran\u0131 ortalamadan belirgin farkl\u0131 \u00fcr\u00fcnlerde gerekir; maliyeti 300 TL olan \u00fcr\u00fcnde ayn\u0131 teslim oran\u0131nda katk\u0131 t \u00d7 120 TL d\u00fc\u015fer ve s\u0131f\u0131r katk\u0131 noktas\u0131 y\u00fckselir.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Reklam paneli teslim edilmeyen kap\u0131da \u00f6deme sipari\u015fini de ciro sayabilir. Kendi e\u015fi\u011finizi kart, kap\u0131da \u00f6deme ve onayl\u0131 sipari\u015f i\u00e7in ayr\u0131 ayr\u0131 bulun.<\/p>\n","protected":false},"author":1,"featured_media":522,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[67],"tags":[5,9,72],"class_list":["post-524","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kargo-fiyatlari-ve-maliyetler","tag-kargo-maliyetleri","tag-kargo-maliyetleri-dusurme","tag-siparis-yonetimi"],"_links":{"self":[{"href":"https:\/\/porego.com\/blog\/wp-json\/wp\/v2\/posts\/524","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=524"}],"version-history":[{"count":3,"href":"https:\/\/porego.com\/blog\/wp-json\/wp\/v2\/posts\/524\/revisions"}],"predecessor-version":[{"id":622,"href":"https:\/\/porego.com\/blog\/wp-json\/wp\/v2\/posts\/524\/revisions\/622"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/porego.com\/blog\/wp-json\/wp\/v2\/media\/522"}],"wp:attachment":[{"href":"https:\/\/porego.com\/blog\/wp-json\/wp\/v2\/media?parent=524"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/porego.com\/blog\/wp-json\/wp\/v2\/categories?post=524"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/porego.com\/blog\/wp-json\/wp\/v2\/tags?post=524"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}