An Introduction to Conversational Commerce and Bots

Blog post originally published on State of Digital as part of a monthly column.

Conversations.

These days, there is a lot of chatter about talking – and it’s not that surprising considering the forays in AI, machine learning and natural language processing have made interactions with technology more conversational, more human. Bots are now capable to think, but also view, speak, and listen. So businesses are discussing how they can, could, will, and should be using bots to drive more personalised conversational interfaces with their customers.

“By 2020, customers will manage 85% of their relationship with the enterprise without interacting with a human.” – Gartner Predicts

I already prefer to use an ATM at the bank and I go to the self-checkout when doing my groceries. It doesn’t seem like that far fetched to see how conversational bots can become an extension of a self-service interface to your brand across the platform and channel your customer choose.

Bing has already a few chatbots integrated directly into the search results page, creating new, deeper engagement with the brand right here where the customer intent is verbalised. As I was planning my latest trip to Seattle, I’ve found it pretty useful to interact via the bot to quickly discover the parking availability for the restaurant I was heading to and to make sure it offered gluten-free dishes for the colleague who was joining me:

What are bots and chatbots?

There is no difference. In the beginning bots were just pieces of software designed to automate specific tasks. Today, bots have evolved thanks to the accelerations of our capabilities in machine learning and natural language process to comprehend and engage in conversations. They are acting as an interface that can be plugged into APIs or various data sources to deliver information on demand and help drive conversational commerce. In many ways, they are a new paradigm to how we will consume the web information. We used to go to web pages, then to interact with apps… We are about to exchange with this new interface through natural language which will, in turn, retrieve the information we are after. We will stop browsing or tapping: we will start asking.

What’s the difference between bots and digital assistants?

A digital assistant like Cortana, Siri, Alexa or the Google Assistant is more advanced than a chatbot. Some call them “meta agents”. In addition to being able to parse conversational language like a chatbot they are also incorporate additional layers of artificial intelligence to help merge utility, productivity, entertainment and the ability to accomplish actions together to become an intelligent agent. It is both contextually and historically aware, which means that it can provide relevant information, proactive recommendations, tailored to your preferences and situation. As such, Cortana is a predictive and proactive agent that can, based on interactions, learn to interact with you, other people and bots.

What’s the difference between bots and skills?

What do you want to teach the digital assistant to do? A skill. A skill teaches the digital assistant how to do something or to take an action, based on a voice command. I might ask, “Hey Cortana, ask HUE to dim the kitchen lights” or “Hey Alexa, book a UBER in ten minutes!”,  “Hey Cortana, let OPENTABLE book a table for two at John Howie Steakhouse at 7pm.”

Conversational Commerce – Connecting the dots

When it first launched, Domino’s Pizza Bot was super simple. Simple but effective. Customers typed the word Pizza and it would place for their connected account an “Easy Order.” The bot wasn’t really conversational in nature, but it started with an easy-to-use feature which allowed Domino’s to get their foot in the connected kitchen door in order to test and learn. Currently, Domino’s has both a true conversational commerce chatbot and Amazon Alexa skills with increased capabilities. Although retaining their ambition for a simple consumer benefit, ordering a pizza, they have upped the AI complexity to allow users to build their order from scratch, but also to track an order or reorder their most recent order.

Let’s take a high lever look at getting started with bots and what you need to keep top of mind as you get started.

Tips for getting started with bots:

1. Plan
   1. Set goals and expectation for what it can do.
   2. Focus on interactions that mean the most to your customers
2. Start Simple:
   1. Focus on building a feature that works amazingly and will delight your customers.
   2. Don’t reveal all the features at once. It can overwhelm your customers.
   3. Integrate the features into the flow of the conversation where they make sense.
3. Develop your bot:
   1. Choose a frame, like the Microsoft bot framework that can help you scale across channels.
   2. Don’t try to launch across every channel at first. Take a test-and-learn approach and roll out features and channels.
4. Monitor bots closely:
   1. Mistakes are inevitable – Learn from them and fix any identified errors/mistakes often and quickly.
      1. Examine it: What questions did people ask that the bot wasn’t able to answer?
      2. Teach it: What words does the bot not understand? Does it not get that veggie is another term for vegetarian?
      3. Humanize it: Does the tone of your brand shine through? Make the experiences more engaging?
   2. Ask your customer for feedback, especially early on. Give your customers the option at the end of the session if they’d like to participate to help make the bot better!
   3. Learn from customer interactions and feedback.
   4. Generate smarter, more personalized interactions capitalizing on the growing number of cognitive services available
5. Iterate and Adapt. Rinse & Repeat.

Everyone loves a good conversation. Bots and skills are opening up ways to communicate directly and more conversationally with your customers – providing them a more natural experience. It also can give your business a deeper look into the customer experience – including their emotions and sense of urgency during the interactions. Bots and skills can help you provide more personalized experiences that create a more meaningful connection with your customers.

So, what if we’d stop chatting, and started coding?

Podcast: speaking with Movidiam on AI, Chatbots and Augmented Reality

