Alison's New App is now available on iOS and Android! Download Now

Marketing Analytics: Customer Value and Promotion Strategy

Discover how to calculate Customer Lifetime Value and sensitivity analysis for your business in this free online course.

Publisher: Start-Tech Academy
Your sales team strives to acquire new customers continually. Do you know what value they will bring to your business in the long-run? Vital business decisions such as product pricing, acquisition cost, and marketing budget should be based on customer lifetime value. How do businesses determine this value? This course teaches you different techniques of customer valuation and sensitivity analysis using Microsoft Excel.
Marketing Analytics: Customer Value and Promotion Strategy
  • Duration

    1.5-3 Hours
  • Students

  • Accreditation






View course modules


An effective marketing strategy to acquire and retain customers is vital to any business. On what do you base this strategy? Do you know how much your customers are worth to your company? If you are a marketing manager or business owner, you would understand that your sales and marketing budget should be based on the revenue that your customers will ultimately generate. However, given the market uncertainties, competition, and other factors, it is not easy to predict this value. Nothing can be worse than an arbitrary budget based solely on your capacity to spend at present, not knowing the current value of future cash flows. Modern businesses, therefore, rely on customer valuation using data analytics to base their business decisions on. Are you one of those who make intelligent and informed decisions on how to spend money on your business? Then this course is for you.

This course teaches you to calculate your Customer’s Lifetime Value (CLV) under varying market conditions and customer scenarios, using simple Excel techniques. You will begin by understanding concepts such as Net Present Value (NPV), Discounted Cash Flow (DCF), and Customer Churn, which are valuable indicators of the health of your business. Using these concepts, you will learn how to predict the lifetime value of a set of customers and how this value helps evaluate the effectiveness of your marketing strategy. You will then learn to take up various uncertain conditions and create a customer lifetime valuation model using Monte Carlo simulation. This model will enable you to estimate a range of outcomes for your marketing decisions. You will learn how to use Excel functionalities to create these models and simulations to get the best results. Going forward, you will be able to create your own Excel templates and tools using these techniques. You will also learn practical applications of these methods through business case examples and some examples in this marketing course have been taken from the book Marketing Analytics: Data-Driven Techniques with Microsoft Excel [Winston, Wayne L.]. This book can serve as good reference material and supplemental reading as well.

In the past, analysts often used mathematical techniques and formulas to calculate CLV and NPV. Now, with a large number of customers and a wide range of uncertainties, it becomes tedious and inaccurate. With the availability of software, it has become easier to use advanced models to predict customer behaviour and increase the company’s profitability. However, you need to know which parameters to consider for simulation and modelling. After completing this course, you will be able to confidently create, incorporate and discuss customer value models used by organizations worldwide. You don’t need any prior knowledge of advanced mathematics or computational skills. All you need are a PC with Excel installed, and basic knowledge of how to open and save Excel files. If you are a marketing professional or entrepreneur, this short course will prove invaluable for you. Enrol now, and within just a couple of hours you can become proficient in using data-driven techniques for business decisions.

Start Course Now