[LEGACY] Exposing 'RollWorks Account Data' custom fields on your Standard Account object

  Transition to new custom objects starts September 2024

RollWorks will release new Salesforce custom objects and reports to all customers by September 1st 2024 and will continue to write data to both old and new custom objects for 90 days to give you time to transition your Salesforce reports, dashboards, or automations to read from the new custom objects.

If you expose RollWorks data from the old custom objects to your Standard Object as a workaround to combine multiple types of RollWorks data in one report, you no longer need this workaround. The new objects allow you to join different data types (e.g., Fit, Intent, Engagement, Advertising) in one Salesforce report.

Learn how to transition to the new custom objects here.


Before you start

Your Salesforce Administrator must manually create custom fields on your Account object and a Flow to trigger an automation to populate these fields from the related RollWorks Account Data records. This guide reflects a unique use case for demonstration purposes only, you may use it as a guide for determining your own custom criteria and adjust your flow with your own unique conditions and values. 


Exposing 'RollWorks Account Data' object on Standard object

After completing the initial Salesforce Integration setup, RollWorks will automatically create custom objects and custom fields in your Salesforce. With this RollWorks data, you can build reports and dashboards in Salesforce as well as trigger workflows.

While these custom objects and custom fields containing RollWorks data are linked directly to your Account, Contact, and Lead records in Salesforce, you may choose to bring over certain custom fields directly into the Account object to allow for more robust reporting capabilities.

The solution is straightforward - creating a custom field and a Flow to populate the Account fields from related RollWorks Account Data records. Your Salesforce Administrator would complete the following steps to set up the new Account Object.

This example covers how to expose Fit Grade and Journey Stage

This article walks you through a specific example to add Fit Grade and Journey Stage to your Account record in Salesforce.

Be sure to only use your ICP Name(s) exactly as written in your RollWorks account. Click here to open the RollWorks App and find your organization's ICP Name(s).


Watch the 8-minute video below or continue reading this article for step-by-step instructions.


STEP 1. Create Custom Fields on your Account object

Create a custom field (text) on the Account object for each field on the RollWorks Account Data record that you would like to see directly on your Accounts. In this example, you will create two separate custom fields on the standard Account object to expose Fit Grade and Journey Stage.

To create the custom fields:

  • Go to Setup > Object Manager > Account
  • From there, click on Fields & Relationships and select New
  • The data type of the field should be Text.
  • Click on Next and save the field after naming and providing details. 


STEP 2. Create a Flow to populate the Custom Fields with related RollWorks Account Data

Once you have your custom fields created, you are ready to create a Flow to automate populating your new custom fields using the related RollWorks Account Data records. 

  • To create your flow, go Setup > Flows and select New Flow

  • From here a popup window will appear to select the type of Flow. Select Record-Triggered Flow and then Create.

  • Under the Configure Start window, select the following options and click Done:
    • Select Object: RollWorks Account Data
    • Configure Trigger: A record is created or updated
    • Set Entry Conditions: All Conditions are Met
      • Field: adroll__Account_Id__c 
      • Operator: isnull
      • Value: False
    • When to Run the Flow for Updated Records: Every time a record is updated and meets the condition requirements
    • Optimize the Flow for: Actions and Related Records

Now the Flow Builder is open and ready to configure. 

  • Click on the + right below the Start node and select the Decision element. 
  • Name the Decision and add a Description
  • Create a separate outcome with conditions for both Journey Stage and Fit Grade. In this specific example:
    • For Journey Stage the field should be populated when ANY related RollWorks Account Data record is created or updated with a Journey Stage. 
    • For Fit Grade, you should only use records that fit your ICP to populate on the applicable Account so you will set additional criteria on the outcome. 

Below is the criteria for this custom example that you may edit to meet your individual needs.

RollWorks data attribute Custom example
Fit Grade

If the related RollWorks Account Data record has an ICP Name of StrategicTAL, then the Account must have company employees of equal or greater than 500 (based on our Account Company Employees field) to populate the Fit Grade. If ICP Name is SMBTAL, then the company employees must be less than 500.


- Be sure to only use your ICP Name(s) exactly as written in your RollWorks account. Click here to open the RollWorks App and find your organization's ICP Name(s).

- Be sure to consult your Marketing team to confirm if you should limit the RollWorks Data written to only records over a specific number of employees, or you may skip this condition altogether. This employee count filter is a suggestion for demonstrations purposes and may not apply to your organization.

Journey Stage The related RollWorks Account Data record has the Journey Stage populated.

Once your criteria and outcomes are complete, click Done

Next, you will assign the Account field values from the related RollWorks Account Data record. 

  • Access the Toolbox on the left side of the Flow Builder and select New Resource
  • Create a Variable called AccounttoUpdate and select the following:
    • Resource Type = Variable
    • Data Type = Record
    • Object = Account
  • Click Done.

Once you create the variable, you can assign values based on each decision node. 

  • Select the + under the first outcome and select the Assignment element. 
  • Populate the following variables for Journey Stage to ensure the flow knows which Account to update and which field, in this case, Journey Stage with the value from the related RollWorks Account Data record:
    • Variable: AccounttoUpdate>Account ID Operator: Equals Value: Record Account ID
    • Variable: AccounttoUpdate>RollWorks Journey Stage Operator: Equals Value: Record Journey Stage
  • Click Done when complete and repeat the same steps for Fit Grade. 

Once the assignments are complete, you will create an action to update the Account with the new values from related RollWorks Account Data records. 

  • Click on the + at the very end of your flow right above End and select Update Records
  • Add a label called Update Account.
  • Ensure Use the IDs and all field values from a record or record collection is selected to find records. 
  • Select AccounttoUpdate under Records to Update. This is the variable that you created in an earlier step. 
  • Click Done when complete.

Now you are ready to save and activate your Flow. A standard naming convention is recommended, for example, the object that the flow is triggered by and the actions. In this case “RollWorks Account Data Create Update After Save Flow” is appropriate.


STEP 3. Create Reporting Utilizing the New Account Fields

Now you will create reports based on data from the new account fields. Here is an example report created to display the number of Accounts owned by a sales user and their Journey Stage and Fit Grades. 

This particular report is filtered on an individual sales user where Account Stage and Fit Score are not blank. 


Additional Salesforce Resources

Was this article helpful?
1 out of 1 found this helpful

Articles in this section

Chat with an agent
Mon - Fri 10am - 6pm EST
Send a support email
Mon - Fri 10am - 6pm EST