25 Eylül 2021 Cumartesi

CRM Road Map Preparation-1

The CRM Road Map Planning phase (we call as Phase Zero) is the most important phase of the entire project. If started incorrectly, time and costs increase.

CRM projects consist of many stages and the most important stage is planning [2]. During the preparation of the Road Map [3], careful and intensive work is required. In this period, intensive efforts in the right direction affect the success of the CRM project positively. It provides a shorter and more efficient application.

Some companies want to start the project as soon as possible and present something to the boss. However, when starting out without good planning, the chance of success in the medium and/or long term is negligible. In fact, the time spent preparing the Road Plan prevents unnecessary time wasted in the later stages of the project, going back and starting many times later.

In this article, we will discuss the principles of road map planning.

As in every industry or every company or every project, the road map planning in CRM is the result of investigation:

  • What do we want to be in the future?
  • How are we now?
  • What is the difference?

The preparation process starts with the definition of the ideal environment to be seen after the CRM project.

Important note: Here, when we say ideal, we mean the affordable & applicable ideal, which we call “reasonable ideal“, not an ideal in which technologies that are not common or expensive today are used.

In other words first of all, where you want to be in the future is determined. Management is asked what they want to know, do or learn. Thus, concepts that are thought to be marketing jargon (or CRM bull shit) are made concrete.

We ask a question to the managers working at various levels of the departments that come into direct contact (such as sales team, branch / dealer / agency employees, service stations, repair maintenance team, call center employees) or indirect contact (such as operations, collections, loans, logistics) with customers: “If everything went as desired, at the end of the CRM project what questions would you like answered?”

Often the following questions are encountered:

For financial services:

  • Which of my clients are likely to take their account balance to another bank?
  • What are the profiles of my most and least profitable customers?
  • What is the risk associated with loan applicants?
  • What is the profile of low-risk and high-risk customers?
  • Who is more at risk of default?
  • What are debt movements that indicate a possible bankruptcy?
  • What purchase transactions indicate credit card fraud?

For the public sectors:

  • What actions can be associated with taxes, benefits, contraband drugs, and other illegal acts?
  • What kind of people, which means of transportation, material are indicative of possible illegal movements?
  • Which military personnel would be the better leader in war conditions?
  • What methods are helpful in monitoring stock market movements?
  • What are the indicators of violations in investment transactions?
  • What indicators reveal money laundering cases?

For telecommunications:

  • Which customers are likely to leave the Firm or move to another Firm?
  • Which are the most and least profitable customers?
  • What products and services should be offered to potential customers?
  • What is the customer profile that defines frequent card users?
  • What usage patterns indicate fraud?

For tourism:

  • Which of my customers are likely to travel with another company?
  • What are the profiles of my most and least profitable customers?

For insurance agents:

  • Why was my offer not accepted? (Relationship or price?)
  • Will my other jobs be affected because I lose this job?
  • What other jobs can I get for my current client?

For companies in every industry:

  • Which product/service groups sell better to which customers?
  • How do I understand my client’s life stage or lifestyle changes?
  • Which customer profiles are the most promising for which campaign?
  • Who are the customers who are most likely to respond positively to the presented offer?
  • Which proposals are most likely to receive a positive response?
  • How should existing and prospective customers be segmented for maximum profitability?
  • What are the customer characteristics that will generate high lifetime revenue?
  • How often and when should customers be approached?
  • What are the cheapest but most efficient ways to acquire new customers?
  • Where can we find the most efficient customer segments?
  • Which customers am I likely to lose?

Apart from these questions that indicate the needs of the institution or company, the needs and expectations of various departments should also be specified.

Expectations of Marketing Departments:

  • To save on promotional expenses by not offering products that it will not use;
  • Predict future yields (life time value) of customers;
  • To identify the customers that can be profitable and the segments where this customer potential exists;
  • To determine which products are more suitable for “cross-selling” with which other products;
  • Studying or weeding out how we can make profitable customers with negative or zero profitability;
  • To be able to see whether the customers that dealers, branches and agencies call “profitable” are really profitable;

