Accurate impact estimations can make or break your business case.<\/strong><\/p>\n Yet, despite its importance, most teams use oversimplified calculations that can lead to inflated projections. These shot-in-the-dark numbers not only destroy credibility with stakeholders but can also result in misallocation of resources and failed initiatives. But there\u2019s a better way to forecast effects of gradual customer acquisition, without requiring messy Excel spreadsheets and formulas that error out.<\/p>\n By the end of this article, you will be able to calculate accurate yearly forecasts and implement a scalable Python<\/a> solution for Triangle Forecasting.<\/p>\n When asked for annual impact estimations, product teams routinely overestimate impact by applying a one-size-fits-all approach to customer cohorts. Teams frequently opt for a simplistic approach:\u00a0<\/p>\n Multiply monthly revenue (or any other relevant metric) by twelve to estimate annual impact.<\/em>\u00a0<\/p>\n While the calculation is easy, this formula ignores a fundamental premise that applies to most businesses:<\/p>\n Customer acquisition happens gradually throughout the year.<\/strong><\/p>\n<\/blockquote>\n The contribution from all customers to yearly estimates is not equal since later cohorts contribute fewer months of revenue.\u00a0<\/p>\n Triangle Forecasting can cut projection errors by accounting for effects of customer acquisition timelines.<\/strong><\/p>\n Let us explore this concept with a basic example. Let\u2019s say you\u2019re launching a new subscription service:<\/p>\n An oversimplified multiplication suggests a revenue of $1,440,000 in the first year (= 100 new customers\/month * 12 months * $100 spent \/ month * 12 months).<\/p>\n The actual number is only $780,000!\u00a0<\/p>\n This 46% overestimation is why impact estimations frequently do not pass stakeholders\u2019 sniff test.<\/strong><\/p>\n Accurate forecasting is not just about mathematics\u200a\u2014\u200a<\/p>\n It is a tool that helps you build trust and gets your initiatives approved faster without the risk of over-promising and under-delivering.<\/p>\n<\/blockquote>\n Moreover, data professionals spend hours building manual forecasts in Excel, which are volatile, can result in formula errors, and are challenging to iterate upon.\u00a0<\/p>\n Having a standardized, explainable methodology can help simplify this process.<\/p>\n Triangle Forecasting is a systematic, mathematical approach to estimate the yearly impact when customers are acquired gradually. It accounts for the fact that incoming customers will contribute differently to the annual impact, depending on when they onboard on to your product.\u00a0<\/p>\n This method is particularly handy for:<\/p>\n The \u201ctriangle\u201d in Triangle Forecasting refers to the way individual cohort contributions are visualized. A cohort refers to the month in which the customers were acquired. Each bar in the triangle represents a cohort\u2019s contribution to the annual impact. Earlier cohorts have longer bars because they contributed for an extended period.<\/p>\n To calculate the impact of a new initiative, model or feature in the first year\u00a0:<\/p>\n 2. Total yearly impact = Sum of all monthly cohort impacts<\/p>\n Let\u2019s calculate the actual revenue for our subscription service:<\/p>\n Calculating in Excel, we get:<\/p>\n The total annual revenue equals $780,000<\/strong>\u2014 46% lower than the oversimplified estimate!<\/p>\n Need to build estimates without perfect data? Read my guide on \u201cBuilding Defendable Impact Estimates When Data is Imperfect\u201d.<\/p>\n While we can implement Triangle Forecasting in Excel using the above method, these spreadsheets become impossible to maintain or modify quickly. Product owners also struggle to update forecasts quickly when assumptions or timelines change.<\/p>\n Here\u2019s how we can perform build the same forecast in Python in minutes:<\/p>\n Continuing with our previous example of subscription service, the revenue from each monthly cohort can be visualized as follows:<\/p>\n We can also leverage Python to visualize the cohort contributions as a bar chart. Note how the impact decreases linearly as we move through the months.\u00a0<\/p>\n Using this Python code, you can now generate and iterate on annual impact estimations quickly and efficiently, without having to manually perform version control on crashing spreadsheets.<\/p>\n While the above example is straightforward, assuming monthly acquisitions and spending are constant across all months, that need not necessarily be true. Triangle forecasting can be easily adapted and scaled to account for\u00a0:<\/p>\n For varying monthly spend based on spend tiers, create a distinct triangle forecast for each cohort and then aggregate individual cohort\u2019s impacts to calculate the total annual impact.<\/p>\n Typically, businesses don\u2019t acquire customers at a constant rate throughout the year. Acquisition might start at a slow pace and ramp up as marketing kicks in, or we might have a burst of early adopters followed by slower growth. To handle varying rates, pass a list of monthly targets instead of a single rate:<\/p>\n To account for seasonality, multiply each month\u2019s impact by its corresponding seasonal factor (e.g., 1.2 for high-season months like December, 0.8 for low-season months like February, etc.) before calculating the total impact.<\/p>\n Here is how you can modify the Python code to account for seasonal variations:<\/p>\n These customizations can help you model different growth scenarios including:<\/p>\n Having dependable and intuitive forecasts can make or break the case for your initiatives.\u00a0<\/p>\n But that\u2019s not all\u200a\u2014\u200atriangle forecasting also finds applications beyond revenue forecasting, including calculating:<\/p>\n Ready to dive in?<\/strong> Download the Python template shared above and build your first Triangle forecast in 15 minutes!\u00a0<\/p>\n Real-world estimations often require dealing with imperfect or incomplete data. Check out my article \u201cBuilding Defendable Impact Estimates When Data is Imperfect\u201d for a framework to build defendable estimates in such scenarios.<\/em><\/p>\n Acknowledgement:<\/strong><\/p>\n Thank you to my wonderful mentor, Kathryne Maurer<\/a>, for developing the core concept and first iteration of the Triangle Forecasting method and allowing me to build on it through equations and code.<\/p>\n<\/blockquote>\n I\u2019m always open to feedback and suggestions on how to make these guides more valuable for you. Happy reading!<\/p>\n The post Triangle Forecasting: Why Traditional Impact Estimates Are Inflated (And How to Fix\u00a0Them)<\/a> appeared first on Towards Data Science<\/a>.<\/p>\n<\/div>\nThe Hidden Cost of Inaccurate Forecasts<\/h2>\n
\n
\n
\n
Introducing Triangle Forecasting<\/h2>\n
\n
![\"\"](\"https:\/\/i0.wp.com\/towardsdatascience.com\/wp-content\/uploads\/2025\/02\/1_RFR0uRaIDICAu3BYW-R8oA.png?resize=683%2C786&ssl=1\")
\n
\n
![\"\"](\"https:\/\/i0.wp.com\/towardsdatascience.com\/wp-content\/uploads\/2025\/02\/1_ge8FeqocLEEWMOb3dKoSGA-1024x395.png?resize=1024%2C395&ssl=1\")
Building Your First Triangle\u00a0Forecast<\/h3>\n
\n
![\"\"](\"https:\/\/i0.wp.com\/towardsdatascience.com\/wp-content\/uploads\/2025\/02\/1_FU-C57cElTFCw7cW5Q2znA-1024x379.png?resize=1024%2C379&ssl=1\")
![\"\ud83d\udca1\"](\"https:\/\/i0.wp.com\/s.w.org\/images\/core\/emoji\/15.0.3\/72x72\/1f4a1.png?ssl=1\")
Pro Tip: Save the spreadsheet calculations as a template to reuse for different scenarios.<\/strong><\/p>\nPutting Theory into Practice: An Implementation Guide<\/h3>\n
import pandas as pd\nimport numpy as np\nimport matplotlib.pyplot as plt\n\ndef triangle_forecast(monthly_acquisition_rate, monthly_spend_per_customer):\n \"\"\"\n Calculate yearly impact using triangle forecasting method.\n \"\"\"\n # Create a DataFrame for calculations\n months = range(1, 13)\n df = pd.DataFrame(index=months, \n columns=['month', 'new_customers', \n 'months_contributing', 'total_impact'])\n\n # Convert to list if single number, else use provided list\n acquisitions = [monthly_acquisitions] * 12 if type(monthly_acquisitions) in [int, float] else monthly_acquisitions\n \n # Calculate impact for each cohort\n for month in months:\n df.loc[month, 'month'] = f'Month {month}'\n df.loc[month, 'new_customers'] = acquisitions[month-1]\n df.loc[month, 'months_contributing'] = 13 - month\n df.loc[month, 'total_impact'] = (\n acquisitions[month-1] * \n monthly_spend_per_customer * \n (13 - month)\n )\n \n total_yearly_impact = df['total_impact'].sum()\n \n return df, total_yearly_impact<\/code><\/pre>\n# Example\nmonthly_acquisitions = 100 # 100 new customers each month\nmonthly_spend = 100 # $100 per customer per month\n\n# Calculate forecast\ndf, total_impact = triangle_forecast(monthly_acquisitions, monthly_spend)\n\n# Print results\nprint(\"Monthly Breakdown:\")\nprint(df)\nprint(f\"nTotal Yearly Impact: ${total_impact:,.2f}\")<\/code><\/pre>\n![\"\"](\"https:\/\/i0.wp.com\/towardsdatascience.com\/wp-content\/uploads\/2025\/02\/1_fMOIBuqustAE-8LJ3OxREw.png?resize=984%2C560&ssl=1\")
![\"\"](\"https:\/\/i0.wp.com\/towardsdatascience.com\/wp-content\/uploads\/2025\/02\/1_HwG1tqn-DOhCcw3HLGxCuQ-1024x501.png?resize=1024%2C501&ssl=1\")
Beyond Basic Forecasts\u00a0<\/h2>\n
\n
\n
# Example: Gradual ramp-up in acquisitions\nvarying_acquisitions = [50, 75, 100, 150, 200, 250, \n 300, 300, 300, 250, 200, 150]\ndf, total_impact = triangle_forecast(varying_acquisitions, monthly_spend)<\/code><\/pre>\n![\"\"](\"https:\/\/i0.wp.com\/towardsdatascience.com\/wp-content\/uploads\/2025\/02\/1_0OUo4p2rBIyc0cgjPgR4og.png?resize=978%2C564&ssl=1\")
\n
import pandas as pd\nimport numpy as np\nimport matplotlib.pyplot as plt\n\ndef triangle_forecast(monthly_acquisitions, monthly_spend_per_customer, seasonal_factors = None):\n \"\"\"\n Calculate yearly impact using triangle forecasting method.\n \"\"\" \n # Create a DataFrame for calculations\n months = range(1, 13)\n df = pd.DataFrame(index=months, \n columns=['month', 'new_customers', \n 'months_contributing', 'total_impact'])\n\n # Convert to list if single number, else use provided list\n acquisitions = [monthly_acquisitions] * 12 if type(monthly_acquisitions) in [int, float] else monthly_acquisitions\n\n if seasonal_factors is None:\n seasonality = [1] * 12\n else:\n seasonality = [seasonal_factors] * 12 if type(seasonal_factors) in [int, float] else seasonal_factors \n \n # Calculate impact for each cohort\n for month in months:\n df.loc[month, 'month'] = f'Month {month}'\n df.loc[month, 'new_customers'] = acquisitions[month-1]\n df.loc[month, 'months_contributing'] = 13 - month\n df.loc[month, 'total_impact'] = (\n acquisitions[month-1] * \n monthly_spend_per_customer * \n (13 - month)*\n seasonality[month-1]\n )\n \n total_yearly_impact = df['total_impact'].sum()\n \n return df, total_yearly_impact\n\n# Seasonality-adjusted example \nmonthly_acquisitions = 100 # 100 new customers each month\nmonthly_spend = 100 # $100 per customer per month\nseasonal_factors = [1.2, # January (New Year)\n 0.8, # February (Post-holiday)\n 0.9, # March\n 1.0, # April\n 1.1, # May\n 1.2, # June (Summer)\n 1.2, # July (Summer)\n 1.0, # August\n 0.9, # September\n 1.1, # October (Halloween) \n 1.2, # November (Pre-holiday)\n 1.5 # December (Holiday)\n ]\n\n# Calculate forecast\ndf, total_impact = triangle_forecast(monthly_acquisitions, \n monthly_spend, \n seasonal_factors)<\/code><\/pre>\n![\"\"](\"https:\/\/i0.wp.com\/towardsdatascience.com\/wp-content\/uploads\/2025\/02\/1_8NWM7hoKjaUi3TbSGDZdpw-1024x501.png?resize=1024%2C501&ssl=1\")
\n
The Bottom\u00a0Line<\/h2>\n
\n
\n
\n