Skip to main content
Sign in

Building Block: Revenue Ranges for Salesforce

  • Updated

The following is a guideline to follow when using the Building Block: Revenue Ranges for Salesforce recipe. Please read these guidelines before cloning the recipe.


Overview

This Building Block uses AnnualRevenue data on Salesforce Account records and categorizes the revenue into a range. 

This recipe provides the following:

  • A bot that will be used to import the Salesforce Accounts data source and run the related job
  • Jobs that process Salesforce Account annual revenue values into ranges
  • An analytics report showing the distribution of ranges in the Salesforce Account object
  • An App Factory Dashboard app that can be used to share the metrics with additional team members for easy viewing

Preparation

  • If a data source does not already exist, create a data source for the Salesforce Lead object with at least the following attributes: Id, AnnualRevenue, Name, IsDeleted.
    *Note: If these data sources are already created, please verify that the following attributes are defined in the data sources.

[Optional] This process uses the Openprise Data Catalog “Sample - Annual Revenue Segments” reference table. If you would like to modify the revenue segments to be used within this process you can download the Data Catalog and customize the values. More can be read in the articles listed below. 

    1. Openprise Data Catalog
    2. Infer task - you'll need to modify the infer task to point to your customized segments

Clone

To clone the Building Block recipe, navigate to Projects Recipes and select the building block recipe to clone. Hint: search the keyword Building Block to easily see which recipes are available.

projects - recipes.png

Revenue ranges.png

You will need to provide:

  • Project name
  • Prefix and/or suffix for all objects in the project
  • Data source to be used in the project

Examine the cloned project

We recommend you look through all the newly created project elements to familiarize yourself with what has been created. Look for any job that is marked with errors. These errors must be manually corrected.

Test the project

When you have reviewed the project and believe that everything is configured correctly, test the project by following these steps.

  1. Run the job manually.
  2. Review the data at the end of the job to ensure the revenue ranges are assigned correctly.
  3. Review the Analytic report in the Project to ensure data is being presented correctly.
  4. Launch the App Portal and view the Building Block App to make sure the data is presented correctly.
  5. If all goes well, create a data target and add an export step to the job to write the data back to Salesforce. You'll need to have a Salesforce field to hold the revenue range value. Then, modify the bot to adjust the schedule, and turn the automation on to have up-to-date data when you need it!