{"id":32129,"date":"2022-07-13T11:39:33","date_gmt":"2022-07-13T06:09:33","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=32129"},"modified":"2024-07-11T15:53:53","modified_gmt":"2024-07-11T10:23:53","slug":"exploring-sales-usage-reporting-feature-in-dynamics-365-ce-sales-analytics","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2022\/07\/exploring-sales-usage-reporting-feature-in-dynamics-365-ce-sales-analytics\/","title":{"rendered":"Exploring sales usage reporting feature in Dynamics 365 CE sales analytics"},"content":{"rendered":"<p>Nowadays Microsoft is working on enhancing the reporting capabilities within Dynamics 365, there are many embedded <a href=\"https:\/\/www.inogic.com\/services\/microsoft-power-platform\/microsoft-power-bi-data-visualisation\/\" target=\"_blank\" rel=\"noopener\">Power BI<\/a> reports that are now available in Dynamics 365 sales.<\/p>\n<p>In the previous <a href=\"https:\/\/www.inogic.com\/blog\/2022\/02\/configuring-sales-acceleration-reporting-preview-feature-in-dynamics-365-ce\/\" target=\"_blank\" rel=\"noopener\">blog<\/a>, we have already explored the capabilities of one of such embedded Power BI report named \u201cSales Acceleration reports\u201d. In this blog, we will explore another such exciting embedded Power BI reporting named \u201cSales usage reports\u201d.<\/p>\n<p>By enabling the \u201cSales usage reports\u201d reporting feature you get a quick overview of sales progress through the below 4 available dashboards:<\/p>\n<ol>\n<li>Opportunity Usage reporting<\/li>\n<li>Lead Usage reporting<\/li>\n<li>Account Usage reporting<\/li>\n<li>Contact Usage reporting<\/li>\n<\/ol>\n<p>This reporting feature lets the sales manager analyze metrics and key performance indicators (KPIs) which then can be tracked and used as a reporting tool for identifying the area of improvement for increasing sales growth. It tracks the leads and opportunities KPIs and Metrics by which they come to know how leads and opportunities have performed over a period.<\/p>\n<p><strong>Configuration steps:<\/strong><\/p>\n<p>Open the Sales hub app &#8211;&gt; Navigate to \u201cApp Settings\u201d &#8211;&gt; click on \u201csales usage reports\u201d &#8211;&gt; by default, this feature is disabled. Just flip the control to enable it as shown below:<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-32130\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/1Dynamics-365-Sales-Analytics.jpeg\" alt=\"Dynamics 365 Sales Analytics\" width=\"1129\" height=\"628\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/1Dynamics-365-Sales-Analytics.jpeg 1129w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/1Dynamics-365-Sales-Analytics-300x167.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/1Dynamics-365-Sales-Analytics-1024x570.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/1Dynamics-365-Sales-Analytics-768x427.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/1Dynamics-365-Sales-Analytics-660x367.jpeg 660w\" sizes=\"(max-width: 1129px) 100vw, 1129px\" \/><\/p>\n<p>Navigate to the \u201cSales\u201d area\u2013&gt; under \u201cSales Analytics\u201d \u2013&gt; click on \u201cSales usage reports\u201d. You will be navigated to the \u201cSales usage reports\u201d dashboard page. As the report is being provisioned for the first time, the following message is shown:<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-32131\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/2Dynamics-365-Sales-Analytics.jpeg\" alt=\"Dynamics 365 Sales Analytics\" width=\"1375\" height=\"660\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/2Dynamics-365-Sales-Analytics.jpeg 1375w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/2Dynamics-365-Sales-Analytics-300x144.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/2Dynamics-365-Sales-Analytics-1024x492.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/2Dynamics-365-Sales-Analytics-768x369.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/2Dynamics-365-Sales-Analytics-660x317.jpeg 660w\" sizes=\"(max-width: 1375px) 100vw, 1375px\" \/><\/p>\n<p><strong>NOTE:<\/strong> when navigated to this report note that by default \u201cOpportunity Usage reporting\u201d dashboard is selected.<\/p>\n<p><strong>Opportunity Usage reporting:<\/strong><\/p>\n<p>Below is the screenshot of the Power BI embedded sales usage report showing the \u201cOpportunity Usage Reporting\u201d dashboard by default:<\/p>\n<p><strong> <img decoding=\"async\" class=\"alignnone size-full wp-image-32132\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/3Dynamics-365-Sales-Analytics.jpeg\" alt=\"Dynamics 365 Sales Analytics\" width=\"1374\" height=\"676\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/3Dynamics-365-Sales-Analytics.jpeg 1374w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/3Dynamics-365-Sales-Analytics-300x148.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/3Dynamics-365-Sales-Analytics-1024x504.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/3Dynamics-365-Sales-Analytics-768x378.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/3Dynamics-365-Sales-Analytics-660x325.jpeg 660w\" sizes=\"(max-width: 1374px) 100vw, 1374px\" \/><\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-32133\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/4Dynamics-365-Sales-Analytics.jpeg\" alt=\"Dynamics 365 Sales Analytics\" width=\"1422\" height=\"405\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/4Dynamics-365-Sales-Analytics.jpeg 1422w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/4Dynamics-365-Sales-Analytics-300x85.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/4Dynamics-365-Sales-Analytics-1024x292.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/4Dynamics-365-Sales-Analytics-768x219.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/4Dynamics-365-Sales-Analytics-660x188.jpeg 660w\" sizes=\"(max-width: 1422px) 100vw, 1422px\" \/><\/p>\n<p>This reporting allows the sales manager to track different KPIs and Metrics as explained below:<\/p>\n<p><strong>KPIs:<\/strong><\/p>\n<ul>\n<li>Opportunities Converted &#8211; KPI that tracks the WON opportunities<\/li>\n<li>Opportunity Conversion Ratio &#8211; KPI that tracks % of opportunity that WON successfully<\/li>\n<li>Avg time (in days) for opportunity conversion &#8211; KPI that tracks the avg no. of days opportunity took to WON successfully<\/li>\n<\/ul>\n<p><strong>Metrics charts:<\/strong><\/p>\n<ul>\n<li>Opportunities over time &#8211; Metric that tracks how the opportunities are trending month-over-month in your organization.<\/li>\n<li>Opportunity status &#8211; Metric that tracks a breakdown of opportunities by status (Open, Won, Lost)<\/li>\n<li>Top users for most opportunities created &#8211; Metric that tracks the breakdown of users who created the most opportunities.<\/li>\n<li>Top users for most opportunities converted &#8211; Metric that tracks the breakdown of users who converted opportunities into won deals<\/li>\n<\/ul>\n<p><strong>Indicators:<\/strong><\/p>\n<ul>\n<li>A green upward triangle indicates an improvement in the score<\/li>\n<li>A red downward triangle indicates a decline in the score<\/li>\n<\/ul>\n<p><strong>Data Filtering:<\/strong><\/p>\n<p>Use the filtering for filtering the period on the basis of the below filtering attributes:<\/p>\n<ul>\n<li>Date: This filter gives the capability to select a timeframe, by default selected filter value is the last 20 weeks<\/li>\n<li>User: This filter gives the capability to select a user, by default selected filter value is All<\/li>\n<li>Manager: This filter gives the capability to select a manager, by default selected filter value is All<\/li>\n<li>Business Unit: This filter gives the capability to select a business unit, by default selected filter value is All<\/li>\n<li>Role: This filter is not functioning as of now, as when I was exploring there was no filtering option available under this filter, by default selected filter value is All<\/li>\n<\/ul>\n<p><strong>Lead Usage reporting:<\/strong><\/p>\n<p>Below is the screenshot of the Power BI embedded sales usage report showing the \u201cLead Usage Reporting\u201d dashboard by default:<\/p>\n<p>This reporting allows the sales manager to track different KPIs and Metrics as explained below:<\/p>\n<p><strong>KPIs:<\/strong><\/p>\n<ul>\n<li>Leads Qualified &#8211; KPI that tracks the QUALIFIED leads<\/li>\n<li>Lead Conversion Ratio &#8211; KPI that tracks % of the lead that QUALIFIED successfully<\/li>\n<li>Avg time (in days) for lead conversion &#8211; KPI that tracks the avg no. of days lead took to QUALIFIED successfully<\/li>\n<\/ul>\n<p><strong>Metrics charts:<\/strong><\/p>\n<ul>\n<li>Leads over time &#8211; Metric that tracks how the leads are trending month-over-month in your organization.<\/li>\n<li>Lead status &#8211; Metric that tracks a breakdown of leads by status (Open, Won, Lost)<\/li>\n<li>Top users for most leads created &#8211; Metric that tracks the breakdown of users who created the most leads.<\/li>\n<li>Top users for most leads qualified- Metric that tracks the breakdown of users who qualified leads<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-32134\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/5Dynamics-365-Sales-Analytics.jpeg\" alt=\"Dynamics 365 Sales Analytics\" width=\"1379\" height=\"683\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/5Dynamics-365-Sales-Analytics.jpeg 1379w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/5Dynamics-365-Sales-Analytics-300x149.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/5Dynamics-365-Sales-Analytics-1024x507.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/5Dynamics-365-Sales-Analytics-768x380.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/5Dynamics-365-Sales-Analytics-660x327.jpeg 660w\" sizes=\"(max-width: 1379px) 100vw, 1379px\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-32135\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/6Dynamics-365-Sales-Analytics.jpeg\" alt=\"Dynamics 365 Sales Analytics\" width=\"1571\" height=\"419\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/6Dynamics-365-Sales-Analytics.jpeg 1571w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/6Dynamics-365-Sales-Analytics-300x80.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/6Dynamics-365-Sales-Analytics-1024x273.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/6Dynamics-365-Sales-Analytics-768x205.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/6Dynamics-365-Sales-Analytics-1536x410.jpeg 1536w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/6Dynamics-365-Sales-Analytics-660x176.jpeg 660w\" sizes=\"(max-width: 1571px) 100vw, 1571px\" \/><\/p>\n<p>Indicators and Data filtering working are the same as explained above.<\/p>\n<p>More details about sales usage report KPIs and Metrics you can find in this <a href=\"https:\/\/docs.microsoft.com\/en-gb\/dynamics365\/sales\/view-understand-sales-usage-reports\" target=\"_blank\" rel=\"noopener\">doc<\/a>.<\/p>\n<p>While exploring further this report, I could not explore the \u201cAccount Usage Reporting\u201d and \u201cContact Usage Reporting\u201d dashboards. As I was getting the following error message:<\/p>\n<p><em>\u201cThere was a problem rendering your report. Please contact Microsoft with error code: 5000101\u201d<\/em><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-32136\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/7Dynamics-365-Sales-Analytics.jpeg\" alt=\"Dynamics 365 Sales Analytics\" width=\"1055\" height=\"419\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/7Dynamics-365-Sales-Analytics.jpeg 1055w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/7Dynamics-365-Sales-Analytics-300x119.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/7Dynamics-365-Sales-Analytics-1024x407.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/7Dynamics-365-Sales-Analytics-768x305.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/7Dynamics-365-Sales-Analytics-660x262.jpeg 660w\" sizes=\"(max-width: 1055px) 100vw, 1055px\" \/><\/p>\n<h2><strong>Conclusion<\/strong><\/h2>\n<p>Sales usage embedded Power BI report provides sales manager more insights of leads and opportunities performance over a period through KPIs and Metrics charts.<\/p>\n<p><a href=\"https:\/\/www.inogic.com\/product\/productivity-apps\/user-adoption-monitor-in-dynamics-crm\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"alignnone wp-image-32137\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/1-1.jpg\" alt=\"\" width=\"848\" height=\"212\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/1-1.jpg 800w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/1-1-300x75.jpg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/1-1-768x192.jpg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/07\/1-1-660x165.jpg 660w\" sizes=\"(max-width: 848px) 100vw, 848px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nowadays Microsoft is working on enhancing the reporting capabilities within Dynamics 365, there are many embedded Power BI reports that are now available in Dynamics 365 sales. In the previous blog, we have already explored the capabilities of one of such embedded Power BI report named \u201cSales Acceleration reports\u201d. In this blog, we will explore\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2022\/07\/exploring-sales-usage-reporting-feature-in-dynamics-365-ce-sales-analytics\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2361],"tags":[2615,2616],"class_list":["post-32129","post","type-post","status-publish","format-standard","hentry","category-technical","tag-dynamics-365-ce-sales-analytics","tag-sales-usage-report"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/32129","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=32129"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/32129\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=32129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=32129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=32129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}