I was recently invited to contribute to Movidiam's podcast and share my thoughts on the future of search, chat bots, Artificial Intelligence, the rise of Augmented Reality and their impact on marketing. If you regularly read this blog, you will be familiar with some of the concepts and principles that I am touching base on, but nonetheless you may be inclined to stop reading and start listening to my French accent:

Here is a link to that podcast.

The evolution of search through a modern consumer journey

Blog post originally published on State of Digital as part of a monthly column.

The IAB UK has just released their digital advertising spend report for 2016 and announced that digital advertising grew at its fastest rate for nine years – up 17.3% to £10.3 billion. The last time annual growth was higher was in 2007 (+38%), when Apple released the iPhone leading to the accelerated adoption of smartphones, the emergence of the app paradigm, etc. The reason I call out that historical reference is because I genuinely believe we are at an equivalently critical inflexion point with the rise of AI: it grew out of search and is about to transform marketing as a whole.

As a matter of fact, the historical powerhouse of the digital landscape, Search, has continued to grow by +15% to £4.99 billion, which reflects two major trends:

• First advertisers have (finally) realised that search plays a role throughout the customer decision journey and not just at the final conversion step
• Second, search is, in itself, evolving drastically to offer new capabilities and surfaces of engagement for advertisers to capture new intents, new behaviours, new usages

Following a modern consumer journey and its query paths

As disruptive technologies reshape the digital marketing landscape, brands are investing time and effort to remain relevant and top-of-mind with consumers. For years, search marketers have obsessed over bottom of the funnel activity for its seemingly higher CTRs and conversion rates, in part fuelled by last click attribution models. But most marketers today agree that it is essential for a brand to appear across all stages of the funnel to drive brand affinity and recall.

Research at Bing Ads now allows us to quantify and better understand the customers behind the clicks and where they stand on the customer decision journey (CDJ). Consumers tend to go through five distinct stages, which vary depending on the type of purchase: initiation, research, comparison, transaction and experience. Consumers are subject to these same five CDJ stages, although each step will vary in length and importance depending on the cost of failure, frequency, cost and complexity of the task, and the shopper type.

As consumers go through a given decision journey, search plays a pivotal role and different types of queries will be used throughout:

• Category searches: Include broad search terms that are not product or brand specific, such as shoes, running shoes, hiking shoes. These usually appear during the initiation, research and comparison stages but can also take part during transaction
• Tangential searches include queries that are related to a given journey, but not in the exact same category. For instance, if I am searching for running shoes, a tangential search could be about preparing for a half marathon, running training program or running equipment. These are similar to category searches in that they usually get searched on before a transaction
• Competitor brand searches: Include your competitors’ brands or products. This is an opportunity for your brand to appear through conquest advertising. For Nike, these terms could include Under Armour, Adidas, etc. As consumers get further along their decision journey they begin to hone in on their purchase and more specific searches occur
• Brand searches: Include a specific brand or product name. Nike is the brand and product searches could include Nike Pegasus or Nike Running shoes. Brand terms are often the best performing keywords helping drive the most transactions

Search drives awareness

Traditionally search has placed a premium on brand keywords. The Bing Ads research team has found new insights on the role of non-brand search terms within today’s journeys. Brand Impact Study on usage data from a major US auto retailer determined that 72% of brand ad clicks (which includes category, competitor and tangential searches) had a non-brand keyword precede the brand click. In other words, retailers who do not run non-brand keywords throughout multiple stages of decision journeys are missing out on a majority of relevant searches and leaving gaps for their competitors.

Additionally, consumers who are exposed to a brand ad on a category or competitor query were 30% more likely to do a branded search. On average they had a 15% higher conversion rate compared to consumers who were not exposed to the brand ad. Having a branded ad appear in category and competitor brand queries improved brand affinity and recall, and increased the propensity for future brand searches.

Another Bing Ads research completed in Q3 2016 with a leader in the automotive insurance vertical measured brand awareness and perception based on exposure to ads within the search results pages. The key learning from this study was that searchers on Bing who saw a branded ad for non-branded search queries showed a statistically significant increase in brand awareness, perception and purchase intent. After being exposed to a branded ad, searchers indicated a 24% lift in unaided awareness, 28% lift in purchase intent and a 30% lift in viewing the retailer as a market leader. Brand awareness further improved when searchers clicked through on the ad and were taken to the brand’s landing page. In the study, consumers who were merely exposed to an ad without clicking on it, self-reported as more likely to take an action or next step

Although search marketers have long assumed some level of brand awareness in search, it is the amount of brand awareness shown here that proves impressive and indicates the importance of staying present throughout each stage of a journey

Search informs and educates

As consumers go through the initiation phase of the consumer journey and begin to do more research and consider purchasing, search can help with the decision-making process.

A Forrester Consumer Technographics study called out that 60% of consumers will use a search engine to find the product they want and 61% will read product reviews before making a purchase. And one of the most trustworthy sources in this research and comparison phase is none other than search engines. Furthermore, consumers consistently rely on search engines, more than any other source, as a reliable place to research about brands, products, or services that they are considering buying. According to Forrester, 49% of consumers reported that they rely on search to inform purchase decisions, and 19% of respondents identified search engines as the most influential source in driving their decisions.

