Dashboard: Analytics

This article will provide you with a comprehensive guide to your Dashboard: Analytics in LMN for your convenience! 

 

Select from the list below to jump to its spot within the article!

 

Home Dashboard

To access your Home Dashboard, select Dashboard on your left menu and then Home mceclip0.png

Here you will see a quick glance of your personal Requests and To-Dos, as well as tracking for your Sales and Estimate Goals! mceclip1.png

Towards the bottom you will also see your monthly updates on your 'New Leads', 'New Clients', 'New To-Dos & Requests', and 'Communication Notes' totals. mceclip1.png

 

CRM DASHBOARD

The dashboard is a way to see a quick summary and highlighted information for everything CRM related.mceclip2.png

For upcoming To-Dos & Requests, you can click on them here to action them, or change their progress. It also gives you a summary of the tasks that need to be completed, and any specific requests gotten from customers.

mceclip3.png

You’ll be able to see your best referral sources, so you can see how many leads fall under each referral source. This is letting you know if your marketing channels are working or not. You'll be able to filter by contacts or by estimates.

mceclip4.png

Down below, you’ll be able to see your most recent customer portal activities. Through this, you can see all your customer interactions in the portal, and the most recent notification dates, notification types, and the notification messages. Whether you have invited a customer to the portal and they accepted that invite, or you sent an estimate or invoice to the portal for your customer to review, or if they have paid an invoice through the portal, you will be able to see all these activities listed on this page.

mceclip5.png

And last but not least, you’ll be able to see your most popular tags. When we add our contacts into our CRM, we’ve included tags on those contacts to specifically classify them. You’ll be able to see the number of contacts that sit within each tag.

mceclip6.png

 

ESTIMATE DASHBOARD

This dashboard is a way to see a summary and highlight important information for everything Estimate related.                                                                                                  mceclip7.png

The first dashboard tab will show information pertaining to all of your estimates – here, you’ll be able to track your goals and progress for each division. You can see the Yearly Data that is highlighted right at the top. As you create estimates and customers approve them, you will be able to see this bar start to fill as you get closer to your estimate goal for the year.

mceclip8.png

Underneath, you’ll be able to see a section for each of our division. mceclip9.png

Each division will outline the estimate goal for the year for that division, the sales goal, estimates to date, actual closing rate, total estimates sold to date (with a progress bar to show what percentage of your sales goal has already been completed), and the total labor hours you’ve sold to date with its own progress bar. These are useful in analyzing whether you are going to hit your sales goal for the year by looking at the progress so far, and whether you are selling enough work to keep your crews busy. Use this page to make sure you’re on track and whether you’re trending towards your goals.

 

To add or adjust your Sales Goal, you can go to Settings > Estimates > Divisions > Click into the Division 

mceclip3.png

mceclip10.png

Estimate Goal (or Estimate $ Required) = Sales Goal / expected closing rate

  • For example: $80,000 = $40,000 Sales Goal divided by your 50% of expected closing rate 

The next two tabs will provide insight as to how your estimates stack up with one another and help you determine the best estimates and work to go after.

The Profit Reports page will help identify your most profitable work & biggest opportunities. Up at the top, you can filter by the estimate type, the salesperson, the estimate status, the range of your estimate start and end date, and by division. Once we have selected our preferences, we can go ahead and click the Show button to update our view. If we want to save these search options for the future, we can click the save search button. We can even download this information into an excel spreadsheet.

mceclip11.png

As we scroll down, we can see 3 different graphs:

  1. The Most Net Profit graph will report on your top 10 most profitable work based on the net income. You’ll also be able to compare it to your gross profit for each job: mceclip12.png
  2. the Most Revenue graph which will report on your top 10 highest revenue work: mceclip13.png
  3. The last graph at the bottom is the Biggest Opportunities graph which reports on your top 10 highest pricing estimates in comparison to the confidence levels that were selected for each estimate:                        mceclip14.png

Next we’ll take a look at the Labor Reports tab, which will outline which jobs take up the most time from your teams:

  1. The Most Labor Hours graph will show us the top 10 estimates that have been quoted with the highest labor hours:            mceclip15.png
  2. The Least Labor Hours graph will show us the top 10 estimates that have the lowest labor hours: mceclip16.png
  3. The Revenue Per Man Hour graph will show us the top 10 estimates with the highest revenue per man hour. (Remember, the revenue per man hour is calculated by the total selling price of the job, divided by the number of houses that are estimated): mceclip17.png
  4. The last graph, Throughput per Man Hour will show the estimates with the highest throughput per man hour which indicates how effect your resources are at generating revenue. (Remember, your throughput is your revenue minus the total variable costs, then we take the throughput and divide it by your total field labor hours. This way, we’re filtering out any revenue that are not staying in the company):          mceclip18.png

 

