---
schema_version: "1"
id: 974f589f884f6185da36ff79cc48aa975d9d2d96be196fb4da3e539983af631e
title: Forecasting and Quotas Data in Sales Analytics
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_app_sales_wave_update_dataset.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_app_sales_wave_update_dataset.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: f74c4c3e7fab79f285d8f92764f486f4b45e19923c6d607e6e4fc2c28bad685a
description: Sales Analytics gives you a choice for how to include your team’s quotas depending on whether you use the Salesforce Forecasting feature to store quotas data.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Forecasting and Quotas Data in Sales Analytics

Sales Analytics gives you a choice for how to include your team’s quotas depending on whether you use the Salesforce Forecasting feature to store quotas data.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d20540e27">User Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d20540e27 ">To create and manage CRM Analytics apps:</td>
            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d20540e27 ">Manage CRM Analytics Templated Apps</td>
          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d20540e27 ">&nbsp;</td>
            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d20540e27 ">Edit CRM Analytics Dataflows</td>
          </tr>
        </tbody>
      </table>

![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 Sales Cloud Einstein customers who use Sales Analytics must use Salesforce Forecasting to see quota data. They can't edit the quota dataset.

You have the following options for including quotas data in Sales Analytics.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small " summary="Sales Analytics Quotas Data Options">
        <caption>Sales Analytics Quotas Data Options</caption>
        <colgroup>
          <col style="width:25%">
          <col style="width:25%">
          <col style="width:25%">
          <col style="width:25%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d20540e54">Option</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d20540e56">Sales Cloud Settings</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d20540e58">Configuration Wizard Settings</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d20540e60">Additional Setup Requirements</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Option" class="slds-cell-wrap" style="vertical-align:top;" headers="d20540e54 ">1</td>
            <td data-label="Sales Cloud Settings" class="slds-cell-wrap" style="vertical-align:top;" headers="d20540e56 ">
              <ul>
                <li>Forecasting is enabled </li>
                <li>Forecasting includes forecast quota data.</li>
              </ul>
            </td>
            <td data-label="Configuration Wizard Settings" class="slds-cell-wrap" style="vertical-align:top;" headers="d20540e58 ">Select Collaborative Forecasting in first wizard screen that lets you add
              objects.</td>
            <td data-label="Additional Setup Requirements" class="slds-cell-wrap" style="vertical-align:top;" headers="d20540e60 ">None. Sales Analytics automatically adds quota data from the Forecasts
              object.</td>
          </tr>
          <tr class="">
            <td data-label="Option" class="slds-cell-wrap" style="vertical-align:top;" headers="d20540e54 ">2</td>
            <td data-label="Sales Cloud Settings" class="slds-cell-wrap" style="vertical-align:top;" headers="d20540e56 ">
              <ul>
                <li>Forecasting is enabled </li>
                <li>Forecasting <em>does not</em> include forecast quota data.</li>
              </ul>
            </td>
            <td data-label="Configuration Wizard Settings" class="slds-cell-wrap" style="vertical-align:top;" headers="d20540e58 ">Select Collaborative Forecasting in first wizard screen that lets you add
              objects.</td>
            <td data-label="Additional Setup Requirements" class="slds-cell-wrap" style="vertical-align:top;" headers="d20540e60 ">Create .CSV file with quotas data, upload to CRM Analytics, rerun dataflow. See
              next instructions.</td>
          </tr>
          <tr class="">
            <td data-label="Option" class="slds-cell-wrap" style="vertical-align:top;" headers="d20540e54 ">3</td>
            <td data-label="Sales Cloud Settings" class="slds-cell-wrap" style="vertical-align:top;" headers="d20540e56 ">Forecasting is <em>not</em> enabled</td>
            <td data-label="Configuration Wizard Settings" class="slds-cell-wrap" style="vertical-align:top;" headers="d20540e58 ">No setting available. Wizard does not give you the option of adding forecast
              data.</td>
            <td data-label="Additional Setup Requirements" class="slds-cell-wrap" style="vertical-align:top;" headers="d20540e60 ">Create .CSV file with quotas data, upload to CRM Analytics, rerun dataflow. See
              next instructions.</td>
          </tr>
        </tbody>
      </table>

![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 Selecting both Opportunity Splits and Collaborative Forecasting pulls in quota data for the split type you've selected in your org.

Wizard settings are optional, depending on whether you want to include forecasting data in your app.

With Option 1, Sales Analytics automatically adds quotas data to your app and its dashboards. With Options 2 and 3, add quotas data to your app by following these instructions.

![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 When you work with .CSV files you want to import to Sales Analytics, create and open them using only a UTF-8-compliant text editor. Opening them in Microsoft Excel or other spreadsheet software reformats .CSV files and makes them unusable in Sales Analytics

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

Important When you create the .CSV file, be sure it contains these fields, in this order, with exactly these names. Field names are case-sensitive.

1. StartDate (in yyyy-mm-dd format)
2. QuotaAmount
3. OwnerName
4. Username

1. Create a .CSV file to include the fields just described, that is StartDate (in yyyy-mm-dd format), QuotaAmount, OwnerName, Username. For an example, see [Sales Analytics Example .CSV File](https://help.salesforce.com/s/articleView?id=analytics.bi_app_sales_wave_quota_csv.htm&release=264.0.0&type=5 "Here’s an example of the .CSV file you create to update the Sales Analytics Quota (Target) dataset.").
2. Save the file to a location that you can easily remember.
3. In Salesforce, go to the CRM Analytics home page and find the Quota dataset.
4. Click the arrow at the upper right corner of the dataset panel and select Edit.
    
    ![Analytics Studio edit dataset](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_dataset.png)
5. Salesforce displays the dataset editing screen for the Quota dataset. Look for **Replace Data** in the upper right corner and click it.
    
    ![Analytics Studio replace data in dataset](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_replace_dataset.png)
6. In the dialog box that opens, navigate to the .CSV file you created in Step 1, and double-click it.
7. Click **Next** to open the Replace Dataset Data page.
8. If your fiscal period is different than the calendar period, that is if it starts on a date other than January 1, update the Quota Metadata file. If your fiscal period starts on January 1, skip to the next step.
    1. Copy the JSON from [Sales Analytics Quota Dataset JSON File](https://help.salesforce.com/s/articleView?id=analytics.bi_app_sales_wave_quota_json.htm&release=264.0.0&type=5 "Use this file to update the Sales Analytics Quota dataset with your fiscal year start date if it’s not January 1.") and paste it into a text editor of your choice.
    2. Change the value of `"fiscalMonthOffset"` from 4 to a number that represents the month your fiscal period starts. In Sales Analytics metadata, the numeral “0” stands for January, “1” stands for February, and so on up to “11,” which stands for December. Save the file to your desktop.
    3. In CRM Analytics Studio, go to the Replace Dataset Data page and locate the Data Schema File area of the page. Click the arrow next to Quota .JSON file, select Replace File, find the file you saved and upload it to CRM Analytics.
9. On the Replace Dataset Data page, click **Next** to open the Edit Field Attributes page. The first column —QuotaAmount— must be selected. If not, select it. In the **Field Attributes** panel on the right, make sure **Field Type** is set to **Measure**.
    
    ![Set the QuotaAmount field attribute to Measure.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_app_dataset_set_field_type.png)
10. Click **Upload**. You’re asked to confirm that you want to replace the file. Click **Replace** to upload the file.
11. After uploading your quota data, rerun the dataflow to update the dashboards.
    1. Click the Gear menu at the upper right of the Sales Analytics screen and select Data Manager.
    2. Select Dataflow view from the menu at the top left of the Data Manager screen.
        
        ![The Analytics Dataflow Scheduler](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_app_data_manager_dataflow.png)
    3. Find your app; which can mean scrolling down the page. Open the menu on the far right of the screen next to the app icon and name, and click Start.![Dataflow Monitor Success](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_app_dataflow_success2.png)That’s it. The dataflow assures that Sales Analytics has your company’s latest sales data. You can learn more about dataflows from [Schedule the Sales App Daily Dataflow](https://help.salesforce.com/HTViewHelpDoc?id=bi_app_sales_wave_schedule_dataflow.htm&language=en_US).

- **[Edit the Forecast Dashboard Data Source Connection Make Sure Quotas Data Is Accurate](https://help.salesforce.com/s/articleView?id=analytics.bi_app_sales_wave_update_dataset_edit_data_source_connection.htm&release=264.0.0&type=5)**  
    If Sales Analyticsquotas numbers look higher than expected in the Forecast dashboard, it can be because the app counts some quotas twice. To make sure that the dashboard accurately reflects your team’s quotas, specify the dataset field the dashboard uses as its data source
- **[Sales Analytics Example .CSV File](https://help.salesforce.com/s/articleView?id=analytics.bi_app_sales_wave_quota_csv.htm&release=264.0.0&type=5)**  
    Here’s an example of the .CSV file you create to update the Sales Analytics Quota (Target) dataset.
- **[Sales Analytics Quota Dataset JSON File](https://help.salesforce.com/s/articleView?id=analytics.bi_app_sales_wave_quota_json.htm&release=264.0.0&type=5)**  
    Use this file to update the Sales Analytics Quota dataset with your fiscal year start date if it’s _not_ January 1.