Business intelligence blog

    How to find sales revenue in your data

    When leading a sales team, all roads must lead to revenue-generating opportunities. And with data considered the most important business asset, you need to consolidate and aggregate your data so you can analyze it accurately. Finding and measuring sales revenue is easy with data analytics, and the new insight will help you reach your sales targets.

    Measuring sales revenue

    Sales revenue is a metric most businesses measure. As the main source of income for retail, manufacturing, and wholesale businesses, it is incredibly important that revenue is not only tracked but understood.

    In Phocas, a dashboard can be set up containing key information such as your sales revenue year on year, sales compared to a target or budget, or by sales consultant or product group. Each dashboard is interactive, and clicking an element on the dashboard lets you dive deeper into the selected data.

    An example of a dashboard is below.

    How-to-measure-revenue-dashboard.jpgYour dashboard may tell you that you are on track to meet your targets. However, when you drill in deeper, you may see that the individual sales consultants are performing differently. One may be performing well, while another may be underperforming. 

    In the example below, we can see that six sales consultants in Texas have made sales of a product (LED light bulbs – 5W round) over the past 12 months. Five members of the sales team have made $2,500+ worth of sales but Joshua Russell has made just $259 worth of sales. He is also selling the products at a lower margin (6.94%) than his colleagues who are all selling at 23%+ margins. As a result, the profit Joshua is bringing into the business for this product is just $17.98 which is far below the top performer ($2,690). Armed with these insights, Joshua’s manager can consider giving him some product training to ensure he knows the benefits of the product and can lift his sales.


    Sales cheat sheet 

    Measuring lost sales

    In the example above, we discussed how you can help your sales team sell more of a product. With Phocas, you can also uncover when customers stop buying from you before you lose them completely. 

    In the example below, you can see that 12 customers placed just over $9 million worth of orders in 2018. In 2019, these same businesses contributed just $3.9 million to your revenue with the exception of COD - AUTOKING who had no sales. This year, in 2020, none of these customers have purchased anything from your business. Are these customers purchasing their products elsewhere? If so, that may be hundreds of thousands of dollars of lost orders for your business.

    With Phocas, you can monitor how much your customers have purchased on a daily, weekly, monthly or annual basis to identify their spending trends. Rather than losing revenue when your customers gradually purchase less from you and eventually stop buying, Phocas gives you the insights so you can reach out before it is too late.

    Finding cross-sell opportunities

    A common way to boost revenue is by identifying opportunities for cross-selling. Cross-selling refers to the concept of selling a complementary product when a given product is already being purchased. For example, many electrical distributors  may expect to sell both LED lights and transformers to their customers. If you find you are only selling transformers, your customer may be purchasing LEDs from another supplier.  There could be multiple reasons for this; the customer may receive a better price elsewhere, they may not be aware you sell the product, or they may buy some of the product but supplement it with a different brand from another supplier.

    See below how easy it is to tell who is buying one type of product but not another. On the left is LED sales and on the right is transformer sales.  With Phocas, you can drill down into the individual product. The same analysis can be run in any business. A food and beverage business may want to see who is buying pasta but the not the sauce.

    Phocas in your business

    Phocas has almost 20 years of experience helping businesses drive sales revenue in retail, wholesale distribution and manufacturing. Our dashboards are provided as an out-of-the-box solution so you can make data driven decisions almost immediately. Phocas is easy to use for anyone, including those without a technical background. With Phocas, you can also decide who has access to your data, so that employees have access to data that is relevant to their role.

    Written by Phocas Software
    Successful Business Intelligence - Phocas Software
    Successful Business Intelligence - Phocas Software

    Top 7 KPIs and metrics for mid-market executives

    Want some quick wins to find sales revenue in your data. Download our cheatsheet 10 ways to take sales to the next level by clicking on the button below.

    Sales cheat sheet


    Download eBook

    Leave a reply

    Your email address will not be published. Required fields are marked *

    Related posts

    How information gives companies a competitive...
    2 MIN

    The pandemic of 2020 created a record number of new companies. A rise in entrepreneurship accompanies every downturn...

    Reduce costs with a data analytics bootcamp
    3 MIN

    There are many courses called data analytics bootcamps which teach participants the basics of working with data....

    BI stands for and other handy data terms
    5 MIN

    BI stands for 'business intelligence' but we all know wrapping your head around words, phrases and acronyms in the...

    Subscribe to our blog

    Sign up to get the latest news and insights from Phocas experts