Drilling Down: Turning Customer Data into Profits with a Spreadsheet


Book Description

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.




Optimization Modeling with Spreadsheets


Book Description

Reflects the latest applied research and features state-of-the-art software for building and solving spreadsheet optimization models Thoroughly updated to reflect the latest topical and technical advances in the field, Optimization Modeling with Spreadsheets, Second Edition continues to focus on solving real-world optimization problems through the creation of mathematical models and the use of spreadsheets to represent and analyze those models. Developed and extensively classroom-tested by the author, the book features a systematic approach that equips readers with the skills to apply optimization tools effectively without the need to rely on specialized algorithms. This new edition uses the powerful software package Risk Solver Platform (RSP) for optimization, including its Evolutionary Solver, which employs many recently developed ideas for heuristic programming. The author provides expanded coverage of integer programming and discusses linear and nonlinear programming using a systematic approach that emphasizes the use of spreadsheet-based optimization tools. The Second Edition also features: Classifications for the various problem types, providing the reader with a broad framework for building and recognizing optimization models Network models that allow for a more general form of mass balance A systematic introduction to Data Envelopment Analysis (DEA) The identification of qualitative patterns in order to meaningfully interpret linear programming solutions An introduction to stochastic programming and the use of RSP to solve problems of this type Additional examples, exercises, and cases have been included throughout, allowing readers to test their comprehension of the material. In addition, a related website features Microsoft Office® Excel files to accompany the figures and data sets in the book. With its accessible and comprehensive presentation, Optimization Modeling with Spreadsheets, Second Edition is an excellent book for courses on deterministic models, optimization, and spreadsheet modeling at the upper-undergraduate and graduate levels. The book can also serve as a reference for researchers, practitioners, and consultants working in business, engineering, operations research, and management science.




Excel Data Analysis


Book Description

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.




The Profit Impact of Business Intelligence


Book Description

The Profit Impact of Business Intelligence presents an A-to-Z approach for getting the most business intelligence (BI) from a company's data assets or data warehouse. BI is not just a technology or methodology, it is a powerful new management approach that – when done right – can deliver knowledge, efficiency, better decisions, and profit to almost any organization that uses it. When BI first came on the scene, it promised a lot but often failed to deliver. The missing element was the business-centric focus explained in this book. It shows how you can achieve the promise of BI by connecting it to your organization's strategic goals, culture, and strengths while correcting your BI weaknesses. It provides a practical, process-oriented guide to achieve the full promise of BI; shows how world-class companies used BI to become leaders in their industries; helps senior business and IT executives understand the strategic impact of BI and how they can ensure a strong payoff from their BI investments; and identifies the most common mistakes organizations make in implementing BI. The book also includes a helpful glossary of BI terms; a BI readiness assessment for your organization; and Web links and extensive references for more information. - A practical, process-oriented book that will help organizations realize the promise of BI - Written by Nancy and Steve Williams, veteran consultants and instructors with hands-on, "in the trenches" experience in government and corporate business intelligence applications - Will help senior business and IT executives understand the strategic impact of BI and how they can help ensure a strong payoff on BI investments




Management Information Systems


Book Description

Management Information Systems provides comprehensive and integrative coverage of essential new technologies, information system applications, and their impact on business models and managerial decision-making in an exciting and interactive manner. The twelfth edition focuses on the major changes that have been made in information technology over the past two years, and includes new opening, closing, and Interactive Session cases.




Web Analytics Demystified


Book Description




Product-Led Growth


Book Description

"Product-Led Growth is about helping your customers experience the ongoing value your product provides. It is a critical step in successful product design and this book shows you how it's done." - Nir Eyal, Wall Street Journal Bestselling Author of "Hooked"




Web Site Measurement Hacks


Book Description

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.




Profit Driven Business Analytics


Book Description

Maximize profit and optimize decisions with advanced business analytics Profit-Driven Business Analytics provides actionable guidance on optimizing the use of data to add value and drive better business. Combining theoretical and technical insights into daily operations and long-term strategy, this book acts as a development manual for practitioners seeking to conceive, develop, and manage advanced analytical models. Detailed discussion delves into the wide range of analytical approaches and modeling techniques that can help maximize business payoff, and the author team draws upon their recent research to share deep insight about optimal strategy. Real-life case studies and examples illustrate these techniques at work, and provide clear guidance for implementation in your own organization. From step-by-step instruction on data handling, to analytical fine-tuning, to evaluating results, this guide provides invaluable guidance for practitioners seeking to reap the advantages of true business analytics. Despite widespread discussion surrounding the value of data in decision making, few businesses have adopted advanced analytic techniques in any meaningful way. This book shows you how to delve deeper into the data and discover what it can do for your business. Reinforce basic analytics to maximize profits Adopt the tools and techniques of successful integration Implement more advanced analytics with a value-centric approach Fine-tune analytical information to optimize business decisions Both data stored and streamed has been increasing at an exponential rate, and failing to use it to the fullest advantage equates to leaving money on the table. From bolstering current efforts to implementing a full-scale analytics initiative, the vast majority of businesses will see greater profit by applying advanced methods. Profit-Driven Business Analytics provides a practical guidebook and reference for adopting real business analytics techniques.




Marketing Analytics


Book Description

Helping tech-savvy marketers and data analysts solve real-world business problems with Excel Using data-driven business analytics to understand customers and improve results is a great idea in theory, but in today's busy offices, marketers and analysts need simple, low-cost ways to process and make the most of all that data. This expert book offers the perfect solution. Written by data analysis expert Wayne L. Winston, this practical resource shows you how to tap a simple and cost-effective tool, Microsoft Excel, to solve specific business problems using powerful analytic techniques—and achieve optimum results. Practical exercises in each chapter help you apply and reinforce techniques as you learn. Shows you how to perform sophisticated business analyses using the cost-effective and widely available Microsoft Excel instead of expensive, proprietary analytical tools Reveals how to target and retain profitable customers and avoid high-risk customers Helps you forecast sales and improve response rates for marketing campaigns Explores how to optimize price points for products and services, optimize store layouts, and improve online advertising Covers social media, viral marketing, and how to exploit both effectively Improve your marketing results with Microsoft Excel and the invaluable techniques and ideas in Marketing Analytics: Data-Driven Techniques with Microsoft Excel.