---
schema_version: "1"
id: 43dc9129695ff7d5ef528ff9c0ca5d55dc16fb81aaa8a15d051ca2bce1c21d78
title: Sales Analytics Account Dashboard (Embedded)
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_app_sales_analytics_dashboard_summary_account.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_app_sales_analytics_dashboard_summary_account.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 1a36ecbcf26efde9a027487a231ef640528bc436f206303b6abcf7e6b3b82bde
description: Get a snapshot of an account, including its average sales cycle, opportunity amount, and win rate. The dashboard is intended for use when embedded in a Salesforce account or opportunity page.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Sales Analytics Account Dashboard (Embedded)

Get a snapshot of an account, including its average sales cycle, opportunity amount, and win rate. The dashboard is intended for use when embedded in a Salesforce account or opportunity page.

![Sales Analytics Account Summary dashboard](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_apps_sales_analytics_dashboard_account_summary.png)

## Default Behavior and Recommended Options

Embed the dashboard in either Lightning and Aloha page layouts.

Edit the dashboard to set target lines and set the upper bounds for gauges. With the dashboard open in CRM Analytics Studio, click the edit icon ![Analytics edit dashboard icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_apps_edit_icon.png) to open the designer, then click the widget you want to edit. Then look for the value you want to change in the properties panel on the right and change it there. Save the dashboard.

## Wizard and Other Setup Options

Average Discount and Breakdown by Product widgets. Only included if you select Products on the wizard page that lets you add objects to the app. Otherwise it includes two activities widgets.

Cases widget. Only included if you select Cases on the wizard page that lets you add objects to the app.

If your org uses account hierarchy, the dashboard can be embedded so that all child account KPIs roll up into KPIs for the parent.

## Embedding Syntax

Here’s the syntax for embedding the dashboard in either Salesforce Classic or Lightning Experience pages. Note the difference between using a filter for single accounts or account hierarchy. `Opportunity` is the developer name for the opportunity dataset. Use the exact developer name of the dataset when embedding the dashboard.

Salesforce Classic

_Embedding the dashboard in the Account page layout._

Here’s the syntax to filter by a single account:

```
{"datasets": { "opportunity": [{"fields": ["AccountId"] ,"filter": { "operator": "in", "values": ["$Id"] }
          } ]}}
```

Here’s the syntax to filter using account hierarchy. Roll ups include KPIs for the account and its child accounts:

```
{"datasets": { "opportunity": [{"fields": ["Account.Parent.AccountParents"] ,"filter": { "operator": "in",
          "values": ["$Id"] } } ]}}
```

_Embedding the dashboard in the Opportunity page layout._

Here’s the syntax to filter by a single account:

```
{"datasets": { "opportunity": [{"fields": ["AccountId"] ,"filter": { "operator": "in", "values":
          ["$AccountId"] } } ]}}
```

Here’s the syntax to filter using account hierarchy. Roll ups include KPIs for the account and its child accounts:

```
{"datasets": { "opportunity": [{"fields": ["Account.Parent.AccountParents"] ,"filter": { "operator": "in",
          "values": ["$AccountId"] } } ]}}
```

Lightning Experience

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note Syntax for Lightning Experience uses single quotes instead of double quotes.

_Embedding the dashboard in the Account page layout._

Here’s the syntax to filter by a single account:

```
{'datasets': { 'opportunity': [{'fields': ['AccountId'] ,'filter': { 'operator': 'in', 'values': ['$Id'] } }
      ]}}
```

Here’s the syntax to filter using account hierarchy. Roll ups include KPIs for the account and its child accounts:

```
{'datasets': { 'opportunity': [{'fields': ['Account.Parent.AccountParents'] ,'filter': { 'operator': 'in', 'values':
          ['$Id'] } } ]}}
```

_Embedding the dashboard in the Opportunity page layout._

Here’s the syntax to filter by a single account:

```
{'datasets': { 'opportunity': [{'fields': ['AccountId'] ,'filter': { 'operator': 'in', 'values': ['$AccountId'] } }
        ]}}
```

Here’s the syntax to filter using account hierarchy. Roll ups include KPIs for the account and its child accounts:

```
{'datasets': { 'opportunity': [{'fields': ['Account.Parent.AccountParents'] ,'filter': { 'operator': 'in', 'values':
          ['$AccountId'] } } ]}}
```

## KPI Calculations

Default Widgets

- Average Sales Cycle. Average of opportunity close date - Created date for won opportunities for life of account.
- Win Rate. Total won/ Total closed (won or lost) for life of account.
    - Total Won. Total won for life of account.
    - Total Lost. Total lost for life of account.
- Open Opportunities. Open opportunities with any close date for the account.
    - Count. Total count of open opportunities with any close date for the account.
    - Push. Total number of open opportunities for the account that have been pushed at least once.

Optional Widgets

Analytics creates these widgets depending on selections you make on the wizard page that lets you add objects to the app.

- Average Discount. 1 - (Product total price for all products sold to account / Product list price). Only appears if you add Products.
- Product Breakdown. Sum of product total price grouped by product. Only appears if you add Products.
- Number of Open Activities. (Not shown.) Count of open tasks and events related to account. Only appears if you add Products.
- Number of Overdue Activities. (Not shown.) Count of overdue tasks related to account. Only appears if you do not add Products.
- Open Cases. Number of open cases related to account. Only appears if you add Cases.