New search experiences, new marketing expectations

The evolution of the consumer behaviours outlined above and the reaction from marketers by investing throughout the different stages of the consumer journeys are a sign of maturation for a discipline that is merely 15 years old. And yet, new search experiences powered by AI are coming to the fore, and are likely to further disrupt the model.

It has been well documented that search is no longer just a search box on a webpage with a list of links. It is literally breaking out of the box; it is changing in some dramatic and exciting ways. Once a function that used to be limited to a text box on a specific site has slowly been integrated into more and more of the technologies/devices, apps and sites we use every day, from phones to gaming consoles. As such, Search becomes more pervasive, but also more personal and predictive.

Conversations as a Platform is a great embodiment of how the Future of Search makes sense of these 3P (personal, predictive and pervasive). The rise of messaging apps where consumers now spend most of their time and technological advancements in NLP, AI and machine learning are creating rupture that is similar to what we have seen in decades past with the App paradigm. Conversations as a platform unlock a more human, personal way to discover, search for, access and interact with information. This new platform will enable us to interact with devices more intuitively, using natural language conversations, evolving us from mechanical keyboard and mouse to touch and beyond.

Search will never again be a constrained to writing in a search box. Instead, search will be a partner that can listen and communicate in dialogue with a consumer on any platform and any device. Thanks to new, more natural interfaces, voice search is becoming increasingly possible and accurate. We imagine a rich ecosystem of conversations, ones that include: people to people, people to your personal digital assistant, people to bots, and even personal digital assistants calling on bots on your behalf. That’s the world that you’re going to get to see in the years to come.

We have already covered the current rise of voice search as a result of mobile search adoption, but it is likely to further accelerate as search becomes more pervasive and turns your TV Set, you fridge or your car into a search box. ComScore predicts that by 2020, over 40% of the queries will be voiced rather than typed. It is worth noting that these experiences are often screenless which further disrupt the preconceptions that too many marketers have when they think they have nailed their search strategy.

How do you optimise your web presence for voice search? How do you market to chatbots? How will we see consumer intent evolve in these new experiences? We already seeing that 16% of searches every month had never searched for before. We also see that 25% of the clicks on the Bing Network are from searches not happening on Google… So, the versatility of the above-mentioned consumer journey is likely to continue to increase. And what an exhilarating evolution it is!

Podcast - glancing at Advertising Week on Chatbots, AI and Machine Learning

Back in March, as my team took part in Advertising Week, I was honoured to be invited by Jason Miller, from the Sophisticated Marketer podcast, to deep dive into the evolution of Artificial Intelligence, Chatbots and what it means for marketers and how they can utilize the technology now and prepare for the future:

Live from #AWEurope: Chatbots, AI and Machine Learning

Connected cows and the greener pastures of big data

Blog post originally published on State of Digital as part of a monthly column.


Remember the cringing router sound that accompanied your early internet connections? Being a 40-year old father of two, when I hear that screeeeeeeechhhhhhhhhh I can’t avoid feeling a smile pop on my face. That sound reminds me, with a touch of nostalgia, of the cry of a newborn. It makes me smile as fond memories have overshadowed the dirty nappies and sleepless nights.

To a certain extent, that sound was indeed the cry of a baby internet, when browsing was a commitment and a flaming logo the pinnacle of creativity. The worldwide web has since grown up. A lot.

Small steps towards big data

Looking back, that dial-up buzz was literally the first signal in our digital footprint. We signed on. And in that very moment big data spun to life.
What were we learning from those early signals? Not much. We knew how many people were online and roughly where they were. But as the web of documents developed, search engines arose and our ability to understand people increased. We started to know what you wanted. Think about it: you probably tell search engines things you wouldn’t tell your closest friends. We understood that your inputs into a search engine were, on a personal level, an expression of your desire, and on a global level, an expression of the world’s consciousness. The so-called Zeitgeist.

Although I have spent the last 10 years in the realm of online advertising, in today’s article I will focus less on search marketing, and more on the information infrastructure and machine learning that Bing is part of, looking at how this is influencing our future. What are we doing with our data footprint? Over the course of the last year I have asked many people across Europe how the idea of data collection made them feel. By large, the response was discomfort and hesitance. Until provided with more perspective.

The heights of data complexity

So let’s get back to our story. In order to understand the complexity and depth of the data infrastructure that we are part of, let’s contemplate what has changed since the emergence of the first search engines. With each of these four changes and associated amount of data surge that came with it, you need to visualize a growing mountain.
First is your search habit. From a few searches per day to multiple searches per hour, we are now searching constantly, and not just you but also the billions of people who got online in the recent decade.

Second is your search access. Most of us had access to a desktop computer 20 years ago. But just one. A grey, cold box, sealed to a desk. We certainly couldn’t put it in our pocket and take it with us to a party. It is not just computers, think about all the devices you own which are harnessing computing power: laptop, tablet, smartphones, TV, but also your car and now your fridge.

