Salesforce Integration

(COMING SOON) Manage your sales from Salesforce Opportunity to Forecast Project

Our Salesforce integration contains a variety of useful tools to help you manage your sales from Salesforce Opportunity to Forecast Project.

Integration Setup

To start the process of installing the Salesforce integration, go to the Salesforce integration page in your Forecast company.

    1. Click the INSTALL/UPDATE PACKAGE button. This will redirect you to Salesforce.
    2. Log in to an admin account in Salesforce (on the instance where you want to install the integration).
    3. Select the Install for All Users option and press Install.
    4. Tick the Yes, grant access to these third-party web sites and press Continue.
    5. Wait for the installation to complete and click the Setup integration button to be redirected back to the Salesforce integration page.
    6. Once the Salesforce integration page is loaded, it will immediately begin the activation process. If this flow is interrupted, you can restart it by going back to the Salesforce integration page and click the ACTIVATE button.
    7. Allow access to the requested information by following the on-screen instructions.
    8. You will be redirected back to the Salesforce integration page one last time, and your integration should now be activated!

    Configuring Opportunity to Project automation

    Now that the integration is set up, you can configure when a Salesforce opportunity should have a corresponding project created in Forecast. On the Salesforce integration page you should see a list of the opportunity stages in your Salesforce instance. The table contains the following columns

    • Order, which is the order of the opportunity stage from Salesforce.
    • Name, the name of the opportunity stage.
    • Project Stage, the project stage which the opportunity stage should map to.
    • Create Project, which indicates whether or not an opportunity reaching this stage should be created in Forecast as a project.
    • Forecast Probability, shows the probability of the project in Forecast, based on the settings.
    • Salesforce Probability, shows the probability of the opportunity when it is in the corresponding stage.

    The default setup is that the lowest order opportunity stage is set as to create a project in Forecast in with the stage "Opportunity". Since it is the lowest order opportunity stage, every other opportunity will also set the project to "Opportunity".

    In this example, an opportunity in Salesforce will only be created in Forecast when it is put into the stage of "Qualification" or "Value Proposition" in Salesforce. Once it is created, it will be moved to the corresponding stage when moved to a opportunity stage (eg. a project moving from "Qualification" to "Id. Decision Makers" will move that project from "Opportunity" to "Planning").

    For the opportunity stages of "Prospecting", "Value Proposition" and "Id. Decision Makers", the probability values are highlighted in red, as they differ. For "Prospecting" this is because the opportunity will not have a corresponding project in Forecast. For "Value Proposition" and "Id. Decision Makers" this is because that the project will be set to "Planning" in Forecast, meaning that it will be counted as having a probability of 100%. 

    Due to the way probability works in Forecast, we recommend a setup similar to this example:

    Creating project by template

    By default the project created in Forecast by the Salesforce integration will be empty and to avoid tedious setup by the user every time a new project is created, you can specify a template which the created project will apply. This can be configured by ...

    Forecast Project record

    Once an opportunity has a corresponding project in Forecast, we create a Forecast Project record in salesforce and link it to the opportunity. The Forecast Project record contains budget number, progress and some overall data, all of which is also reflected in the opportunity object

    Field Description
    Forecast Project Name Name of the project
    Start Date Start date of the project
    End Date End date of the project
    Project Progress Project progress
    Stage Which stage the project is in
    Status The raw status of the project (RED, YELLOW or GREEN)
    Project Status The status of the project interpreted to colors.
    Project URL URL to the project
    Project Contact Contact person of the project
    Baseline budget numbers

    Baseline revenue, cost, profit and margin.

    Planned budget numbers Planned revenue, cost, profit and margin.
    Actual budget numbers Actual revenue, cost, profit and margin.
    Forecast budget numbers Forecast revenue, cost, profit and margin.

    These fields are exposed through the opportunity, so they can be added to page layouts as soon as the package is installed.

    To do this:

    1. Go to your Salesforce instance setup and find the Object Manager.
    2. Find Opportunity in the object list.
    3. Go to Page Layout.
    4. Click the page layout to which you wish to add the Forecast Project record fields.
    5. In the table at the top of the screen, under Fields (should be selected by default), the fields of the project record should be shown alongside the fields of the opportunity (see screenshot below).

    Account Project list

    Included in the package is also a Visualforce Page which displays the list of related Forecast Projects (via opportunities for an Account) from an accounts' page layout. The Visualforce page is called Account Related Forecast Projects.

    Data update

    There are three distinct phases in which the Forecast Project record in Salesforce will be updated:

    • Opportunity: the first phase starts as a Salesforce opportunity triggers the creation of the corresponding Forecast Project in the "Opportunity" stage. When the opportunity changes stage, it will also be updated with the most recent information from the Forecast project. In addition, a periodic update will run when changes are made to the project in Forecast.
    • Project: the opportunity is won and the project is moved to the "Planning" stage. The periodic update will be the sole way in which the information in salesforce is updated.
    • Archived: the project is moved to either "Done" or "Halted", which consequently locks all of the data in Forecast. This manually triggers a data update, to ensure that the "final" data in Salesforce is the same as in Forecast.

    Asides from the initial creation of a project, all of the data flows from Forecast to Salesforce. An exception to this rule is that the probability is synchronized from Salesforce to Forecast (if possible).

    Reports

    With the package also comes a report displaying all of the Forecast Project records in Salesforce. The report is named Forecast Projects Report and is placed in the Forecast Project Reports folder in Salesforce.

    You are of course also able to create your own reports and include Forecast data in those, Salesforce permitting.

    Updating the package

    Occasionally we will be updating the package, which you will then have to do manually by going to the Salesforce integration page and clicking the INSTALL/UPDATE PACKAGE button.

    Feature Requests

    If there is something that you would really like to see done (or done differently) in the Salesforce integration, reach out to us! As you most likely know, Salesforce is highly customizable which makes it difficult for us to make a general enough integration that anyone can use, but specific enough that it provides significant value.