This guide walks through how to build and apply quota attainment models in Runway.
Name
, Title
, Seniority
, Market
, and Start Date
.
months_since_start:
Use dateDiff()
to calculate the difference between their start date and the month evaluated in the model. By wrapping it in an IF()
statement, we can set a floor of 0, which will populate for projected future hires.
monthly_quota:
Start by taking Annual Quota divided by 12:
monthly_quota
data as a driver. You’ll want to segment this data by the granularity you forecast your revenue. In this example, we want to use Market
from our Sales Team but we don’t forecast revenue based on Seniority
like we did in the Sales Team database so we’ll leave that out.