COST CODES DASHBOARD

This dashboard is a great way to see a quick summary and breakdown of each cost code.mceclip19.png

This will help you analyze what areas of your business that you’re winning more work in and whether they are profitable or not. If you’re winning a lot of work in one cost code but it does not result in a high gross and net profit, this will indicate to you that you might need to investigate as to whey you’re not as profitable for these areas of work and whether you should shift your focus towards other types of work that is more profitable.

For each cost code, you’ll see the total estimated work, the total sold work, the winning percentage of how much of the work has been won, and the pending percentage, so what is currently still pending and coming down the pipe. You’ll also be able to see the total number of estimated hours vs the total number of sold hours per cost code. Lastly, you can see the overall gross profit (sold) and net profit (sold) for each cost code. Now for any cost code, you’ll not only want to see if you’re closing and selling a lot of work, but also have high profit margins. You’ll want to focus on the areas that is most profitable and identify which areas might need more work or optimization so you can work to improve the profitability.

mceclip20.png

 

JOB ANALYTICS DASHBOARD

The Job Analytics dashboard will help you identify your company’s inefficient jobs and job performance statuses based on budgeted hours so you can take immediate action to achieve profitable results. mceclip20.png

You’ll see the number of new jobs created in the past 7 days, the total number of active jobs and inactive jobs. If you notice that your active jobs are increasing while your inactive jobs are staying steady, it can be an indication to clean up your Job List and change some jobs to inactive status. The more active jobs you have available for your crews, the more confusing this can be for them when they have to clock into a specific jobsite.  

The Jobs Most Over Budget by Hours (Overall) is going to take the estimated hours and compare it to the actual hours to give you the total time over the budget. This feature shows the Job name and the time by which the job has exceeded the estimated hours. The jobs are ranked by time efficiency with the job with the highest time over the budget at the very top of the list. The Jobs Most Over Budget by % (Overall) will show the same information but in terms of percentages. To access the job itself, you can click on the arrow icon beside the job name.

mceclip22.png

The Tasks Most Over Budget (Overall) and Tasks Most Over Budget (Per Visit) will show the job tasks where the actual hours are over the budgeted hours. It's important to evaluate how accurate the estimated hours are for each tasks. 

mceclip23.png

 

SCHEDULE ANALYTICS DASHBOARD

The Schedule Analytics dashboard is used to track your crew’s schedule to see which of your crews are the busiest and least busy in order to allocate work more efficiently. mceclip24.png

The top banner will show a summary of the critical totals related to Scheduling such as the number of Overdue visits All time, Overdue visits this month, Overdue visits last 7 days, Active jobs Unscheduled and Active Tasks Unscheduled.

mceclip25.png

You'll also be able to see the busiest crew schedules and the least busy crew schedules for today and tomorrow. This helps to identify which crews are the busiest and which of your crews are least busy for today to be able to distribute the work. This way, you can plan ahead and either schedule more jobs or rearrange jobs for specific crews if necessary.

mceclip26.png

 

TIMESHEET ANALYTICS DASHBOARD

The Timesheet Analytics dashboard will help you keep track of the timesheets being reviewed and approved in a timely fashion for payrolls as well as your employee work hours for the week.

mceclip27.png

This new dashboard will help to isolate and identify which employees are working overtime or close to reaching overtime hours, giving you detailed insights for the payroll week. 

From the dropdown of the last 7 days, select the Payroll Week Starting date according to your company. 

mceclip28.png

Once you've done that, you'll be able to view the Timesheet from that weekday you've selected as well as the timesheets from today. For each one, you'll be able to see the timesheets with the following statuses:

  • In Progress
  • Submitted
  • Review
  • Approved 

mceclip29.png

You'll also get a top five employees to date with the most number of hours logged for their payroll. Once an employee crosses their overtime threshold (set in the Settings), the Time will indicate the number of hours that exceed the overtime hours and the bar graph will turn red following the default overtime hours.

 

INVOICE ANALYTICS DASHBOARD

The Invoice Analytics dashboard will provide a high-level overview of your invoices and help to identify trends and proactively respond to any areas that needs your attention. mceclip30.png

You'll be able to see the number of invoices that were generated this month and last month, along with the total revenue from all of these invoices. You'll also be able to see the number of overdue invoices with the outstanding balance across all of them. You can choose to include pending invoices and/or display your overdue invoices by using the checkbox. 

