Author: Wayne L. Winston
Publisher: John Wiley & Sons
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.
Author: Wayne L. Winston
Publisher: John Wiley & Sons
Author: Mark Jeffery
Publisher: John Wiley & Sons
Praise for Data-Driven Marketing "To paraphrase the old adage: 'Half of marketing dollars are effective, we just don't know which half!' This book changes the marketing game so you'll really know what's working and what's not. The 15 metrics, along with the case examples, are an authoritative toolkit for making better decisions to create new markets, drive revenue, increase customer satisfaction, and improve profitability." —John M. Boushy, former CEO, Ameristar Casinos, Inc. "A groundbreaking combination of research, frameworks, and pragmatic advice for both controlling and radically improving marketing. A must-read for the entire marketing organization, from the CMO to the front lines." —Barry Judge, Executive Vice President and Chief Marketing Officer, Best Buy "Business-to-consumer marketing and business-to-business marketing are very different. Through detailed examples, this outstanding book shows how to apply data-driven marketing in both worlds for real results. This book is for anyone in business, not just marketing, who wants to step up the performance of their marketing." —David G. Bills, Senior Vice President and Chief Marketing and Sales Officer, DuPont "Every year, baseball teams go to places like Florida and Arizona to run through the basics which are the cornerstone of performance excellence. This book is the marketing equivalent of taking all those ground balls. An essential read for every marketer who cares about—and wants to improve upon—the science of their craft." —Derek Ungless, Executive Vice President and Chief Marketing Officer, DSW Shoe Warehouse
Master practical strategic marketing analysis through real-life case studies and hands-on examples. In Cutting Edge Marketing Analytics, three pioneering experts integrate all three core areas of marketing analytics: statistical analysis, experiments, and managerial intuition. They fully detail a best-practice marketing analytics methodology, augmenting it with case studies that illustrate the quantitative and data analysis tools you'll need to allocate resources, define optimal marketing mixes; perform effective analysis of customers and digital marketing campaigns, and create high-value dashboards and metrics. For each marketing problem, the authors help you: Identify the right data and analytics techniques Conduct the analysis and obtain insights from it Outline what-if scenarios and define optimal solutions Connect your insights to strategic decision-making Each chapter contains technical notes, statistical knowledge, case studies, and real data you can use to perform the analysis yourself. As you proceed, you'll gain an in-depth understanding of: The real value of marketing analytics How to integrate quantitative analysis with managerial sensibility How to apply linear regression, logistic regression, cluster analysis, and Anova models The crucial role of careful experimental design For all marketing professionals specializing in marketing analytics and/or business intelligence; and for students and faculty in all graduate-level business courses covering Marketing Analytics, Marketing Effectiveness, or Marketing Metrics
Distill Maximum Value from Your Digital Data! Do It Now! Why hasn’t all that data delivered a whopping competitive advantage? Because you’ve barely begun to use it, that’s why! Good news: neither have your competitors. It’s hard! But digital marketing analytics is 100% doable, it offers colossal opportunities, and all of the data is accessible to you. Chuck Hemann and Ken Burbary will help you chop the problem down to size, solve every piece of the puzzle, and integrate a virtually frictionless system for moving from data to decision, action to results! Scope it out, pick your tools, learn to listen, get the metrics right, and then distill your digital data for maximum value for everything from R&D to customer service to social media marketing! Prioritize—because you can’t measure and analyze everything Use analysis to craft experiences that profoundly reflect each customer’s needs, expectations, and behaviors Measure real digital media ROI: sales, leads, and customer satisfaction Track the performance of all paid, earned, and owned digital channels Leverage digital data way beyond PR and marketing: for strategic planning, product development, and HR Start optimizing digital content in real time Implement advanced tools, processes, and algorithms for accurately measuring influence Make the most of surveys, focus groups, and offline research synergies Focus new marketing investments where they’ll deliver the most value • Identify and understand your most important audiences across the digital ecosystem “Chuck and Ken lead marketers clearly and efficiently through the minefield of digital marketing measurement. And they do so with a lightness of touch and absence of jargon so rare in this overhyped, much-misunderstood ecosystem.” —Sam Knowles, Founder & MD of Insight Agents; author of Narrative by Numbers: How to Tell Powerful & Purposeful Stories with Data
Author: Stephan Sorger
Marketing Analytics: Strategic Models and Metrics offers marketing students and professionals a practical guide to strategic decision models and marketing metrics. The tools described in the book will aid marketers in making intelligent decisions to drive revenue and results in their organizations. The book contains a wealth of information on marketing analytics: Almost 500 pages of text, covering a wide variety of decision models and metrics Nearly 400 figures, including diagrams, tables, and charts Step-by-step instructions on market segmentation, conjoint analysis, and other techniques Current examples demonstrating how organizations are applying models and metrics The list of chapters below includes a sample of the topics: Chapter 1. Introduction - Introduction to marketing analytics Chapter 2. Market Insight - Market sizing and trend analysis Chapter 3. Market Segmentation - Segment identification, analysis, and strategy Chapter 4. Competitive Analysis - Competitor identification, analysis, and strategy Chapter 5. Business Strategy - Analytics-based strategy selection Chapter 6. Business Operations - Forecasting, predictive analytics, and data mining Chapter 7. Product and Service Analytics - Conjoint analysis and product/service metrics Chapter 8. Price Analytics - Pricing techniques and assessment Chapter 9. Distribution Analytics - Analytics-based channel evaluation and selection Chapter 10. Promotion Analytics - Promotion budget estimation and allocation Chapter 11. Sales Analytics - Metrics for sales, profitability, and support Chapter 12. Analytics in Action - Pivot tables and data-driven presentations Edition: First Edition, Version 1.1, introduced November 2013. Revision 1.1 incorporates minor corrections and edits. It retains the same layout as the original release (First Edition, Version 1.0). See StephanSorger.com for a complete record of all changes.
Author: Mike Grigsby
Publisher: Kogan Page Publishers
Who is most likely to buy and what is the best way to target them? Marketing Analytics enables marketers and business analysts to answer these questions by leveraging proven methodologies to measure and improve upon the effectiveness of marketing programs. Marketing Analytics demonstrates how statistics, analytics and modeling can be put to optimal use to increase the effectiveness of every day marketing activities, from targeted list creation and data segmentation to testing campaign effectiveness and forecasting demand. The author explores many common marketing challenges and demonstrates how to apply different data models to arrive at viable solutions. Business cases and critical analysis are included to illustrate and reinforce key concepts throughout. Beginners will benefit from clear, jargon-free explanations of methodologies relating to statistics, marketing strategy and consumer behaviour. More experienced practitioners will appreciate the more complex aspects of data analytics and data modeling, discovering new applications of various techniques in every day practice. Readers of Marketing Analytics will come away with a firm foundation in markets analytics and the tools they need to gain competitive edge and increase market share. Online supporting resources for this book include a bank of test questions as well as data sets relating to many of the chapters.
Author: Conrad Carlberg
Publisher: Que Publishing
EXCEL 2016 PREDICTIVE ANALYTICS FOR SERIOUS DATA CRUNCHERS! Now, you can apply cutting-edge predictive analytics techniques to help your business win–and you don’t need multimillion-dollar software to do it. All the tools you need are available in Microsoft Excel 2016, and all the knowledge and skills are right here, in this book! Microsoft Excel MVP Conrad Carlberg shows you how to use Excel predictive analytics to solve real problems in areas ranging from sales and marketing to operations. Carlberg offers unprecedented insight into building powerful, credible, and reliable forecasts, helping you gain deep insights from Excel that would be difficult to uncover with costly tools such as SAS or SPSS. Fully updated for Excel 2016, this guide contains valuable new coverage of accounting for seasonality and managing complex consumer choice scenarios. Throughout, Carlberg provides downloadable Excel 2016 workbooks you can easily adapt to your own needs, plus VBA code–much of it open-source–to streamline especially complex techniques. Step by step, you’ll build on Excel skills you already have, learning advanced techniques that can help you increase revenue, reduce costs, and improve productivity. By mastering predictive analytics, you’ll gain a powerful competitive advantage for your company and yourself. Learn the “how” and “why” of using data to make better decisions, and choose the right technique for each problem Capture live real-time data from diverse sources, including third-party websites Use logistic regression to predict behaviors such as “will buy” versus “won’t buy” Distinguish random data bounces from real, fundamental changes Forecast time series with smoothing and regression Account for trends and seasonality via Holt-Winters smoothing Prevent trends from running out of control over long time horizons Construct more accurate predictions by using Solver Manage large numbers of variables and unwieldy datasets with principal components analysis and Varimax factor rotation Apply ARIMA (Box-Jenkins) techniques to build better forecasts and clarify their meaning Handle complex consumer choice problems with advanced logistic regression Benchmark Excel results against R results
We have designed this book primarily for the business school student or marketing manager, who, with minimal background and technical training, must understand and employ the basic tools and models associated with Marketing Engineering. The 21st century business environment demands more analysis and rigor in marketing decision making. Increasingly, marketing decision making resembles design engineering—putting together concepts, data, analyses, and simulations to learn about the marketplace and to design effective marketing plans. While many view traditional marketing as art and some view it as science, the new marketing increasingly looks like engineering (that is, combining art and science to solve specific problems). We offer an accessible overview of the most widely used marketing engineering concepts and tools and show how they drive the collection of the right data and information to perform the right analyses to make better marketing plans, better product designs, and better marketing decisions. ** The latest edition includes up-to-date examples and references as well as a new chapter on the digital online revolution in marketing and its implications for online advertising. In addition, the edition now incorporates some basic financial concepts (ROI, Breakeven Analysis, and Opportunity Cost) and other tools essential to the new domain of marketing analytics. **
Marketing Science contributes significantly to the development and validation of analytical tools with a wide range of applications in business, public policy and litigation support. The Handbook of Marketing Analytics showcases the analytical methods used in marketing and their high-impact real-life applications. Fourteen chapters provide an overview of specific marketing analytic methods in some technical detail and 22 case studies present thorough examples of the use of each method in marketing management, public policy, and litigation support. All contributing authors are recognized authorities in their area of specialty.
Applied Business Statistics for Business and Management using Microsoft Excel is the first book to illustrate the capabilities of Microsoft Excel to teach applied statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical statistical problems in industry. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in statistics courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Applied Business Statistics for Business and Management capitalizes on these improvements by teaching students and practitioners how to apply Excel to statistical techniques necessary in their courses and workplace. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand business problems. Practice problems are provided at the end of each chapter with their solutions.
This book is a complete introduction to the power of R for marketing research practitioners. The text describes statistical models from a conceptual point of view with a minimal amount of mathematics, presuming only an introductory knowledge of statistics. Hands-on chapters accelerate the learning curve by asking readers to interact with R from the beginning. Core topics include the R language, basic statistics, linear modeling, and data visualization, which is presented throughout as an integral part of analysis. Later chapters cover more advanced topics yet are intended to be approachable for all analysts. These sections examine logistic regression, customer segmentation, hierarchical linear modeling, market basket analysis, structural equation modeling, and conjoint analysis in R. The text uniquely presents Bayesian models with a minimally complex approach, demonstrating and explaining Bayesian methods alongside traditional analyses for analysis of variance, linear models, and metric and choice-based conjoint analysis. With its emphasis on data visualization, model assessment, and development of statistical intuition, this book provides guidance for any analyst looking to develop or improve skills in R for marketing applications.
Mastering Market Analytics
Author: Robert Kozielski
Publisher: Emerald Group Publishing
In Mastering Market Analytics, Robert Kozielski presents various measurement systems and marketing metrics, along with common mistakes made by organizations and managers in the process of measuring business activities, and illustrates how to avoid these mistakes. The new turbulent business environment has resulted in the decrease in effectiveness and efficiency of marketing activities, resulting in 50% of campaigns in social media remaining unnoticed by the public in 2016 alone. Response rates on emailing campaigns have dropped, one dollar invested in TV advertising generates only .32 cents of return, which all leaves the question of whether these activities are still effective in the contemporary world. What does effective marketing actually mean and which areas can be measured while assessing organizational effectiveness? Do sales and marketing benefit only the company or do they also generate value for customers? With over twenty years of experience in world markets, Kozielski takes lessons and case studies from Eastern Europe to delve into 76 indicators, divided into four groups: sales, distribution, marketing communication, and ecommerce and social media, exploring from both the strategic and operational points of view. Linking applicable descriptions of the metrics with systems of measurement for these marketing activities and results, Kozielski's work is of interest to marketing scholars and MBA students.
This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands on, scenario-focused guide helps you use Excel’s newest tools to ask the right questions and get accurate, actionable answers. This edition adds 150+ new problems with solutions, plus a chapter of basic spreadsheet models to make sure you’re fully up to speed. Solve real business problems with Excel–and build your competitive advantage Quickly transition from Excel basics to sophisticated analytics Summarize data by using PivotTables and Descriptive Statistics Use Excel trend curves, multiple regression, and exponential smoothing Master advanced functions such as OFFSET and INDIRECT Delve into key financial, statistical, and time functions Leverage the new charts in Excel 2016 (including box and whisker and waterfall charts) Make charts more effective by using Power View Tame complex optimizations by using Excel Solver Run Monte Carlo simulations on stock prices and bidding models Work with the AGGREGATE function and table slicers Create PivotTables from data in different worksheets or workbooks Learn about basic probability and Bayes’ Theorem Automate repetitive tasks by using macros