Expectations of Operation Departments:

  • To receive the most up-to-date data when the existing customer has a new request,
  • To be able to meet the new product demand of the existing customer at the first contact point (branch, call center or internet) thanks to the decision mechanisms embedded in the system,
  • Being able to determine whether it is worth losing or risking if “not a good customer”;

At Customer Touch Points

  • Respond quickly to customer demands
  • Seeing the necessary customer data on the screen immediately, reaching the next ones quickly,
  • To see the latest status of the customer on the screen,
  • Not having to fill out the form again when the existing customer has a new service request,
  • To be able to meet the new demand of the existing customer at the first contact point,
  • Being able to enter the changed data into the system immediately,
  • For various products, entering various systems and not waiting,


Don’t think that there are so few questions that need to be drilled down to the finest detail, thus revealing your data and process needs. You must have at least 100 – 120 questions or need statements.

Managers who voice these questions and expectations are assumed to know their job better than the CRM project Leader or Consultant.

For each of their questions or expectations, it proceeds with further question-answers focusing on the details. The answers received are questioned down to the smallest detail. Every answer becomes a question again. It is desirable to exemplify with real events or to explain with scenarios. It is continued in this way until a significant part of the data and process needs required for the company to achieve its ideal environment.

Now, the necessary information, data and process needs for the road plan have been determined. After that, the preparation of a consistent road map planning for the CRM project that will meet the expectations of the departments and the company may start.


Additional Materials to read


24 Eylül 2021 Cuma

Operational Definition of the Customer

The purpose of this assignment is to make a “functional” definiton of customer

The definition of the customer should enable to answer the following specific questions like

  • How many active customers do we have?
  • How many customers we are about to lose?

Definition should enable to extract the accurate customers list – such as following examples –  from customer database via queries

  • We have 3689 active customers.
  • If they (the customers) do not make this (any defined) transaction or not show up for more than 3 weeks (or months or years) we will lose 231 customers

Please notice that, in this assignment, our purpose is not to define the “target audience” of advertising agencies, but a FUNCTIONAL “measurable / operational” definition of customer for the selected sector.

In other words, I expect a measurable and comparable definition of customer such as

  • The person who buys gasoline from our station at least twice a month is our customer. However  the person who buys time to time from us while passing close to our station and stop by chance is not going to be considered our customer.

The customer should be defined in such a way after querying from data warehouse the following groups of customers can be identified.

  • Active customer
  • Inactive customer
  • Lost customer

Thus, you can distinguish between valuable customers from the rest of the customers. These functional definitions are also essential if the purpose is to regain the lost customer. For example; by utilizing the measurable definition of the customer, when the customers who formerly defined as active customer became inactive customers it will be easy to identify those inactive customer and the target who are intended to be regained can be clearly identified.

Important note: Those definitions should be “mutually exclusive and collectively exhaustive”. It means, their union must cover all the events, but no more than one event can occur at a given time. Just like puzzle, all pieces together form the complete picture and any of the pieces are not overlapping.

Once someone became a customer, she/he (on an institution) is either active or inactive or lost customer or some other cluster (such as pass through customer) . An area between them should not exist.

Please watch the following funny video to see how operational definition is important.  https://www.youtube.com/watch?v=cDA3_5982h8

24 Eylül 2021 Cuma

Standart ve Sürdürülebilirlik

İstanbul Bilgi Üniversitesi MBA programının değerli katılımcılarından Kübra Engin, Linkedin’de önemli bir paylaşımda bulunmuş.

