Keyword | CPC | PCC | Volume | Score | Length of keyword |
---|---|---|---|---|---|
mcdowell county schools | 1.89 | 0.4 | 6371 | 82 | 23 |
mcdowell | 0.74 | 0.5 | 988 | 76 | 8 |
county | 1.51 | 0.3 | 6180 | 1 | 6 |
schools | 0.1 | 0.6 | 3196 | 39 | 7 |
Keyword | CPC | PCC | Volume | Score |
---|---|---|---|---|
mcdowell county schools | 0.24 | 0.1 | 1219 | 3 |
mcdowell county schools nc | 1.51 | 0.9 | 6364 | 79 |
mcdowell county schools wv | 1.9 | 0.9 | 6326 | 80 |
mcdowell county schools marion nc | 0.43 | 0.8 | 6573 | 61 |
mcdowell county schools calendar | 0.04 | 0.6 | 7468 | 68 |
mcdowell county schools welch wv | 1.61 | 0.7 | 6488 | 41 |
mcdowell county schools wv facebook | 0.42 | 0.4 | 3388 | 70 |
mcdowell county schools website | 1.33 | 0.4 | 3175 | 6 |
mcdowell county schools jobs | 0.2 | 0.5 | 7259 | 18 |
mcdowell county schools closing | 0.89 | 0.4 | 1048 | 84 |
mcdowell county schools menu | 1.82 | 0.2 | 1721 | 83 |
mcdowell county schools overview | 0.87 | 0.1 | 5592 | 31 |
mcdowell county schools calendar 24-25 | 0.13 | 0.3 | 5883 | 48 |
mcdowell county schools wv calendar | 1.26 | 0.6 | 1654 | 47 |
mcdowell county schools nc jobs | 1.05 | 0.4 | 9756 | 58 |
chad marsh mcdowell county schools | 0.23 | 0.9 | 7998 | 95 |
riverview high school mcdowell county wv | 1.66 | 1 | 3504 | 97 |
https://apps.apple.com/us/app/lead-to-win-simplified-sales-pipeline-tracker/id1183723071
Mar 02, 2017 . Lead To Win! is a sales pipeline tracker using a simplified pipeline - Lead (+), Prospect (!), Won (checkmark), and Lost (X). All information is kept locally on the device, fully integrated with the Contacts & Calendar apps and no account registration is required to … Category: Productivity
Category: Productivity
DA: 83 PA: 31 MOZ Rank: 16
https://spotio.com/blog/sales-pipeline-metrics/
1. # New Qualified Leads per week 1. # New Qualified Leads per week This is the first step that needs to be tracked in the pipeline. You can’t close deals if you don’t first fill the pipeline with qualified leads. I.e. people who are ready, willing and able to buy. Image: Executive report inside SPOTIO showing the number of new leads created by users and territory over time. This metric allows you to answer questions such as: How well are generating new leads? Based on historical conversion rates, does the company have enough lead volume to hit revenue goals? Are sales reps focusing too much on lead quantity at the expense of quality? A healthy pipeline is one that’s consistently filled with new leads. For many companies, such as , the number of new qualified leads is the most important metric. CEO Ben Walker shared the following: “Most of our sales are very timely in nature, meaning people want transcription services now. We’ve been doing this for 10 years now and that is the best metric we have. So we simplified it and go with one very simple percentage: how many leads did we get and how many did we close on a monthly basis. That’s it and that’s all we need to know about our company and industry.” It may not be as simple for your company, but this metric can’t be overlooked.2. # New Opportunities per week 2. # New Opportunities per week Sales opportunities are the next step in the pipeline. An opportunity is a qualified contact. They’ve expressed interest in your product or service, spoke with you (or someone on your team), and are interested in learning more (via a proposal or presentation). Every opportunity starts as a lead, but the people in this stage of your pipeline are more interested in moving forward. Generally speaking, a higher number of qualified leads should translate into hot sales opportunities. There’s no one-size-fits-all formula for calculating new opportunities. This varies from person to person and company to company. For example, you may move a prospect from lead to opportunity once they book a demo. Conversely, another company may not consider a prospect an opportunity until they request a formal proposal.3. # New Meetings Booked 3. # New Meetings Booked A booked meeting is typically defined as a face-to-face encounter, but in today’s environment, it can come in other virtual forms, such as a Zoom meeting or conference call. This metric is important because it signifies the number of serious opportunities in the pipeline. A booked meeting is often the final step in the process. To track the number of new meetings booked, first start by defining what a meeting is, and then add it to your .4. # New Closed Deals 4. # New Closed Deals A closed deal is the final step in the pipeline. A deal is closed when you have a signed contract in hand or the prospect has made payment. A verbal agreement is good, but it’s not yet a done deal. Closed deals translate directly into revenue. Sales organizations should track this metric both the rep and team levels to get a more granular understanding of strengths and weaknesses in the sales process. Image: SPOTIO sales leaderboard showing the top reps by win rate, leads won, value won and number of sales activities completed. Closed deals can answer a number of questions, including: Who are the top performers? Are deals stalling late in the sales cycle? Why? Are there training opportunities that can help close more deals? With the number of new closed deals trending in the right direction, an increase in revenue will follow.5. Lead-Opportunity Conversion Rate 5. Lead-Opportunity Conversion Rate Image: SPOTIO report showing the conversion rate between each stage in the pipeline for a field sales team. Remember: it’s not just the number of new leads, it’s the number of new qualified leads. Lead to opportunity conversion rate tells you two things: The quality of the leads How efficiently a sales team is converting leads into opportunities Qualified leads have a much greater chance of turning into an opportunity, as well as a booked meeting and closed deal. Calculate this by dividing the number of opportunities by the overall number of leads. For example, if 10 leads out of 100 move to the opportunity stage, the lead to opportunity conversion rate is 10 percent. The higher the rate, the better the lead qualification process. If you have a high number of qualified leads that don’t convert into opportunities, it may be a sign of deeper issues such as poor product-market fit, a weak value proposition, or inadequate sales training. The point is, this metric can help you quickly isolate where the breakdown (or bottleneck) is occurring.6. Win Rate % 6. Win Rate % Win rate is the percentage of leads that convert to sales. It’s important to track this pipeline metrics over a specific period of time, such as monthly, quarterly or annually, so you can track progress. Eric Quanstrom, CMO of , noted that he watches closed deals more than anything, but that this impacts other levels of the pipeline: “We have a waterfall of conversion rates for each sales stage prior. A big conversion rate number is Discovery call to Closed Won (overall CR%) of our 5-step sales process. Win rate percentage is calculated by dividing the number of closed deals by the number of leads, opportunities, or meetings. It can also be calculated at each stage in the pipeline. For example: 100 leads and 3 closed deals = win rate of 3 percent 25 opportunities and 3 closed deals = win rate of 12 percent If you notice a low or declining win rate percentages at a specific stage in the pipeline, it’s important to identify why, and then quickly formulate a plan to improve the conversion path. Conversely, if you have a high win rate, but sales overall sales have fallen off, it may signal that there is actually a prospecting or marketing problem. Dig deeper by calculating win rate percentage by channels or activities, such as cold calls and cold email. This provides a better idea of which source is generating the highest number of leads, opportunities and/or deals.7. Deal Loss Reasons 7. Deal Loss Reasons Losing the deal hurts. But, it shouldn’t be treated as a lost cause. Use it as an opportunity to learn why you lost the deal, and use those insights to improve the sales process. Was it price? Poor value proposition? Feature gap? Customer service? SPOTIO allows you to easily track the reason for every lost deal, which provides an opportunity to adjust your strategy and/or reallocate training resources. Closed deals are way more exciting than losses, but don’t miss out on an invaluable learning experience. Use the insights to ensure you don’t make the same mistake twice.8. Average Sales Cycle 8. Average Sales Cycle This is the length of time it takes to move a lead from initial contact to a closed deal. If it takes too long for a lead to move through each stage of the sales pipeline, it can slow pipeline velocity (more on this below). Calculating the sales cycle length for a particular deal is as simple as calculating the time interval between: When the first contact was first made When was the deal closed If you want to then calculate the average sales cycle length, you simply divide the aggregate total days to close by the number of closed deals. For example: if it took 100 days to close 20 different deals, your average sales cycle length is 5 days. Once a baseline metric is set, you can use it to pinpoint stagnate deals, and divert more resources to those, especially if they are at a later stage in the pipeline.9. Average Deal Size 9. Average Deal Size The average value of a won deal will impact your sales strategy, as well as the velocity of your pipeline. Typically, larger deals are slower to convert, as there’s more money on the line and more people involved in the decision making process. Conversely, smaller deals move much more quickly. Calculate average deal size by adding together the value of all closed deals and dividing it by the number of deals. Here’s an example: $1,000,000 in value/50 closed deals = average deal size of $20,000 Understanding this metric allows you to pinpoint the deal size that converts most often. This helps you target leads with a budget that fits.10. Sales Velocity 10. Sales Velocity Pipeline velocity is the speed at which a lead moves through your sales pipeline. As a general rule of thumb, faster is better. The sooner a lead converts, the sooner you can allocate resources to other prospects. Here’s the formula for calculating sales velocity: The number of deals in your pipeline x the overall win rate percentage x average deal size ($) / length of sales cycle (days) For example: Suppose you have 100 opportunities in your sales pipeline. Your average win rate is 30%, and your average deal size is $5,000. Your average sales cycle is 20 days. Your pipeline velocity = 100 x .3 x 5,000 / 20, or $7,500. This means that every day your company has $7,500 moving through the pipeline. In order to increase your sales pipeline velocity, you’ll need to improve at least one of the levers in the equation. I.e. improve your win rate percentage, increase the deal size, or reduce the average sales cycle. Sales pipeline velocity can provide countless insights. Angela Ash, Digital Marketing Specialist at Flow SEO, shared how understanding sales velocity can help customize outreach: The sales velocity allows you to see the revenue that your sales team brings in on a daily basis – as opposed to an overall total. Knowing this can help you to see which times of the month are more productive than others. This can be important when it comes to anything from applying more outreach on certain days of the week to optimal weeks to encourage team members to take vacation time.”11. Total Pipeline Value (By Stage) 11. Total Pipeline Value (By Stage) Image: SPOTIO report showing the total value of pipeline leads broken out by users and territories over time. Add up the total value of every deal in the pipeline. This is your total pipeline value. The higher the number the better, as it provides more opportunity to generate more revenue. However, you can’t expect every deal to close. And even if they do, they won’t all close on the same day. Taking this one step further, break down total pipeline value by stage: lead, opportunity, and meetings booked. As you make your way toward the end of the pipeline, you’ll typically find the total value declining. However, these prospects are also closest to signing on the dotted line. Tip: use total pipeline value to compare sales rep performance.12. CLV:CAC Ratio 12. CLV:CAC Ratio Customer lifetime value (CLV) and customer acquisition cost (CAC) are two unique metrics that go hand in hand. This ratio helps you understand your return on investment. A higher number is always better, with a ratio of 1:1 as low as you want to see. With a CLV:CAC ratio of 1:1, it means your customer pays you the same amount that it takes to acquire them. In other words, you break even. If your ratio is less than 1:1, it means you’re paying more to acquire customers than they’re paying you. You’re burning money. You must track two data points to calculate this metric: The amount of money you pay to acquire a customer The total lifetime value of the customer With these numbers, you can then use the following formula to accurately calculate your ratio: CAC = the total acquisition spend/the number of customers acquired Evaluate this number at an activity or channel level to ensure your dollars are invested in areas that are having the biggest impact on the bottom line.13. # of Referrals 13. # of Referrals There’s nothing more valuable than referrals. Not only do these prospects come highly recommended, but you don’t have to spend any resources – time or money – to acquire them. By providing current clients with an extraordinary experience and/or incentivizes, you can generate regular referrals. Alex Birkett, a co-founder of , describes why referrals are so important: “The referral rate is probably the most important and underrated metric, because it means the prospects are both well-qualified for our business and they’re happy enough that they tell their well-qualified friends.” Chad Burmeister | CEO # of New Pipeline Opportunities Created / Week – This gives a leading indicator of the health of future closed/won deals. # of Closed/Won Opportunities/Week – This shows the number of united signed per week (is it moving up, down, or flat). % Win Rate – This shows the health of the sales effort. # of Revenue New Customers /week – This shows how many net new deals we’re signing. Baseline is 2/week. If we fall below that, it’s bad. When we increase, that’s good. # of Cross-Sell Up-sell Customers Signed/Week – This helps us understand the health of our solution. Baseline is 1.7/week. If we’re constantly adding add-on orders within our customer base, that’s a good thing. Why do we do this? Because we’re part of Unstoppable Sunday by TK Kader, and in his courses, he shows us how to track all of these metrics. He did this for ToutApp, and Marketo, and had a successful exit as a result. Bob Apollo | Founder Monitoring the health of the sales pipeline is a critical function. We’ve found the following to be particularly useful. They are measured at the overall sales organisation, sales team and individual salesperson level: Value and Volume (# active opportunities) of the pipeline, both overall and by stage, plus the trends in these numbers: provides a “high level overview” Velocity of Individual Opportunities: time since created, plus time in current stage, both benchmarked against winning deal precedents – strong opportunities move faster than weak opportunities Formal, Evidence-based Opportunity Qualification Score: deal level qualification against defined criteria is critical to assessing probability of winning Source of Close Date: customer must act by this date, customer hopes to act by this date, or salesperson hopes for order by this date – we also look for the number of times the date has changed: more changes = less confidence Win Rates: Opportunity Value vs. Plan, Actual Close Date vs. Plan Note that we don’t believe in the mythical “3 times pipeline coverage” standard. In our experience, win rates (and time-to-close) varies significantly between net new business, new projects in existing customers, add-ons to existing projects, migrations and renewals. Different benchmarks must be established for each. Kerry Beeby | Director We love to look at the number of clients that turn into repeat business for us. Once we’ve started to build a relationship with a client on their first project, they often come back to us and ask for our services again. With this data, we can then start to look at how well we’re able to gain repeat customers and why they come back to us so often for their next project. After we start to figure out the formula for promoting reoccurring clients, we can start to apply that formula to a number of other clients. Eric Quanstom | CMO Closed Won Deals — obvious importance, but we have a waterfall of conversion rates for each sales stage prior. A big conversion rate number is Discovery call to Closed Won (overall CR%) of our 5-step sales process. Alex Birkett | Co-founder Since we’re a small agency, we need to guard our time resources most strictly. Therefore, common sales pipeline metrics like response rates or meetings booked are actually not great for us. We don’t have the resources to spend on meetings that don’t convert to sales. So we basically only look at three metrics: Qualified meetings booked (they have to reach all of our sales qualification dimensions) Signed proposal (this is when the client closes) Referral rate (this incentivizes us to do a really awesome job for current clients instead of spending all our time trying to fill the top of the funnel). The referral rate is probably the most important and underrated metric, because it means the prospects are both well-qualified for our business and they’re happy enough that they tell their well-qualified friends. Kristie Jones | Principal New deals added to the pipeline each month. Consistent filling of the top of the funnel is critical for consistent revenue. New deals added to the should at a min. cover what is coming out of the pipeline from Closed/Won and Closed/Lost. Use each sales reps “sales math” to determine how many deals need to be in the pipeline at all times. For example: 20% close rate/ Ave. sales of $10,000/ Quarterly Quota of $250K 125 deals being worked each quarter to sell 25 at an ave. sales of $10,000 On average, you’ll need 50-60 deals in the pipeline all time Mica Longanecker | Director of Business Develpoment SQL to Demo SQL Ratio to make sure SQLs are getting demos SQL to Opportunities to make sure the SQLs are converting to Opportunities Sales Activity (Calls, Demos, Emails) to make sure reps are hitting activity targets Pipeline stages to forecast revenue and understand current capacity Ben Walker | CEO How many leads we close is pretty much all we track. Most of our sales are very timely in nature, meaning people want transcription services now, so they either go with us or go with another company. We’ve been doing this for 10 years now and that is the best metric we have after dabbling with a lot of other numbers and variations on follow up calls and emails. So we simplified it and go with one very simple percentage, how many leads did we get and how many did we close on a monthly basis. That’s it and that’s all we need to know for our company and industry. Dario Sipos | Digital Marketing Strategist Customer acquisition cost is a measure of how much it costs in sales and marketing to get a new customer. We want this number to be as low as possible, so we monitor it closely. Jessica Magoch | CEO, Sales Coach Offers made to deals closed. We train our people to have the patience and discipline to not present an offer to everyone. We want them to truly verify the product is a good fit and that it is the right time to present a solution, meaning the decision makers are present and that budget and urgency have been established. Presenting at the right time helps capitalize on what we know about emotions and how they play a role in the decision making process – thus, it leads to higher conversion rates overall and a greater impact for the good we can do. The second mostly highly focused on metric is referrals. When a salesperson is other-centered and goes above and beyond for their clients, they stand out from the rest. This is reflected in the number of referrals they generate from each conversation, and encourages them to keep reminding customers of the importance of word of mouth business. Finally, I look at average revenue per sale to make sure the salesperson is not leaning on the price of lower priced products to earn the sale, and to help them overcome any internal objections they may have about the pricing of our premium products. Seb Dean | Director One of our biggest metrics that we record is the time taken to convert a potential client into a paying client. We track this because we can then review the data and look at how we can speed up the sales process without putting any pressure of the client. This also shows us which areas that we might be least efficient inso that we can start to develop our processes and become a more time efficient company. We also track average order value which means that we’re able to look at the way in which we spend money on advertising and compare that you the value that each lead is likely to bring. We do this because we can look into how we’re targeting and maybe move towards a new market or segment to increase the average order value. James Lewin | Sales & Marketing Manager Our biggest metric that we track at the moment is the conversion rate of out ecommerce site. Knowing how many people we have managed to turn from a potential buyer into a real, paying customer helps us to better understand the way that users interact with our website as we perform A/B tests. If we find that having a certain colour for the ‘add to cart’ button converts better than the previous colour, we’ll change it on the website and test another colour. We also often look at the revenue produced by each of our A/B tests of our sales pipeline too. We do this because, although the conversion rate might be higher on one of the variations, the revenue created may be a lot lower at the same time. This then defeats the point of an ecommerce website. Any King | Director We look at our retention rate of customers so that we can see where we might not be as effective. For example: if we end up losing a client due to their own cash flow problems then this isn’t connected to us. But if they tell us that we haven’t offered enough leads or that they aren’t happy with the amount of communication between us then this is obviously something that we need to be changing. This is where we’re then able to reflect on our history with the company and analyse what might have gone wrong or why they might be closing their account with us. We also often look at the lifetime value of each of our clients. This is going to give us a good indicator of how each one of our clients will be spending their money with us and the way in which they’re likely to help us grow. We can then start to target different segments depending on which type of client is likely to be a high or low performing audience. Richard Harris | Founder This is one of my favorite strategies around KPIs. Specifically with new hires and onboarding. I want to try and focus on conversions. Conversion from outreach to first meeting set First meeting set to 2nd meeting 2nd Meeting to Next meeting While this is more of a lagging indicator, I think it’s important so you can then focus in on messaging and improving it quickly, especially during an onboarding process. I do like running reports off these semi-regularly for fully ramped AEs as well. This helps me look for overall areas of improvement, market trends, etc. Jeni Wehrmeyer | COO/CMO Ducks (meetings with potential decision makers). Stage 1: Uncovered compelling reasons to buy Stage 2: Has capacity (time, money, resources) to fix Stage 3: Present/Proposal Sent/Delivered Stage 4: SOW sent/delivered Stage 5: Deal sold Spencer Smith | CEO Right now we’re tracking number of total touch points and number of emails sent and received. They’re all very basic metrics but they really help keep a pulse on cold outreach efforts. Total touch points tell us a rep’s activity level and number of possible sales opportunities whereas number of emails sent tells us how individual rep outbound effort is for the day. Number of emails received tells us how well those emails are faring (i.e. response rate). Thomas Allen | Founder Where the lead came from, and if enough leads come through from that source, we can tailor content to increase those leads coming from that source. It’s a green light to do more in that area and that leads are coming through from it. Kim Orlesky | President New Deals Created. Deals come and deals go. Timing is everything and if we start a deal with a client and expect it to go right up until closed, we end up putting all our eggs in one basket. It’s better to see are we constantly creating new deals, and are the new deals created more than the deals that are closed won or lost. This way if we ever have a bad month we can always go right back to our pipeline and see if there are any deals that aren’t quite at the closed stage yet and see if we can push them over the edge and get them signed up Nicole Suther | Marketing Manager Qualified monthly new leads to customer conversion rate. This metric helps us identify where gaps are within our sales process to help close more deals. If we are not closing on our qualified leads, we want to identify what is happening and what processes can we put into place to help close more deals. We also look at customer value and compare it to the cost of acquiring the customer. This takes in our marketing spend as well as the sales time to close. Looking at this metric helps us make better decisions on how to keep each deal profitable. Andrew Ruditser | Co-Founder & Lead Technology Coordinator I follow several vital sales pipeline metrics, and each one of them offers our agency with valuable pieces of insight. I’ll include three sales pipeline metrics that we follow closely. Track all New Gained Opportunities: This metric is what fuels a sales pipeline. It is crucial to understand how many new leads and prospects added to our sales pipeline and where they came from. Track the Qualification of all Leads: It’s essential to know how many new opportunities actually turn into qualified leads. Without this metric, it is impossible to determine whether the quality of your outreach efforts are worth it or not. Track the Number of Wins: This is arguably the most powerful of all metrics. Understanding the percentage of wins based on the number of opportunities gained is crucial. These numbers will portray how well your sales team performs and where you can make the necessary adjustments to be more successful. Robert Bedell | Outsourced VP of Sales Results – That is what you want in the end. If you measure calls, the team will make the number of calls you want. But what if it results in no sales? If you measure meetings, they will get the meetings. What if they result in no sales? You get the idea. Measure what you really want, results. They will make the calls, set the meetings, etc., they need to to get the results you want. Chris Gadek | Head of Growth & Marketing For us, the win rate equals the bottom line, which will determine if our sales and marketing strategies can be considered successful. This is important because, if things aren’t going according to plan, continuous monitoring will provide us with the data required to make a pivot and implement a new campaign. Carrie McKeegan | CEO and Co-Founder The win rate is a highly important sales pipeline metric, as it helps to establish how successful you are at “winning” new opportunities. This can enable you to see if you need to adjust the manner in which you gather leads, or if you need to implement new closing strategies. Andrea Loubier | Founder We like to really focus on new opportunities. Being able to understand where our opportunities for sales are coming from can help us to create better campaigns in the future, whether it be for outreach, email marketing or creating new content. Alexandra Zamolo | Head of Content Marketing Qualified leads can really be an eye-opener when it comes to monitoring our lead generation process. When doing outreach to gain leads, it’s imperative to understand when we’re being successful, or if we’re just spinning our wheels. Innovation is key to finding qualified leads, so that we can pivot when needed to convert these leads into sales. Angela Ash | Digital Marketing Specialist The sales velocity allows you to see the revenue that your sales team brings in on a daily basis – as opposed to an overall total. Knowing this can help you to see which times of the month are more productive than others. This can be important when it comes to anything from applying more outreach on certain days of the week to optimal weeks to encourage team members to take vacation time. Rian Doris | Chief Growth Officer Retention is an important sales metric for any business niche, as putting in the effort to retain current customers is imperative. While a focus must definitely be placed on generating new leads and converting those leads to new sources of revenue, we must be careful not to allow that to overshadow retaining our current customer base as well. Srish Agrawal | Founder & CEO Have you ever wondered, what is the key to success? The key towards unchallenged success lies not in collecting data – but in separating the crux from the noise. If your aim is to fire up your sales team, amplify revenue, and beat out the competition, you must understand data. To keep your sales cogwheel moving, you don’t need more sales metrics to wade through. You just need the right one to track. Automatically the data will give you an overall insight into your business. So that you can tweak and optimize the metrics ensuring your sales pipeline’s stability and robustness. From my point of view and what we practice, the Sales Cycle Length seems to be the most credible metric to be tracked. The Sales cycle length is the time taken for an initial lead to turn into a paying customer. Simply put, this is the average time to close an opportunity. This is an immensely valuable metric that empowers the sales team to calculate when funds will be available. This also helps sales departments measure the overall performance of their sales strategy. The shorter the sales cycle length, the better is the effectiveness of your sales team. Drilling on this metric allows a business to optimize business processes incrementally and grow revenue in a sustainable manner. See How Spotio Helps You Hit Your Numbers
DA: 90 PA: 49 MOZ Rank: 57
https://indzara.com/2020/03/sales-pipeline-tracker-free-google-sheet-template/
Step 1: Make a Copy of the sheet Step 1: Make a Copy of the sheet Click on the link above and then make a copy of the sheet as shown in the screenshot below. Make a copy You can save the copy in your own google drive for your use. Once copied, it can also be shared with your colleagues to collaborate as needed. Step 2: Configure the input entries Step 2: Configure the input entries Review Stages in Sales Process By default, the template comes with 5 stages (Lead, Opportunity, Demo, Quote and Sale) . The first 4 can be renamed easily by typing directly on the stage names. 4 Stages in the Sales Pipeline – Rename Stage names Entering a new Sales deal (or lead) We can enter new deals by typing in the Deals table. Each row is a separate deal and it would have Company name, Contact person name, Deal Value and Created Date. Enter sales leads data – Company name Contact name Deal value and Deal created date Deal Value can be estimated if it has not been determined yet. But please enter a value so that the pipeline can be evaluated. We will then enter the current Stage of the deal. Enter Current Stage of each deal from the drop down The 4 stages we had defined earlier will be the values to choose from, in the drop down list. Then, we enter a Win % for each deal. For deals that are not closed yet, we would enter our estimate of the chances of winning a deal. If we have a 50-50 chance of winning or losing a deal, we would enter 50%. In some businesses, the Win % are defined to be constant for a specific stage. Example: 10% for all Leads, 30% for all Opportunities, 50% for all Demos, 80% for all Quotes. This is a sample data set with Stage and Win % entered. Sample Sales Deals data with Stage and Win % 4 more Columns are provided to enter the Email address, Phone Number, Next Activity Date and Notes. Updating a Deal As we continue to work on deals, new information may arrive. Based on that, we need to update the deals. Update Win % and Stage columns for deals as needed, so that your active pipeline is always reflecting the reality. After working on the deal, we would usually schedule the next activity for a future date. We can enter that next activity date in the Next Activity Date column and enter details in the Notes column. Enter follow up details – Next Activity Date and Notes Closing a Deal Deals can be closed if a decision has been taken by the customer to purchase. This is the scenario of a deal WON. If prospect decides to not to purchase or if it has been a while since the prospect has been in touch, we can close the deal as LOST. We can enter this information by entering the STATUS to be ‘WON’ or ‘LOST’. Then, we should enter the CLOSE DATE. This date is used to calculate the Average time taken to Win a deal. Sample Closed Deals data with Status Won or Lost and Close Date If the Close Date is left blank, you will see a red background color indicating that the entry is missing. Data Validation – Missing Close Date for Closed Deals – Shown by Red data field This red background color will also appear if Close Date is less than Create Date. This is to ensure that the data is accurately entered. Tips:Win % could be deleted for closed deals as we already know the result of the deal. They will be ignored for calculations.For lost deals, Stage should reflect the last stage the deal was in. This will be used to identify where deals are being lost the most.Step 3: Monitor Sales Performance Step 3: Monitor Sales Performance This step is one that should be done regularly. It is important to keep an eye on the pipeline metrics to improve performance. The top section of the sheet shows several important metrics needed. Let’s discuss one by one. Active Pipeline Sales Pipeline Tracker – Active Sales Pipeline – Metrics First, the pipeline summary metrics. Sales Pipeline Summary Metrics Deals, Deal Value and Expected Value Open Deals: This represents the number of deals that are not closed yet. Any deal whose status is empty (neither WON nor LOST) will be considered as an open deal. Once a status is entered, it becomes a Closed Deal.Total Value: This is the total value of all open deals. The Deal Value we enter in the Deals table will be used as such. If we win all the open deals, this is the amount we will successfully sell.Expected Value: The reality is that we will win some deals and lose some deals. So, it is better to be realistic about our estimated sales. Expected value is the weighted sum of deal value by Win %. Metrics by Stage As the summary metrics describe the current scenario of the entire pipeline, it is also equally important to know the metrics on the deals by stage. Sales Pipeline Metrics by Stage – Deals, Deal Value and Expected Value As shown in the image above, the same three metrics (Number of Open Deals, Total Deal Value and Expected Deal Value) are shown for each of the 4 stages. Closed Deals Performance The previous section showed the active pipeline. As important that is, it is also important to know how we have been performing in closing deals. It can tell a lot about the future. The next section shows the performance of closed deals. Performance Metrics of Closed Deals – Conversion Rate, Time To Win Deals Deals Won and Lost Closed Deals – Number of Deals Won and Lost – Deal Value In the sample above, 3 deals were won for total of $161,000 and 7 deals were lost valued at a total of $74,000. Conversion Rate & Average Time to win deals Conversion Rate and Average Time to win Deals 3 deals were won out of 10 closed deals and hence Conversion Rate is shown as 30%. The 3 won deals took on average 17 days to close. This is based on the Close Date and Created Date we entered. Where are deals lost? By knowing where the deals are being lost, we can work on those stages to improve our performance. Deals Lost by Stage Of the 7 deals we lost, 29% were lost in the Lead stage, 14% in the Opportunity stage, 43% in Demo stage and 14% in Quote stage. We have entered a small sample of deals here. As we enter more and more data, these % will become very telling in revealing our strengths and weaknesses. If Demo is the stage we fail most often, we may need to improve the demo event to convince our prospects about the usefulness of our products. Related Free Templates Recommended Template $50 Rated 4.86 out of 5 based on 7 customer ratings $50 Filed under: , Post Navigation
DA: 29 PA: 12 MOZ Rank: 77
https://blog.hubspot.com/sales/sales-pipeline
May 20, 2021 . Win rate: The number of sales qualified leads (SQLs) divided by the number of customers — essentially how many leads become paying customers: Sales pipeline value: The total value of every qualified opportunity in your pipeline: Average length of sales cycle: The average time to convert a lead and close an opportunity: Sales velocity
DA: 2 PA: 39 MOZ Rank: 40
https://www.saleshacker.com/sales-excel-templates/
Dec 08, 2020 . A basic pipeline tracker spreadsheet to help you get a 10,000-foot view of your pipeline for each quarter. You can even use it to generate your sales forecast, and adjust the weighting by the probability of each stage in the sales funnel.
DA: 41 PA: 25 MOZ Rank: 22
https://www.zendesk.com/blog/guide-to-the-sales-pipeline/
Jun 04, 2019 . A sales pipeline helps you keep track of all opportunities so that you maintain a healthy number of leads and are reminded to nurture existing customer relationships. Read on to learn everything you need to know about sales pipelines, including: The definition of a sales pipeline. The sales pipeline stages.
DA: 50 PA: 100 MOZ Rank: 96
https://www.salesmate.io/blog/stages-of-sales-pipeline/
A robust sales pipeline will give you valuable insight into anticipated revenue, cash flow, process bottlenecks, resource gaps, and overallocation. In this article, we’ll look at seven stages of a sales pipeline every entrepreneur should understand. 1. Prospecting. Prospecting is the first stage of a sales pipeline.
DA: 46 PA: 84 MOZ Rank: 16
https://www.dodgepipeline.com/products/dodge-pipeline
Construction leads, simplified. Dodge Pipeline combines the most comprehensive source of information on construction projects in North America, with the tools to find and win your next job. Contractors, specialty trades and manufacturers have the tools they need, in the office or in the field, to find the right construction projects, manage and ...
DA: 24 PA: 10 MOZ Rank: 13
https://www.membrain.com/blog/sales-metrics
Feb 25, 2015 . 4. Weighted Pipeline (monthly) Your weighted pipeline is the value of all opportunities in the pipeline, adjusted with the estimated probability of winning each deal. Be careful setting probabilities based on over-simplified rules, like the phase they are in or just the subjective feelings of the sales person.
DA: 95 PA: 24 MOZ Rank: 53
https://idealcrm.app/
Opportunity board, list views, calendars, and task lists allow you to easily follow your entire sales pipeline, from new leads and opportunities to estimating, follow-up, and closeout. Create, send, and track proposals – The iDeal Proposal Creator helps you create professional-looking proposals with just a few clicks.
DA: 25 PA: 34 MOZ Rank: 49
https://indzara.com/product/sales-pipeline-manager/
Reviews. Sales Pipeline Manager (CRM) Excel Template Sales Pipeline Manager (CRM) Excel Template. 4.86 5 7 7. $ $50. ET061001 A simple and effective solution to Sales Pipeline Management. CRM Sales software that provides visibility to your sales funnel and enables you to take smart decisions to improve conversion and increase sales.
DA: 49 PA: 9 MOZ Rank: 48
https://www.teamgram.com/main/en/activity-management/
The Smart Way To Manage Team Tasks TeamGram helps your team focus on getting things done. On-time, every time. Create, view and update activities. Identify issues before they become problems. Try for free Multiuser Activity Management Task lists Progress Indicators Calendar View Geolocation Delegation Teamwork, Simplified. Create an activity, pick the due date, …
DA: 1 PA: 1 MOZ Rank: 24
https://uptics.io/
Win Customers Faster. The all-in-one sales automation platform for remote and inside sales teams to easily launch outbound campaigns, nurture inbound leads, pack your deal pipeline, and drive top-line revenue.
DA: 89 PA: 39 MOZ Rank: 75
https://clodura.ai/blog/b2b-sales-pipeline-management/
Jun 23, 2020 . 14. Fix Bottlenecks in Your Pipeline. CRM is a wonderful tool, and it can help you keep track of where each lead is in the sales pipeline with the help of system tags. These system tags will update the status of every prospect in your system every time a lead progresses to the next stage in the pipeline.
DA: 95 PA: 81 MOZ Rank: 44
https://play.google.com/store/apps/details?id=com.netmine.rolo.crm&hl=en_US&gl=US
Sales reps can enter data without having to learn complicated software. Business can get better visibility without having to invest time in training and configuration. It is a win-win. To learn more visit https://rolocrm.in Features + Create and Manage Teams + Import and Add Business Contacts + Assign Leads to Team Members
DA: 26 PA: 96 MOZ Rank: 11
https://salesflare.com/templates/free-sales-funnel-template/
A typical sales funnel has stages that your sales leads are in. These funnel stages are based on the steps of your sales process that you lead customers through. When you visualize your sales process in this sales funnel template you can test it, improve it and forecast your revenue.
DA: 15 PA: 33 MOZ Rank: 67
https://apps.apple.com/us/app/ls2a-tracker/id1435003952
Screenshots. iPad. iPhone. Description. LS2a Tracker application helps Transportation managers locate their fleet right from their mobile phone and receive notifications instantly only (push-notifications). In order to access the complete functionality of the fleet management system, Transport Manager needs to access the system from his PC.
DA: 45 PA: 1 MOZ Rank: 75
https://trello.com/
Trello helps teams move work forward. It’s more than work. It’s a way of working together. Start with a Trello board, lists, and cards. Customize and expand with more features as your teamwork grows. Manage projects, organize tasks, and build team spirit—all in one place. Start doing →. Join over 1,000,000 teams worldwide that are using ...
DA: 99 PA: 29 MOZ Rank: 55
https://projul.com/
Easily manage your pre-sales leads in our simple to use sales pipeline and close 50% more sales with less work. Learn more. Demo this Feature. Employee Time Tracking made Painless. Time Tracking with geo-fencing and notifications to ensure workers clock in/out while you ensure job profit. ... iOS, Android, Windows & Mac. Projul mobile Apps ...
DA: 29 PA: 37 MOZ Rank: 17
© 2021. All rights reserved