Commerce analytics

  • Article

Important

This content is archived and is not being updated. For the latest documentation, go to What's new and planned in Dynamics 365 Commerce. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview General availability
Users by admins, makers, or analysts Nov 15, 2021 To be announced

Business value

Dynamics 365 Commerce analytics enables organizations to make informed data-driven decisions about their business with rich insights from transactional data as well as from behavioral e-commerce user data. Unified omnichannel insights allow for a cohesive end-to-end view of business operations. Robust extensibility allows organizations to extend and customize the insights to suit their unique business needs. Commerce analytics is built on a modern scalable platform, and enables organizations to use powerful industry-leading and familiar tools such as Power BI and Azure Synapse Analytics.

Feature details

This feature enables native analytics based on Dynamics 365 Commerce sales, operational insights, and e-commerce web activity. The feature also enables high-scale data storage using Azure Data Lake, standardized analytics schema using Common Data Model, high-performance querying using Azure Synapse Analytics, and interactive visualization using Power BI.

Turn-key analytics will be available for business users and data analysts in Commerce headquarters, as well as embedded scoped access at the point of sale (POS) for store managers and store associates. This feature also empowers data engineers with standardized access to both aggregated and disaggregated data for custom ad-hoc querying and extending and customizing default reports. This feature includes the following key reports:

Core sales analytics. This category of reports provides essential sales and operational insights needed to run commerce business operations:

  • Sales and margin performance.
  • Inventory analysis.
  • Loyalty and gift card analysis.

Core e-commerce web activity analytics. This category of reports provides insights about visitor engagement on your e-commerce website:

  • E-commerce sales conversion funnel.
  • E-commerce product impressions.
  • E-commerce page module conversion and effectivity.

Mashups. This category of reports provides unique insights about your e-commerce visitor engagement by combining web activity data with historical transactional data:

  • E-commerce conversion funnel by customer lifetime value (LTV).
  • E-commerce acquisition analysis by gross margin return on inventory investment (GMROII).
  • E-commerce product impressions by product category hierarchy.

Point of sale (POS). This category of reports provides contextual operational insights for store managers and cashiers directly at the POS:

  • Channel sales.
  • Customer RFM and spend analysis.
  • Order activity.

Connected Spaces. This category of reports provides insights about shoppers in your store by correlating sales transactional insights with observational data collected by in-store sensors and cameras:

  • Foot traffic analysis.
  • Queue length.
  • Display effectiveness.

Commerce Analytics - Sales insights.

Commerce Analytics - Payment method insights.

Commerce Analytics - Customer metrics.

Commerce Analytics - Metrics comparison.

Commerce Analytics - E-commerce web analysis.

See also

Feature exploration (video)

Commerce analytics Preview (docs)