The third big change is your search expression. You have gone from using basic computer commands, with amp signs and inverted commas, to using more human a language. You’ve gone from asking “what” to asking “why…” and “how to…”. In fact we have seen the growth of queries starting by Why being three-fold the growth of What queries, which means we are no longer looking for information, we are looking for answers. You’ve layered sequential searches on top of these, in a complex web of intents.

Finally, the integration of search with other infrastructures has also changed. A search engine used to be an isolated service. Now it’s plugged into the social graph. This means that several points of contact are linked and with them a flurry of new signals, millions of them that only a few super-computers are able to capture, organize, model and render. Search engines are the database of intents, and social networks are the depository of sentiments. We have developed the ability to process, analyze and understand these two humongous, historical and real-time information sets together.

The search crystal ball

We can understand your sentiment for certain events or entities, estimate popularity trends, as well as predict outcomes of future events. Microsoft has developed a program called Bing Predicts which combines and models all the data signals we can find, and comes up with incredibly accurate predictions. We initially explored popularity-based contests like American Idol, for which the web and social signals are very strong and highly correlate with popularity voting patterns. Bing Predicts could accurately project who would be eliminated each week during American Idol and who the eventual winner would be. Just by using all of the signals that are out there.

Getting more complex, we turned to sporting events and even world political challenges. During the World Cup in Brazil, our team predicted accurately with 100% accuracy the winners of the final elimination round. During the last year Rugby World cup, we had 80% accuracy across the tournament. Surprised? In order to successfully predict a sporting event outcome, the number and type of signals we incorporated quadrupled from what we used to predict a basic popularity event like American Idol. This is because we recognize that popularity alone does not predict whether a team will win – Sorry for the fans. A fan base has however special insights into the abilities of their teams, and those fans are having constant discussions about their team. This is called the Insider Knowledge. We up-weighted their knowledge against player and team stats, tournament trends, game history, location and even weather conditions. This is how we were successful in our predictions.

We finally turned our attention to political events, and in particular the Scottish referendum two years ago. The process and results were presented at TEDxSuzhou.


We were and are predicting the future. Can you imagine a business need that this kind of prediction can answer? Of course you can! We’re experimenting right now with predicting the upcoming trends in fashion, in automobile, in technology – so we can help our advertisers make smarter business decisions.

So we saw how predictions can play a role in entertainment, sport or business, fine. Fine, until we find a way to make this kind of data infrastructure even more meaningful, at a society and mankind level. What can we do with this capability that goes beyond entertainment and the novelty factor? Can we use our big data to make a meaningful impact on society?

Up close

All of this is exciting on a global or country level. When we’re talking about millions of inputs, it’s no wonder you can make predictions and have an impact like this. It is just a massive sample size. What about bringing this big data infrastructure to a personal level? Is it possible for a machine to learn so much about you that it can accurately predict your next move? Or predict when you will need something, and provide it? That is the promise behind digital personal assistant like Cortana.
Cortana is not only on Windows Phone but also Android and iPhone. And since the release of Windows 10, she’s even on your desktop. As outlined in a previous article, you set up Cortana with some basic info about yourself, then use her to help you with things like scheduling and reminders and web searches. Before you know it, Cortana is spontaneously sending you an alert to inform you that you should leave the office now to be on time for your next appointment in Farringdon, because she found some congestion on your normal route. It doesn’t take Cortana long to learn so much about you that she can predict your next move and offer assistance.

A new layer of data in your coat

While our mobile phones aren’t exactly wearables, we sometimes behave as if they are, keeping them on our body no matter where we go. With wearables, two important things converge: big data infrastructure and your expectations.

When you hear “wearables”, you probably think of a smart watch or one of these fitness bands. But to go back to my introductory analogy, these are just the first baby steps towards the full potential of wearable and how that technology will be able to enhance our capabilities, as individuals or as professionals. Think about it: wearables can capture and communicate signals about your location, your manner of travel – whether you’re on foot or in a car – time of day, most recent queries, usual route home from work, the weather, your physiological state, etc.

So for instance, if your wearable identifies that your hydration is low, it could prompt a notification that factors in your location, whether you’re moving, what time of day it is and therefore whether the nearby branch of your favourite coffee shop is open. It could even cross-reference this with your earlier interest in gingerbread lattes, and the fact that it is raining, and direct you to the nearest open coffee shop with plenty of indoor seating and gingerbread lattes on the holiday menu. Your wearable might even send you an alert for a coupon the coffee shop is offering.

Greener pastures ahead

As the wearable technology grows, your expectations for your experience with technology in general will change. And that is for the better. After all what the point accumulating data points like hoarders unless you do something greater about it. And if I have learned something about the internet, is that it is a fertile ground for creative usage of untapped opportunities.