mceclip31.png

You’ll also be able to see all the payments that have been processed for this month and the last month. The payments are split between the ones that were automatically added and manually added. Manual payments are those payments which you are processing via your admin account on LMN. If your customer paid via the customer portal, you will be able to see those payments within Automated section, with the count and the revenue.

mceclip32.png

The bottom section shows your Overdue Invoices. Listed are the invoice numbers, the invoice due dates, the outstanding balance of the invoices, as well as the customer’s name as entered in the invoice. You'll see all the invoices that have a date on the invoice prior to today’s date which have not been paid. If you click on the arrow icons for each invoice, the overdue invoice will be opened for review. 

mceclip33.png

 

STAFF REVENUE GOALS DASHBOARD

Measure productivity, motivate and reward your key staff for all their hard work using the Staff Revenue Goals Dashboard! 

mceclip34.png

You can now use the Staff Revenue Goals Dashboard to track sales goals, progress, and revenue earned for crew leads, salespeople, and account managers. 

1. Setup users based on Estimate or Time permissions

  • Login to your LMN account> Settings> Users & Staff > LMN Users > Select the User. Ensure that the user has the appropriate Estimate permissions and Time permissions based on the work they’re responsible for.mceclip35.png

2. Select and assign Revenue Goals

  • Scroll over to the right-hand side and click on the Revenue Goals tab. This is where you’ll set up the year that you want to track the revenue for, the position of the user, and the revenue goal.
  • Click on the +Add Goal tab and use the dropdown menu to select the year, position (crew lead, salesperson, or account manager), and enter in the revenue goal for the year.
  • Click on the Save button down at the bottom. Make sure you do this for all of your crew leads, salespeople, and account managers – so anyone you want to track the revenue goals for. Once you’re done, click on Close.
  • mceclip36.png

3. Assigned Revenue Goals within Invoices

  • Now let us take a look at how the revenue from the invoices are assigned to each person.
  • Once you have generated an invoice, you will see the account manager and salesperson on the right hand side. Ideally, this information is transferred over when the estimate was created in LMN Estimating. (Use the dropdown to change the salesperson or account manager, if needed).
  • mceclip37.png
  • Within each line item of the invoice, you can assign a crew lead, or split the amount between multiple crew leads. Click on the +Assign button and use the dropdown menu to assign a the crew lead. Once selected, you have the ability to set the percentage of total line item cost to be counted towards this selected crew lead’s revenue goal. You can also enter the percentage based on the work multiple crew leads. Once completed, you can then click Save.
  • mceclip38.png

4. Staff Goals Dashboard and Tracking

  • Click on Dashboards on the left-hand menu, and then Staff Revenue. At the top, you can select the year, whether you want to look at the goals tracking for your crew lead, account manager, or salesperson, and also check off whether you want to include pending invoices. You’ll be able to see the staff name, their position, the revenue goal, as well as the sales goal tracking progress. 
  • You also have the option to download a CSV file by clicking on Print CSV. mceclip39.png

 

DIVISION ANALYTICS DASHBOARD

The Division Analytics dashboard helps to track your invoice revenue by Division. mceclip36.png

This will help you to track each of your division’s volume of work and progress so you can address successful and improvement opportunities.

You can filter the year and month you want to see the data using the dropdown menu. You can choose to see ALL the months or filter by a specific month. If you would like to see pending invoices data, make sure you check off the “include pending invoices” box.

mceclip37.png

If you filter your month by ALL, you’ll be able to see the Division Name, along with the Invoice Count, as well as the Invoice To Date, and the % of Annual Division Goal (this would have been set in your Settings -> Estimates -> Divisions). When a division exceeds its Annual  Division Goal, LMN will indicate that for you by showing a little trophy icon in the far right column once the % is over 100.

mceclip38.png

If you choose a specific month, then you'll be able to see a new column called "vs Last Month" which shows how your current month’s revenue compares with last month’s. If there isn’t enough data from last month to do a comparison, LMN will indicate that for you as so.

mceclip39.png

 

Please note - Estimating stats will NOT include any estimates info where the "Exclude from Stats" toggle has been enabled.  The toggle can be found within the "Customer Info" tab in "Standard/Service" estimates.

 

 

 

If you require further assistance, please contact our Support Team via email at support@golmn.com or reach out to us through our Live Chats feature or by Phone: (888) 347-9864! 

Was this article helpful?

Related articles

Comments

0 comments
Article is closed for comments.