Marketing Model Template - Set Name, MQL, Opp Targets for 2014 and Beyond

Not all marketers like to dive into the numbers, but having an excellent demand generation model tied to company revenue goals is critical for many reasons. This is why I created this easy to customize model which you are free to download and use during your next modeling exercise. All you need to do is enter some basic data points (revenue target, budget, ASP, etc...) and this demand creation model automatically calculates targets for you. I have created models for half a dozen companies or so, and I tried to incorporate all variables and factors that I would want in a marketing model.
Interested in learning how it works? Get a quick walk though:
This marketing model includes custom inputs and calculations to account for:
- Your revenue contribution goals
- Your average sales cycles
- Your average Marketing cycles (name-to-opp)
- Your average sales price (ASP)
- Your pipeline contributions by channel: Inbound - Organic, Inbound - Paid, Marketing Outbound, Referral & Sales Outbound
- Your Conversion rates by channel for each stage: Names, Prospect, MQL, SQL, SAL, Opps, Deals, Pipeline and Revenue/Bookings $'s
- Adjustable seasonality
- Your cost by Name, Prospect, MQL, SQL, SAL, Opp, Meeting, and deal
- Offers top down or bottom up approach to modeling
- Custom rounding settings for all dollar values (from $1-$1,000,000)
- Sales Development Reps (SDR) hiring plan, target and quota calculations
- Account Executive (AE) hiring plan, target and quota calculations
- Excel based so you can edit in any way that you would like
I hope you enjoy and it would be great to get your feedback.
Share:
Thanks,
Chris
by Chris Russell

marketing_model_template.xlsx | |
File Size: | 147 kb |
File Type: | xlsx |