Drilling Down Turning Customer Data Into Profits With A Spreadsheet

I spend a lot of time in marketing-oriented discussion lists. If you do, you probably also sense the incredible frustration of people who keep asking about using their customer data to retain customers and increase profits. Everybody knows they should be doing it, but can't find out how to do it. Consultants and agencies make this process sound like some kind of "black magic", something you can't possibly do yourself. I disagree. I think the average business owner can do a perfectly decent job creating profiles and using them to retain customers and drive profits. Thus the book. The examples provided are Internet specific, but the methods can be used in any business where customer data is available. This book is about the down-and-dirty, nitty-gritty art of taking chunks of data generated by your customers and making sense of it, getting it to speak to you, creating insight into what types of marketing or general business actions you can take to make your business more profitable. We'll be talking about "action-oriented" ideas you can generate on your own to drive sales and profits, ideas that will reveal themselves by analyzing your own customer data, using only a spreadsheet. We have all heard how important it is to collect customer data, to "know" your customer. What I don't hear much about is what exactly you DO with all that data once you have collected it. How is it used? What exactly is Drilling Down into the data supposed to tell me, and what am I looking for when I get there? For that matter, what data should I be collecting and how will I use it when I have it? And how much is this process going to cost me? The following list outlines what you will learn and be able to do after reading the Drilling Down book: --What data is important to collect about a customer and what data is not --How to create action-oriented customer profiles with an Excel spreadsheet --How to use these profiles to plan marketing promotions --How to use these profiles to define the future value of your customers --How to use these profiles to measure the general health of your business --How to use these profiles to encourage customers to do what you want them to --How to predict when a customer is about to defect and leave you --How to increase your profits while decreasing your marketing costs --How to design high ROI (Return on Investment) marketing promotions How to blow away investors with predictions of the future profitability of your business Table of Contents Chapter 1: What's a Customer Profile? Chapter 2: Data-Driven Marketing - Customer Retention Basics Chapter 3: The Language of Data, The Science of Profit Chapter 4: Interactivity Changes the Rules of the Game Chapter 5: How to Build a Customer Profiling Spreadsheet Chapter 6: How to Profile (Score) Your Customers Chapter 7: Marketing Using Customer Scores - Basic Approach Chapter 8: Using Customer Characteristics and Multiple Scores Chapter 9: Watching Scores over Time - Customer LifeCycles Chapter 10: Customer Scoring Grids - Profiling on Steroids Chapter 11: Calculating and Using LifeTime Value in Promotions Chapter 12: Turning Profiles into Profits - the Staging Area Chapter 13: Turning Profiles into Profits - the Financial Model Chapter 14: Turning Profiles into Profits - Financial Tweaks Chapter 15: Measuring Success in Best Customer Promotions Chapter 16: Some Final Thoughts Seasonal Adjustments to Marketing Promotions Don't Fight Customer Behavior CRM Software and Customer Scoring Data-Driven Marketing Program Descriptions There's more! Automate the basic customer scoring process on large groups of customers. Use the software included free with this edition! Windows OS and MS Access and Excel required to run the software.

In order to establish and then maintain a successful presence on the Web, designing a creative site is only half the battle. What good is an intricate Web infrastructure if you're unable to measure its effectiveness? That's why every business is desperate for feedback on their site's visitors: Who are they? Why do they visit? What information or service is most valuable to them? Unfortunately, most common Web analytics software applications are long on functionality and short on documentation. Without clear guidance on how these applications should be integrated into the greater Web strategy, these often expensive investments go underused and underappreciated. Enter Web Site Measurement Hacks, a guidebook that helps you understand your Web site visitors and how they contribute to your business's success. It helps organizations and individual operators alike make the most of their Web investment by providing tools, techniques, and strategies for measuring--and then improving--their site's usability, performance, and design. Among the many topics covered, you'll learn: definitions of commonly used terms, such as "key performance indicators" (KPIs) how to drive potential customers to action how to gather crucial marketing and customer data which features are useful and which are superfluous advanced techniques that senior Web site analysts use on a daily basis By examining how real-world companies use analytics to their success, Web Site Measurement Hacks demonstrates how you, too, can accurately measure your Web site's overall effectiveness. Just as importantly, it bridges the gulf between the technical teams charged with maintaining your Web's infrastructure and the business teams charged with making management decisions. It's the technology companion that every site administrator needs.

