Sales YOY Analytics

Detailed document about Sales Year-Over-Year Analytics for better usage.

The Sales YOY Analytics dashboard helps analyze and understand the Company's sales year-over-year (Previous vs Current).

Your historical sales data is now at your access, you can analyze and understand your sales revenue and gross profit over time. The company’s past and current sales figures are compiled for you to strategize the business growth.

Provides a view and access to your sales history, so you can identify trends and patterns. You can gain a better view of what tactics are working and how you can further improve your figures in the future.

Sales YOY Analytics is designed to present below KPIs and Insights

KPI	Insights
Revenue YOY \| Monthly View	This KPI is used to present the revenue generated based on the monthly view.
Close Ratio \| Year over Year	The close ratio is compared year over year.
Yearly view Revenue	Metrics to understand Total Revenue generated per Year, You can also compare Previous vs Current Years Total Revenue
Invoiced($) \| Year over Year	The invoiced amount is compared year over year, to get the pattern of the data.
Jobs Accepted by Year	Understand Total Jobs Accepted for current vs previous years.
Jobs Declined by Year	Understand Total Jobs Declined for this current versus the previous year.
Proposed ($) vs Accepted ($) vs Declined ($) \| Monthly view	The underlying pattern among the proposed, accepted, and declined revenue impact is shown based on the monthly view year over year.
Revenue by Job Status \| Year Over Year	Helps you understand the revenue from each job status over the year.
Salesperson revenue ($) board \| Year over Year	Track and Understand the revenue from each salesperson over the years.
State-wise Revenue \| Year over Year	To analyze and understand yearly Revenue, from each state.
Sales by Service Category per Year	To analyze and understand Yearly Revenue, Gross Profit, and Cost at the Service Category Level, and also you can compare to your previous year's sales
Revenue by Service Status \| Year over Year	Helps you understand the revenue from each service status over the year.
Accepted vs Proposed per Salesperson \| Year over Year	Over the years the revenue generated from accepted and proposed jobs by each salesperson.

Calculation

Revenue = SUM(Price) considered.

Gross Profit = SUM(Price) - SUM(Cost)

Note*
Price = If Actual Price is not set for the service then Estimated Price is considered.

Here are the business constraints that are applied.

All the Metrics are calculated for the applied date range filter.
Not considered the Jobs that are under Job status `Generated`
Considered only active Jobs
Considered only active Services

Importance of having Sales YOY

It paints a complete picture of whether your company is coming up short or is meeting or beating the previous year's performance.
Your year-over-year calculations can help you measure your business’s performance. You can see if your business is growing from year to year. The year-over-year growth rate smooths out any monthly volatility. Instead of seeing large increases and decreases between seasonal months, you can compare your current business numbers to the same time last year.
It provides you with more accurate information for monthly revenue growth, especially with products or services that are seasonal. It provides you with an important measurement of how your business performs. It helps you to see how your business's financial performance changes over time.
It Helps you spot errors, similar to using a comparative income statement, doing a year-over-year analysis might help you find errors and discrepancies in your books.
If there are big increases or decreases from last year, you might have incorrectly recorded something. Examining several periods year-over-year can help you narrow down when you may have made the error.