Loading
CRM Analytics
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Upload a Quota Dataset to the Revenue Operations Analytics App

            You are here:

            1. Salesforce Help
            2. Docs
            3. CRM Analytics

            Upload a Quota Dataset to the Revenue Operations Analytics App

            If you don’t have Salesforce Forecasting enabled, you must add quota data to your app. Without quota data, the Team Performance charts can’t provide an accurate visualization of performance metrics.

            Required Editions

            Available with CRM Analytics, which is available for an extra cost in Enterprise, Performance, and Unlimited Editions. Also available in Developer Edition. Requires a CRM Analytics Plus license.
            Permission Sets Needed
            To create and manage the Revenue Operations Analytics app: CRM Analytics Plus Admin permission set
            To use the Revenue Operations Analytics app: CRM Analytics Plus User permission set

            Your quota data must be in a CSV file and contain these fields in this order.

            • StartDate (yyyy-mm-dd format)
            • QuotaAmount
            • OwnerName
            • Username

            For an example, see Sales Analytics Example .CSV File.

            1. From the Analytics tab or Analytics Studio, click Browse and find the Quota dataset.
            2. In the Quota dataset dropdown menu, select Edit.
            3. In the upper-right corner, click the replace data Analytics Studio replace data in dataset icon icon.
            4. Locate the CSV file.
            5. Click Next.
            6. If your fiscal period starts on a date other than January 1, update the Quota Metadata file.
              1. Copy the JSON from Sales Analytics Quota Dataset JSON File and paste it into a text editor.
              2. Change the value of "fiscalMonthOffset" from 4 to a number that represents the month that your fiscal period starts, where “0” indicates January, “1” February, and so on, up to “11” for December.
              3. Save the file.
              4. On the Replace Dataset Data page, locate the Data Schema File area.
              5. Click the arrow next to the Quota .JSON file, select Replace File, find the file that you saved and upload it.
            7. On the Replace Dataset Data page, click Next.
            8. Select the first column —QuotaAmount— and in the Field Attributes panel on the right, set Field Type to Measure.
              Set the QuotaAmount field attribute to Measure.
            9. Upload your CSV file with the quota data.
            10. Rerun the dataflow to update the dashboards.
              1. In Data Manager, click Dataflows & Recipes and find your app’s dataflow.
              2. In the app dataflow’s dropdown menu, click Run now.
             
            Loading
            Salesforce Help | Article