I am from the French Alps where I spent most of my summers walking the mountains with my grandmother. She used to herd cattle in these alpine pastures and she was telling me stories about how much each of her cows were almost like members of her family. They had names, and she could tell when something was wrong with any of them.
These days are gone. Nowadays a farm is no longer taking care of a small dozens of cows, but hundreds. The personal relationship of each animal is no longer an option. The story of the connected cows started with a farmer in Japan who was exhausted with the effort of figuring out the exact time his cows were fertile – because it is a very short window, only 12-18 hours every 21 days, and it happens usually between 10pm and 8am. Of course knowing this precise time of estrus would give farmers a chance to successfully inseminate the cows.

These are farms with hundreds of cows – you can image what a nightmare this would be to keep track. Could technology help? A farmer in Japan asked Fujitsu for help. Fujitsu consulted with some university researchers and they came up with this idea of putting wearables – pedometers – on the cows, and providing the data to Microsoft Azure, in the cloud, for analysis and alerts that go straight to the farmer’s smartphone.

It turns out that when a cow is in estrus, she paces. The number of steps she is taking increases tremendously, and this data alerts the farmer to the right moment for fertilization. The connected cow project has been 95% accurate – and that 5% where it misses the mark turns out to be when the cow actually skips the farm and goes missing.
Not only is this wearable incredibly accurate, it also helped the researches discover that there is an optimum window for fertilization if you’d like a female or if you’d like a male. With 70% probability, a farmer should fertilize in the first half of the estrus window if he needs more milk cows or if he needs more bulls. But it does not stop there… The Fujitsu researchers were able to also correlate pacing patterns with increased risks of genetic diseases and pathology.


It is amazing what data can tell you, if you know how to look at it. Sometimes creatively! This is the joy of data infrastructure. We can do wonderful things in the world when we collect, analyze and render the data that’s available to us. Microsoft is on the leading edge of this, with products like Power BI, Azure, our cloud platform but also Bing our search engine and its machine learning capabilities which can make sense of the millions other data points that come together to make big data smart, useful, creative and – yes – joyful. And you, what was the last time you found a creative inspiration in your data set?

Lifting the lid of the search box: Excel tips for search marketers

Blog post originally published on State of Digital as part of a monthly column.

The motivational quote encourages us to “think outside the box”… But for once, I want you to think behind the box. Have you ever thought about the cogs, bots, artificial intelligence and other algorithms that are getting in motion every time someone hits the “search” button? The computing forces in motion are staggering and the amount of data that is crunched and produced is even more. Lines and lines of data, with in each of them a little piece of insight that could make all the difference in your marketing strategy. If only… If only you could overcome the spreadsheet blindness and see them.

Several of my posts in State of Digital are about visionary topics: the rise of AI, predictive modelling applied to individuals, digital transformation and the lessons that search engines could give to other businesses… This month, I was keen to be more tactical, and explore a little bit further the capabilities of the beloved Excel when it comes to making sense of large amount of data.

Picture that emotion

Advertising is all about creating an emotional bond between a brand and consumers. And since the infancy of our discipline, both marketers and agencies have been trying to visualize this connection. Focus groups, vox pop, surveys, research… They all had a go at it. But personally I never got fully satisfied by them. As a matter of fact, I don’t believe that people give you access to their core beliefs when prompted over the phone or in the street.

Then Social Media arose. And you must admit that they are simply great for that corollary use. After all, what are these platforms but the depository of our intimate sentiment?

So obviously you can have a quick peek at Facebook and look up for the fan pages for your brands. That is straightforward as people are overtly expressing their sentiment towards the brand through these pages. They revive dormant products and re-energize old brands. They also virtually stone others to death.

But what if you are interested in emotions more deeply engrained in consumer minds? And looking at visualizing them? Personally I used to visit photo sites like Flickr or Instagram and run a query on a given brand. Type Bailey’s and you will get hundreds of pictures showing up. The resulting mosaic is fantastically enriching. You will of course see people sipping their favorite liquor but also loads of pictures of dogs and cats named after that brand. What a better proof of brand advocacy than to name your beloved pet after a trademark? Or to tattoo the swoosh on your hip or a Harley Davidson eagle on your shoulder?

Think outside the (search) box

This digression meant to make a point: we can find consumer insights everywhere. You just need to be a bit creative to see them. I remember discovering Bing Ads Intelligence tool, and having one of these ah-ah moments.

This tool is by essence a brilliant search marketing tool that enables search marketers to make more informed choices when creating a campaign: based on historical and forecasted data from Bing search queries, it provides you for any keyword with traffic volumes, demographical and geographical information about the searchers, even indicative CPC for the different positions in the auction… And it is free!

If you have not downloaded it yet, I would strongly recommend you do. Even if you are not working in search marketing. In fact, I should say “especially if you are not working in search”.

This little freeware can indeed help a lot of marketers out there. As a matter of fact, in the current economic climate, when costs are cut to their bare minimum, can you afford to research what your audience’s actual demographic profile is and where they live? Are your pockets deep enough to run a regular research to audit your brand awareness against this audience?

Search engines are for finding

