{"id":9671,"date":"2018-07-02T09:00:15","date_gmt":"2018-07-02T07:00:15","guid":{"rendered":"http:\/\/passodue.flywheelsites.com\/2018\/07\/02\/data-analysis\/"},"modified":"2020-12-09T14:47:17","modified_gmt":"2020-12-09T13:47:17","slug":"data-analysis","status":"publish","type":"post","link":"https:\/\/diariodiunconsulente.it\/en\/2018\/07\/02\/data-analysis\/","title":{"rendered":"Do you think it, or do you know it? The data analysis underlying marketing choices"},"content":{"rendered":"<p><span style=\"font-size: 18px;\">di <a href=\"\/en\/passodue\/\">Alberto Aleo<\/a><\/span><\/p>\n<p><span style=\"font-size: 18px;\">In our experience as consultants we see many companies operating in many different sectors, but despite this great variety, most of them suffer from the same recurring problem: a lack of <strong>data analysis<\/strong> to support strategic and operational choices.<\/span><\/p>\n<h3 style=\"text-align: left;\"><span style=\"font-size: 18px;\"><strong>&#8211; &#8211; &#8211;<\/strong><\/span><br \/>\n<span style=\"font-size: 21px;\"><em><strong>Data analysis<\/strong> lies at the basis of many company activities. <strong>Marketing<\/strong>, especially, is closely connected to statistics and measurable information; so close, in fact, that it could hardly exist without them.<\/em><\/span><strong><br \/>\n<span style=\"font-size: 18px;\">&#8211; &#8211; &#8211;<\/span><\/strong><\/h3>\n<figure id=\"attachment_11987\" aria-describedby=\"caption-attachment-11987\" style=\"width: 2000px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11987 size-full\" title=\"Data analysis\" src=\"https:\/\/diariodiunconsulente.it\/wp-content\/uploads\/2020\/12\/rawpixel-586687-unsplash.jpg\" alt=\"Data analysis\" width=\"2000\" height=\"1334\" \/><figcaption id=\"caption-attachment-11987\" class=\"wp-caption-text\"><span style=\"font-size: 13px;\">Photo by <a href=\"https:\/\/unsplash.com\/@rawpixel\" target=\"_blank\" rel=\"noopener noreferrer\">rawpixel<\/a> on Unsplash<\/span><\/figcaption><\/figure>\n<p><span style=\"font-size: 18px;\">The lack of <strong>data analysis<\/strong> that afflicts many of our companies is often engendered by a certain presumption or a misplaced creative flair. I\u2019ll try to explain better: even today some sales executives, when asked to provide data on sales or a forecast of turnover, respond: <span class=\"text-highlight\">&#8220;What\u2019s the point? I know my clients well and I know what the market wants!&#8221;.<\/span> The same happens with certain entrepreneurs who turnup their noses when presented with a <strong>profile of the target <\/strong>or data on the effectiveness of communication tools (for which they pay a lot of money every year), their typical response being, &#8220;If we had to rely on figures before making any decision we would not go far \u2013 even Steve Jobs said that <a href=\"\/en\/2018\/04\/30\/segmentation-changing-consumers\/\"><strong>marketing analysis<\/strong><\/a> is useless!&#8221;.<\/span><\/p>\n<p><span style=\"font-size: 18px;\">In these cases, <strong>sales<\/strong> is seen as an activity that requires you to \u2018go with your gut\u2019, with no specific expertise behind it, and <strong>marketing<\/strong> is perceived as an \u2018artistic\u2019 activity that should leave you free to create, with few constraints. Obviously, we are oversimplifying a more complex reality that, however, increasingly reflects reality.<\/span><\/p>\n<p><span style=\"font-size: 18px;\"><a href=\"https:\/\/www.unibo.it\/sitoweb\/riccardo.silvi\">Riccardo Silvi<\/a>, professor of performance measurement systems at the University of Bologna, frequently asks his students questions, looking for possible solutions to business problems. When they answer he then asks: &#8220;<em>Do you think it, or do you know it?&#8221;.<\/em>\u00a0<span class=\"text-highlight\">This question forces them to question whether their <strong>opinions<\/strong> are based on knowledge or personal feelings,<\/span> inviting them to adopt a rational, analytical approach based on elements and <strong>analysis of context data<\/strong>. We, too, every day in our work, should try to answer Professor Silvi&#8217;s question.<\/span><\/p>\n<figure id=\"attachment_11990\" aria-describedby=\"caption-attachment-11990\" style=\"width: 2000px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11990 size-full\" title=\"Analytics\" src=\"https:\/\/diariodiunconsulente.it\/wp-content\/uploads\/2020\/12\/jessica-ruscello-196422-unsplash.jpg\" alt=\"Analytics\" width=\"2000\" height=\"1333\" \/><figcaption id=\"caption-attachment-11990\" class=\"wp-caption-text\"><span style=\"font-size: 13px;\">Photo by <a href=\"https:\/\/unsplash.com\/@sharonmccutcheon\" target=\"_blank\" rel=\"noopener noreferrer\">Sharon McCutcheon<\/a> on Unsplash<\/span><\/figcaption><\/figure>\n<h3 style=\"text-align: left;\"><span style=\"font-size: 18px;\"><strong>&#8211; &#8211; &#8211;<\/strong><\/span><br \/>\n<span style=\"font-size: 21px;\"><em>Indeed, it is precisely in choosing what to observe, and in how to cross-check the data arising from this observation, that we express much of our \u2018strategic talent\u2019.<\/em><\/span><strong><br \/>\n<span style=\"font-size: 18px;\">&#8211; &#8211; &#8211;<\/span><\/strong><\/h3>\n<p><span style=\"font-size: 18px;\">Yet very few companies carry out, for example, a serious analysis of their customer portfolio.<\/span><\/p>\n<p><span style=\"font-size: 18px;\">Identifying customer segments will allow us, among other things, to study payment methods and credit risk as the characteristics of the <strong>target<\/strong> change. This is how many companies discover that the famous 20% of customers that generate 80% of turnover (the ones that should represent the \u2018hard core\u2019 of their business) are, in fact, a \u2018time bomb\u2019 ready to go off at any moment. We also receive information that is fundamental to calibrate sales arguments: we might discover that entire customer segments are much less sensitive to price leverage than other characteristics of the product or service. I personally believe that the minimum database available, should be as follows:<\/span><\/p>\n<ul>\n<li><span style=\"font-size: 18px;\"><strong>Analysis of sales trend data,<\/strong> not only the general turnover but also margins and payments. Obviously, searchable by product, commercial area, customer;<\/span><\/li>\n<li><span style=\"font-size: 18px;\"><strong>Analysis of general market data<\/strong> with (if possible) identification of our penetration rate and that of our main competitors (for the calculation of the share, take a look at the post \u2018<a href=\"\/en\/2018\/02\/26\/calculating-market-share\/\">Mission Impossible: calculating the market share when there are no data<\/a>\u2019);<\/span><\/li>\n<li><span style=\"font-size: 18px;\"><strong>Comparison analysis with the competition<\/strong>, crossing the characteristics of the entire supply system (hence, not only products, but also services, communication and everything that constitutes the company \u2018output\u2019) with the market share to better identify which choices have been rewarded by customers;<\/span><\/li>\n<li><span style=\"font-size: 18px;\"><strong>ABC analysis of customers<\/strong> (the one we talked about in the post mentioned at the beginning of this article);<\/span><\/li>\n<li><span style=\"font-size: 18px;\"><strong>Verification of the company&#8217;s performance<\/strong>, with a specific focus on the commercial activity that shows, for example, visits to customers, the estimates generated and their percentage of closure as well as the number, frequency and average amount of purchases. We should also check how many new customers are entering our portfolio.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 18px;\">Finding all this information is not always easy, but I assure you that in many cases all you need is an Excel spreadsheet and a little good will: <span class=\"text-highlight\">you will be amazed at how much information and how many new ideas you will get from this work!<\/span> Observing is a \u2018creative\u2019 act not only because it prompts new ideas, but also because &#8211; in a certain sense &#8211; it changes the object of our observation.<\/span><\/p>\n<figure id=\"attachment_11993\" aria-describedby=\"caption-attachment-11993\" style=\"width: 2000px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11993 size-full\" title=\"ask information\" src=\"https:\/\/diariodiunconsulente.it\/wp-content\/uploads\/2020\/12\/carl-heyerdahl-181868-unsplash.jpg\" alt=\"ask information\" width=\"2000\" height=\"1333\" \/><figcaption id=\"caption-attachment-11993\" class=\"wp-caption-text\">Photo by <a href=\"https:\/\/unsplash.com\/@carlheyerdahl\" target=\"_blank\" rel=\"noopener noreferrer\">Carl Heyerdahl<\/a> on Unsplash<\/figcaption><\/figure>\n<p><span style=\"font-size: 18px;\">Just as in quantum physics, even in sales the act of <strong>observing <a href=\"\/en\/2016\/10\/17\/new-business\/\">customers<\/a><\/strong> carefully, of asking them the right questions and pinpointing their needs with greater precision, changes our relationship with them, thereby increasing our commercial performance.<\/span><\/p>\n<p><span class=\"text-highlight\" style=\"font-size: 18px;\">It is a virtuous circle that must be triggered as soon as possible!<\/span><\/p>\n<p><span style=\"font-size: 18px;\">We leave you with an exercise that will help you reflect on today&#8217;s topic and which is, once again, inspired by Professor Silvi&#8217;s lectures. Imagine taking a photo of your <strong>typical customer<\/strong> and then trying to describe their characteristics, their styles of consumption, the history of the relationship that binds you together and so on. How many of the things you are describing are supported by data and how much is \u2018what you think\u2019? Have you ever verified all this by checking the figures?<\/span><\/p>\n<pre>| partem claram semper aspice |<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>di Alberto Aleo In our experience as consultants we see many companies operating in many different sectors, but despite this great variety, most of them suffer from the same recurring problem: a lack of data analysis to support strategic and operational choices. &#8211; &#8211; &#8211; Data analysis lies at the basis of many company activities.&hellip;<\/p>\n","protected":false},"author":295,"featured_media":9672,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[92,85],"tags":[260,233,231,263],"class_list":["post-9671","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-best-of-marketing-2","category-abilities","tag-business-2","tag-customer","tag-marketing-en","tag-marketing-advise","entry","has-media"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v15.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>The data analysis underlying marketing choices - Diario di un Consulente<\/title>\n<meta name=\"description\" content=\"How to analyze data usefully in order to choose marketing strategies based on facts and not on opinions? With the analysis of marketing data.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/diariodiunconsulente.it\/en\/2018\/07\/02\/data-analysis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The data analysis underlying marketing choices - Diario di un Consulente\" \/>\n<meta property=\"og:description\" content=\"How to analyze data usefully in order to choose marketing strategies based on facts and not on opinions? With the analysis of marketing data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/diariodiunconsulente.it\/en\/2018\/07\/02\/data-analysis\/\" \/>\n<meta property=\"og:site_name\" content=\"Passodue\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/passodue\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-02T07:00:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-09T13:47:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/diariodiunconsulente.it\/wp-content\/uploads\/2020\/12\/freddie-marriage-264214-unsplash-copia.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"690\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@passodue\" \/>\n<meta name=\"twitter:site\" content=\"@passodue\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/#organization\",\"name\":\"Passodue\",\"url\":\"https:\/\/diariodiunconsulente.it\/en\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/passodue\",\"https:\/\/www.instagram.com\/passodue\/\",\"https:\/\/www.linkedin.com\/company-beta\/10017842\/\",\"https:\/\/www.youtube.com\/channel\/UCbxyw6anbCWhBzUaNayFTMA\",\"https:\/\/twitter.com\/passodue\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/diariodiunconsulente.it\/wp-content\/uploads\/2020\/09\/Passodue.png\",\"width\":401,\"height\":112,\"caption\":\"Passodue\"},\"image\":{\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/#website\",\"url\":\"https:\/\/diariodiunconsulente.it\/en\/\",\"name\":\"Passodue\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/diariodiunconsulente.it\/en\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/2018\/07\/02\/data-analysis\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/diariodiunconsulente.it\/wp-content\/uploads\/2020\/12\/freddie-marriage-264214-unsplash-copia.jpg\",\"width\":1920,\"height\":690,\"caption\":\"Photo by freddie marriage on Unsplash\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/2018\/07\/02\/data-analysis\/#webpage\",\"url\":\"https:\/\/diariodiunconsulente.it\/en\/2018\/07\/02\/data-analysis\/\",\"name\":\"The data analysis underlying marketing choices - Diario di un Consulente\",\"isPartOf\":{\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/2018\/07\/02\/data-analysis\/#primaryimage\"},\"datePublished\":\"2018-07-02T07:00:15+00:00\",\"dateModified\":\"2020-12-09T13:47:17+00:00\",\"description\":\"How to analyze data usefully in order to choose marketing strategies based on facts and not on opinions? With the analysis of marketing data.\",\"breadcrumb\":{\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/2018\/07\/02\/data-analysis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/diariodiunconsulente.it\/en\/2018\/07\/02\/data-analysis\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/2018\/07\/02\/data-analysis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/\",\"url\":\"https:\/\/diariodiunconsulente.it\/en\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/2018\/07\/02\/data-analysis\/\",\"url\":\"https:\/\/diariodiunconsulente.it\/en\/2018\/07\/02\/data-analysis\/\",\"name\":\"Do you think it, or do you know&hellip;\"}}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/2018\/07\/02\/data-analysis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/2018\/07\/02\/data-analysis\/#webpage\"},\"author\":{\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/#\/schema\/person\/bedd532bcdb7b6f68b1b4bd5928d953f\"},\"headline\":\"Do you think it, or do you know it? The data analysis underlying marketing choices\",\"datePublished\":\"2018-07-02T07:00:15+00:00\",\"dateModified\":\"2020-12-09T13:47:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/2018\/07\/02\/data-analysis\/#webpage\"},\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/2018\/07\/02\/data-analysis\/#primaryimage\"},\"keywords\":\"business,customer,marketing,marketing advise\",\"articleSection\":\"Ethical marketing,Professional abilities\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/diariodiunconsulente.it\/en\/2018\/07\/02\/data-analysis\/#respond\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/#\/schema\/person\/bedd532bcdb7b6f68b1b4bd5928d953f\",\"name\":\"Alberto Aleo\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/diariodiunconsulente.it\/en\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7d28a64414ff44a1afcc034ef396492b00f974709aa67e492e6316c8b7b5881f?s=96&d=mm&r=g\",\"caption\":\"Alberto Aleo\"},\"description\":\"Un percorso accademico non convenzionale insieme ad una carriera manageriale che \\u00e8 durata pi\\u00f9 di un decennio nel ruolo di responsabile marketing e di direttore vendite per note aziende italiane, mi hanno trasformato in un \\u201carchitetto\\u201d di strategie di mercato. Nel 2011 ho fondato insieme a mia moglie Alice lo studio di consulenza e formazione Passodue il che mi ha permesso di poter mettere a disposizione dei clienti un bagaglio di esperienze e conoscenze molto vario, che spazia dall\\u2019economia, al marketing, alla gestione di reti commerciali.\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/diariodiunconsulente.it\/wp-content\/uploads\/2020\/12\/freddie-marriage-264214-unsplash-copia.jpg","_links":{"self":[{"href":"https:\/\/diariodiunconsulente.it\/en\/wp-json\/wp\/v2\/posts\/9671","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/diariodiunconsulente.it\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/diariodiunconsulente.it\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/diariodiunconsulente.it\/en\/wp-json\/wp\/v2\/users\/295"}],"replies":[{"embeddable":true,"href":"https:\/\/diariodiunconsulente.it\/en\/wp-json\/wp\/v2\/comments?post=9671"}],"version-history":[{"count":0,"href":"https:\/\/diariodiunconsulente.it\/en\/wp-json\/wp\/v2\/posts\/9671\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/diariodiunconsulente.it\/en\/wp-json\/wp\/v2\/media\/9672"}],"wp:attachment":[{"href":"https:\/\/diariodiunconsulente.it\/en\/wp-json\/wp\/v2\/media?parent=9671"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/diariodiunconsulente.it\/en\/wp-json\/wp\/v2\/categories?post=9671"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/diariodiunconsulente.it\/en\/wp-json\/wp\/v2\/tags?post=9671"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}