Bugün de güzel bir gelişmenin haberini aldık.
Her geçen gün giderek artan elektronik cihaz kullanımıyla birlikte, çekmelerimizde fazladan fazladan biriken şarj kablolarına artık bir standart getiriliyor. Şarj bağlantıları standart hale getirilecek ve USB-C bağlantı olacak. Hem üretimden hem de imha/bertarafından oluşan ekonomik kaybın ve çevresel zararın önüne geçilmesinin yanı sıra kullanıcılar için de büyük kolaylık olacak. Ayrıca şarj aletlerinin, elektronik aletlerden ayrı olarak satışı gerçekleşecek.

Sevgili Kübra Engin’in özetlediği Avrupa Komisyonu haberinin aslı şurada.

Resim, evdeki şarj kabloları

Avrupa Komisyonunun bu kararı çok önemli bir gelişme.

Her yeni PC veya telefon modelinin şarj girişlerinin farklılaştırılması, böylece daha fazla “aksesuar” satışının zorunlu olması engellenmeliydi.
Zaten bu “her seferinde değişiklik yaparak daha fazla tüketim özendirme“nin sanayi devrimi kavramı olduğunu ve teknoloji şirketlerine yakışmadığını nicedir söylüyordum.

Girişimcilerin Bilişim Dönemine uyum sağlaması konusundaki – 8 yıl önceki – şu yazımda

Bilişimle uğraşsalar bile, Sanayi Dönemi kültüründeki Gates, Jobs, Brandon örneklerinden öte gidemeyen Türk girişimcisi misiniz; yoksa bilişim dönemini yakalamış biri mi?

cümleme takılan yorumcuya verdiğim şu yanıtta

Apple shop’da, 2 önceki modelin şarj cihazını sorduğumda “Onu çöpe atın ve yenisini alın diye üretmiyoruz” diyorsa, her Apple markalı cihazın şarj ünitesi birbirinden farklıysa sizce Bilişim Dönemi mantığında mıdır?

Tekrarlıyorum, para kazanma biçimi Sanayi veya Bilişim Döneminde olduğunu belirliyor. Yaptıkları bağışları konuşursak, “çalıyor ama yol yapıyor” noktasına geliriz. Sanayi Dönemi’nin örneklerini aklıyor gibi de görünebiliriz.


Sevgili Kübra Engin şöyle yazmış:

Teknoloji şirketlerine yakışmadığı konusuna yüzde yüz katılıyorum. Tüketici olarak şarj aleti yüzünden yaşadığımız tatsız deneyimler de var.

Geçen hafta bilgisayarımın şarj aletini unutup şirkete gittim ve onlarca bilgisayar arasından şarjı benimkine uyan tek bir bilgisayar olmadığı için pilim bittikten sonra verimsiz (bilgisayarsız) geçen bir 3 saat yaşadım. Üstelik bir tanesi neredeyse birebir benimkiyle aynı model olmasına rağmen şarj girişi farklıydı 😅 .

Evlerde çekmeceleri dolduran tatsız kablo görüntüleri de cabası. Gereksiz olan finansal maliyeti ve çevresel zararı zaten ortada…

Dikkatinizi çekmek istiyorum: “neredeyse birebir benimkiyle aynı model olmasına rağmen şarj girişi farklıydı” diyor.


Birkaç sene önceye kadar Samsung’un tüm ürünleri birbirine uyan kablolarla bağlanabiliyordu. Cep telefonunun şarj kablosu Samsung fotoğraf makinesine de  uyumluydu. Cep telefonunu bilgisayara bağladığın kabloyla TV cihazını da bağlayabiliyordun. Sonra Samsung da bu akıma kapıldı ve -maalesef- sürekli kablo değişikliklerine başladı. Gözümde ciddi değer kaybına neden oldu.


Sizi bilişimin nimetlerinden yararlandırmak yerine, sürekli katma değersiz değişikliklerle tüketime ve kaynakların anlamsız kullanımına zorlayan kurumlar, bilişim satsalar bile Bilişim Dönemi değil Sanayi Dönemi kurumlarıdır.

İşte, sürdürülebilirlik konuşan tüm kurumlara sormamız gereken soru karşımızda…