Digital expert and author John Battelle once qualified search engines as the database of intents. With over than 28m unique users in the UK alone, Bing offers you a statistically relevant sample of these intentions. So why not use the Bing Ads Intelligence to run your own piece of research? It provides you access to actual logs, so you can use them as proxy for your consumer intents. How many consumer have searched for your brand in the last month, and how many have for your competitors? That will provide you with a good indication of your brand awareness. Did they search on a PC or from a mobile device? Have queries increased after your latest local TV campaign? Was your regional billboard campaign efficient? Where are visitors searching from? London, Liverpool, outside the UK?

A lot of these questions can be answered and visualized by pressing a button in Excel. Three actually.

Three Excel features to make your data click

The first click should be on Bing Ads Intelligence. As said, you just have to enter a word (a brand for instance) and choose what you want to know: demographics, device usage… And since you are in Excel you can rapidly turn the data into a compelling visualization like this:





Now knowing more about who searched, my second click would be on another Excel free tool, PowerMap. If you are running Office 365, this is a native feature in your ribbon. If you are using an earlier version, you can download that add-on for free. Power Map is a 3D visualization add-on for Excel for mapping, exploring, and interacting with geographical and temporal data, enabling people to discover and share new insights. It allows Excel to automatically chart the search data to see where the customers who are searching for you are located, where your revenue is generated, where prospects are congregating, etc. I particularly like that if you have your data points for several periods, you can turn your map into a little video which will illustrate the evolution of your chosen KPI over time. The brilliant thing in this feature? Excel does all the work for you. Leveraging Bing technology, it recognizes the geo-information present in your spreadsheet and plots the relevant data points on a map accordingly.

Of course, neither tool will ever replace a full professional research or extensive monitoring application, but these are valuable indicators and visualizations for a superior desk research. Personally I find these free tools simply brilliant for those who are always looking for innovative ways to increase cost-efficiently their agility, identify new opportunities and niches.

Who, where and now when?

My third click would be to dig into the question of time and create a day parting heat map using the conditional formatting of Excel to rapidly identify when is my marketing sweet spot. How do you do that? Conditional formatting is a brilliant function that allows you to automatically change the format of a cell, based on values and parameters that you dictate. So let’s say that you have a search account report that you downloaded from Bing Ads with Hour of Day as the unit of time. It would originally look something like this (painful to watch you would reckon):


Highlight each column individually and use conditional formatting. We then see a picture of account performance by time of day, and a heat map emerge. I’ve left the Clicks, Impressions, Cost, and Converted Clicks columns untouched right now, as I prefer to display those with a different formatting.  The red vs. green distinction is a little too arbitrary for these numbers, so I go with a bar graph to show them instead.



Now this chart tells us a story. It portrays the ebb and flow of our daily traffic, and it clearly shows us both where we can pull back on our bids with day-parting modifiers – early morning from midnight to 4 AM – and where to be more aggressive. We have a real lost opportunity here starting at 4 PM to 8 PM to increase our bid modifier and gather even more traffic. Our Average Position and Average CPC metrics let us know exactly when our competitors are ramping up their spend, and the hours in which we should do the same… until about 10 PM, when our conversion rate drops again.

This report takes less than five minutes to pull, and no custom modifications were made to these rules aside from highlighting each column individually and selecting the right formatting.  Day-parting is the easy and obvious use for this kind of analysis, but it can also assist in ad reviews, geographic performance… really, in any case that leaves you staring at a spreadsheet for hours on end, mining for insights.

To go further

So you’ve manipulated and made your data more digestible. It has worked and you have identified some interesting data points but now you want to tie this in with the rest of your company’s data sources and tell a story. That is when tools like Power BI become handy. It indeed allows you to connect your data with a wide variety of data sources, from local on-premises databases to Excel worksheets to cloud services. Currently, over 59 different cloud services such as Facebook and Marketo have specific connectors, and you can connect to generic sources through XML, CSV, text, and ODBC. Data.gov for instance is a great base of public domain data set that you can mash with your own.

So what can this mean? How about comparing the demographic profile of your audience with the latest census? Identify the correlation between your customer engagement and the weather variations? There is so much data out there, it is really just about letting your creativity unleash the power of insights. Or when data becomes clear, and actionable.

The unbearable lightness of having

Ouch! I just walked yet on a lingering Lego bricks kindly left behind by one of my two boys as a token to their gratitude. Re-ouch! What did I trip over this time? Oh, just one of my wife's precious items from her impressive plastic bag collection (including this very special vintage edition by Tesco from 2007)...

Organised mess?

Many new parents will certainly sympathise, so yes I confess, I live in a flat that is cluttered... Books, toys, plastic and handbags, stilettos, pens and a few devices here and there (because the geek that I am does contribute to that mayhem, of course). No matter how creative you get with storage, they always seem to overflow. So the problem may not be the storage, but the content. Of course it is.

