Skip to Content
Business Trends
Author's profile photo Jan Matthes

Embedded customer analytics with SAP Business ByDesign CRM

One of the key assets of SAP Business ByDesgin is its built-in in-memory analytics. By using embedded analytics, planning & simulation you get perfect transparency on all your customer engagement activities (aka analytical CRM, customer analytics) in marketing, sales and service without need for additional best-of-breed analytics tools or complicated data extraction.

Sign-up for a free online training with exercises in demo systems and
certification on SAP Business ByDesign

ByDesign CRM incl. customer analytics

ByDesign analytics

ByDesign customer analytics provides:

  • Analytics, planning & simulation based on real-time data either embedded or in Excel
  • Deep insight through interactive drill-down with predefined key figures & characteristics for marketing, sales & service
  • Insight to Action: Direct navigation to business data e.g. open account or create target group
  • More than 500 built-in reports of which more than 50 are tailored for marketing, sales & service

Since our 1811 release the embedded customer analytics will provide enhanced capabilities to build and adapt sales, marketing and service dashboards and to embed KPIs to measure success. You can:

  1. Define, use & adapt analytical overview pages with free definition of key figures & drill-down
  2. Embed highly aggregated key performance indicators (KPI) with target, reference and threshold values
  3. Directly navigate to the full report
  4. Many of the report views and KPIs are available as out-of-the-box content in the analytics work center.

Furthermore you can use the KPI Designer (in the key user analytics work center) to design marketing, sales & service KPIs based on standard key figures with target, reference and threshold values. Here you can see more details and examples.


In the following sections you find more insights on the benefits of ByDesign customer analytics:

  1. Customer analytics – measure success with flexible drill down either in the browser or in Excel
  2. Sales Pipeline Simulation
  3. Flexible Sales Planning and success tracking
  4. More helpful links and resources

1. Customer analytics – measure success with flexible drill downs

ByDesign provides powerful predefined reports and data sources for marketing, sales and service employees and manager.

  1. Visibility & control of Key Figures such as number of members, responders, response rate, number of leads, opportunities, quotes, orders…
  2. Free selection of characteristics like sales unit, account, contact, product, country, language etc.
  3. Display with various chart types including table view and analysis using Excel as frontend
  4. Navigate from reports to e.g. accounts. Additionally target groups can be created from reports e.g. the sales order volume to filter for top revenue accounts only
  5. More than 50 marketing, sales and service reports in 12 work centers
  6. Flexibility to build own reports and data sources

Here is a video which shows how to slice and dice a report and how to consume reports in Excel:

More tips and tricks for using ByD reports in Excel

VBA macros for using ByD reports in Excel


2. Sales Pipeline Simulation

With the sales pipeline simulation sales reps can analyze their opportunities and do “what-if” simulations to see the effect on your pipeline:

  1. Analyze opportunities by sales phase, progress, change of success and expected value
  2. Simulation allows to change multiple opportunities and to see the potential effect on the pipeline
  3. Commit or cancel changes with one click

Here is a demo

3. Flexible Sales Planning and success tracking

ByDesign sales planning provides and easy way to set targets for your sales team and to track the success:

  • Easy plan creation and copy of plan data
  • Workplace-embedded planning with Excel
  • Powerful Plan/Actual reporting to monitor sales targets, forecasts, and revenue at a glance


4. More helpful resources on ByDesign analytics

Overview on ByDesign customer engagement & commerce

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo wuyanxia wuyanxia
      wuyanxia wuyanxia

      3. Flexible Sales Planning and success tracking,

      • Powerful Plan/Actual reporting to monitor sales targets, forecasts, and revenue at a glance