The Business Tools Blog

  • Strategic Analysis: A Choice of Tools

    <p>We are all familiar with SWOT and PEST as strategic analysis tools. Many will be less familiar with the <strong>S</strong>trategic<strong> P</strong>osition <strong></strong>&amp; <strong>AC</strong>tion<strong> E</strong>valuation matrix, frequently referred to as SPACE Matrix tool.</p><p>The SWOT and PEST tools are both environment (internal and external) analysis tools.</p><p>PEST takes us through a process that scrutinizes the external environment within which the organization has got to plan and operate.The four factors <strong>P</strong>olitical, <strong>E</strong>conomic, <strong>S</strong>ocial and <strong>T</strong>echnical will all to a greater or lesser extent impact the organization. The PEST analysis helps to get clarity around these factors that will impact the planning horizon and get consensus among the members of the planning team.</p><p>SWOT analysis focuses on <strong>S</strong>trengths, <strong>W</strong>eaknesses, <strong>O</strong>pportunities and <strong>T</strong>hreats. It helps to identify and clarify the strengths and weaknesses of the organizations as it seeks to develop a strategy and plan that can pursue and exploit the identified Opportunities while taking due cognizance of identified Threats, all within the external environment identified by the PEST analysis. </p><p><a href="http://www.businesstoolsstore.com/categories/Strategic-Business-Planning/">SWOT and PEST analysis templates </a>for Excel, Word and PowerPoint are available at<a href="http://www.businesstoolsstore.com/">The Business Tools Store</a>. </p><p>Our <a href="http://www.businesstoolsstore.com/strategic-planning-workbook/">Strategic Planning Workbook </a>can be used to facilitate and record the PEST and SWOT analysis outcomes.</p><p><strong><br></strong></p><p><strong>The SPACE Matrix </strong></p><p>The SPACE matrix takes a slightly different approach to the analysis. </p><p>It is used to determine what type of strategy a company should undertake. It focuses on strategy formulation especially as related to the competitive position of an organization. </p><p>The matrix is broken down to four quadrants where each quadrant suggests a different strategy:</p><ul> <li>Aggressive </li><li>Conservative </li><li>Defensive </li><li>Competitive</li></ul><p>The outcome of the analysis is plotted and the result depicted in one of the four quadrants to suggest the appropriate strategy.</p><p><strong><br></strong></p><p><strong><br></strong><strong>The SPACE Matrix Analysis</strong></p><p>The SPACE Matrix uses two internal and two external strategic dimensions in order to determine the organization's strategic posture in the industry. The four areas of analysis are:</p><p>Internal strategic dimensions:</p><ul> <li>Financial strength (FS)</li><li>Competitive advantage (CA)</li></ul><p>External strategic dimensions:</p><ul> <li>Environmental stability (ES)</li><li>Industry strength (IS)</li></ul><p>Financial Strength (FS): This internal dimension can include return on investment, leverage, liquidity, capital, risk involved in business etc. as key factors.</p><p>Competitive Advantage (CA): This internal dimension can include market share, product quality, product life cycles etc. as key factors.</p><p>Industry Strength (IS): This external dimension can include growth and profit potential, financial stability, technological know-how etc. as key factors.</p><p>Environmental Stability (ES): This external dimension can include technological change, rate of inflation, demand variability, price range of competing products etc. as key factors. </p><p><strong><br></strong></p><p><strong>Which Analysis Should Use?</strong></p><p>The SPACE matrix can be a useful initial analysis to identify a generic strategy. It can also be useful in assessing strategic alternatives suggested by the PEST or SWOT analysis.</p><p>A <a href="http://www.businesstoolsstore.com/space-matrix-template-excel/" target="_blank">SPACE Matrix template</a> is available for Excel&nbsp;in the&nbsp;<a href="http://www.businesstoolsstore.com/">The Business Tools Store</a>.</p>

  • Another Satisfied Customer

    <p><span style="font-size: x-small;">We set ourselves the highest standards in customer service and go the extra mile when necessary to ensure we have a satisfied customer. So it is really pleasing when we get a thank you message and genuine appreciation from our customers.</span></p><p><span style="font-size: x-small;">We recently received message on Friday night at 10.00 PM (our time) from “Tom” who had placed an order earlier in the week for MS-Word and MS-Excel General Electric GE McKinsey Matrix Templates. Tom had “ a meeting on Monday morning where I need to make use of the MS-Word and MS-Excel General Electric GE McKinsey Matrix Templates and hope that I will be able to obtain them sometime early this weekend so I'll have the time to work with them.”</span></p><p><span style="font-size: x-small;">He couldn’t find our email with the download link. As it was out of hours we picked the message up on a cell phone while having dinner with friends.</span></p><p><span style="font-size: x-small;">On checked back we confirmed that the order had been received early in the week and an automatic email with the appropriate download link had been generated and sent to Tom. The most appropriate action was to generate the email again and to suggest to Tom that if he didn’t receive it to check his SPAM folder or other possible locations where it might be hiding.&nbsp;&nbsp; Despite exhaustive searches he couldn’t find it, so time for plan B; we downloaded the files and user guide and sent them as an email attachment.</span></p><p><span style="font-size: x-small;">We were delighted to receive an message from Tom shortly afterwards that confirmed that he had received them and the following comment “Please allow me to say that in handling this matter, you displayed a level of support and customer service that is rare these days and that which I've not seen in a long, long time. You went above and beyond making sure I received the files in time for me to make use of them. Your diligence in doing whatever it took to get these files to me is highly commendable and greatly appreciated.”</span></p><p><span style="font-size: x-small;">Thank you Tom and we happily when back to our dinner friends in time for coffee and all before 11.00 PM</span></p>

  • Useful under-utilized Excel Features

    <h1>&nbsp;</h1><h1>&nbsp;</h1><h1><span style="font-size: large;"><span style="color: rgb(54, 95, 145);"><span style="font-family: Cambria;">3D Analysis in Excel</span></span></span></h1><p><span style="font-size: small;"><span style="font-family: Times New Roman;">Excel has always been a very popular and powerful business tool.</span></span></p><p><span style="font-size: small;"><span style="font-family: Times New Roman;">One of the features of Excel that is easy to use and is frequently under-utilized is the Excel Bubble chart.</span></span></p><p><span style="font-size: small;"><span style="font-family: Times New Roman;">The power of the Bubble chart is that it allows us to present data analysis in three dimensions and can be significantly more informative than visually trying to aggregate multiple two-dimensional charts in the mind’s eye.</span></span></p><p><span style="font-size: small;"><span style="font-family: Times New Roman;">By way of example, we are all familiar with customer surveys where we ask our customers to rate our performance under a number of headings such as quality, customer service, etc. The results are usually informative and useful. </span></span></p><p><span style="font-size: small;"><span style="font-family: Times New Roman;">We can add a second dimension by asking to customer to also rate the factors in terms of their importance to him/her. By plotting the data in two dimensions we can now see how our performance is rated for the factors that are most important, are therefore most significant, to the customer.</span></span></p><p><span style="font-size: small;"><span style="font-family: Times New Roman;">However, customers’ approach to rating can vary from those who give everybody a 5 out of 5 to those who are much conservative and only rate above 3 out of 5 in exceptional circumstances. “If I gave somebody a 5 there would be no room for improvement”</span></span></p><p><span style="font-size: small;"><span style="font-family: Times New Roman;">Asking the customer to rate you on how you compare to competitors and other suppliers provides an additional insight into how to interpret the ratings he/she had given you.</span></span></p><p><span style="font-size: small;"><span style="font-family: Times New Roman;">For most of us the goal would be to be rated very highly for those factors that are most important to the customer and to be perceived to be much better than our competitors.</span></span></p><p><span style="font-size: small;"><span style="font-family: Times New Roman;">An Excel Bubble chart allows you to analyse the results in 3D; the X-axis being used for the rating you receive for the factor, Y-axis for the rating of the importance of the factor and the size of the Bubble indicating how you compare with the competition.</span></span></p><p><span style="font-size: small;"><span style="font-family: Times New Roman;">A low X value, a high Y value and a small Bubble spells trouble and indicates that you have a lot of work to do on this factor as you are rating as being poor for a factor that the customer considers important and you are perceived to be much worse that your competitors.</span></span></p><p><span style="font-size: small;"><span style="font-family: Times New Roman;">A “picture being worth a 1,000 words” the chart allows us to quickly hone in on the factors where we need to make improvement most urgently. </span></span></p><p><span style="font-size: small;"><span style="font-family: Times New Roman;">There are many other examples where a Bubble chart can prove useful. </span></span></p><p><span style="font-size: small;"><span style="font-family: Times New Roman;">In the case of a SWOT analysis the X-axis might indicate the size of the SWOT factor (Strength, Weakness, etc.) the Y-axis indicating the immediate or short-term importance/impact of the factor and the Bubble size indicating the more long-term strategic importance/impact of the factor.</span></span></p><p><span style="font-family: Times New Roman; font-size: small;">The </span><a href="https://www.businesstoolsstore.com/swot-analysis-template-excel-swot-matrix-template-excel/"><span style="font-family: Times New Roman; font-size: small;">SWOT analysis</span></a><span style="font-family: Times New Roman; font-size: small;"> example can be seen on the </span><a href="https://www.businesstoolsstore.com/"><span style="font-family: Times New Roman; font-size: small;">Business Tools Store</span></a><span style="font-family: Times New Roman; font-size: small;"> together with other examples for </span><a href="https://www.businesstoolsstore.com/ansoff-market-product-matrix-excel-template/"><span style="font-family: Times New Roman; font-size: small;">Ansoff matrix</span></a><span style="font-family: Times New Roman; font-size: small;">, </span><a href="https://www.businesstoolsstore.com/bcg-matrix-template-excel/"><span style="font-family: Times New Roman; font-size: small;">Boston Consulting Group (BCG) chart</span></a><span style="font-family: Times New Roman; font-size: small;"> and </span><a href="https://www.businesstoolsstore.com/general-electric-ge-mckinsey-matrix-template-ms-excel/"><span style="font-family: Times New Roman; font-size: small;">GE/McKinsey 9-cell matrix</span></a><span style="font-size: small;"><span style="font-family: Times New Roman;">.</span></span></p>

  • Joined up Sales Revenue Planning

    <h1>&nbsp;</h1> <h1><span style="font-size: small;"><span style="font-family: Calibri;">Sales revenue is the lifeblood of all commercial organisations.</span></span></h1> <p><span style="font-size: small;"><span style="font-family: Calibri;">On an annual basis, long debates and negotiations take place before the annual sales revenue budget is finalised.</span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">Once the revenue number is finalised and signed-off it is over to the Sales Management to make it happen. Sales management need to dissect the revenue monthly numbers and translate the revenue targets into numbers and value of sales that need to be closed each month. </span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">Many organisations have contracted recurring revenue, e.g. monthly maintenance fees. This should be subtracted from the monthly revenue target to identify the net new sales revenue which the sales organisation needs to close each month.</span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">As all sales organisations will tell you, sales do not just happen and close on their own. The prospect goes through a buying process, particularly in the Business-to-Business (B2B) environment, that involves a number of steps or stages from need identification, through to brand/supplier awareness, consideration and preference to purchase intention and actual purchase. </span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">The sales pipeline or funnel is characterised by having a series of stages or steps in the sales process that seeks to match and respond to the needs at each stage of the buying process and can include initial lead qualification, need identification and assessment, proposal development, negotiation and closure. Typically the stages are characterised by the numbers in the pipeline being reduced as it goes through each stage (pipeline stage leakage) and hence the funnel shape. </span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">In order to scope the work to be done to achieve the monthly sales revenue plan, sales management must work back through the pipeline stages to identify how many leads, prospects, proposals etc. must be achieved each month if the sales revenue numbers are to be achieved in subsequent months. </span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">The elapsed time that the buying process taken and hence the time it takes to process a sale through the pipeline sages varies by industry and in some cases can be in excess of six or twelve months. In the case of a six month pipeline duration the outcome in month six is limited by the number of new leads entering the pipeline in the first month.</span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">A tool such as the Excel-based <a title="Sales Pipeline Planner and Calculator" href="https://www.businesstoolsstore.com/sales-funnel-calculator-template-excel-sales-pipeline-template-excel-calculator/" target="_blank">Sales Pipeline Planner and Calculator</a> available from the <a title="Business Tools Store" href="https://www.businesstoolsstore.com" target="_blank">Business Tools Store</a>&nbsp;takes care of the calculations for each stage of the pipeline for each month and identifies the numbers required at each stage to achieve the sales revenue budget in subsequent months.</span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">Having identified the number of new leads required each month to support the sales revenue plan it is now the turn of Marketing to provide Sales with a steady stream of the required number of leads. </span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">Increasingly Marketing is becoming required to justify budgets and demonstrate ROI and the expenditure should be tied to the specific target number of leads to be generated.</span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">There are many options/channels that Marketing can choose when developing a lead generation program from traditional advertising, tradeshows and telemarketing to more recent options such as email and web marketing, webinars and social media. </span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">A lead generation budget/plan should be drawn up that assigns a budget to each channel to be used and identifies the number of leads to be generated as a result. This allows the cost per lead to be calculated and compared across the different channels. </span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">This approach can be taken to a more granular level by assigning budgets and number of leads to be generated to individual programs/campaigns within each channel, i.e. if one is using email marketing or telemarketing assigning a budget and leads target to individual campaigns or similarly breaking the tradeshow budget and target number of leads down to individual tradeshows.</span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">The Excel-based <a title="Sales Leads Budget Planner" href="https://www.businesstoolsstore.com/sales-leads-generation-plan-budget-ms-excel-template/" target="_blank">Lead Generation Budget Planner</a> available from the <a title="Business Tools Store" href="https://www.businesstoolsstore.com" target="_blank">Business Tools Store</a>&nbsp;facilitates the development of such a budget.</span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">Once the leads begin to flow a crucial step in a joined up process is to manage the leads and nurture them through the different pipeline stages to a successful conversion into orders and ultimately sales revenue. </span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">Typically in the initial stages of the selling process very limited information is available of their precise requirements and there is a low probability of successfully converting the lead into a sale; perhaps only as few as one in ten of initial leads identified are successfully converted. As the prospect goes through the buying process this probability increases. </span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">The sales pipeline should match the buying process and each stage should be focused on moving the prospect successfully through the corresponding buying stage. By using the probabilities assigned to each stage a net pipeline value can be calculated for sales forecasting purposes. </span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">A sales pipeline management system should track the status of all active leads and should also provide lead source analysis so that the most successful sources in terms of generating leads, conversions and revenue can be identified</span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">There are many tools available to manage prospects through the sales pipeline, including sophisticated CRM and sales automation systems. </span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">For organisations for which such systems are not appropriate, simpler Excel-based tools that are easy to deploy and use are available. </span></span></p> <p><span style="font-size: small;"><span style="font-family: Calibri;">The Excel-based <a title="Sales Pipeline management" href="https://www.businesstoolsstore.com/sales-pipeline-template-excel/" target="_blank">Sales Pipeline Management system</a> available from the <a title="Business Tools Store" href="https://www.businesstoolsstore.com" target="_blank">Business Tools Store</a>&nbsp; is one such system. </span></span></p>

  • How to Maximise Revenue from Online Sales

    <p><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">Online </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">sales continue to </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">account </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">for </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">a </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">growing </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">proportion </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">of </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">total </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">sales</span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN">. </span></p> <p><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">Even </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">the </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">smallest </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">business </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">can no longer&nbsp;</span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">ignore </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">the </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">online </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">channel</span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN">. </span></p> <p><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN">The online channel offers opportunities for every type of business and with ecommerce platforms like&nbsp;<a href="http://www.bigcommerce.com/p/2306-0-4-7.html">Big Commerce</a>** it was never easier or more affordable to open an online store.</span></p> <p><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">Once </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">you have an </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">online </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">sales </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">presence,</span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN"> channel </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">revenue </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">maximisation </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">becomes </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">a </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">key </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">objective</span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN">.</span></p> <p><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">Three </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">key </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">variables </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">impact </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">the</span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN"> total </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">revenue </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">from </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">the </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">channel</span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN">. </span></p> <p><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">&nbsp;These </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">are:</span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN">&nbsp;&nbsp;(1) total </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">number </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">of </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">site</span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN"> visitors</span></p> <p style="padding-left: 60px;"><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN">&nbsp; &nbsp; </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN">(2) </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">the </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">conversion </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">rate </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">of </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">visitors </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">to </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">customers</span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN"> and </span></p> <p style="padding-left: 60px;"><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN">&nbsp;&nbsp;&nbsp;&nbsp;(3) </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">average </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">order </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">value</span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN">. </span></p> <p><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">Should </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">you </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">focus </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">on </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">increasing </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">the </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">total </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">number </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">of </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">visitors </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">or </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">seek </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">to </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">increase the </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">conversion </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">rate</span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN">, </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">say</span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN">, </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">by</span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN"> 20% </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">or </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">increase </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">the </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">average </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">order </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">value </span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">by,</span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;">say</span><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN">, 10%? </span></p> <p><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN">Each requires a different strategy and results in a different revenue outcome.</span></p> <p><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN">Our&nbsp;</span><a href="https://www.businesstoolsstore.com/ecommerce-revenue-business-model-calculator/"><span style="font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN">Ecommerce Revenue Business Model Calculator</span></a><span style="color: #282828; font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN"> lets you do &ldquo;what-if&rdquo; revenue analysis on these key variables for each of four periods.</span></p> <p><span style="color: #282828; font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN">Revenue, traffic and conversion rate projections are calculated and displayed in tabular format and in a graphic dashboard.</span></p> <p>&nbsp;</p> <p><span style="color: #282828; font-family: 'Arial','sans-serif'; font-size: 10pt;" lang="EN">** Big Commerce is used by over 39,000 small business online store worldwide and&nbsp;costs as little&nbsp;as $25 per month.</span></p> <p><span>&nbsp;</span></p>

  • Do we need to change the way we do SEO?

    <p>Google has quietly released major changes in the way which search data is reported which is likely to have a significant impact on the way SEO is practiced.</p><p>So what is the big game changer?</p><p>In October 2011 Google announced that it was encrypting the data arising from organic search for those users who were signed in to their Google account, in the interest of protecting personal privacy and security. The result was that when one used Google analytics organic search sources to see what keywords were sending traffic to your site this encrypted data was reported as “not provided”.</p><p>While this was an inconvenience, Google said at the time that it would not exceed 10%, one could infer from the not encrypted searches what keywords the page was ranking/not ranking for and carry out on-page SEO to improve the ranking and resultant traffic and conversions.</p><p>The big change in the recent Google announcement is that Google will now encrypt 100% of the data. As a result you will be able to see search traffic results for each page but have no idea what search words were used to generate that traffic.</p><p>How can you help users to find what they are looking for if you have no idea what search terms they are using? It is akin to driving your car by looking out the rear window.</p><p>You can now guess what keywords might be relevant, carry out your on-page SEO and check for changes in traffic in the following few weeks, i.e. while driving guess if you should turn left or right and check for the resultant impact.</p><h2>Why is Google Doing This?</h2><p>Google is doing this “in the interest of protecting personal privacy and security” so that third parties cannot spy on your search activities.</p><p>This sounds reasonable. However, suspicion as to the motive has been raised when this same keyword data is available for Adwords account holders.</p><p>Ad search traffic is not encrypted, so that when someone arrives on your site after searching Google and clicking on an Ad, the search data is available. A small detail is that you pay a click fee for each visitor that arrives via this route.</p><h2>What can you do?</h2><p>Microsoft Bing search data is still available. The data will represent only a very small percentage of all searches carried out – Bing is typically 17% versus Goggle’s 66%.</p><p>Perhaps you can make the assumption that Bing users are a representative sample of all search users.</p><p>Google Webmaster tools, still provides search data estimates for the previous 90 days.</p><p>However, it is worth noting that the figures are only estimates and only the data for the most recent 90 days are available. To build up a history, once should download the data on a regular basis.</p><p>Use one of a number of independent providers, who have access to other sources of search data, and offer commercial alternatives.</p><p><a href="http://www.wordtracker.com">Wordtracker</a> one such vendor who claims to have a database of 3.5 billion searches per month. Wordtracker also have a limited functionality free alternative.</p>

  • PEST and SWOT Analysis

    <p>&nbsp;</p> <p>Introverted strategic planning that focuses exclusively on the organisation itself is doomed to failure.</p> <p>All organisations, irrespective of size, operate within a macro-environment over which they have little control.</p> <p>PEST analysis (Political, Economic, Social and Technological analysis) provides a useful framework of macro-environmental factors used in the environmental analysis component of strategic planning.</p> <p>The output from the PEST analysis provides a good background against which to proceed with a SWOT analysis to evaluate the Strengths, Weaknesses, Opportunities, and Threats of the organization.</p> <p>The results of the PEST and SWOT analysis can inform later steps in planning to achieve objectives, which is covered in our<a title="Strategic Planning Workbook" href="https://www.businesstoolsstore.com/strategic-planning-workbook/" target="_blank"> Strategic Planning Workbook </a>.</p> <p>Our<a title="Strategic Planning Workbook" href="https://www.businesstoolsstore.com/strategic-planning-workbook/" target="_blank"> Strategic Planning Workbook </a>and our <a title="PEST Analysis Template" href="https://www.businesstoolsstore.com/pest-analysis-template/" target="_blank">PEST</a> and <a title="SWOT Analysis Template" href="https://www.businesstoolsstore.com/swot-analysis-chart-templates/" target="_blank">SWOT templates </a>may be helpful in the process.&nbsp;</p>

  • Strategic Planning Workbook Available

    <p>&nbsp;</p> <p>We are all familiar with SWOT and PEST analysis as techniques to use during the planning process.</p> <p>Many are unsure how to use them effectively and how they fit together.</p> <ol> <li>Should I use SWOT or PEST or both?</li> <li>Once I have completed the analysis how do I most effectively incorporate the results into the overall planning process?</li> </ol> <p>The Business Tools Store has produced a <a title="Strategic Planning Workbook" href="https://www.businesstoolsstore.com/strategic-planning-workbook/" target="_blank">Strategic Planning Workbook </a>that allows the novice and expert alike to use both PEST and SWOT in a complementary fashion and to use the results to identify appropriate strategies.</p> <p>The workbook identifies relevant objectives, and defines action items to achieve the selected objectives.</p> <p>It further assigns metrics, timelines and executive ownership to all actions, thus ensuring follow through from the PEST and SWOT analysis to &ldquo;on the ground&rdquo; implementation.</p> <p>A PDF version is available FREE to <a href="https://www.businesstoolsstore.com/strategic-planning-workbook/">download</a>, while a fully editable Word version can be purchased.</p> <p>PEST analysis is used to analyze the external macro-environment. <strong>PEST</strong> stands for <strong>P</strong>olitical, <strong>E</strong>conomic, <strong>S</strong>ocial and <strong>T</strong>echnological; the four categories under which the external environmental factors are classified.</p> <p>SWOT analysis is used to analyze the external micro-environment and the internal environment. <strong>SWOT</strong> stands for <strong>S</strong>trengths, <strong>W</strong>eakness, <strong>O</strong>pportunities and <strong>T</strong>hreats; the micro external environment being analyzed for threats and opportunities, while the internal environment is analyzed for strengths and weaknesses.</p> <h3>How does PEST Analysis and SWOT Analysis Compare?</h3> <p>PEST analysis is appropriate for the big picture external macro environment analysis within which SWOT analysis provides an analysis of the external micro and internal environment and as such it is usual to complete the PEST analysis initially and to use the results as a backdrop and framework within which the SWOT analysis is then carried out.</p> <p>PEST analysis usually involves factors over which the organization has very little influence, e.g. inflation rate, trade restrictions, population growth projections.</p> <p>On the other hand, SWOT analysis deals with factors over which the organization can have a measure of control and influence in developing and executing the strategic plan, e.g. further developing and exploiting the organization&rsquo;s strengths and taking action to minimize the impact of external threats or take advantage of identified opportunities.</p> <p>The techniques are most effective when the PEST analysis is completed first and the output of the PEST analysis provides an informed view of the external macro environment within which strengths, weakness, opportunities and threats are assessed.</p> <p>Get an editable Business Planning Workbook <strong><span style="background-color: #ffff00;">FREE</span></strong> with SWOT &amp; PEST templates use code &ldquo;SPWFREE&rdquo; at checkout <a href="http://businesstoolsstore.com" target="_blank">http://businesstoolsstore.com</a></p>

  • SPACE Matrix Chart Excel Template Added

    <p><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>Continuing to expand our extensive portfolio of strategic planning tools we have recently added an Excel SPACE Matrix template.</span></p><p><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>To&nbsp;start using it to produce your SPACE Matrix just click on <a href="https://www.businesstoolsstore.com/space-matrix-chart-template-excel/">SPACE Matrix Excel template</a>.</span></p><p><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>Is the SPACE matrix tool for you?</span></p><p><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>The <strong>S</strong>trategic<strong> P</strong>osition &amp;<strong> Ac</strong>tion<strong> E</strong>valuation matrix or <strong>SPACE</strong> matrix focuses on strategy formulation particularly from the competitive position<br> of an organization and helps companies to decide the appropriate type of strategy analysis the company should undertake.</span></p><p><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>The SPACE matrix analysis outcome can be used as a basis for other analyses, such as&nbsp;PEST&nbsp;analysis,&nbsp;SWOT analysis,&nbsp;Ansoff, BCG matrix or GE-McKinsey models, for which we have a comprehensive portfolio of <a href="https://www.businesstoolsstore.com/categories/Strategic-Business-Planning/">Strategic Planning templates</a>.</span></p><p><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>The SPACE matrix has four quadrants. Each quadrant suggests a different type of strategy and the SPACE analysis places the organisation in one of the quadrants indicating the type of strategy the company should undertake.</span></p><p><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>The different types of strategy suggested are:</span></p><ul><li><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>Aggressive</span></li><li><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>Conservative</span></li><li><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>Defensive</span></li><li><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>Competitive</span></li></ul><p><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'><a href="https://www.businesstoolsstore.com/space-matrix-chart-template-excel/"><img width="442" height="428" title="space-matrix-chart-template.jpg" class="__mce_add_custom__" alt="space-matrix-chart-template.jpg" src="https://www.businesstoolsstore.com/product_images/uploaded_images/space-matrix-chart-template.jpg" unselectable="on"></a></span></p><p><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </span></p><p><strong><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 9pt;'>SPACE Matrix Analysis</span></strong></p><p><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>The SPACE Matrix analysis framework has four dimensions in order to determine the organization's strategic positioning in the industry.</span></p><p><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>These are:<strong></strong></span></p><ul><li><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>Financial strength (FS)</span></li><li><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>Competitive advantage (CA)</span></li><li><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>Environmental stability (ES)</span></li><li><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>Industry strength (IS)</span></li></ul><p><img width="500" height="359" title="space-matrix.jpg" class="__mce_add_custom__" alt="space-matrix.jpg" src="https://www.businesstoolsstore.com/product_images/uploaded_images/space-matrix.jpg" unselectable="on"></p><p><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>&nbsp;</span></p><p><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>The CA score is added to the IS score to give the total X-axis score</span></p><p><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>The FS score is added to the ES score to give the total Y-axis score.</span></p><p><span style='color: black; font-family: "Verdana","sans-serif"; font-size: 7.5pt;'>This point of intersection is then plotted on an SPACE matrix and the resulting quadrant location indicated the appropriate strategy.</span></p>

  • Sales Pipeline Funnel Template Upgraded

    <h1>Sales Funnel Graphic Image added to Sales Pipeline Funnel Template</h1> <p>The Sales Pipeline Funnel Calculator has been upgraded to include a graphic image that dynamically shows the shape of the funnel that results from the sales process pipeline being used.</p> <p>&nbsp;</p> <p><a title="Sales Funnel Template Calculator" href="https://www.businesstoolsstore.com/products/Sales-Funnel-Template-%7C-Sales-Pipeline-Template-Excel-Calculator.html"><img class="__mce_add_custom__" style="float: left;" title="sales pipeline funnel" src="https://www.businesstoolsstore.com/product_images/uploaded_images/sales-cycle-funnel.jpg" alt="sales pipeline funnel" width="511" height="378" /></a></p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>The graphic shows how the number of active leads in the funnel decrease as they flow through the funnel.</p> <p>This allows the user to quickly see the impact of any changes in the parameters defining the funnel, i.e. the number of leads entering the funnel, the number of stages in the sales process and the leakage in the funnnel as one goes from one stage to the next.</p> <p>The new template is available to download from <a title="Sales-Funnel-Template|Sales-Pipeline-Template-Excel-Calculator" href="https://www.businesstoolsstore.com/products/Sales-Funnel-Template-%7C-Sales-Pipeline-Template-Excel-Calculator.html">Sales-Funnel-Template | Sales-Pipeline-Template-Excel-Calculator</a>.</p>