In fact, after having sold us alternatively the dreams that as the ultimate luxury was space or that some Swedish wizardry could help make more out of our jam-packed spaces, a more recent trend has emerged from the media. It is no longer about expanding or optimising micro-inches of cramped living space: it is now a matter of decluttering. If in the past, there was a relatively basic dichotomy between the have's and the have-not's, there is now amongst the upper-middle class a third category: the don't-want-to-have's. For them, it becomes a decision not to possess.

Inspired by Japanese Zen and Feng-Shui philosophies, this phenomenon is trending far and large in the press, as more and more books are released about how to tidy and clear out. You must admit this is in itself a bit schizophrenic... After all, avid fans may end up cluttering their house with books on decluttering!

Spring cleaning

Fad or trend? We are now in the very last days of Spring, and many of us have felt the almost therapeutic feeling of emptying cupboards and other hidden boxes from the junk we had been accumulating over the previous twelve months. Off with that candle holder in terracotta. To the bin the piles of Time Out magazines you have been promising your self to catch up on in order to be up to speed with what is hot... or, well, what was hot in June 2013 by the look of the cover of the edition you hold in your hand.

It feels good to reclaim some ground over the mess. It feels even better when you clear your conscious when you hand over your definitely too tight jeans to a charity on the high street. But it would be interesting to see how this trend evolves once the dust has settled. Nevertheless this phenomenon struck a cord with me (and not only because I have a profound admiration for Japan and obsessed by the necessity to bring order to chaos). It led me to another very contemporary divergence: possession versus materialism.

Is digitalisation cheating?

For years the concept of possession was necessarily associated to physical object. Wealth was measured by the ground you owned, the serfs ploughing your fields, the pile of gold you could put on the table... And then came the banks, and money got dematerialised. You had no more trinkets but access to money, an abstract concept. It was still your sweat and tears (or your servants), but it was no longer your very own treasure. There was no more attachment to the object itself, rather to its value.

Similarly, information which was once captured in pages, books and bookshelves was first digitised but still remained visible. It was on that floppy disk or in that server that was buzzing in the corner of the office. It was not looking like a good old book anymore, but it was still there. This changed with the rise of Cloud computing. With it, the virtualisation accelerates and objects further dematerialise. Like the golden nuggets an jewels which were replaced by bank statements, books, disks, CD, cassettes, external hard drives, servers... are disappearing from the local premises to see their quintessence hosted somewhere in the cloud.

Slowly the reticence of not being able to touch-to-own is fading. People are perceiving the value of virtualisation: easy and ubiquitous access; lower costs as you pay only for the storage you actually need; security of having your assets backed up in several locations... Of course there are hackers, like there were bank robbers, and there are still people who don't trust the cloud like many did not trust bankers and preferred to sleep with money under their matrass. But there are also genuine enthusiasts who are seeing in technology the opportunity to live the above-described trend to its fullest. 

Technologically-enhanced lives

I indeed recently met that technophile whose job was to educate businesses about the latest evolutions and what they entail in terms of opportunity. As a technologist, he had decided to explore how far he could go in adopting technologies which could help him get rid of the unnecessary. He got a chip inserted under the skin, a bit of code here and there, and off he went to dematerialise his home. Sensors capture his presence and switches on and off the wifi, the lights, the heating system, etc. automatically based on agreed gestures, rules and orders passed through his phone. The keys to his flat were rapidly gone too, as his unique identifier emitted by his chip could open the door lock through NFC. Whilst many of us switch between different screens, he opted to retain only one, acknowledging that smartphones nowadays are sufficiently powerful to be a TV, a PC, a watch and even a phone. Why having a fridge if you could get his daily food intake delivered fresh to his door, prepared to meet his dietary requirements? One by one, he went through his inventory and tried to get rid of what was not really needed. He wanted to go back to the basics... Connected basics. 

This leads to some interesting points of reflection: the digitalisation of the world implies the rise of a new paradigm where you can own without possessing. You still own information, tunes, photos... but they do not materially exist any more. This means that the renunciation to physical ownership does not necessarily jeopardise the codes of our Western societies. Pushed to the extreme, wealth could materialise in absence of physical possession whilst the poorest would be the ones anchored in a material world, unable to digitised... Internet behind a social walled garden, so to speak.

In that hypothetical, yet plausible world, Maslow's pyramid of needs may see "wifi access" being added to its lower, more basic needs. This is one of the scenarios that the Singularity University explores during their curriculum: "how to apply exponential technologies to address humanity’s grand challenges" with a democratised access to the internet as a prerequisite to avoid a new social rupture between the connected and the disconnected. This is also why companies like Google are exploring ways to give access to the internet in creative ways like the Loon project (and not to expand the reach of their advertising audience of course).

Tidying my thoughts

Personally, I am enthused by what new technologies can offer, and as a humanist, I believe in our ability to keep the potential demons at bay. Without going to the extreme of my technologist, I am slowly decluttering my flat, saving one foot nail at a time my physical integrity, my sanity, and hopefully a tiny bit of the planet by not consuming beyond what I really need. I am from the Generation X, that generation who has come to the world amidst the recession after years of prosperity. Because of that, I am more than ever convinced that we are therefore a transitional breed, and probably better suited than anyone to help facilitate and educate the change without being blinded by optimism or pessimism. We are an agent of change. For the better.

