{"id":15927,"date":"2020-05-05T10:14:07","date_gmt":"2020-05-05T08:14:07","guid":{"rendered":"https:\/\/www.dase-analytics.com\/blog\/?p=15927\/"},"modified":"2022-10-27T14:54:46","modified_gmt":"2022-10-27T12:54:46","slug":"rfm-analyza","status":"publish","type":"post","link":"https:\/\/www.dase-analytics.com\/blog\/sk\/rfm-analyza\/","title":{"rendered":"RFM anal\u00fdza: Spoznajte spr\u00e1vanie z\u00e1kazn\u00edkov"},"content":{"rendered":"<p><span style=\"font-weight: 400;\"><div id=\"toc_container\" class=\"toc_wrap_right toc_white no_bullets\"><p class=\"toc_title\">Obsah \u010dl&aacute;nku<\/p><ul class=\"toc_list\"><li><\/li><li><\/li><li><\/li><li><ul><li><\/li><li><\/li><li><\/li><li><\/li><\/ul><\/li><li><\/li><li><\/li><\/ul><\/div>\n<\/span><\/p>\n<p><span style=\"font-weight: 400;\">RFM (<\/span><b>R<\/b><span style=\"font-weight: 400;\">ecency, <\/span><b>F<\/b><span style=\"font-weight: 400;\">requency, <\/span><b>M<\/b><span style=\"font-weight: 400;\">onetary) anal\u00fdza je jednoduch\u00fd sp\u00f4sob ako rozdeli\u0165 z\u00e1kazn\u00edkov do segmentov na z\u00e1klade ich n\u00e1kupn\u00e9ho spr\u00e1vania. T\u00e1to anal\u00fdza sa vyu\u017e\u00edva u\u017e viac ako 25 rokov k zlep\u0161eniu cielenia, zni\u017eovaniu n\u00e1kladov a zvy\u0161ovaniu n\u00e1vratnosti invest\u00edci\u00ed v reklame.<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"RFM Anal\u00fdza | Z\u00e1klady Analytiky | DASE\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/M-c99JtdF3w?feature=oembed&#038;enablejsapi=1&#038;origin=https:\/\/www.dase-analytics.com\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<h1><span id=\"Historia_RFM_Analyzy\"><span style=\"font-weight: 400;\">Hist\u00f3ria RFM Anal\u00fdzy<\/span><\/span><\/h1>\n<p><span style=\"font-weight: 400;\">RFM anal\u00fdza poch\u00e1dza z USA, kde ju pou\u017e\u00edvali z\u00e1sielkov\u00e9 firmy zameran\u00e9 na katal\u00f3gov\u00fd predaj, ako napr\u00edklad <\/span><a href=\"https:\/\/en.wikipedia.org\/wiki\/Lands%27_End\"><span style=\"font-weight: 400;\">Lands&#8216; End<\/span><\/a><span style=\"font-weight: 400;\">, <\/span><a href=\"https:\/\/en.wikipedia.org\/wiki\/Charles_Tyrwhitt\"><span style=\"font-weight: 400;\">Charles Tyrwhitt<\/span><\/a><span style=\"font-weight: 400;\"> alebo <\/span><a href=\"https:\/\/en.wikipedia.org\/wiki\/JCPenney\"><span style=\"font-weight: 400;\">JCPenney<\/span><\/a><span style=\"font-weight: 400;\">. Vyu\u017e\u00edvali ju za \u00fa\u010delom minimaliz\u00e1cie n\u00e1kladov na dopravu a maximaliz\u00e1ciu ziskov z predajov. V\u010faka nej vedeli identifikova\u0165 z\u00e1kazn\u00edkov, ktor\u00fdm bolo zbyto\u010dn\u00e9 zasiela\u0165 katal\u00f3gy alebo pon\u00faka\u0165 r\u00f4zne z\u013eavy.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Efektivitu RFM anal\u00fdzy potvrdzuj\u00fa aj tieto pr\u00edklady z praxe:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Eastwood zv\u00fd\u0161il zisky z e-mailov\u00e9ho marketingu o 21 % (2008).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u2019Occitane z\u00edskali 25-kr\u00e1t vy\u0161\u0161\u00ed v\u00fdnos z e-mailu.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Frederick\u2019s of Hollywood zv\u00fd\u0161il konverze o 6-9 %.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Viac si m\u00f4\u017eete pre\u010d\u00edta\u0165 v <\/span><a href=\"https:\/\/nmcdn.io\/e186d21f8c7946a19faed23c3da2f0da\/712f15a792524df4bfe0912e6bf5bb2a\/files\/RFM-Analysis\/Windsor_Circle_Whitepaper_-_RFM_Analysis_pdf.pdf\"><span style=\"font-weight: 400;\">\u0161t\u00fadi\u00ed od Winston Circle<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h1><span id=\"Rozdelenie_zakaznikov_do_segmentov\"><span style=\"font-weight: 400;\">Rozdelenie z\u00e1kazn\u00edkov do segmentov\u00a0<\/span><\/span><\/h1>\n<p><span style=\"font-weight: 400;\">V\u00fdsledkom RFM anal\u00fdzy b\u00fdva rozdelenie z\u00e1kazn\u00edkov do segmentov. Mno\u017estvo segmentov z\u00e1vis\u00ed od v\u00e1s, no \u0161tandardne sa pou\u017e\u00edva rozdelenie do 11 segmentov.\u00a0 V tabu\u013eke je preh\u013ead segmentov spolu s ich defin\u00edciou a vhodn\u00fdmi odpor\u00fa\u010daniami.<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Segment z\u00e1kazn\u00edkov<\/b><\/td>\n<td><b>Aktivita<\/b><\/td>\n<td><b>Tip na akciu<\/b><\/td>\n<\/tr>\n<tr>\n<td><b><i>VIP (Champions)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">Nak\u00fapili v poslednej dobe, nakupuj\u00fa \u010dasto a m\u00ed\u0148aj\u00fa najviac.<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Odme\u0148te ich. M\u00f4\u017eu by\u0165 \u010doskoro adopt\u00e9ri nov\u00fdch produktov. Ur\u010dite tie\u017e propaguj\u00fa va\u0161u zna\u010dku.<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>Loj\u00e1lni z\u00e1kazn\u00edci (Loyal Customers)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">M\u00ed\u0148aj\u00fa \u010dasto ve\u013ea pe\u0148az\u00ed. Reaguj\u00fa na kampane.<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Up-sell produktov vy\u0161\u0161ej hodnoty. Po\u017eiadajte ich o recenzie. Zapojte ich.<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>Potenci\u00e1lni loj\u00e1lni (Potential Loyalist)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">Ned\u00e1vni z\u00e1kazn\u00edci, \u010do minuli ve\u013ea pe\u0148az\u00ed a nak\u00fapili viac ako raz.<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Ponuka na registr\u00e1ciu \/ \u010dlenstvo vo vernostnom programe. Odpor\u00fa\u010danie \u010fal\u0161\u00edch produktov.<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>Nov\u00ed z\u00e1kazn\u00edci (New Customers)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">Najnov\u0161\u00ed z\u00e1kazn\u00edci, ktor\u00ed i zatia\u013e neminuli ve\u013ea.<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Poskytn\u00fa\u0165 onboarding support. Za\u010da\u0165 s nimi budova\u0165 vz\u0165ah hne\u010f od za\u010diatku.<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>S\u013eubn\u00ed (Promising)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">Nak\u00fapili ned\u00e1vno, ale nenakupuj\u00fa \u010dasto.<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Vytvorte povedomie o zna\u010dke. Pon\u00faknite nie\u010do zadarmo.<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>Z\u00e1kazn\u00edci, ktor\u00ed potrebuj\u00fa pozornos\u0165 (Customers Needing Attention)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">Nadpriemern\u00e1 aktu\u00e1lnos\u0165, frekvencia aj hodnota n\u00e1kupov, ale nak\u00fapili pred dlh\u0161ou dobou.<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Poskytnite \u010dasovo obmedzen\u00e9 ponuky, odpor\u00fa\u010dajte na z\u00e1klade predch\u00e1dzaj\u00facich n\u00e1kupov. Reaktivujte.<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>Pripraven\u00ed zaspa\u0165 (About To Sleep)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">Pod priemernou aktu\u00e1lnos\u0165ou, frekvenciou aj pe\u0148a\u017enou hodnotou. Strat\u00edte ich, ak nebud\u00fa znovu aktivovan\u00ed.<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Zdie\u013eajte s nimi cenn\u00e9 zdroje \/ know-how, odpor\u00fa\u010dajte ob\u013e\u00faben\u00e9 produkty alebo im poskytnite z\u013eavy. Sk\u00faste ich znovu oslovi\u0165.<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>V riziku (At Risk)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">Minuli ve\u013ea pe\u0148az\u00ed a nakupovali \u010dasto. Potrebujete ich vr\u00e1ti\u0165 sp\u00e4\u0165!<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Posielajte im personalizovan\u00e9 e-maily, aby ste sa znovu spojili. Pon\u00faknite z\u013eavu. Zdie\u013eajte d\u00f4le\u017eit\u00e9 zdroje a know-how.<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>Nem\u00f4\u017eeme ich strati\u0165 (Can\u2019t Lose Them)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">Nakupovali \u010dasto a\u00a0 m\u00ed\u0148ali ve\u013ea, ale dlho sa nevr\u00e1tili.<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Z\u00edskajte si ich z\u013eavou alebo nov\u0161\u00edm produktom. Nenechajte ich od\u00eds\u0165 ku konkurencii. Porozpr\u00e1vajte sa s nimi. Z\u00edskajte sp\u00e4tn\u00fa v\u00e4zbu.<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>Hibern\u00e1cia (Hibernating)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">Posledn\u00fd n\u00e1kup bol d\u00e1vno v minulosti, nakupovali za m\u00e1lo a zriedka.<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Pon\u00faknite \u010fal\u0161ie relevantn\u00e9 produkty a \u0161peci\u00e1lne z\u013eavy. Zv\u00fd\u0161te hodnotu va\u0161ej zna\u010dky v ich o\u010diach.<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>Straten\u00ed z\u00e1kazn\u00edci (Lost)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">Najmen\u0161ia aktu\u00e1lnos\u0165, frekvencia a pe\u0148a\u017en\u00e1 hodnota.<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Vysk\u00fa\u0161ajte reaktiva\u010dn\u00fa kampa\u0148. Ak nebud\u00fa reagova\u0165, zabudnite na nich. Vyra\u010fte ich z va\u0161ich aktiv\u00edt.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h1><span id=\"Preco_RFM_Analyza\"><span style=\"font-weight: 400;\">Pre\u010do RFM Anal\u00fdza<\/span><\/span><\/h1>\n<p><span style=\"font-weight: 400;\">Pomocou RFM anal\u00fdzy m\u00f4\u017eete n\u00e1js\u0165 odpovede na ot\u00e1zky ako:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Kto s\u00fa va\u0161i najlep\u0161\u00ed a najvernej\u0161\u00ed z\u00e1kazn\u00edci?<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ak\u00ed z\u00e1kazn\u00edci s\u00fa najbli\u017e\u0161ie k tomu aby v\u00e1s opustili?\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ako zv\u00fd\u0161i\u0165 frekvenciu opakovan\u00fdch n\u00e1kupov?<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u010co komunikova\u0165 na jednotliv\u00e9 segmenty z\u00e1kazn\u00edkov?<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ako zv\u00fd\u0161i\u0165 pravdepodobnos\u0165 opakovan\u00e9ho n\u00e1kupu u nov\u00fdch z\u00e1kazn\u00edkov?<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Hlavn\u00fdm princ\u00edpom, ktor\u00fd sa vyu\u017e\u00edva pri RFM anal\u00fdze je <\/span><a href=\"https:\/\/en.wikipedia.org\/wiki\/Pareto_principle\"><span style=\"font-weight: 400;\">paretov princ\u00edp<\/span><\/a><span style=\"font-weight: 400;\">. \u010ci\u017ee zameranie sa na d\u00f4le\u017eit\u00e9 segmenty z\u00e1kazn\u00edkov, ktor\u00e9 v\u00e1m pravdepodobne poskytn\u00fa vy\u0161\u0161iu n\u00e1vratnos\u0165 invest\u00edci\u00ed.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">D\u00fafam, \u017ee ste teraz presved\u010den\u00ed o u\u017eito\u010dnosti RFM anal\u00fdzy pre va\u0161e vlastn\u00e9 podnikanie.<\/span><\/p>\n<h1><span id=\"Zakladne_vypocty\"><span style=\"font-weight: 400;\">Z\u00e1kladne v\u00fdpo\u010dty<\/span><\/span><\/h1>\n<p><span style=\"font-weight: 400;\">Pre v\u00fdpo\u010dty budete potrebova\u0165 o ka\u017edom z\u00e1kazn\u00edkovi nasleduj\u00face inform\u00e1cie:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">ID z\u00e1kazn\u00edka (email, user ID, client ID, meno a pod.), pomocou ktor\u00fdch ich m\u00f4\u017eete identifikova\u0165.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Aktu\u00e1lnos\u0165<\/b><span style=\"font-weight: 400;\"> (<\/span><b>R<\/b><span style=\"font-weight: 400;\">ecency)<\/span><b>: <\/b><span style=\"font-weight: 400;\">Ko\u013eko dn\u00ed, t\u00fd\u017ed\u0148ov, mesiacov ubehlo od ich posledn\u00e9ho n\u00e1kupu? Na v\u00fdpo\u010det aktu\u00e1lnej hodnoty sta\u010d\u00ed odpo\u010d\u00edta\u0165 d\u00e1tum posledn\u00e9ho n\u00e1kupu od dne\u0161n\u00e9ho d\u0148a.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Frekvencia<\/b><span style=\"font-weight: 400;\"> (<\/span><b>F<\/b><span style=\"font-weight: 400;\">requency): Ko\u013ekokr\u00e1t u v\u00e1s z\u00e1kazn\u00edk nak\u00fapil? Napr\u00edklad, ak u v\u00e1s niekto za ur\u010dit\u00e9 \u010dasov\u00e9 obdobie nak\u00fapil 10-kr\u00e1t, jeho frekvencia bude 10.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Hodnota n\u00e1kupov<\/b><span style=\"font-weight: 400;\"> (<\/span><b>M<\/b><span style=\"font-weight: 400;\">onetary): Ko\u013eko pe\u0148az\u00ed u v\u00e1s z\u00e1kazn\u00edk minul? Ak u v\u00e1s za vybran\u00e9 obdobie niekto nak\u00fapil dokopy za 1000 \u20ac, tak t\u00e1to hodnota bude 1000 \u20ac.<\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/RFM-Anal\u00fdza-1.png\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-15959\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/RFM-Anal\u00fdza-1.png\" alt=\"RFM Anal\u00fdza\" width=\"1200\" height=\"628\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/RFM-Anal\u00fdza-1.png 1200w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/RFM-Anal\u00fdza-1-300x157.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/RFM-Anal\u00fdza-1-1024x536.png 1024w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/RFM-Anal\u00fdza-1-600x314.png 600w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/a><\/p>\n<h2><span id=\"Ukazka_udajov\"><span style=\"font-weight: 400;\">Uk\u00e1\u017eka \u00fadajov<\/span><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Pre na\u0161e v\u00fdpo\u010dty pou\u017eijeme \u00fadaje zo slu\u017eby Google Analytics, kde si ako identifik\u00e1tor z\u00e1kazn\u00edka m\u00f4\u017eete posiela\u0165 <\/span><a href=\"https:\/\/www.dase-analytics.com\/blog\/sk\/vyraz\/client-id\/\"><span style=\"font-weight: 400;\">client ID<\/span><\/a><span style=\"font-weight: 400;\"> do vlastnej dimenzie.\u00a0<\/span><\/p>\n<p><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--><\/p>\n<table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col width=\"200\" \/>\n<col width=\"200\" \/>\n<col width=\"200\" \/>\n<col width=\"200\" \/><\/colgroup>\n<tbody>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Client ID&quot;}\">Client ID<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Date&quot;}\">Date<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Transactions&quot;}\">Transactions<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Revenue&quot;}\">Revenue<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:100438314.155627}\">100438314.1556<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43587}\">2019-05-02<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2}\">2<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1750}\" data-sheets-numberformat=\"{&quot;1&quot;:4,&quot;2&quot;:&quot;#,##0.00[$ \u20ac]&quot;}\">1,750.00 \u20ac<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:100515227.155676}\">100515227.1557<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43587}\">2019-05-02<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:3}\">3<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2297}\" data-sheets-numberformat=\"{&quot;1&quot;:4,&quot;2&quot;:&quot;#,##0.00[$ \u20ac]&quot;}\">2,297.00 \u20ac<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1006060326.15639}\">1006060326.1564<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43705}\">2019-08-28<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2}\">2<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2916}\" data-sheets-numberformat=\"{&quot;1&quot;:4,&quot;2&quot;:&quot;#,##0.00[$ \u20ac]&quot;}\">2,916.00 \u20ac<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1010126481.1552}\">1010126481.1552<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43560}\">2019-04-05<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2}\">2<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2308}\" data-sheets-numberformat=\"{&quot;1&quot;:4,&quot;2&quot;:&quot;#,##0.00[$ \u20ac]&quot;}\">2,308.00 \u20ac<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:101406401.157123}\">101406401.1571<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43910}\">2020-03-20<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2}\">2<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:4590}\" data-sheets-numberformat=\"{&quot;1&quot;:4,&quot;2&quot;:&quot;#,##0.00[$ \u20ac]&quot;}\">4,590.00 \u20ac<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><i><span style=\"font-weight: 400;\"><em><b>Pozn\u00e1mka: <\/b><\/em>Ak neviete ak\u00fd je rozdiel medzi client ID a <\/span><\/i><a href=\"https:\/\/www.dase-analytics.com\/blog\/sk\/vyraz\/user-id\/\"><i><span style=\"font-weight: 400;\">user ID<\/span><\/i><\/a><i><span style=\"font-weight: 400;\"> odpor\u00fa\u010dam v\u00e1m pre\u010d\u00edta\u0165 si tento \u010dl\u00e1nok: <\/span><\/i><a href=\"https:\/\/www.dase-analytics.com\/blog\/sk\/user-id-vs-client-id-alebo-preco-nie-je-google-analytics-dokonaly\/\"><i><span style=\"font-weight: 400;\">User ID vs. Client ID alebo pre\u010do nie je Google Analytics dokonal\u00fd?<\/span><\/i><\/a><\/p>\n<p><span style=\"font-weight: 400;\">Transakciu v na\u0161om pr\u00edpade predstavuje pre\u010d\u00edtanie \u010dl\u00e1nku a v\u00fdnosy (revenue) predstavuje po\u010det slov v \u010dl\u00e1nku, ktor\u00fd n\u00e1v\u0161tevn\u00edk str\u00e1nky pre\u010d\u00edtal na na\u0161om blogu.<\/span><\/p>\n<p>V\u00fdpo\u010det Recency Frequency a Monetary hodn\u00f4t<\/p>\n<p><span style=\"font-weight: 400;\">Z \u00fadajov vy\u0161\u0161ie si v Google Sheets vypo\u010d\u00edtate nasleduj\u00face inform\u00e1cie:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u00e1tum prvej transakcie (<\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/3094017\"><span style=\"font-weight: 400;\">MIN funkcia<\/span><\/a><span style=\"font-weight: 400;\">)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u00e1tum poslednej transakcie (<\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/3094013\"><span style=\"font-weight: 400;\">MAX funkcia<\/span><\/a><span style=\"font-weight: 400;\">)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Po\u010det mesiacov od posledn\u00e9ho n\u00e1kupu (<\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/6055612\"><span style=\"font-weight: 400;\">DATEDIF<\/span><\/a><span style=\"font-weight: 400;\">)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Priemern\u00fa hodnotu objedn\u00e1vky (<\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/3093583\"><span style=\"font-weight: 400;\">SUMIF<\/span><\/a><span style=\"font-weight: 400;\">)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Priemern\u00fa frekvenciu objedn\u00e1vok (po\u010det transakci\u00ed)<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Aby va\u0161e \u00fadaje viac zodpovedali realite, m\u00f4\u017eete pou\u017ei\u0165 frekvenciu objedn\u00e1vok za de\u0148, mesiac alebo rok. M\u00f4\u017eete si vybra\u0165 \u010dasov\u00e9 obdobie, ktor\u00e9 m\u00e1 zmysel pre va\u0161e podnikanie. Napr\u00edklad ak pred\u00e1vate k\u00e1vu, tak bude vhodn\u00e9 pou\u017ei\u0165 dni, ak aut\u00e1, tak by bolo rozumnej\u0161ie zvoli\u0165 si napr\u00edklad rok.\u00a0<\/span><\/p>\n<p><em><b>Pozn\u00e1mka: <\/b><span style=\"font-weight: 400;\">Pri v\u00fdpo\u010dtoch nez\u00e1le\u017e\u00ed \u010di sa zameriate na priemern\u00fa hodnotu objedn\u00e1vok za mesiac, rok alebo de\u0148, preto\u017ee n\u00e1sledne budete pre ka\u017ed\u00e9ho z\u00e1kazn\u00edka po\u010d\u00edta\u0165 sk\u00f3re RFM na \u0161k\u00e1le od 1-5 pomocou <\/span><a href=\"https:\/\/en.wikipedia.org\/wiki\/Percentile\"><span style=\"font-weight: 400;\">percentilu<\/span><\/a><span style=\"font-weight: 400;\">.\u00a0<\/span><\/em><\/p>\n<h2><span id=\"Ako_vypocitat_skore_RFM_na_stupnici_od_1_do_5\"><span style=\"font-weight: 400;\">Ako vypo\u010d\u00edta\u0165 sk\u00f3re RFM na stupnici od 1 do 5?<\/span><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tieto hodnoty m\u00f4\u017eete vypo\u010d\u00edta\u0165 viacer\u00fdmi sp\u00f4sobmi. Jedn\u00fdm z nich je odhad, kedy sa pozriete na v\u00fdsledky a poviete si, \u017ee v\u0161etci z\u00e1kazn\u00edci, ktor\u00ed u v\u00e1s nak\u00fapili do 30 dn\u00ed bud\u00fa ma\u0165 sk\u00f3re pre recency (R) 5.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Odpor\u00fa\u010dam v\u00e1m v\u0161ak pre v\u00fdpo\u010det RFM sk\u00f3re pou\u017ei\u0165 <\/span><a href=\"https:\/\/cs.wikipedia.org\/wiki\/Kvantil\"><span style=\"font-weight: 400;\">kvantily<\/span><\/a><span style=\"font-weight: 400;\">. Kvantily s\u00fa ako percentil, ale namiesto rozdelenia \u00fadajov na 100 \u010dast\u00ed ich rozde\u013euje na 5 rovnak\u00fdch \u010dast\u00ed. T\u00e1to met\u00f3da je trochu komplikovanej\u0161ia na v\u00fdpo\u010det, no m\u00f4\u017eete ju uplatni\u0165 na ak\u00e9ko\u013evek odvetvie. Jej v\u00fdhoda spo\u010d\u00edva v tom, \u017ee distribuuje z\u00e1kazn\u00edkov rovnomerne do v\u0161etk\u00fdch kvantilov.<\/span><\/p>\n<p><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--><\/p>\n<table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col width=\"112\" \/>\n<col width=\"110\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"111\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/><\/colgroup>\n<tbody>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Customer ID&quot;}\">Customer ID<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Transactions&quot;}\">Transactions<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Last order&quot;}\">Last order<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;First order&quot;}\">First order<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Recency&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">Recency<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Monetary&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">Monetary<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Updated Frequency&quot;}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\">Updated Frequency<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:100438314.155627}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-formula=\"=UNIQUE('Raw Data'!R[14]C[0]:C[0])\">100438314.1556<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-formula=\"=ArrayFormula(COUNTIF('Raw Data'!C[-1]:C[-1],R[0]C[-1]:C[-1])) \">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43587}\" data-sheets-numberformat=\"[null,5,&quot;M\/d\/yyyy&quot;,1]\" data-sheets-formula=\"=ARRAYFORMULA(TO_DATE(IFNA(VLOOKUP(R[0]C[-2]:C[-2],SORTN(SORT({'Raw Data'!R[14]C[-2]:C[-2],'Raw Data'!R[14]C[-1]:C[-1]}, 2, 0), 999^99, 2, 1, 1), 2, 0))))\">5\/2\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43587}\" data-sheets-numberformat=\"{&quot;1&quot;:5}\" data-sheets-formula=\"=ARRAYFORMULA(TO_DATE(IFNA(VLOOKUP(R[0]C[-3]:C[-3],SORTN(SORT({'Raw Data'!R[14]C[-3]:C[-3],'Raw Data'!R[14]C[-2]:C[-2]}, 2, 1), 999^99, 2, 1, 1), 2, 0))))\">5\/2\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:368}\" data-sheets-formula=\"=ArrayFormula(DATEDIF(R[0]C[-2]:C[-2],now(),&quot;D&quot;))\">368<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1750}\" data-sheets-numberformat=\"[null,4,&quot;#,##0.00[$ \u20ac]&quot;,1]\" data-sheets-formula=\"=ArrayFormula(IFERROR(SUMIF('Raw Data'!C[-5]:C[-5],R[0]C[-5]:C[-5],'Raw Data'!C[-2]:C[-2]),0))\">1,750.00 \u20ac<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:0.002717391304347826}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-formula=\"=ArrayFormula(IFERROR(R[0]C[-5]:C[-5]\/R[0]C[-2]:C[-2],0))\">0.0027<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:100515227.155676}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">100515227.1557<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-ischild=\"\">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43587}\" data-sheets-numberformat=\"[null,5,&quot;M\/d\/yyyy&quot;,1]\" data-sheets-ischild=\"\">5\/2\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43587}\" data-sheets-numberformat=\"{&quot;1&quot;:5}\" data-sheets-ischild=\"\">5\/2\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:368}\" data-sheets-ischild=\"\">368<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2297}\" data-sheets-numberformat=\"[null,4,&quot;#,##0.00[$ \u20ac]&quot;,1]\" data-sheets-ischild=\"\">2,297.00 \u20ac<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:0.002717391304347826}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">0.0027<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1006060326.15639}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">1006060326.1564<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-ischild=\"\">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43705}\" data-sheets-numberformat=\"[null,5,&quot;M\/d\/yyyy&quot;,1]\" data-sheets-ischild=\"\">8\/28\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43705}\" data-sheets-numberformat=\"{&quot;1&quot;:5}\" data-sheets-ischild=\"\">8\/28\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:250}\" data-sheets-ischild=\"\">250<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2916}\" data-sheets-numberformat=\"[null,4,&quot;#,##0.00[$ \u20ac]&quot;,1]\" data-sheets-ischild=\"\">2,916.00 \u20ac<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:0.004}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">0.0040<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1010126481.1552}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">1010126481.1552<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-ischild=\"\">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43560}\" data-sheets-numberformat=\"[null,5,&quot;M\/d\/yyyy&quot;,1]\" data-sheets-ischild=\"\">4\/5\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43560}\" data-sheets-numberformat=\"{&quot;1&quot;:5}\" data-sheets-ischild=\"\">4\/5\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:395}\" data-sheets-ischild=\"\">395<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2308}\" data-sheets-numberformat=\"[null,4,&quot;#,##0.00[$ \u20ac]&quot;,1]\" data-sheets-ischild=\"\">2,308.00 \u20ac<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:0.002531645569620253}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">0.0025<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:101406401.157123}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">101406401.1571<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-ischild=\"\">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43910}\" data-sheets-numberformat=\"[null,5,&quot;M\/d\/yyyy&quot;,1]\" data-sheets-ischild=\"\">3\/20\/2020<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43910}\" data-sheets-numberformat=\"{&quot;1&quot;:5}\" data-sheets-ischild=\"\">3\/20\/2020<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:45}\" data-sheets-ischild=\"\">45<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:4590}\" data-sheets-numberformat=\"[null,4,&quot;#,##0.00[$ \u20ac]&quot;,1]\" data-sheets-ischild=\"\">4,590.00 \u20ac<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:0.022222222222222223}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">0.0222<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">V \u010fal\u0161om kroku si potrebujete zoradi\u0165 va\u0161ich z\u00e1kazn\u00edkov, k \u010domu pou\u017eijete funkciu <\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/3094098\"><span style=\"font-weight: 400;\">RANK<\/span><\/a><span style=\"font-weight: 400;\">. Pomocou tejto funkcie prirad\u00edte ka\u017ed\u00e9mu z\u00e1kazn\u00edkovi sk\u00f3re, ktor\u00e9 nesk\u00f4r pou\u017eijete pri v\u00fdpo\u010dte percentilov.\u00a0<\/span><\/p>\n<p><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--><\/p>\n<table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col width=\"112\" \/>\n<col width=\"110\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"111\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/><\/colgroup>\n<tbody>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Customer ID&quot;}\">Customer ID<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Transactions&quot;}\">Transactions<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Last order&quot;}\">Last order<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;First order&quot;}\">First order<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Recency&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">Recency<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Monetary&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">Monetary<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Updated Frequency&quot;}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\">Updated Frequency<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;R Rank&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">R Rank<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;F Rank&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">F Rank<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;M Rank&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">M Rank<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:100438314.155627}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-formula=\"=UNIQUE('Raw Data'!R[14]C[0]:C[0])\">100438314.1556<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-formula=\"=ArrayFormula(COUNTIF('Raw Data'!C[-1]:C[-1],R[0]C[-1]:C[-1])) \">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43587}\" data-sheets-numberformat=\"[null,5,&quot;M\/d\/yyyy&quot;,1]\" data-sheets-formula=\"=ARRAYFORMULA(TO_DATE(IFNA(VLOOKUP(R[0]C[-2]:C[-2],SORTN(SORT({'Raw Data'!R[14]C[-2]:C[-2],'Raw Data'!R[14]C[-1]:C[-1]}, 2, 0), 999^99, 2, 1, 1), 2, 0))))\">5\/2\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43587}\" data-sheets-numberformat=\"{&quot;1&quot;:5}\" data-sheets-formula=\"=ARRAYFORMULA(TO_DATE(IFNA(VLOOKUP(R[0]C[-3]:C[-3],SORTN(SORT({'Raw Data'!R[14]C[-3]:C[-3],'Raw Data'!R[14]C[-2]:C[-2]}, 2, 1), 999^99, 2, 1, 1), 2, 0))))\">5\/2\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:368}\" data-sheets-formula=\"=ArrayFormula(DATEDIF(R[0]C[-2]:C[-2],now(),&quot;D&quot;))\">368<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1750}\" data-sheets-numberformat=\"[null,4,&quot;#,##0.00[$ \u20ac]&quot;,1]\" data-sheets-formula=\"=ArrayFormula(IFERROR(SUMIF('Raw Data'!C[-5]:C[-5],R[0]C[-5]:C[-5],'Raw Data'!C[-2]:C[-2]),0))\">1,750.00 \u20ac<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:0.002717391304347826}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-formula=\"=ArrayFormula(IFERROR(R[0]C[-5]:C[-5]\/R[0]C[-2]:C[-2],0))\">0.0027<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:65}\" data-sheets-formula=\"=ArrayFormula(RANK(R[0]C[-5]:C[-5],R[0]C[-5]:C[-5],1))\">65<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:64}\" data-sheets-formula=\"=ArrayFormula(RANK(R[0]C[-2]:C[-2],R[0]C[-2]:C[-2],1))\">64<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:80}\" data-sheets-formula=\"=ArrayFormula(RANK(R[0]C[-4]:C[-4],R[0]C[-4]:C[-4],1))\">80<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:100515227.155676}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">100515227.1557<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-ischild=\"\">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43587}\" data-sheets-numberformat=\"[null,5,&quot;M\/d\/yyyy&quot;,1]\" data-sheets-ischild=\"\">5\/2\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43587}\" data-sheets-numberformat=\"{&quot;1&quot;:5}\" data-sheets-ischild=\"\">5\/2\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:368}\" data-sheets-ischild=\"\">368<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2297}\" data-sheets-numberformat=\"[null,4,&quot;#,##0.00[$ \u20ac]&quot;,1]\" data-sheets-ischild=\"\">2,297.00 \u20ac<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:0.002717391304347826}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">0.0027<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:65}\" data-sheets-ischild=\"\">65<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:64}\" data-sheets-ischild=\"\">64<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:178}\" data-sheets-ischild=\"\">178<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1006060326.15639}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">1006060326.1564<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-ischild=\"\">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43705}\" data-sheets-numberformat=\"[null,5,&quot;M\/d\/yyyy&quot;,1]\" data-sheets-ischild=\"\">8\/28\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43705}\" data-sheets-numberformat=\"{&quot;1&quot;:5}\" data-sheets-ischild=\"\">8\/28\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:250}\" data-sheets-ischild=\"\">250<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2916}\" data-sheets-numberformat=\"[null,4,&quot;#,##0.00[$ \u20ac]&quot;,1]\" data-sheets-ischild=\"\">2,916.00 \u20ac<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:0.004}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">0.0040<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:176}\" data-sheets-ischild=\"\">176<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:165}\" data-sheets-ischild=\"\">165<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:227}\" data-sheets-ischild=\"\">227<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1010126481.1552}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">1010126481.1552<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-ischild=\"\">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43560}\" data-sheets-numberformat=\"[null,5,&quot;M\/d\/yyyy&quot;,1]\" data-sheets-ischild=\"\">4\/5\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43560}\" data-sheets-numberformat=\"{&quot;1&quot;:5}\" data-sheets-ischild=\"\">4\/5\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:395}\" data-sheets-ischild=\"\">395<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2308}\" data-sheets-numberformat=\"[null,4,&quot;#,##0.00[$ \u20ac]&quot;,1]\" data-sheets-ischild=\"\">2,308.00 \u20ac<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:0.002531645569620253}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">0.0025<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:34}\" data-sheets-ischild=\"\">34<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:33}\" data-sheets-ischild=\"\">33<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:179}\" data-sheets-ischild=\"\">179<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:101406401.157123}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">101406401.1571<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-ischild=\"\">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43910}\" data-sheets-numberformat=\"[null,5,&quot;M\/d\/yyyy&quot;,1]\" data-sheets-ischild=\"\">3\/20\/2020<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43910}\" data-sheets-numberformat=\"{&quot;1&quot;:5}\" data-sheets-ischild=\"\">3\/20\/2020<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:45}\" data-sheets-ischild=\"\">45<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:4590}\" data-sheets-numberformat=\"[null,4,&quot;#,##0.00[$ \u20ac]&quot;,1]\" data-sheets-ischild=\"\">4,590.00 \u20ac<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:0.022222222222222223}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">0.0222<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:299}\" data-sheets-ischild=\"\">299<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:293}\" data-sheets-ischild=\"\">293<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:281}\" data-sheets-ischild=\"\">281<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Po zoraden\u00ed si v pomocnej tabu\u013eke vypo\u010d\u00edtate percentily, pod\u013ea ktor\u00fdch budete prira\u010fova\u0165 RFM sk\u00f3re. K tomu pou\u017eijete funkciu <\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/3094093\"><span style=\"font-weight: 400;\">PERCENTILE<\/span><\/a><span style=\"font-weight: 400;\">. Pomocou nej dostanete hodnoty na z\u00e1klade ktor\u00fdch viete rozdeli\u0165 z\u00e1kazn\u00edkov do 5 rovnak\u00fdch skup\u00edn (kvantilov).<\/span><\/p>\n<p><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--><\/p>\n<table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/><\/colgroup>\n<tbody>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Quantile&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">Quantile<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;R Rank Percentil&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">R Rank Percentil<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;F Rank Percentil&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">F Rank Percentil<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;M Rank Percentil&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">M Rank Percentil<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;RFM Score Individual&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">RFM Score Individual<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;81-100&quot;}\" data-sheets-numberformat=\"[null,3,&quot;0.00%&quot;,1]\">81-100<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:255.4}\" data-sheets-formula=\"=PERCENTILE(R2C[-11]:C[-11],0.8)\">255.4<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:254.8}\" data-sheets-formula=\"=PERCENTILE(R2C[-11]:C[-11],0.8)\">254.8<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:255.4}\" data-sheets-formula=\"=PERCENTILE(R2C[-11]:C[-11],0.8)\">255.4<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:5}\">5<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;61-80&quot;}\" data-sheets-numberformat=\"[null,3,&quot;0.00%&quot;,1]\">61-80<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:191}\" data-sheets-formula=\"=PERCENTILE(R2C[-11]:C[-11],0.6)\">191<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:191.59999999999997}\" data-sheets-formula=\"=PERCENTILE(R2C[-11]:C[-11],0.6)\">191.6<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:191.79999999999998}\" data-sheets-formula=\"=PERCENTILE(R2C[-11]:C[-11],0.6)\">191.8<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:4}\">4<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;51-60&quot;}\" data-sheets-numberformat=\"[null,3,&quot;0.00%&quot;,1]\">51-60<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:127.4}\" data-sheets-formula=\"=PERCENTILE(R2C[-11]:C[-11],0.4)\">127.4<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:127.4}\" data-sheets-formula=\"=PERCENTILE(R2C[-11]:C[-11],0.4)\">127.4<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:128}\" data-sheets-formula=\"=PERCENTILE(R2C[-11]:C[-11],0.4)\">128<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:3}\">3<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;21-40&quot;}\">21-40<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:64.6}\" data-sheets-formula=\"=PERCENTILE(R2C[-11]:C[-11],0.2)\">64.6<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:64}\" data-sheets-formula=\"=PERCENTILE(R2C[-11]:C[-11],0.2)\">64<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:64.6}\" data-sheets-formula=\"=PERCENTILE(R2C[-11]:C[-11],0.2)\">64.6<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2}\">2<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;0-20&quot;}\">0-20<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-formula=\"=PERCENTILE(R2C[-11]:R4296C[-11],0) \">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-formula=\"=PERCENTILE(R2C[-11]:R4296C[-11],0) \">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-formula=\"=PERCENTILE(R2C[-11]:R4296C[-11],0) \">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\">1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Na z\u00e1klade percentilu prirad\u00edte ka\u017ed\u00e9mu z\u00e1kazn\u00edkovi RFM sk\u00f3re pomocou <\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/3093364\"><span style=\"font-weight: 400;\">IF<\/span><\/a><span style=\"font-weight: 400;\"> funkcie na z\u00e1klade jeho ranku. Tak\u017ee ak je rank z\u00e1kazn\u00edka pre recency vy\u0161\u0161\u00ed ako hodnota 255.4, tak tento z\u00e1kazn\u00edk patr\u00ed medzi top 20 % z\u00e1kazn\u00edkov pod\u013ea recency.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Vo v\u00fdsledku dostanete pre ka\u017ed\u00e9ho z\u00e1kazn\u00edka jeho sk\u00f3re pre recency, frequency a monetary.<\/span><\/p>\n<p><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--><\/p>\n<table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col width=\"112\" \/>\n<col width=\"110\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"111\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/><\/colgroup>\n<tbody>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Customer ID&quot;}\">Customer ID<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Transactions&quot;}\">Transactions<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Last order&quot;}\">Last order<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;First order&quot;}\">First order<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Recency&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">Recency<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Monetary&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">Monetary<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Updated Frequency&quot;}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\">Updated Frequency<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;R Rank&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">R Rank<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;F Rank&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">F Rank<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;M Rank&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">M Rank<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;R Score&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">R Score<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;F Score&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">F Score<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;M Score&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">M Score<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;RFM Score&quot;}\" data-sheets-numberformat=\"[null,4,&quot;\\&quot;$\\&quot;#,##0&quot;,1]\">RFM Score<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:100438314.155627}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-formula=\"=UNIQUE('Raw Data'!R[14]C[0]:C[0])\">100438314.1556<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-formula=\"=ArrayFormula(COUNTIF('Raw Data'!C[-1]:C[-1],R[0]C[-1]:C[-1])) \">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43587}\" data-sheets-numberformat=\"[null,5,&quot;M\/d\/yyyy&quot;,1]\" data-sheets-formula=\"=ARRAYFORMULA(TO_DATE(IFNA(VLOOKUP(R[0]C[-2]:C[-2],SORTN(SORT({'Raw Data'!R[14]C[-2]:C[-2],'Raw Data'!R[14]C[-1]:C[-1]}, 2, 0), 999^99, 2, 1, 1), 2, 0))))\">5\/2\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43587}\" data-sheets-numberformat=\"{&quot;1&quot;:5}\" data-sheets-formula=\"=ARRAYFORMULA(TO_DATE(IFNA(VLOOKUP(R[0]C[-3]:C[-3],SORTN(SORT({'Raw Data'!R[14]C[-3]:C[-3],'Raw Data'!R[14]C[-2]:C[-2]}, 2, 1), 999^99, 2, 1, 1), 2, 0))))\">5\/2\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:368}\" data-sheets-formula=\"=ArrayFormula(DATEDIF(R[0]C[-2]:C[-2],now(),&quot;D&quot;))\">368<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1750}\" data-sheets-numberformat=\"[null,4,&quot;#,##0.00[$ \u20ac]&quot;,1]\" data-sheets-formula=\"=ArrayFormula(IFERROR(SUMIF('Raw Data'!C[-5]:C[-5],R[0]C[-5]:C[-5],'Raw Data'!C[-2]:C[-2]),0))\">1,750.00 \u20ac<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:0.002717391304347826}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-formula=\"=ArrayFormula(IFERROR(R[0]C[-5]:C[-5]\/R[0]C[-2]:C[-2],0))\">0.0027<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:65}\" data-sheets-formula=\"=ArrayFormula(RANK(R[0]C[-5]:C[-5],R[0]C[-5]:C[-5],1))\">65<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:64}\" data-sheets-formula=\"=ArrayFormula(RANK(R[0]C[-2]:C[-2],R[0]C[-2]:C[-2],1))\">64<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:80}\" data-sheets-formula=\"=ArrayFormula(RANK(R[0]C[-4]:C[-4],R[0]C[-4]:C[-4],1))\">80<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2}\" data-sheets-formula=\"=ArrayFormula(if(R[0]C[-3]:C[-3]&gt;=R2C[8],R2C22,if(R[0]C[-3]:C[-3]&gt;=R3C[8],R3C22,if(R[0]C[-3]:C[-3]&gt;=R4C[8],R4C22,if(R[0]C[-3]:C[-3]&gt;=R5C[8],R5C22,R6C22))))) \">2<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2}\" data-sheets-formula=\"=ArrayFormula(if(R[0]C[-3]:C[-3]&gt;=R2C[8],R2C22,if(R[0]C[-3]:C[-3]&gt;=R3C[8],R3C22,if(R[0]C[-3]:C[-3]&gt;=R4C[8],R4C22,if(R[0]C[-3]:C[-3]&gt;=R5C[8],R5C22,R6C22))))) \">2<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2}\" data-sheets-formula=\"=ArrayFormula(if(R[0]C[-3]:C[-3]&gt;=R2C[8],R2C22,if(R[0]C[-3]:C[-3]&gt;=R3C[8],R3C22,if(R[0]C[-3]:C[-3]&gt;=R4C[8],R4C22,if(R[0]C[-3]:C[-3]&gt;=R5C[8],R5C22,R6C22))))) \">2<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;222&quot;}\" data-sheets-formula=\"=ArrayFormula(R[0]C[-3]:C[-3]&amp;R[0]C[-2]:C[-2]&amp;R[0]C[-1]:C[-1]) \">222<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:100515227.155676}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">100515227.1557<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-ischild=\"\">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43587}\" data-sheets-numberformat=\"[null,5,&quot;M\/d\/yyyy&quot;,1]\" data-sheets-ischild=\"\">5\/2\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43587}\" data-sheets-numberformat=\"{&quot;1&quot;:5}\" data-sheets-ischild=\"\">5\/2\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:368}\" data-sheets-ischild=\"\">368<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2297}\" data-sheets-numberformat=\"[null,4,&quot;#,##0.00[$ \u20ac]&quot;,1]\" data-sheets-ischild=\"\">2,297.00 \u20ac<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:0.002717391304347826}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">0.0027<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:65}\" data-sheets-ischild=\"\">65<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:64}\" data-sheets-ischild=\"\">64<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:178}\" data-sheets-ischild=\"\">178<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2}\" data-sheets-ischild=\"\">2<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2}\" data-sheets-ischild=\"\">2<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:3}\" data-sheets-ischild=\"\">3<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;223&quot;}\" data-sheets-ischild=\"\">223<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1006060326.15639}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">1006060326.1564<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-ischild=\"\">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43705}\" data-sheets-numberformat=\"[null,5,&quot;M\/d\/yyyy&quot;,1]\" data-sheets-ischild=\"\">8\/28\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43705}\" data-sheets-numberformat=\"{&quot;1&quot;:5}\" data-sheets-ischild=\"\">8\/28\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:250}\" data-sheets-ischild=\"\">250<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2916}\" data-sheets-numberformat=\"[null,4,&quot;#,##0.00[$ \u20ac]&quot;,1]\" data-sheets-ischild=\"\">2,916.00 \u20ac<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:0.004}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">0.0040<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:176}\" data-sheets-ischild=\"\">176<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:165}\" data-sheets-ischild=\"\">165<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:227}\" data-sheets-ischild=\"\">227<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:3}\" data-sheets-ischild=\"\">3<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:3}\" data-sheets-ischild=\"\">3<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:4}\" data-sheets-ischild=\"\">4<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;334&quot;}\" data-sheets-ischild=\"\">334<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1010126481.1552}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">1010126481.1552<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-ischild=\"\">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43560}\" data-sheets-numberformat=\"[null,5,&quot;M\/d\/yyyy&quot;,1]\" data-sheets-ischild=\"\">4\/5\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43560}\" data-sheets-numberformat=\"{&quot;1&quot;:5}\" data-sheets-ischild=\"\">4\/5\/2019<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:395}\" data-sheets-ischild=\"\">395<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:2308}\" data-sheets-numberformat=\"[null,4,&quot;#,##0.00[$ \u20ac]&quot;,1]\" data-sheets-ischild=\"\">2,308.00 \u20ac<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:0.002531645569620253}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">0.0025<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:34}\" data-sheets-ischild=\"\">34<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:33}\" data-sheets-ischild=\"\">33<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:179}\" data-sheets-ischild=\"\">179<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-ischild=\"\">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-ischild=\"\">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:3}\" data-sheets-ischild=\"\">3<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;113&quot;}\" data-sheets-ischild=\"\">113<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:101406401.157123}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">101406401.1571<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\" data-sheets-ischild=\"\">1<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43910}\" data-sheets-numberformat=\"[null,5,&quot;M\/d\/yyyy&quot;,1]\" data-sheets-ischild=\"\">3\/20\/2020<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:43910}\" data-sheets-numberformat=\"{&quot;1&quot;:5}\" data-sheets-ischild=\"\">3\/20\/2020<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:45}\" data-sheets-ischild=\"\">45<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:4590}\" data-sheets-numberformat=\"[null,4,&quot;#,##0.00[$ \u20ac]&quot;,1]\" data-sheets-ischild=\"\">4,590.00 \u20ac<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:0.022222222222222223}\" data-sheets-numberformat=\"[null,2,&quot;0.0000&quot;,1]\" data-sheets-ischild=\"\">0.0222<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:299}\" data-sheets-ischild=\"\">299<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:293}\" data-sheets-ischild=\"\">293<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:281}\" data-sheets-ischild=\"\">281<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:5}\" data-sheets-ischild=\"\">5<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:5}\" data-sheets-ischild=\"\">5<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:5}\" data-sheets-ischild=\"\">5<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;555&quot;}\" data-sheets-ischild=\"\">555<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>Z\u00e1kazn\u00edci, ktor\u00ed si u v\u00e1s ned\u00e1vno nak\u00fapili, s\u00fa \u010dast\u00fdmi kupuj\u00facimi a\u00a0 min\u00fa u v\u00e1s ve\u013ea pe\u0148az\u00ed, dostan\u00fa sk\u00f3re 555 &#8211; Recency (R) &#8211; 5, Frequency (F) &#8211; 5, Monetary (M) &#8211; 5. S\u00fa to va\u0161i najlep\u0161\u00ed z\u00e1kazn\u00edci.<\/p>\n<p><span style=\"font-weight: 400;\">Na druhej strane, z\u00e1kazn\u00edci utratia najmenej, takmer v\u00f4bec nenakupuj\u00fa a ich posledn\u00fd n\u00e1kup bol naozaj d\u00e1vno dostan\u00fa sk\u00f3re 111. Recency (R) &#8211; 1, Frekvencia (F) &#8211; 1, Monetary(M) &#8211; 1.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To d\u00e1va zmysel, v\u0161ak?<\/span><\/p>\n<h2><span id=\"Zoskupenie_zakaznikov_do_segmentov\"><span style=\"font-weight: 400;\">Zoskupenie z\u00e1kazn\u00edkov do segmentov<\/span><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">R, F a M maj\u00fa sk\u00f3re od 1 do 5, tak\u017ee existuje celkom 5 x 5 x 5 = 125 kombin\u00e1ci\u00ed hodnoty RFM. Keby ste sa mali pozrie\u0165, ko\u013eko z\u00e1kazn\u00edkov m\u00e1te pre ka\u017ed\u00fa hodnotu RFM, museli by ste sa pozrie\u0165 na 125 samostatn\u00fdch segmentov.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ma\u0165 takto granulovan\u00e9 d\u00e1ta nemus\u00ed, pre mnoh\u00e9 firmy, d\u00e1va\u0165 zmysel, a preto si m\u00f4\u017eete zhrn\u00fa\u0165 anal\u00fdzu do 11 segmentov, aby ste lep\u0161ie porozumeli va\u0161im z\u00e1kazn\u00edkom. Tieto segmenty som\u00a0 spom\u00ednal u\u017e na za\u010diatku tohto \u010dl\u00e1nku.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tu je tabu\u013eka, ktor\u00e1 vysvet\u013euje, ako m\u00f4\u017eete na z\u00e1klade sk\u00f3re RFM vytvori\u0165 11 segmentov.<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Segment<\/b><\/td>\n<td><b>Scores<\/b><\/td>\n<\/tr>\n<tr>\n<td><b><i>VIP (Champions)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">555, 554, 544, 545, 454, 455, 445<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>Loj\u00e1lni z\u00e1kazn\u00edci (Loyal Customers)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">543, 444, 435, 355, 354, 345, 344, 335<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>Potenci\u00e1lni loj\u00e1ln\u00ed (Potential Loyalist)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">553, 551,552, 541, 542, 533, 532, 531, 452, 451, 442, 441, 431, 453, 433, 432, 423, 353, 352, 351, 342, 341, 333, 323<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>Nov\u00ed z\u00e1kazn\u00edci (New Customers)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">512, 511, 422, 421, 412, 411, 311<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>S\u013eubn\u00ed (Promising)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">525, 524, 523, 522, 521, 515, 514, 513, 425, 424, 413,414, 415, 315, 314, 313<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>Z\u00e1kazn\u00edci, ktor\u00ed potrebuj\u00fa pozornos\u0165 (Customers Needing Attention)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">535, 534, 443, 434, 343, 334, 325, 324<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>Pripraven\u00ed zaspa\u0165 (About To Sleep)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">331, 321, 312, 221, 213<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>V riziku (At Risk)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">255, 254, 245, 244, 253, 252, 243, 242, 235, 234, 225, 224, 153, 152, 145, 143, 142, 135, 134, 133, 125, 124<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>Nem\u00f4\u017eeme ich strati\u0165 (Can\u2019t Lose Them)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">155, 154, 144, 214,215,115, 114, 113<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>Hibernuj\u00faci\u00a0 (Hibernating)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">332, 322, 231, 241, 251, 233, 232, 223, 222, 132, 123, 122, 212, 211<\/span><\/td>\n<\/tr>\n<tr>\n<td><b><i>Straten\u00ed z\u00e1kazn\u00edci (Lost)<\/i><\/b><\/td>\n<td><span style=\"font-weight: 400;\">111, 112, 121, 131,141,151<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span id=\"Vizualizacia_vysledkov_RFM_analyzy\"><span style=\"font-weight: 400;\">Vizualiz\u00e1cia v\u00fdsledkov RFM anal\u00fdzy<\/span><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Grafick\u00e9 zn\u00e1zornenie v\u00e1m pom\u00f4\u017ee sa r\u00fdchlej\u0161ie a jednoduch\u0161ie zorientova\u0165 vo v\u00fdsledkoch RFM anal\u00fdzy. Pri vizualiz\u00e1ci\u00ed je vhodn\u00e9 pou\u017ei\u0165 jednoduch\u00e9 st\u013apcov\u00e9 grafy, ktor\u00e9 v\u00e1m uk\u00e1\u017eu distrib\u00faciu z\u00e1kazn\u00edkov v jednotliv\u00fdch segmentoch. M\u00f4\u017eete tie\u017e prida\u0165 priemern\u00e9 hodnoty RFM pre jednotliv\u00e9 segmenty, detailn\u00fd preh\u013ead pre ka\u017ed\u00e9ho z\u00e1kazn\u00edka a jednotliv\u00e9 odpor\u00fa\u010dania pre segmenty.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Pozrite si ako m\u00f4\u017ee vyzera\u0165 vizualiz\u00e1cia RFM anal\u00fdzy v Data Studiu.<\/span><\/p>\n<p><strong><a href=\"https:\/\/datastudio.google.com\/embed\/reporting\/1i1CdwgZ93p-AxaOCNr2m7zq1BlpsY3eO\/page\/tDvNB\">Uk\u00e1\u017eka vizualiz\u00e1cie v\u00fdsledkov RFM anal\u00fdzy v Google Data Studiu<\/a><\/strong><\/p>\n<h1><span id=\"Odporucania_na_vyuzitie\"><span style=\"font-weight: 400;\">Odpor\u00fa\u010dania na vyu\u017eitie<\/span><\/span><\/h1>\n<p><span style=\"font-weight: 400;\">Ak v\u00e1s zauj\u00edma odkia\u013e k v\u00e1m chod\u00ed najviac VIP z\u00e1kazn\u00edkov, m\u00f4\u017eete si v\u00fdsledky anal\u00fdzy nahra\u0165 do Google Analytics pomocou importu \u00fadajov. N\u00e1sledne viete na t\u00fdchto z\u00e1kazn\u00edkov cieli\u0165 reklamu na mieru a s vysokou pravdepodobnos\u0165ou zn\u00ed\u017ei\u0165 n\u00e1klady a zv\u00fd\u0161i\u0165 n\u00e1vratnos\u0165.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ak ste k RFM anal\u00fdze pou\u017eili emaily. M\u00f4\u017eete tieto emaily importova\u0165 do reklamnej platformy a zacieli\u0165 na pou\u017e\u00edvate\u013eov, ktor\u00ed s\u00fa podobn\u00ed va\u0161im VIP z\u00e1kazn\u00edkom alebo naopak vyl\u00fa\u010di\u0165 z reklamy z\u00e1kazn\u00edkov, ktor\u00ed patria do segmentu straten\u00fdch.\u00a0<\/span><\/p>\n<h1><span id=\"Zaver\"><span style=\"font-weight: 400;\">Z\u00e1ver<\/span><\/span><\/h1>\n<p><span style=\"font-weight: 400;\">Pre\u010d\u00edta\u0165 si \u010dl\u00e1nok je pekn\u00e9, no je d\u00f4le\u017eit\u00e9 aby ste t\u00fato anal\u00fdzu a jej v\u00fdsledky vyu\u017eili aj v praxi.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Prihl\u00e1ste sa na newsletter a za\u0161leme v\u00e1m podrobn\u00e9 odpor\u00fa\u010dania ako importova\u0165 e-mailov\u00e9 adresy do reklamn\u00fdch platforiem ako Google Ads, Facebook Ads, Linkedin Ads alebo Twitter Ads.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ak sa v\u00e1m \u010dl\u00e1nok p\u00e1\u010dil, budem r\u00e1d ak ho budete zdie\u013ea\u0165 so svojimi kolegami a s priate\u013emi.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>RFM (Recency, Frequency, Monetary) anal\u00fdza je jednoduch\u00fd sp\u00f4sob ako rozdeli\u0165 z\u00e1kazn\u00edkov do segmentov na z\u00e1klade ich n\u00e1kupn\u00e9ho spr\u00e1vania&#8230;.<\/p>\n","protected":false},"author":69,"featured_media":15963,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[640],"tags":[603,642,643,777,775,776],"_links":{"self":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/15927"}],"collection":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/users\/69"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/comments?post=15927"}],"version-history":[{"count":52,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/15927\/revisions"}],"predecessor-version":[{"id":18920,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/15927\/revisions\/18920"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/media\/15963"}],"wp:attachment":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/media?parent=15927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/categories?post=15927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/tags?post=15927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}