Transforming data into revenue generating strategies and actions Organizations are swamped with data—collected from web traffic, point of sale systems, enterprise resource planning systems, and more, but what to do with it? Monetizing your Data provides a framework and path for business managers to convert ever-increasing volumes of data into revenue generating actions through three disciplines: decision architecture, data science, and guided analytics. There are large gaps between understanding a business problem and knowing which data is relevant to the problem and how to leverage that data to drive significant financial performance. Using a proven methodology developed in the field through delivering meaningful solutions to Fortune 500 companies, this book gives you the analytical tools, methods, and techniques to transform data you already have into information into insights that drive winning decisions. Beginning with an explanation of the analytical cycle, this book guides you through the process of developing value generating strategies that can translate into big returns. The companion website, www.monetizingyourdata.com, provides templates, checklists, and examples to help you apply the methodology in your environment, and the expert author team provides authoritative guidance every step of the way. This book shows you how to use your data to: Monetize your data to drive revenue and cut costs Connect your data to decisions that drive action and deliver value Develop analytic tools to guide managers up and down the ladder to better decisions Turning data into action is key; data can be a valuable competitive advantage, but only if you understand how to organize it, structure it, and uncover the actionable information hidden within it through decision architecture and guided analytics. From multinational corporations to single-owner small businesses, companies of every size and structure stand to benefit from these tools, methods, and techniques; Monetizing your Data walks you through the translation and transformation to help you leverage your data into value creating strategies.

This book offers a comprehensive and readable introduction to modern business and data analytics. It is based on the use of Excel, a tool that virtually all students and professionals have access to. The explanations are focused on understanding the techniques and their proper application, and are supplemented by a wealth of in-chapter and end-of-chapter exercises. In addition to the general statistical methods, the book also includes Monte Carlo simulation and optimization. The second edition has been thoroughly revised: new topics, exercises and examples have been added, and the readability has been further improved. The book is primarily intended for students in business, economics and government, as well as professionals, who need a more rigorous introduction to business and data analytics – yet also need to learn the topic quickly and without overly academic explanations.

You can go after the job you want…and get it! You can take the job you have…and improve it! You can take any situation you’re in…and make it work for you! Since its release in 1936, How to Win Friends and Influence People has sold more than 30 million copies. Dale Carnegie’s first book is a timeless bestseller, packed with rock-solid advice that has carried thousands of now famous people up the ladder of success in their business and personal lives. As relevant as ever before, Dale Carnegie’s principles endure, and will help you achieve your maximum potential in the complex and competitive modern age. Learn the six ways to make people like you, the twelve ways to win people to your way of thinking, and the nine ways to change people without arousing resentment.

Today, new media enter our lives faster than ever before. This volume provides a complete, state-of-the-art overview of the newest media technologies and how they can be used in marketing communications - essential information for any organization that wants to maintain an effective advertising program, as well as for experts and students in the fields of advertising and mass communications. Advertising, Promotion, and New Media offers crucial insights on the use of cutting-edge techniques including 3-D advertising, mobile advertising, advergames, interactivity, and netvertising images, as well as more familiar Internet advertising formats such as banner ads and pop-ups. It also discusses such important topics as how to select online affiliates, and how to assess the effectiveness of new media advertising and compare it with traditional formats. Throughout the book, the chapter authors offer up-to-date information and thought provoking ideas on emerging technology and how it can be used effectively for advertising and promotion in the future.

Key Business Analytics will help managers apply tools to turn data into insights that help them better understand their customers, optimize their internal processes and identify cost savings and growth opportunities. It includes analysis techniques within the following categories: Financial analytics – cashflow, profitability, sales forecasts Market analytics – market size, market trends, marketing channels Customer analytics – customer lifetime values, social media, customer needs Employee analytics – capacity, performance, leadership Operational analytics – supply chains, competencies, environmental impact Bare business analytics – sentiments, text, correlations Each tool will follow the bestselling Key format of being 5-6 pages long, broken into short sharp advice on the essentials: What is it? When should I use it? How do I use it? Tips and pitfalls Further reading This essential toolkit also provides an invaluable section on how to gather original data yourself through surveys, interviews, focus groups, etc.

Whether you are brand new to data mining or working on your tenth predictive analytics project, Commercial Data Mining will be there for you as an accessible reference outlining the entire process and related themes. In this book, you'll learn that your organization does not need a huge volume of data or a Fortune 500 budget to generate business using existing information assets. Expert author David Nettleton guides you through the process from beginning to end and covers everything from business objectives to data sources, and selection to analysis and predictive modeling. Commercial Data Mining includes case studies and practical examples from Nettleton's more than 20 years of commercial experience. Real-world cases covering customer loyalty, cross-selling, and audience prediction in industries including insurance, banking, and media illustrate the concepts and techniques explained throughout the book. Illustrates cost-benefit evaluation of potential projects Includes vendor-agnostic advice on what to look for in off-the-shelf solutions as well as tips on building your own data mining tools Approachable reference can be read from cover to cover by readers of all experience levels Includes practical examples and case studies as well as actionable business insights from author's own experience