Chiling Chilean World Cup

Emotions

I have reported in these pages how sport can (and should be) a source of deep emotions for both practitioners and fans. Passion, thrill, deception, excitement... You name it. During the Olympics in London back in 2012, I had the chance to live some such a vibration first hand. Even today, listening to the French national Anthem, La Marseillaise, sung by a jam-packed Copper Box after the Olympic victory of the handball team still triggers a shiver up my spine. It is patriotism, pride, happiness and bucket loads of other emotions that are intertwined and anchored in my psyche. Proust had madeleines... I have a sport achievement.

A cup full of excitement

I will spend some time to discuss the profound connection that the Brit have to football, and how they differ so much from other nations with that respect. But today, I wanted to share another concentrate of emotion with this Chilean video. You may remember those miners who got trapped underground a few years back. Under the scrutiny of the entire country, they united and survived death. Today they unite again to epitomise the nation's hope with regards to their national team in the World Cup. The Chilean team is facing the world champions and the vice-champions, Spain and Netherlands, and inherited of what is nicknamed the Group of the Death... Something way to familiar for the miners. Watch and enjoy what a well written speech can do... A deep emotion!

Olympic tears before the sweat.

The emotional tap.

The London 2012 Olympics are still a vivid memory. I totally embraced the spirit of the Games at that time, enjoyed every second of this international event and the drama that came along with it. Sports are a marvellous catalyst of emotions: joy, despair, achievement, anger, rage, sadness...

This myriad of shared feelings, concentrated in a short period of time, sublimes the actual sport performance to make it something bigger, larger, more universal. It triggers a response of communion between nations.

A marketing plea?

I am personally a cerebral machine that works on emotional fuel. This is why I have been working in advertising. I like to tell stories, engage people emotions. Too often though, and especially in the context of economical pressure, story telling is discarded to focus on transactional messages. "Don't charm, sell" seems to be the motto as if you could not use your charm and connivance to actually drive business relationship.

Of course you do have the big brands that are the trees hiding the forest. For the Nike, Apple and other Microsoft, how many other advertisers are forgetting to instil some emotions in their engagement with their customers? Some claim that brand building is not required for all brands, and that some brands do not require to create an emotional connection with their market. Commodity products spring to mind...

Who cares about toothpicks? I hear you say.
Can buying a USB stick ever give me butterflies in my tommy? Someone adds.

Well, I do think so... It just requires a little more efforts. In fact marketing commodities, like good B2B marketing, is about applying the same level of intransigence as for marketing high-involving products despite more limited resources and an easy path towards complacency. 

Paris-based creative hot shop Buzzman did an amazing job with their Hunter Shoots a Bear interactive video to encourage people to make use of Tippex. And look at what Procter & Gamble has done with the following commercial. It does not sell diapers, wipes, detergent... It sells emotions! And smartly announces their corporate tie-in with the upcoming Sochi Winter Olympics that surely will be heavily used in shops to drive product usage and adoption. Smart. And efficient.

Enjoy!

Melody... Nippon Style

Asian noodling.
 
Last year Korea was trusting the world music charts with a Psy-chedelic tune that was all the more representative of the emancipation and internationalisation of the country, let alone region. I have personally never been to the Country of the Calm Morning, but have done a few immersions in the broader eastern region. If I loved walking the unspoilt Burmese countryside, the constant smile of the Malaysian people, the spices of the thailandese food... It is really Japan that caught my imagination, like no other (as Sony once said in its advertising).

I belong to the generation X, which means that I have grown up with the rise of that nation on the international scene. Sega and Nintendo have kept me awake at night ; Shizuo Koizumi and his anime "Attacker Yu!" (Jeanne & Serge in French) made me discover volley ball and live magnificent moments with great fellows ; I have delightfully seen sushi bars take over France restaurant scene like Pizzerias did in the 70s, Vietnamese restaurants in the 80s, Kebab shop in the 90s... It was therefore natural for my wife and I to aim for the archipelago when evaluating our honey moon destinations.

Nippon Style.

It was already a few years back, and I have written a few articles on that experience, but what I recall most is this frenetic calm that tears appart that nation. On the one hand Tokyo and its always-on beats, strobe lights and capsule hôtels, and on the other hand the traditions and relaxing nature of the Takayama region.

And it is always a pleasure to dive back in these fantastic memories through the pictures I brought back, or thought more serendipity. The latest happy accident was this advertisement for the Touchwood SH-08C, a very special phone by Sharp and launched by NTT Domoco.

As introduced in Engadget:

Kenjiro Matsuo was responsible for the creation of the instrument, while Morihiro Harano is being handed credit for the idea itself; in fact, he confirmed to The New York Times that no artificial music was added whatsoever, with only the background levels being adjusted up for effect. You may have never listened to a piece of classical music in your life, but you're sorely missing out if you ignore Bach's Cantata 147, "Jesu, Joy of Man's Desiring." Or, at least the version in that video below.